Database Migration Engineer

Tata Consultancy Services; Bengaluru; On-site; INR 700,000 - 1,200,000; Full time

Job summary

Tata Consultancy Services is seeking a Database Developer/Engineer in Bengaluru, India. The ideal candidate will have between 5 to 12 years of IT experience, focusing on traditional data migration and database management.

Responsibilities include performing data migrations, ensuring database performance, and collaborating with team members on various projects. Strong proficiency in MS SQL and MySQL, as well as expertise in optimizing SQL, are essential for this role.

Qualifications

• 5 to 12 years of IT experience in database development and migration.
• Strong understanding of database performance, security, and availability.
• Experience with various SQL databases.

Responsibilities

• Perform data migration for small to large databases.
• Ensure database configuration for AWS EC2 instances.
• Maintain database security and performance.
• Prepare documentation for customer processes.
• Optimize server resource usage and collaborate effectively.

Skills

MS SQL

MySQL

PostgreSQL

SQL optimization

Database management

Job description

Overview

TCS Hiring for Database Developer/ Engineer

Experience Range: - 05 To 12 Years (Mandatory)

(Note: Candidates below 5 years of IT experience shall not be considered)

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