Database Administrator (PostgreSQL, MySQL, MSSQL)
About Rosmerta Autotech Limited :
Rosmerta Autotech Limited, a part of the Rosmerta Technologies group, is a leader in India's automotive technology and mobility solutions sector.
With a strong presence in areas like High-Security Registration Plates (HSRP), Smart Driving Licenses, and Intelligent Transport Management Systems (ITMS), we are at the forefront of driving safer, smarter, and more connected roads.
We are committed to innovation and leveraging technology to transform the automotive landscape.
Position Summary :
We are seeking a highly skilled and experienced Database Administrator to join our team in Gurugram.
The ideal candidate will be responsible for the management, maintenance, and support of our PostgreSQL, MySQL, and MSSQL database systems.
This role is crucial for ensuring the high availability, performance, and security of our critical data infrastructure.
Key Responsibilities :
- Database Management : Administer, maintain, and support production and non-production database systems for PostgreSQL, MySQL, and MSSQL.
- Performance Tuning : Proactively analyze database performance, identify bottlenecks, and implement query optimization and performance tuning strategies to ensure optimal system speed and efficiency.
- High Availability : Configure and manage database replication (e.g., streaming replication, logical replication) to ensure high availability and disaster recovery capabilities.
- Backup & Recovery : Develop, implement, and maintain robust backup and recovery strategies to safeguard data integrity and ensure rapid recovery in case of a disaster.
- Data Security : Implement and manage security protocols for SQL servers, including user access control, roles, and permissions to protect sensitive data.
- Monitoring & Troubleshooting : Continuously monitor database health, resolve performance issues, and troubleshoot complex database-related problems.
- Data Migration & ETL : Perform data migration tasks and manage ETL (Extract, Transform, Load) processes to support data movement and integration requirements.
- Documentation : Maintain comprehensive documentation of database configurations, processes, and troubleshooting procedures.
Required Skills & Qualifications :
Experience : A minimum of 4+ years of professional experience in Database Skills :Strong expertise in PostgreSQL and MySQL administration is essential.Proficiency in SQL Performance Tuning, including query analysis and optimization.Hands-on experience with Database Administration, Backup and Recovery, and Disaster Recovery Planning.Familiarity with various Replication methods.Experience with ETL Processes.Knowledge of MSSQL administration is a plus.Educational Qualification : in a relevant field.Problem-Solving : Excellent analytical and problem-solving skills with a keen attention to detail.Communication : Strong verbal and written communication skills.Job & Interview Details :
Job Location : Vatika Tower, 66, Sector 44, Gurgaon, Near Millennium City Metro.Interview Location : Vatika Tower, 66, Sector 44, Gurgaon.Interview Process : Approximately 2 rounds. The first round will be conducted online, and the final round will be held in offline mode at our office.(ref : hirist.tech)