Senior Database Administrator (Senior DBA)

The Senior DA is responsible for the design, implementation, administration, performance optimization, security, availability, and lifecycle management of enterprise database platforms supporting mission-critical applications. The role provides technical leadership for database architecture, automation, cloud migration, disaster recovery, capacity planning, and operational excellence across multiple database technologies., 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

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