Postgresql Database Administrator

Over the past 15 years, Medanta has created an unrivalled impact in delivering world class multi-specialty care for patients in India. We have hospitals in Gurgaon, Lucknow, Patna, Indore and Ranchi. In addition, we have clinics in Defence Colony (South Delhi), Cybercity & Subhash Chowk (Gurgaon), and at the Delhi Airport. Medanta is constantly growing and has also ventured in Retail vertical through Diagnostics (Laboratory Services) and Pharmacies. We also have also launched homecare services. We further plan to scale up existing facilities and expand into a few more geographical areas and also identify new avenues (Academics - Medical College) within the Healthcare eco-system. As we continue to scale and grow into new geographies, explore innovative methods of healthcare delivery, we are looking to hire exceptional talent to achieve our vision and grow in the process to achieve their professional aspiration. We are looking to hire exceptionally motivated and talented professionals to join our Information Technology team and be partners in this exciting journey.

Job Location - Gurgaon

Work Days - 6 days week

Key Responsibilities:

• Design, install, configure, and maintain PostgreSQL, REDIS database systems.
• Good to have skills on MongoDb and/or MySQL but NOT Mandatory
• Perform regular database performance tuning, monitoring, and optimization to ensure efficient and reliable operation.
• Monitor and manage database backups, disaster recovery processes, and high availability solutions.
• Collaborate with development teams to optimize SQL queries, indexes, and database schema designs.
• Identify and resolve database performance issues, bottlenecks, and inefficiencies.
• Implement and enforce security best practices and access controls to protect data integrity and confidentiality.
• Perform database capacity planning and provide recommendations for hardware and infrastructure upgrades.
• Troubleshoot and resolve database-related incidents and errors in a timely manner.
• Create and maintain documentation, including database standards, procedures, and operational guidelines.
• Stay up to date with the latest advancements and best practices in PostgreSQL, REDIS(Remote Dictionary Server) technologies.

Requirements:

• Bachelor's degree in Computer Science, Information Systems, or a related field (or equivalent work experience).
• Proven work experience as a Database Administrator (DBA) with expertise in PostgreSQL, REDIS (Mandatory).
• Good to have skills on MongoDB, and SQL Server but not mandatory
• Strong knowledge and experience in database administration, performance tuning, and optimization.
• Proficiency in SQL and experience with database query optimization.
• In-depth understanding of PostgreSQL, REDIS Server architectures, features, and administration tools.
• Familiarity with database backup and recovery mechanisms, high availability solutions, and disaster recovery planning.
• Experience with database security practices and implementing access controls.
• Solid understanding of Linux/Unix and Windows operating systems and command-line tools.
• Strong problem-solving and analytical skills with the ability to diagnose and resolve complex database issues.
• Excellent communication and collaboration skills to work effectively with cross-functional teams.
• Familiarity with cloud-based database platforms (e.g., AWS RDS, Azure Database Services).

Nice to Have Skills:

• Certification in PostgreSQL, MongoDB, and/or SQL Server administration.
• Experience with other database technologies such as MySQL, Oracle, or Redis.
• Knowledge of database automation and orchestration tools (e.g., Ansible, Puppet, Chef).
• Understanding of database performance monitoring and profiling tools (e.g., pg_stat_statements, MongoDB Profiler, SQL Server Profiler).
• Experience with database migration, replication, and data synchronization techniques.