SPECIFIC DUTIES AND RESPONSIBILITIES
Database Administration:
Install, configure, upgrade, and maintain Oracle databases (9i, 10g, 11g, 12c, 19c) in both RAC and single-instance environments.
Administer SQL Server and PostgreSQL databases.
Implement and maintain database security measures.
Develop and implement backup and recovery procedures.
Troubleshoot and resolve complex database issues.
Performance Tuning and Optimization:
Monitor database performance and identify areas for improvement.
Implement performance tuning strategies to optimize database performance and resource utilization.
Conduct proactive performance analysis and capacity planning.
Cloud Infrastructure and Deployment:
Design, implement, and manage database deployments on Microsoft Azure and AWS.
Utilize cloud-native services for database management and automation.
Ensure security and compliance in cloud environments.
Automation and Scripting:
Develop and maintain scripts for database automation and monitoring.
Implement infrastructure-as-code (IaC) practices for database deployments.
Collaboration and Mentorship:
Work closely with development, operations, and security teams to ensure database integrity and availability.
Provide technical guidance and mentorship to junior database administrators.
Participate in on-call rotation and provide support during off-hours.
Emerging Technologies:
Evaluate and implement new database technologies and best practices.
Stay up-to-date with the latest trends in database administration and cloud computing.
COMPETENCIES
Core Competencies (Must-have Competencies)
Extensive experience (8+ years) as a Database Administrator with a focus on Oracle.
In-depth knowledge of Oracle database technologies (9i, 10g, 11g, 12c, 19c), including RAC and single-instance configurations.
Experience with SQL Server and PostgreSQL administration.
Strong understanding of cloud infrastructure, particularly Microsoft Azure and AWS.
5 years+ of experience with database performance tuning, backup and recovery, and security.
Excellent troubleshooting and problem-solving skills.
Strong communication and collaboration skills.
Complementary Competencies
Experience with Oracle GoldenGate.
Experience with Exadata administration.
Experience with NoSQL databases (e.g., MongoDB).
Experience with SAP Hana.
Knowledge of DevOps practices and tools.
QUALIFICATIONS
Work Conditions
Work From Home Set-up
Amenable to work on night shift – 8PM to 5AM