Position : Database Administrator (Postgres, MongoDB)
Experience : 5 - 8 Years
Location : Noida
Employment Type : Full-time
Job Summary :
We are seeking a highly experienced Database Administrator (DBA) with 58 years of experience, specializing in managing and optimizing heterogeneous database environments, specifically PostgreSQL and MongoDB. This role is critical for ensuring the high performance, availability, sustainability, and security of all database systems. The DBA will be responsible for the full lifecycle management of these platforms, including configuration, performance tuning, real-time troubleshooting, and establishing robust backup and disaster recovery plans.
Key Responsibilities :
Database Operations and Maintenance :
- Lead the configuration, maintenance, and ongoing administration of PostgreSQL and MongoDB database servers and associated processes.
- Perform Database installation and continuously Monitor systems health and performance to ensure peak operational status.
- Execute routine Patch existing database servers to maintain security and functionality.
- Conduct proactive Database maintenance and optimization activities, including setting and maintaining global database standards.
Performance, Availability, and Troubleshooting :
Drive specialized Performance tuning and Performance monitoring initiatives to ensure highlevels of performance and low latency.
Analyse, solve, and correct issues in real-time, demonstrating strong skills in Troubleshootingand the ability to Diagnose and troubleshoot database errors.
Implement and manage solutions for high availability and sustainability (e.g., replication, Backup, and Disaster Recovery :Establish and enforce stringent Database security policies and manage granular databaseaccess controls.
Oversee and execute all aspects of Backup and recovery procedures for both Postgres and MongoDB.Develop and manage comprehensive Disaster recovery planning to ensure business continuity and minimize data loss.Implement Auditing mechanisms to monitor Database usage and compliance.Automation and Data Management :
Develop and implement Automation tools and Create automation for repeating database tasks using scripting (e.g., Python, Bash) to enhance efficiency.Support and execute Data migration activities between database systems or different : Mandatory 58 years of experience as a Database Expertise (Mandatory) : Deep technical expertise in administering and troubleshooting PostgreSQL and Skills : Proven experience in database configuration, monitoring, patching, and & DR : Strong practical experience in Backup and recovery and Disaster recovery : Expertise in advanced Performance tuning and optimization techniques.Preferred Skills :
Experience in Database design principles and their application in both relational and NoSQLmodels.
Proficiency in writing scripts (Python, Bash) for database Automation and operational tasks.Experience with cloud database services (AWS RDS / Aurora, Azure DB).(ref : hirist.tech)