Database Migration Engineer (Pan India)

Tata Consultancy Services; India; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Tata Consultancy Services is seeking a Database Migration Specialist to manage traditional data migration using backup/restore methods for databases of varying sizes. This role covers configuring on-premises database servers and AWS EC2 instances, ensuring performance, security, and high availability throughout the migration process.

You will work with MS SQL, MySQL, PostgreSQL, and Oracle databases, optimize SQL statements, document processes, and collaborate with teammates and stakeholders to

Qualifications

• Strong proficiency in MS SQL, MySQL and PostgreSQL.
• Experience with Oracle, PostgreSQL and other SQL databases.
• Ability to write and optimize SQL statements and implement best practices.

Responsibilities

• Migrate data using backup/restore for databases of various sizes.
• Configure on-premises DB servers and AWS EC2 instances.
• Ensure performance, security, availability of databases.
• SQL Server installation, mirroring, migration, high availability, disaster recovery and Always On.
• Prepare documentation and customer processes for migration needs.
• Handle encrypted data (PII, PCI) during migrations.
• Handle upgrade, backup & restore, recovery, migration tasks.
• Profile server resources and optimize as needed.
• Collaborate with team members and stakeholders.
• Plan resource requirements from high-level specifications.

Skills

MS SQL

MySQL

PostgreSQL

Oracle

Data migration

Backup and restore

Performance tuning

Security

HA/DR

Documentation

Job description

JOB LOCATION: Anywhere in India

JOB DESCRIPTION

Key Responsibilities

• Traditional data migration using backup, restore approach for small to large size databases.
• Ensure the right configuration and objects are in place, like on-premises database servers to AWS EC2 instances.
• Ensure performance, security, and availability of databases.
• SQL Server Installation, Mirroring, Database migration, High Availability, Disaster Recovery and Always on feature.
• Prepare documentation and maintain the right set of customer processes to meet migration needs.
• Handling and migrating encrypted and different types of data (e.g.: PII, PCI etc.)
• Handle common database procedures, such as upgrade, backup & restore, recovery, migration, etc.
• Profile server resource usage, optimize and tweak as necessary,
• Collaborate with other team members and stakeholders
• Ability to plan resource requirements from high level specifications

Key Skills

• Strong proficiency in MS SQL, MySQL and PostgreSQL database management.
• Decent experience with recent versions of MySQL, MS SQL, Oracle, PostgreSQL
• Understanding of underlying storage engines of database
• Knowledge of de‑facto standards and best practices in database
• Proficient in writing and optimizing SQL statements
• Proficiency with other SQL databases