Back to list

Vacancy description

Senior database engineer - MySQL & PostgreSQL in Chennai, भारत

  • Full-timeStandard weekly hours

Chennai, भारत

Senior database engineer - MySQL & PostgreSQL

Position Description
Experience 6+ Years
Role Senior Database Engineer – MySQL & PostgreSQL
Location Bangalore/ Chennai
Position – 01

. Location – Bangalore
. Work from client office 3 days

Job Summary
We are looking for an experienced MySQL & PostgreSQL Database Engineer with 6+ years of hands on experience in database development, administration, performance tuning, troubleshooting, and production support. The candidate will be responsible for designing, developing, optimizing, and maintaining highly available and scalable database environments. The role requires strong expertise in MySQL and PostgreSQL, SQL development, query optimization, database performance, backup/recovery, and troubleshooting of production issues.
Key Responsibilities
Database Development

. Design and develop database schemas, tables, views, indexes, stored procedures, functions, and triggers.
. Develop complex and optimized SQL queries for MySQL and PostgreSQL.
. Perform database design and data modeling based on application requirements.
. Review existing database structures and recommend improvements.
. Support database migration and data transformation activities.

Performance Tuning

. Analyze and optimize slow running SQL queries.
. Perform execution plan analysis and identify performance bottlenecks.
. Optimize indexes, joins, stored procedures, functions, and database configurations.
. Monitor database performance and proactively identify capacity and performance issues.
. Work closely with application teams to resolve database related performance problems.

MySQL & PostgreSQL Administration

. Install, configure, upgrade, and maintain MySQL and PostgreSQL databases.
. Manage database users, roles, permissions, and security.
. Configure and monitor database parameters.
. Perform database health checks and capacity planning.
. Support high availability and replication environments.

Backup & Recovery

. Implement and manage database backup and recovery strategies.
. Perform database restoration and recovery activities.
. Validate backup integrity and recovery procedures.
. Participate in disaster recovery activities and drills.

Production Support

. Provide L2/L3 database support for production environments.
. Troubleshoot database incidents and identify root causes.
. Participate in incident, problem, and change management activities.
. Support database deployments and production releases.
. Work with development, DevOps, infrastructure, and application teams to resolve issues.

Migration & Upgrade

. Participate in MySQL/PostgreSQL version upgrades and database migrations.
. Perform database assessment, migration planning, validation, and post migration support.
. Support migration between database environments where required.
. Ensure data consistency and integrity during migration activities.

Required Technical Skills
MySQL

. Strong hands on experience with MySQL 5.x/8.x.
. Advanced SQL and query development.
. Query optimization and execution plan analysis.
. Indexing and database performance tuning.
. MySQL replication and backup/recovery.
. Stored procedures, functions, triggers, and views.
. Database security, users, and privileges.

PostgreSQL

. Strong hands on experience with PostgreSQL.
. Advanced SQL and PL/pgSQL.
. Query optimization and execution plan analysis using tools such as EXPLAIN / EXPLAIN ANALYZE.
. Indexing and performance tuning.
. PostgreSQL backup and recovery.
. Replication and high availability concepts.
. Roles, permissions, and database security.
. Stored procedures, functions, triggers, and views.

General Database Skills

. Strong understanding of RDBMS concepts.
. Excellent SQL skills.
. Data modeling and database design.
. Database performance monitoring and troubleshooting.
. High availability and disaster recovery concepts.
. Database security and access management.
. Strong understanding of production support processes.

Preferred Skills

. Experience working with AWS / Azure / GCP databases.
. Experience with cloud managed database services such as Amazon RDS/Aurora or Azure Database services.
. Knowledge of Docker/Kubernetes environments.
. Experience with CI/CD and database deployment automation.
. Knowledge of database monitoring tools.
. Experience with scripting using Shell/Python.
. Experience with database migration tools.
. Exposure to Infrastructure as Code such as Terraform.

Soft Skills

. Strong analytical and problem solving skills.
. Good communication and stakeholder management skills.
. Ability to troubleshoot critical production issues under pressure.
. Ability to work independently as well as within a distributed team.
. Strong documentation and knowledge sharing skills.
. Willingness to participate in on call/production support activities when required.

Education

. Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
. Equivalent professional experience may also be considered.

Experience Summary
Must Have:

. 6+ years of database experience.
. Strong hands on experience with both MySQL and PostgreSQL.
. Advanced SQL development.
. Database performance tuning and troubleshooting.
. Production database support.
. Backup/recovery and database maintenance.
. Database design and optimization.

Good to Have:

. Cloud database experience.
. Database migration/upgrade experience.
. HA/replication experience.
. Python/Shell scripting.
. DevOps/CI CD exposure.

Your future duties and responsibilities

Required qualifications to be successful in this role

Together, as owners, let’s turn meaningful insights into action.

Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll reach your full potential because…

You are invited to be an owner from day 1 as we work together to bring our Dream to life. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.

Your work creates value. You’ll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise.

You’ll shape your career by joining a company built to grow and last. You’ll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.

That same commitment to fairness extends to how we use technology. To support our recruitment team, AI tools may be used to help assess applications though they never replace human judgement. All hiring decisions remain entirely in the hands of our recruitment professionals.

Come join our team—one of the largest IT and business consulting services firms in the world.

Similar vacancies

More like this role

LANCESOFT INDIA PRIVATE LIMITED

MySQL Database Administrator

... Kubernetes clusters/Container platforms in production and non-production environments.- Perform database installation, configuration, patching, and upgrades for MySQL.- Implement and manage robust backup and recovery strategies for MySQL (e.g., Mysql Enterprise Backup, mysqldump).- Monitor MySQL health, performance, and capacity, ...

Bangalore, भारत

  • Remote
  • Full-time
... scalable databases. You will be responsible for database performance, availability, and automation, while also supporting modernization efforts into cloud-based database environments. Responsibilities - Design, build, and administer highly available and performant MySQL databases. - Support production databases across global ...

Hyderabad, भारत

  • Full-time
Senior data science role at HCLTech in Bengaluru. What you'll do - Develop and enhance GenAI features using Python and prompt engineering techniques, ensuring effective utilization of large language models for assigned tasks - Integrate RESTful APIs with GenAI solutions to enable seamless communication between application ...

Bangalore, भारत

  • Hybrid
  • Full-time
  • Contract
Agency : Havas Creative Job Description : The Senior Database Engineer is a hands-on senior engineering role responsible for designing, building, optimizing, and evolving modern Microsoft data platforms across Azure and Microsoft Fabric. The position owns cloud data engineering, enterprise warehouse and lakehouse architecture, ...

Chennai, भारत

  • Hybrid
  • Full-time
  • Contract

€6.95 EUR

... generated total revenues of EUR 6.95 billion; and has been among the best performing stocks in Europe over the past 20 years. Job Description Job Title: Solution Database Engineer Work Location: Bangalore Shift timings: 8.00am to 5.00pm OR 12.00pm to 9.00pm IST Work mode: Hybrid - 3 Days office Role Summary: We are seeking an ...

Bangalore, भारत

Eurofins seeks an experienced Data Warehouse Developer to design and maintain enterprise ETL solutions using SQL Server Integration Services. The role involves building data integration pipelines, optimizing SQL queries, and supporting business intelligence and analytics across large-scale transactional systems.

Bangalore, भारत

  • Hybrid
  • On-site
  • Full-time
Job Description: The Senior DBRE position is part of a central Database Systems Engineering team supporting data services and platforms across Enterprise Technologies, multiple business segments and global development teams. The role focuses on the design, support and optimization of on-premise and cloud-based database ...

Bangalore, भारत

  • Full-time
... Deep knowledge of storage structures: B+ Trees, LSM-Trees, and columnar storage layouts (e.g., Parquet, ORC, ClickHouse Wide/Compact formats). - Operational Database Experience: - 4+ years running production database infrastructure, with deep expertise in [PostgreSQL / MySQL]. - Experience optimizing and managing cost/quotas ...

Bangalore, भारत

... management tools - Experience with database performance tuning, monitoring, and recovery strategies - Familiarity with relational and NoSQL platforms (e.g., PostgreSQL, MySQL, MongoDB, DynamoDB) - Strong problem-solving skills and ability to work across engineering and infrastructure teams Perks & Benefits - Opportunity to ...

Chennai, भारत

  • Full-time
... DevOps, Platform Engineering, SRE, or MLOps roles. - Minimum 3+ years supporting Machine Learning, Deep Learning, or AI production systems. - Proficient in Databases specially Graph Db like Neo4j, memgraph (NosQL and SQL) - Must be able to do Data Modelling - Must know about Embeddings, Vector Database, Semantic Search ...

Pune, भारत