- Posted 25 days ago
- Over 100 applicants have applied
Job Description
We are seeking a skilled and proactive Database Engineer with 2-3 years of hands-on experience in MySQL and PostgreSQL databases. The successful candidate will play a key role in the development, optimization, and maintenance of our database systems, ensuring reliability, performance, and scalability. If you are passionate about databases and eager to work with cutting-edge technologies, we want to hear from you!
Responsibilities:
- Database Management: Design, implement, and maintain MySQL and PostgreSQL databases, ensuring high availability, reliability, and data integrity.
- Performance Optimization: Monitor database performance, analyze query execution plans, and tune queries to improve performance. Implement indexing strategies and other optimization techniques.
- Backup & Recovery: Design and implement backup and recovery strategies to ensure data availability and business continuity.
- Database Design: Assist in creating efficient database schemas, including normalization, to support application and reporting needs.
- SQL Development: Write efficient, optimized SQL queries, stored procedures, and functions for both MySQL and PostgreSQL databases.
- Database Migration: Assist with data migration tasks, including version upgrades and migrations between MySQL and PostgreSQL.
- Automation & Scripting: Write scripts to automate routine database tasks, such as backups, monitoring, and maintenance.
- Monitoring & Troubleshooting: Regularly monitor database health, resolve performance issues, and troubleshoot complex database problems as they arise.
- Collaboration: Work closely with development teams to ensure optimal database performance for applications and provide database-related support for development projects.
- Security: Implement and enforce database security practices, including user management and access control, to ensure the protection of sensitive data.
- Documentation: Maintain clear and concise documentation on database architectures, procedures, and troubleshooting steps.
- Compliance: Ensure compliance with data protection regulations (e.g., GDPR) and best practices in database management.
Skills & Qualifications:
- 2-3 years of experience as a Database Engineer or Database Administrator working with MySQL and PostgreSQL.
- Proficiency in SQL, with strong experience in writing complex queries, stored procedures, and functions.
- Hands-on experience in performance tuning, including query optimization, indexing, and improving database performance.
- Experience in database backup, recovery, and disaster recovery strategies.
- Familiarity with database design principles such as normalization, schema design, and data modeling.
- Experience with data migration between different database platforms, particularly MySQL and PostgreSQL.
- Knowledge of database security best practices, including user access control and encryption.
- Familiarity with Linux/Unix-based environments (for PostgreSQL) is a plus.
- Experience with cloud database platforms (e.g., AWS RDS, Azure Database for PostgreSQL/MySQL) is a plus.
- Strong troubleshooting and problem-solving skills, especially in a database-centric environment.
- Familiarity with monitoring tools like Prometheus, Grafana, or similar tools for database health monitoring.
- Knowledge of ETL processes and data integration is a plus.
Preferred Qualifications:
- Bachelors degree in Computer Science, Information Technology, or a related field.
- Certification in MySQL or PostgreSQL is a plus.
- Familiarity with containerization and orchestration tools like Docker and Kubernetes is a plus.
- Exposure to NoSQL databases (e.g., MongoDB, Cassandra) is a plus.
More Info
Key Skills
database design principles
Postgresql Database Administration
About Company
Progressive Infotech is a leading provider of Transformation Services which spans across Cloud, Digital and Operations. We have been reinventing ourselves to remain relevant to the global marketplace and bring significant value to our clients engagements.
With its robust delivery process and Integrated Quality Management System certified for ISO 9001:2008, ISO 20000-1:2005, as well as ISO 27001: 2005 standards and Governance models based on COBIT, Progressive is constantly redefining the way services are being delivered and consumed by our clients across the globe with assurance on sharper experience and superior outcomes.
Founded in the year 1998, Progressive’s presence has grown to over 130+ locations with 1200+ associates spread across India, USA and the Middle East.
Progressive Infotech also has ventured into international market through subsidiaries in USA and Middle East, to cater to the North America, Middle East, and African markets. For its globally distributed customers, Progressive has set up a state-of-the-art Hybrid NOC at its sprawling facility in NOIDA, the National Capital Region of Delhi.
With over 27 years of experience across various Industry verticals, Progressive has traversed the journey from being a large VAR to a Cloud, Digital and Operations Transformation Services Company today. Our focus is to help our customers maximize returns on their existing IT investments, help manage the IT as well Transform IT to align with the constantly changing demands of their business. We differentiate through our agile, flexible, and razor-sharp focus on customer experience.
