Database Engineer
- Progressive Infotech
- 2 - 3 years
- Bengaluru
- 1 month ago
- Email to a friend
- Report this job
Job Description
Job Title: Database Engineer (2-3 Years Experience) : MySQL & PostgreSQL
Job Location: Bengaluru
Job Type: Full-time
Job Overview:
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.
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: IT & Information SecurityRole Category: IT SupportRole: IT Support - OtherEmployement Type: Full timeContact Details:
Company: Progressive InfotechLocation(s): Bengaluru
Keyskills: MySQL Postgresql Database Backup database design principles Postgresql Database Administration Database Security SQL Server Linux/Unix-based environments
Similar positions
Progressive Infotech
Nasscom-McKinsey placed our client at the upper end of the value chain in software outsourcing. Could it be why over 90 offshore projects have been placed with us since our inception in 1987, ensuring a technical and functional edge, as well as faster time-to-market for our client's products. A larg...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in