Location: Pune

Exp: 5-12years

Work mode: All 5 days Work from office

Send resumes to: [email protected] with below details:

Name:

Exp:

Notice period:

Current location:

Role Context:

Own database administration and operational excellence for both SQL and NoSQL data stores across on-prem and cloud-managed environments. The DBA will partner with engineering, data, and QA teams to provide performance guidance , define operational runbooks , and ensure systems are tuned, resilient, secure, and calibrated for evolving workloads (ETL, APIs, analytics, and ML workloads where applicable).

Key Responsibilities

• Administer and support SQL and NoSQL databases across environments (DEV/QA/UAT/PROD).
• Own database performance management: indexing, partitioning, query plan analysis, parameter tuning, and workload optimization.
• Provide performance guidance to teams: schema design feedback, query rewrite recommendations, and access pattern optimization.
• Define operational guidelines: backup/restore, DR, replication, patching, maintenance windows, capacity planning.
• Calibrate systems for workload patterns: concurrency, connection pooling, cache sizing, I/O tuning, and resource governance.
• Implement monitoring and alerting for DB health (availability, latency, slow queries, locks, storage).
• Manage security: roles/permissions, encryption, key management integrations, auditing and compliance practices.
• Support incident response: troubleshooting outages, RCA, preventive actions, and reliability improvements.
• Collaborate with DevOps/SRE teams on infrastructure provisioning and automation.

Must Have

• Strong DBA experience across at least one major RDBMS: PostgreSQL / MySQL / Oracle / SQL Server .
• Practical experience with at least one NoSQL system: MongoDB / Cassandra / Redis / Elasticsearch (as applicable to your stack).
• Advanced SQL expertise including execution plans, indexing strategies, lock analysis, and performance tuning.
• Experience with cloud-managed database services on AWS/Azure/GCP :
• Examples: RDS/Aurora, Azure SQL/Managed Instance, Cloud SQL, Cosmos DB, DynamoDB, etc.
• Strong understanding of HA/DR patterns: replication, failover, backups, PITR, and recovery testing.
• Operational discipline: change management, release readiness, environment standardization, SOPs/runbooks.
• Delivery/DevOps fundamentals: Git-based configuration/versioning, CI/CD awareness for DB changes (migration tooling), automation mindset.
• Non-technical: strong collaboration, ability to communicate performance recommendations clearly, ownership during incidents.

Good To Have

• Experience with data platforms/warehouses: Snowflake/Redshift/BigQuery/Synapse.
• Knowledge of database migration tooling (Flyway/Liquibase) and schema versioning practices.
• Observability tooling exposure (CloudWatch/Azure Monitor/Stackdriver, Prometheus, Grafana, ELK).
• Familiarity with Kubernetes operators for databases or DB on containers (where relevant).
• Exposure to ETL workload patterns and data engineering ecosystems.