Rajesh Annam

PostgreSQL & AWS Database Administrator with 4.5+ years of hands-on experience — the last 2.6 years managing production Amazon RDS and Aurora PostgreSQL clusters, and 2 years before that running on-premise PostgreSQL environments. Comfortable owning performance tuning, high availability, backup/PITR, and CloudFormation-based infrastructure changes end to end. Also handle 24x7 production support and SOX database security compliance, most recently leading a CIDR-hardening initiative across production security groups.

PostgreSQL / AWS Database Administrator at Tata Consultancy Services — Client: GE Aerospace (2024-04 – Present)

• Administer AWS RDS PostgreSQL and Aurora PostgreSQL clusters supporting production workloads, ensuring availability, performance, and data integrity.
• Led a SOX security-hardening initiative to remove legacy CIDR ranges from RDS/Aurora security groups across production environments with zero downtime.
• Manage automated backup strategy, snapshot retention, and Point-in-Time Recovery (PITR) to meet recovery objectives.
• Monitor cluster health via CloudWatch (CPU, IOPS, storage, replica lag) and proactively tune parameters and storage to prevent incidents.
• Deploy and version-control infrastructure changes using CloudFormation templates.
• Support SOX compliance through access reviews, change documentation, and audit evidence preparation.
• Provide 24x7 on-call support for production database incidents, minimizing downtime and business impact.

PostgreSQL Database Administrator at Tata Consultancy Services — Client: Applied Materials (2022-02 – 2024-03)

• Administered PostgreSQL databases across Production, QA, and Development environments, building the operational foundation now applied to cloud-managed services.
• Configured and maintained streaming replication for high availability across critical systems.
• Executed PostgreSQL version upgrades and patching with minimal downtime.
• Implemented backup strategies using pg_dump, WAL archiving, and PITR; ran disaster recovery testing and restore validation.
• Diagnosed and resolved locking, blocking, and long-running query performance issues.
• Delivered 24x7 production support and incident troubleshooting for enterprise database systems.

Master of Computer Applications (MCA) – Sri Krishna Chaitanya Degree College (2022 – 2022)