03 Nov
|
Quess IT Solutions
|
Gurugram
03 Nov
Quess IT Solutions
Gurugram
Job Summary
We are looking for an Oracle Database Administrator with 3 to 4 years of hands-on experience to manage and support our Oracle environments across development, staging, and production. You will own database availability, performance, security, and recovery, handle production incidents, and work closely with application, infrastructure, cloud, and DevOps teams to keep our databases reliable.
Key Responsibilities
- Install, configure, upgrade, patch, and maintain Oracle databases across development, staging, and production environments.
- Perform database administration, monitoring, troubleshooting, and performance tuning.
- Manage schemas, tablespaces, indexes, users, roles, and privileges.
- Analyze SQL queries and execution plans to identify and resolve performance issues.
- Manage backup and recovery using RMAN, and implement Point-in-Time Recovery (PITR) strategies.
- Support high availability, disaster recovery, and database replication environments.
- Monitor database health, capacity, and storage, and address potential issues proactively.
- Handle production incidents, RTB (Run the Business), and BTB (Build the Business) activities.
- Implement database security through roles, privileges, access controls,
encryption, and auditing.
- Support database migrations, version upgrades, patching, and environment refreshes.
- Automate routine DBA tasks using scripts and automation tools.
- Collaborate with application, infrastructure, cloud, and DevOps teams to ensure database reliability and availability.
Required Skills and Qualifications
- 3 to 4 years of hands-on experience in Oracle database administration.
- Strong knowledge of Oracle architecture, SQL, PL/SQL, indexing, and query optimization.
- Hands-on experience with Oracle backup and recovery, preferably using RMAN.
- Valuable understanding of performance tuning, execution plans, AWR/ASH reports, and database monitoring.
- Knowledge of high availability and disaster recovery concepts.
- Strong troubleshooting skills in production environments.
- Good knowledge of Linux/Unix environments.
- Exposure to cloud platforms such as AWS, Azure, or Oracle Cloud.
- Understanding of CI/CD and infrastructure automation.
- Experience with scripting or automation using Bash, Python, Ansible, Terraform, or similar tools.
📌 Oracle DBA (Gurugram)
🏢 Quess IT Solutions
📍 Gurugram