Srikanth Kata

Architected and supported high-availability Aurora PostgreSQL platforms for mission-critical workloads. Designed PostgreSQL architectures supporting high-throughput transactional systems and analytical workloads. Implemented pgBackRest-based backup strategies with full, differential, incremental backups and PITR. Performed major version upgrades with minimal downtime using blue/green and replica-based approaches. Proactively handled performance troubleshooting (CPU load, locks, blocking sessions, long-running queries, index optimization). Built monitoring using CloudWatch and Prometheus for database health and capacity planning. Automated PostgreSQL operations using Shell and Python scripts.

Designed and administered PostgreSQL on AWS EC2 and RDS for multi-TB production databases. Planned and executed database migrations using AWS DMS. Tuned PostgreSQL for mixed workloads (OLTP + analytics) using indexing strategies, vacuum tuning, and read replicas. Implemented secure PostgreSQL configurations, access control, and compliance-oriented monitoring. Supported containerized workloads and PostgreSQL deployments with Kubernetes exposure.

Designed PostgreSQL upgrade strategies and performed major and minor version upgrades. Built streaming replication and HA architectures using Repmgr and Pgpool. Implemented routine maintenance automation (vacuum, analyze, reindex, backup validation). Optimized complex queries using EXPLAIN, pg_stat_statements, and index tuning. Administered large PostgreSQL environments supporting reporting and OLTP workloads.

• Administered and optimized PostgreSQL and MySQL databases, implementing advanced clustering and performance tuning techniques. • Configured MSSQL Log Shipping and Mirroring for disaster recovery across multiple data centers. • Implemented Oracle RAC for enhanced performance and availability, ensuring seamless failover during planned and unplanned outages. • Designed Oracle DR solutions using Data Guard, ensuring minimal downtime and data loss. • Designed and implemented MySQL NDB Cluster for horizontal scalability, improving data distribution and load balancing across nodes. • Administered and optimized PostgreSQL, Oracle, MSSQL and MySQL databases, implementing advanced performance tuning techniques. • PostgreSQL VACUUM processes to prevent bloat and maintain high database performance. • Set up PostgreSQL clustering for high availability, reducing the risk of downtime during critical operations. • Index management and optimization to speed up query execution on Databases. • Automated backups and replication monitoring for PostgreSQL, Oracle, MSSQL and MySQL databases using Bash and PowerShell. • Worked on PostgreSQL query tuning by analyzing execution plans and using tools like EXPLAIN and pg_stat_statements. • Managed MySQL Cluster with multi-master replication, ensuring zero-downtime failover and high availability for production systems. • Ensured high availability using MySQL replication and PostgreSQL streaming replication. • Applied patches and maintained database security, ensuring high availability and disaster recovery.

Supported PostgreSQL and MySQL production systems. Designed backup, recovery, and DR strategies. Performed performance tuning and proactive monitoring.

Administered PostgreSQL environments with replication, backups, and performance optimization. Delivered 24x7 production support and incident management. Automated operational DBA tasks using shell scripting.

• Supported and optimized PostgreSQL, Oracle, MSSQL and MySQL databases, focusing on query optimization, backup, and recovery. • Handled day-to-day database tuning and replication monitoring for MySQL and PostgreSQL in production environments. • Automated database administration processes, leveraging Bash and Python scripting. • Developed automated backup and disaster recovery plans for PostgreSQL, Oracle, MSSQL and MySQL. • Worked extensively with MySQL Workbench for performance tuning and query optimization. • Set up MSSQL Log Shipping for disaster recovery and Mirroring for high availability. • Administered Oracle RAC for load balancing and high availability across multiple nodes. • Implemented Oracle Data Guard to ensure data consistency and disaster recovery across multiple sites. • Database partitioning in MySQL and PostgreSQL to improve query performance on large datasets.

Managed PostgreSQL clusters, replication, and patching cycles. Tuned high-volume databases and supported application teams.

• Administered PostgreSQL, Oracle, MSSQL and MySQL databases, performing backup and recovery, replication, and tuning. • Worked on database encryption and security policies to safeguard data. • Used pgAdmin and other PostgreSQL tools to monitor and optimize database performance.

PostgreSQL architecture optimization.

BSC Computers