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