TCS is looking for a Database Migration Specialist

(Candidate needs to be located or relocate to Querétaro, CDMX, Guadalajara or Monterrey, it will be requested to attend office at least 3 day per week)

Job Summary

We are seeking an experienced Database Migration Specialist with strong expertise in AWS RDS PostgreSQL, Cloud Database Administration, and SQL Server Administration . The candidate will be responsible for planning, designing, and executing database migration projects from on-premises environments to AWS RDS PostgreSQL while ensuring high availability, security, performance, and compliance. The role requires hands-on experience with database administration, backup and recovery, monitoring, access management, encryption, and migration of best practices.

Key Responsibilities

Database Migration & Modernization

- Lead end-to-end database migration initiatives from On-Premises databases to AWS RDS PostgreSQL .
- Assess existing database environments and develop migration strategies, runbooks, and execution plans.
- Perform schema conversion, data migration, validation, and post-migration optimization.
- Identify and mitigate migration risks while ensuring minimal downtime.
- Support application teams during migration planning, testing, and production cutovers.
- Administer and manage AWS RDS PostgreSQL environments.
- Configure and maintain RDS instances, parameter groups, option groups, and storage settings.
- Monitor database health, performance, and availability using AWS native monitoring tools.
- Perform performance tuning, capacity planning, and resource optimization.

SQL Server Administration

- Manage and support Microsoft SQL Server environments.
- Monitor database performance and troubleshoot SQL Server issues.
- Plan and execute SQL Server upgrades, patching, and maintenance activities.




- Support migrations from SQL Server to PostgreSQL where applicable.

Database Operations

- Configure and manage database backup, restoration, and disaster recovery processes.
- Schedule and maintain database jobs and routine maintenance tasks.
- Implement and support database replication, failover, and high-availability configurations.
- Ensure database operational excellence through proactive monitoring and alert management.

Monitoring & Support

- Monitor AWS RDS and database infrastructure for performance, availability, and security events.
- Troubleshoot complex database issues and provide root cause analysis.
- Develop operational documentation, SOPs, and knowledge transfer materials.
- Collaborate with cloud, infrastructure, application, and security teams.

Required Skills & Experience

- Strong experience as a Cloud DBA .
- Hands-on experience migrating On-Premises Databases to AWS RDS PostgreSQL .
- AWS RDS monitoring and performance management.
- Database backup, recovery, and disaster recovery planning.
- Database job scheduling and maintenance automation.
- Database access control, authentication, and authorization management.
- Database encryption and security implementation.
- Performance tuning and troubleshooting for PostgreSQL and SQL Server.
- Experience with AWS services related to database operations.

What we offer to you:

- Direct contract
- Benefits above law

Tata Consultancy Services is an equal opportunity employer, our commitment to diversity & inclusion drives our efforts to provide equal opportunity to all candidates who meet our required knowledge & competency needs, irrespective of any socio-economic background, race, color, national origin, religion, sex, gender identity/expression , age, marital status, disability, sexual orientation or any others. We encourage anyone interested to build a career in TCS to participate in our recruitment & selection process.

#J-18808-Ljbffr

📌 Database Migration Specialist (Monterrey)
🏢 Tata Consultancy Services
📍 Monterrey