Senior Database Administrator (Amazon Aurora)

The Amazon Aurora PostgreSQL Database Administrator (DBA) is responsible for managing, optimizing, securing and maintaining cloud-native relational database systems on AWS. This role focuses on ensuring database performance, availability, scalability and security while supporting cloud migrations, automation initiatives and disaster recovery strategies across enterprise environments.

Key Responsibilities

Database Administration

• Provision, configure, monitor and maintain Amazon Aurora PostgreSQL and Amazon RDS databases.
• Perform database installation, upgrades, patching and lifecycle management.
• Monitor database health, capacity and performance metrics.

Performance Optimization

• Analyze and optimize SQL queries and database workloads.
• Implement indexing strategies and query tuning best practices.
• Manage connection pooling and resolve infrastructure bottlenecks.
• Troubleshoot and resolve database performance issues.

High Availability & Disaster Recovery

• Design and implement Multi-AZ deployments and cross-region replication.
• Develop, test, and maintain backup and disaster recovery processes.
• Ensure database availability and business continuity objectives are met.

Cloud Migration & Modernization

• Lead or support database migration initiatives to Aurora PostgreSQL.
• Utilize AWS Database Migration Service (DMS) and Schema Conversion Tool (SCT) for migration projects.
• Perform migration assessments, validations and post-migration optimization.

Security & Compliance

• Implement security controls, database encryption and access management.
• Apply database patches and vulnerability remediation activities.
• Ensure compliance with organizational and regulatory security standards.
• Perform periodic security reviews and audit support activities.

Technical Skills

• Strong expertise in PostgreSQL architecture, replication, backup and recovery.
• Deep knowledge of AWS database services, including: Amazon Aurora PostgreSQL, Amazon RDS, AWS DMS, AWS SCT, CloudWatch, IAM, KMS
• Experience with database performance tuning and troubleshooting.
• Proficiency in scripting languages such as Python, Bash, or PowerShell.
• Experience with Infrastructure-as-Code tools including Terraform, Ansible or CloudFormation.
• Familiarity with CI/CD tools and DevOps practices.

What can you expect from us?

• Professional development and constant evolution of your skills, always in line with your interests.
• Opportunities to work outside Brazil
• A collaborative, diverse and innovative environment that encourages teamwork.

What do we offer?

• TCS Benefits – Brazil:
• Health insurance
• Dental Plan
• Life insurance
• Transportation vouchers
• Meal/Food Voucher
• Childcare assistance
• Totalpass
• TCS Cares – free 0800 that provides psychological assistance (24 hrs/day), legal, social and financial assistance to associates
• Partnership with SESC
• Reimbursement of Certifications
• Free TCS Learning Portal – Online courses and live training
• International experience opportunity
• Discount Partnership with Universities and Language Schools
• Bring Your Buddy – By referring people you become eligible to receive a bonus for each hire
• TCS Gems – Recognition for performance
• Xcelerate – Free Mentoring Career Platform

At TATA Consultancy Services we promote an inclusive culture, we always work for equity. This applies to Gender, People with Disabilities, LGBTQIA+, Religion, Race, Ethnicity. All our opportunities are based on these principles. We think of different actions of inclusion and social responsibility, in order to build a TCS that respects individuality. Come to be a TCSer!