Description

Key Responsibilities

Database Administration & Operations

• Manage and support large-scale production databases with 24x7 availability requirements.
• Administer Oracle, PostgreSQL, MongoDB, Cassandra  and other enterprise database platforms.
• Perform database installation, configuration, upgrades, patching, cloning, and migrations.
• Ensure database health, availability, integrity, and performance.

Performance Tuning & Optimization

• Analyze and optimize SQL queries, indexing strategies, execution plans, and database configurations.
• Conduct capacity planning and resource utilization forecasting.
• Resolve performance bottlenecks and implement proactive tuning measures.

High Availability & Disaster Recovery

• Design and maintain HA and DR solutions.
• Manage technologies such as:
  • Oracle Data Guard
  • RAC
  • PostgreSQL Replication
  • Cassandra Multi-DC Clusters
  • MongoDB Replica Sets/Sharding
  • Always-On Availability Groups
• Conduct periodic DR drills and recovery testing.

Cloud & Modernization

• Support cloud database platforms:
  • AWS RDS/Aurora
  • PostgreSQL
  • AWS DynamoDB
  • MongoDB Atlas
• Lead database migration and modernization initiatives.

Automation & DevOps

• Develop automation scripts using:
  • Shell
  • Python
  • Ansible
  • Terraform
• Implement Database CI/CD pipelines.
• Integrate database deployments with DevOps toolchains.
• Champion Infrastructure as Code (IaC) practices.

Incident & Problem Management

• Provide L3/L4 support for critical database incidents.
• Conduct RCA and implement preventive actions.
• Participate in major incident management and change governance.

Required Technical Skills

Database Technologies

• Oracle (RAC, ASM, Data Guard)
• PostgreSQL
• MongoDB
• Cassandra

Cloud Platforms

• AWS

Automation & Scripting

• Python
• Shell Scripting
• PowerShell
• Ansible
• Terraform

Monitoring Tools

• Dynatrace
• Splunk
• Grafana
• Prometheus

DevOps & CI/CD

• Git
• Jenkins
• GitHub Actions
• Kubernetes (preferred)
• Docker

Key Competencies

• Technical Leadership
• Problem Solving
• Stakeholder Management
• Automation Mindset
• Risk Management
• Operational Excellence
• Customer Focus
• Team Mentoring

Key Skills

Education

Any Gradute