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