Location: Noida
Job Type: Full-time
Job Summary:
We are looking for an experienced Database Administrator (DBA) with 6 to 8 years of hands-on experience in managing, maintaining, and optimizing relational and/or NoSQL database systems. The ideal candidate will be responsible for ensuring database performance, availability, scalability, and security across development, testing, and production environments.
Key Responsibilities:
- Install, configure, and maintain database systems (e.g., PostgreSQL, MySQL, SQL Server, Oracle, MongoDB).
- Monitor database performance, identify bottlenecks, and implement tuning solutions.
- Design and implement backup, restore, and disaster recovery strategies.
- Ensure database security through access control, encryption, and vulnerability assessments.
- Automate routine maintenance tasks using scripts and scheduled jobs.
- Collaborate with developers and DevOps teams to optimize query performance and data access patterns.
- Perform database upgrades and patch management with minimal downtime.
- Maintain high availability and failover solutions (e.g., clustering, replication).
- Conduct data migration, transformation, and integration activities.
- Maintain data integrity and support compliance with regulations (e.g., GDPR, HIPAA).
Required Qualifications:
- 6–8 years of proven experience as a DBA in a complex production environment.
- Deep knowledge of RDBMS (e.g., PostgreSQL, Oracle, SQL Server, MySQL).
- Hands-on experience with NoSQL systems (e.g., MongoDB, Redis, Cassandra) is a plus.
- Expertise in SQL and PL/SQL or procedural extensions.
- Strong understanding of database architecture, indexing, partitioning, and replication.
- Experience with monitoring tools (e.g., New Relic, Nagios, Prometheus, pgBadger).
- Proficient in shell scripting, Python, or PowerShell for automation.
- Familiarity with cloud databases (e.g., Amazon RDS, Azure SQL, Google Cloud SQL).
- Solid understanding of backup/recovery solutions, such as RMAN, pg_dump, logical/physical backups.
Preferred Qualifications:
- Experience with high-availability architectures and failover planning.
- Knowledge of DevOps tools and CI/CD pipelines involving database changes.
- Familiarity with database infrastructure in containerized environments (Docker, Kubernetes).
- Certifications such as Oracle Certified Professional (OCP), Microsoft Certified: Azure Database Administrator Associate, or AWS Certified Database - Specialty.
Job Type: Full-time
Pay: ₹1,200,000.00 - ₹1,500,000.00 per year
Work Location: In person