10 Sep
|
Progressive Infotech
|
Bengaluru
10 Sep
Progressive Infotech
Bengaluru
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 workplace.
- 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.
📌 Database Engineer (Bengaluru)
🏢 Progressive Infotech
📍 Bengaluru