19 Oct
|
Tngone Software Labs
|
India
19 Oct
Tngone Software Labs
India
About the Role
We are looking for an experienced Senior Oracle Database Administrator with 9+ years of hands-on experience managing large-scale and business-critical Oracle databases.
The candidate will be responsible for database installation, configuration, upgrades, patching, performance tuning, backup and recovery, security, high availability, disaster recovery, migrations, and production support.
Key Responsibilities
- Install, configure, upgrade, patch, and maintain Oracle databases, including Oracle 11g, 12c, 19c, and 21c.
- Manage and support Oracle RAC, ASM, Data Guard, RMAN, Oracle Enterprise Manager (OEM), and GoldenGate.
- Monitor database health and performance and perform SQL and database performance tuning.
- Tune SQL queries, indexes, execution plans, memory, and database parameters.
- Manage backup and recovery using RMAN and implement disaster recovery using Data Guard.
- Troubleshoot critical production database issues and perform Root Cause Analysis (RCA).
- Manage database security, user access, audits, vulnerabilities, and compliance requirements.
- Perform database migrations, upgrades, cloning, refreshes, patching, and capacity planning.
- Manage database storage and ensure high availability and reliability.
- Provide support for 24x7 production environments and participate in on-call support when required.
- Automate regular DBA activities using Shell Scripting, Python, or Ansible.
- Work closely with Application, Infrastructure, Cloud, DevOps, and Information Security teams.
- Prepare and maintain technical documentation, SOPs, recovery procedures, and operational runbooks.
- Lead database modernization, upgrade, and reliability improvement activities.
- Mentor and support junior DBAs.
Required Skills and Experience
Oracle Database
- 9+ years of strong experience in Oracle Database Administration.
- Hands-on experience with:
- Oracle RAC
- ASM
- Data Guard
- RMAN
- Oracle Enterprise Manager (OEM)
- GoldenGate
- Experience with Oracle 11g, 12c, 19c, and 21c.
- Strong knowledge of Oracle database performance tuning.
Core DBA Skills
- Backup and recovery
- Disaster recovery
- Database migration and cloning
- Database upgrades and patching
- High availability
- Capacity planning
- Storage management
- Performance optimization
- Production troubleshooting
Operating Systems
- Strong experience with Linux, especially RHEL or Oracle Linux.
- Experience with Unix environments.
SQL and Automation
- Solid knowledge of SQL and PL/SQL.
- Experience with Shell Scripting.
- Working knowledge of Python.
- Experience with Ansible or other automation tools is preferred.
Production Support
- Experience independently managing large, business-critical Oracle databases.
- Experience working in 24x7 production environments.
- Ability to handle critical incidents, troubleshoot issues,
and restore services quickly.
Cloud
Experience with Oracle databases hosted on any of the following is preferred:
- Oracle Cloud Infrastructure (OCI)
- AWS RDS for Oracle
- Azure
Preferred Skills
- Oracle Exadata administration and performance management.
- Experience with DevOps and infrastructure automation.
- Monitoring and observability tools such as:
- Splunk
- Grafana
- Dynatrace
- Oracle Enterprise Manager
- Experience in Banking, Financial Services, Insurance, FinTech, or other enterprise environments.
- Experience managing databases larger than 5 TB.
- Knowledge of Docker, Kubernetes, and CI/CD pipelines.
- Experience with ITIL-based Incident, Problem, and Change Management.
Qualifications
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
- Oracle Certified Skilled (OCP) certification is preferred.
- Oracle Certified Master (OCM) is an advantage.
- Strong experience supporting large-scale enterprise production databases.
Professional Competencies
- Strong troubleshooting and problem-solving skills.
- Good analytical and technical skills.
- Explicit communication with technical and business teams.
- Ability to handle and lead critical production incidents.
- Strong ownership and attention to detail.
- Ability to identify and reduce operational risks.
- Ability to mentor junior DBAs and lead technical initiatives.
- Strong documentation and operational discipline.
- Focus on continuous improvement and database reliability.
📌 Senior Oracle Database Administrator (India)
🏢 Tngone Software Labs
📍 India