Database Administrator (Oracle/SQL Server/AWS/Azure)

SHASHI KIRAN

Birmingham, AL 205-***-**** ***********.******@*****.*** linkedin.com/in/shashi-kiran-dba PROFESSIONAL SUMMARY

DBA with 5 years of production experience in banking, financial services, and healthcare also with enterprise reporting and analytics support experience. Core expertise in Oracle (11g/12c/19c), SQL Server (2016-2022), MySQL, and PostgreSQL covering high availability, disaster recovery, performance tuning, and compliance in regulated environments. Hands-on across AWS RDS, AWS Aurora, and Azure SQL with experience deploying and managing databases in cloud-native and hybrid environments. Familiar with MongoDB for document-based workloads. Proven ability to maintain 99.9% uptime across multi-terabyte transactional systems while meeting SOX, PCI-DSS, and HIPAA requirements. TECHNICAL SKILLS

Databases Oracle 11g/12c/19c, SQL Server 2016-2022, MySQL 5.7/8.0, PostgreSQL 12/13, MongoDB Oracle RAC, Data Guard, Goldengate, RMAN, AWR/ASH, OEM, PL/SQL, Data Pump, Tablespace Management, Upgrades and Patching

SQL Server Always On AG, Log Shipping, Mirroring, T-SQL, SSIS, SSMS, Execution Plans, Index Tuning, SQL Server Agent, Upgrades and Patching

MySQL Master-Slave and Group Replication, Percona Toolkit, InnoDB Tuning, Slow Query Log, EXPLAIN, mysqldump, Binary Logs

Cloud AWS RDS (Oracle, SQL Server, MySQL, PostgreSQL), AWS Aurora, AWS EC2, Azure SQL Database, Azure Monitor, GCP Cloud SQL, Docker

HA and DR Oracle Data Guard, Oracle RAC, Oracle Goldengate, SQL Server Always On, Log Shipping, MySQL Replication, PostgreSQL Streaming Replication

Security TDE, SSL/TLS, RBAC, Auditing, Data Masking, SOX, PCI-DSS, GLBA, GDPR, HIPAA Monitoring SolarWinds DPA, DataDog, OEM, AWS CloudWatch, Azure Monitor, Nagios, Zabbix Scripting Python, PowerShell, Shell, T-SQL, PL/SQL Infrastructure

Other skills

Linux RHEL/CentOS, Windows Server, VMware

Azure SQL Database, Azure SQL Managed Instance, GitHub, CI/CD Pipelines, Power BI, Data Warehouse Support, Operational Data Store (ODS)

PROFESSIONAL EXPERIENCE

Simmons Bank (Remote, US)

Database Administrator (September 2024 – Present)

• Manage Oracle 19c and SQL Server 2019/2022 production databases across AWS RDS and Azure SQL totaling 6-7 TB across accounts, loans, deposits, and ACH transactions, maintaining 99.9% uptime with zero unplanned outages.

• Own Oracle Data Guard and SQL Server Always On end-to-end including standby configuration, log transport, sync monitoring, and quarterly failover drills ensuring both platforms are always recovery ready.

• Supported Azure SQL databases used by operational and reporting teams, working closely with analysts to improve query performance and ensure reliable access to business-critical data. Maintained database standards, operational procedures, recovery documentation, and environment configuration records to support production support and audit requirements.

• Improved query performance by 20-25% on financial reporting workloads through T-SQL rewrites, execution plan analysis, and index tuning; use Oracle AWR and ASH reports to catch bottlenecks before they impact production.

• Built fully automated RMAN and SQL Server backup workflows in PowerShell with job scheduling, completion validation, and failure alerting, achieving 100% backup compliance and cutting recovery time by 40%.

• Performed production-to-nonproduction database refreshes for testing and validation activities while ensuring data protection and compliance requirements were maintained.

• Maintain SOX, PCI-DSS, and GLBA compliance through TDE, SSL/TLS, RBAC, and access reviews with zero findings across two consecutive audits.

• Set up proactive monitoring via AWS CloudWatch, Azure Monitor, and DataDog with custom thresholds for CPU, IOPS, storage, and query latency, preventing multiple potential outages through early detection.

• Handle all patching, upgrades, and capacity planning on AWS RDS, coordinating changes with application teams in low-traffic windows with zero unplanned downtime.

• Partner with DevOps teams on CI/CD deployments reviewing schema changes, coordinating release windows, and validating database readiness before every production push.

Hexaware Technologies (Chennai, India)

Database Administrator (July 2022 - November 2023)

• Administered Oracle 11g/12c/19c, SQL Server 2016/2019, MySQL 5.7/8.0, PostgreSQL 12/13, and AWS Aurora for 5+ global clients in banking, financial services, and healthcare, maintaining 99.9% uptime across all environments.

• Built and managed Oracle RAC clusters, Data Guard configurations, and Goldengate replication streams for banking clients including standby setup, switchover drills, and node health monitoring to meet RTO/RPO commitments.

• Led Oracle upgrades from 11g to 12c and 12c to 19c across dev, QA, and production with complete rollback plans and change management sign- off. Supported database environments used for enterprise reporting and analytics workloads, assisting development and reporting teams with performance tuning and data access requirements.

• Reduced batch job runtimes by 18-22% through AWR/ASH-driven Oracle tuning, PL/SQL optimization, and targeted indexing across reporting- heavy client environments.

• Managed SQL Server Always On, index maintenance, backup jobs, and SSIS troubleshooting alongside T-SQL performance tuning for multiple banking clients. Worked with application teams and reporting users to troubleshoot data issues, optimize SQL workloads, and support business intelligence initiatives across client environments.

• Handled MySQL replication health, slow query tuning with EXPLAIN, and zero-downtime schema changes via Percona Toolkit pt-online-schema- change on 5.7 and 8.0 environments.

• Managed PostgreSQL 12/13 databases for select clients covering streaming replication setup, pg_dump and pg_restore backup workflows, and query tuning using EXPLAIN ANALYZE, ensuring data integrity and performance across reporting workloads.

• Extended Oracle Goldengate replication streams to support real-time data synchronization across heterogeneous environments, participating in configuration, monitoring, and trail file management for banking clients.

• Supported MongoDB document store deployments used alongside relational databases for application caching and event logging workloads, handling user management, index creation, and instance health monitoring.

• Deployed and managed AWS Aurora (MySQL-compatible) clusters for banking and healthcare clients including read replica configuration, automated backups, and CloudWatch and DataDog dashboards with custom alarms, reducing incident response time by 30%.

• Developed automation scripts using Shell and Python to simplify routine database administration tasks, deployment validation, and operational health checks. Enforced HIPAA controls for healthcare clients and maintained SOX and GDPR compliance for financial clients with zero findings on all quarterly reviews.

• Automated health checks, backup validation, disk monitoring, and log cleanup using Shell and Python, reducing repetitive manual effort across the multi-client environment.

Metasystems (Hyderabad, India)

Associate Database Administrator (May 2020 - June 2022)

• Supported senior DBAs managing Oracle 11g/12c, SQL Server 2016, MySQL 5.7, and PostgreSQL across Linux and Windows environments, monitoring alert logs, disk space, and backup jobs and escalating issues as needed.

• Assisted with Oracle tablespace monitoring, RMAN backup scheduling, user management, and Data Pump exports and imports.

• Helped maintain SQL Server Agent jobs, index rebuild scripts, and database growth tracking using Nagios and Zabbix.

• Managed MySQL backups, user accounts, and routine health checks; used EXPLAIN to identify slow queries and missing indexes, reducing page load times by 25-30%.

• Assisted with MySQL master-slave replication setup, lag monitoring, and error resolution.

• Supported an AWS Aurora migration project gaining hands-on experience with cluster structure, endpoint management, and CloudWatch monitoring.

EDUCATION

Master of Science in Computer Science (January 2024 - May 2025) University of Alabama at Birmingham (UAB) Birmingham, AL Bachelor of Technology in Computer Science and Engineering (August 2017 - May 2021) Kakatiya University Warangal, India

Contact this candidate