Database Administrator - Oracle/SQL Server Expert (AWS)

Shashi Kiran

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

PROFESSIONAL SUMMARY

Database Administrator with 5 years of experience managing Oracle, SQL Server, and MySQL in banking, financial services, and healthcare environments. Hands-on with Oracle 11g/12c/19c covering Data Guard, RAC, RMAN, and AWR/ASH tuning. Strong SQL Server background across 2016–2022 with Always On, T-SQL optimization, and AWS RDS in regulated banking. Solid MySQL skills including replication, Percona Toolkit, and query tuning. Familiar with AWS Aurora. Experienced in keeping production databases available, compliant, and well-performing while managing everything from daily operations to DR to automation.

TECHNICAL SKILLS

Databases: Oracle 11g/12c/19c SQL Server 2016–2022 MySQL 5.7/8.0 PostgreSQL 12/13

Oracle: RAC, Data Guard, RMAN, Data Pump, AWR/ASH, OEM, PL/SQL, Stored Procedures, Tablespace Mgmt, Upgrades & Patching

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

MySQL: Master-Slave & Group Replication, Percona Toolkit (pt-online-schema-change), mysqldump, Binary Logs, EXPLAIN, Slow Query Log, InnoDB Tuning

Cloud: AWS RDS (Oracle, SQL Server, MySQL, PostgreSQL), AWS Aurora (MySQL-compatible), AWS CloudWatch, Azure SQL Database

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

Security & Compliance: TDE, SSL/TLS, RBAC, Auditing, Data Masking, SOX, PCI-DSS, GLBA, GDPR, HIPAA

Monitoring: OEM, SolarWinds DPA, AWS CloudWatch, Nagios, Zabbix, MySQL Enterprise Monitor

Scripting: Python, Shell, PowerShell, T-SQL, PL/SQL

Infrastructure: Linux RHEL/CentOS, Windows Server, VMware

PROFESSIONAL EXPERIENCE

Simmons Bank Birmingham, AL

Database Administrator September 2024 – Present

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

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

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

•Built fully automated RMAN and SQL Server backup workflows in PowerShell with scheduled jobs, completion validation, and instant failure alerts, achieving 100% backup compliance and cutting recovery time by 40%.

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

•Set up proactive monitoring through AWS CloudWatch and SolarWinds DPA with custom alerts for CPU, IOPS, storage, and query latency, preventing several potential outages through early detection.

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

Hexaware Technologies Chennai, India

Database Administrator July 2022 – November 2023

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

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

•Ran Oracle upgrades from 11g to 12c and 12c to 19c across dev, QA, and production with full rollback plans and change management sign-off.

•Tuned Oracle performance using AWR and ASH reports, optimized PL/SQL procedures and indexing reduced batch job runtimes by 18–22% across reporting-heavy client environments.

•Managed SQL Server Always On, backup jobs, index maintenance, and SSIS troubleshooting for several clients alongside T-SQL performance tuning.

•Handled MySQL replication health, slow query tuning with EXPLAIN, and live schema changes using pt-online-schema-change on 5.7 and 8.0 environments without downtime.

•Deployed and managed AWS Aurora (MySQL-compatible) for select clients cluster endpoints, read replicas, automated backups, and CloudWatch monitoring.

•Enforced HIPAA controls for the healthcare client covering audit logging, access controls, and data handling; maintained SOX and GDPR compliance for financial clients all clean on quarterly reviews.

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

Metasystems Hyderabad, India

Associate Database Administrator May 2020 – June 2022

•Supported senior DBAs in managing Oracle 11g/12c, SQL Server 2016, and MySQL 5.7 across Linux and Windows environments for internal and client-facing applications.

•Handled day-to-day database operations monitoring alert logs, checking disk space, reviewing backup job statuses, and escalating issues to senior DBAs for resolution.

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

•Helped with SQL Server Agent job monitoring, index rebuild scripts, and database growth tracking using Nagios and Zabbix.

•Managed routine MySQL tasks including mysqldump backups, user management, and health monitoring; used EXPLAIN to identify slow queries and missing indexes, reducing page load times by 25–30%.

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

•Supported a migration project involving AWS Aurora learned cluster structure, endpoint management, and basic CloudWatch monitoring.

EDUCATION

Master of Science in Computer Science Jan 2024 – May 2025

University of Alabama at Birmingham (UAB) Birmingham, AL

Bachelor of Technology in Computer Science & Engineering Aug 2017 – May 2021

Kakatiya University Warangal, India

Contact this candidate