We are seeking an experienced Oracle and Microsoft SQL Server Database Administrator to manage, maintain, and optimize enterprise databases. The role involves installation, configuration, performance tuning, backup & recovery, and ensuring high availability of mission-critical systems.
ACCOUNTABILITIES & DAY TO DAY RESPONSIBLITIES
• Database Administration
• Install, configure, and upgrade Oracle and MS SQL Server databases.
• Create and manage database instances, schemas, and security roles.
• Perform proactive monitoring, performance tuning, and optimization of database environments.
• Backup & Recovery
• Implement and maintain backup, restore, and disaster recovery strategies (e.g., RMAN, Always On, Log Shipping, or third-party tools).
• Regularly test recovery procedures to ensure business continuity.
• Performance & Optimization
• Analyse execution plans, indexes, and queries to enhance performance.
• Optimize storage and memory usage for efficiency.
• High Availability & Replication
• Manage clustering, replication, and failover solutions (Oracle RAC, Data Guard, SQL Always On).
• Monitor uptime and ensure SLA compliance
• Security & Compliance
• Apply patches and security updates to maintain compliance with IT policies.
• Implement access controls, encryption, and auditing.
• Collaboration & Support
• Work with development teams to support database design and query optimization.
• Provide L2/L3 support for production incidents and troubleshooting.
• Documentation & Automation
• Maintain proper documentation for processes, configurations, and procedures.
• Automate repetitive tasks using scripts or tools
PRE-REQUISITES:
In order to succeed in this role, it is expected that you will have:
Knowledge/Experience
• Experience in a similar role for 10 to 15 years
• A minimum of 10 years of experience in Oracle & 8 years in SQL
Technical/Professional Skills required:
• Oracle 12c/19c administration, Data Guard, RMAN, OEM, RACK
• SQL Server 2016/2019 administration, Always On, SSIS/SSRS/SSAS.
• Strong SQL and PL/SQL or T-SQL scripting skills.
• Experience with performance tuning and query optimization.
• Knowledge of Linux/Unix and Windows environments.
• Familiarity with cloud platforms (Azure, AWS, or OCI).
Qualifications
• Education: Bachelor’s degree in Computer Science, Information Technology, or related field.
KNOWLEDGE, SKILLS, AND EXPERIENCE REQUIRED
• 10 to 15 years experience as a DBA with both Oracle and SQL Server environments.
• Hands-on experience with database upgrades, migrations, and patching.
Key Performance Indicators (KPIs)
• Database uptime and SLA adherence.
• Backup success and recovery test results.
• Number of performance issues resolved proactively.
• Timely completion of maintenance and patching tasks.
Preferred Qualifications
• Certifications like Oracle Certified Professional (OCP) or Microsoft Certified: Azure Database Administrator Associate.
• Experience with database automation tools or DevOps integration.
• Familiarity with NoSQL or cloud-native databases.
Soft Skills
• Strong analytical and problem-solving abilities.
• Excellent communication and documentation skills.
• Ability to work in 24x7 support environment and handle on-call duties.