Oracle Dba Database Administrator

Sudhakar Mekala

Oracle DBA/PostgreSQL/AlloyDB/MySQL/AWS Email id: ****************@*****.***

www.linkedin.com/in/sudhakar-mekala-23255b222 Mobile: +1-346-***-****

Summary of experience:

With 14 years of DBA experience in Oracle DBA. PostgreSQL, AlloyDB, MySQL, AWS and Aurora across various OSs (Linux, Ubuntu, Windows NT), I have expertise in installation, backup, recovery, high availability, performance tuning, data modeling and replication, having successfully delivered on all administration tasks as a Senior Database Administrator, contributing to seamless operations; directed the implementation of advanced security protocols to reduce data breaches, collaborated with the IT team to design and maintain database structures for new and ongoing projects, and managed capacity planning for efficient data storage and retrieval.

Key strengths:

Database experience using Oracle 19c/18c/12c/11g/10g/9i, SQL, PL/SQL, SQL LOADER, Stored Procedures, TOAD, Explain Plan, TKPROF FUNCTIONS, Materialized Views, Database links, and streams

Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.

Experience in using features Data pump, Flash-Back Recovery, AWR, ADDM, Grid Monitoring, and Recycle Bin.

Strong Experience with Oracle advanced features such as, RAC, ASM, Data Guard, RMAN (backup/data recovery), Oracle Advanced Compression, Oracle Advanced Security Transparent Data Encryption (TDE), Oracle Key Vault

Implemented and managed Oracle Transparent Data Encryption (TDE) to secure sensitive data at rest in compliance with industry standards (e.g., PCI-DSS, HIPAA).

Configured and maintained Oracle Wallet and Auto-Login Wallets for seamless encryption key management across multiple environments.

Performed tablespace-level and column-level encryption in Oracle 12c/19c databases to protect Personally Identifiable Information (PII).

Enabled and tested TDE key rotation and master key re-keying to support ongoing security and compliance requirements.

Integrated TDE with Oracle Key Vault (OKV) for centralized encryption key lifecycle management.

Automated the opening of TDE wallets during database startup using secure scripting and Oracle best practices.

Conducted pre-encryption impact assessments and coordinated with application teams to ensure minimal service disruption.

Validated and maintained RMAN backup compatibility with encrypted tablespaces and tested recovery scenarios involving encrypted data.

Hands-on experience with Oracle Exadata for high-performance OLTP and data warehousing environments; familiar with Oracle Key Vault (OKV) for TDE key management and integration with ZDLRA and Oracle ZFS Storage for secure and efficient backup/recovery solutions.

Coordinate with other team members to ensure software consistency across the Oracle landscape.

Will participate in the IT Change Management process and validate/approval all Oracle database related changes.

Proactively keeps abreast of new developments and forecasts of future trends in the areas of database security technology.

Good experiences in Upgradation and Migrations across all platforms.

Strong ability to handle multiple projects simultaneously through completion and ability to work independently or in a team environment and the ability to function successfully in a highly stressful environment.

Extensive experience in heterogeneous database migrations (Oracle, DB2, MySQL to PostgreSQL), homogeneous migrations (Oracle to PostgreSQL), and cloud migrations.

Good expertise in data migration efforts from on-prem to AWS Aurora PostgreSQL.

Strong expertise in handling cloud database infrastructure (AWS).

Experienced in implementing best security standards across database infrastructure.

Hands-on experience with open-source databases and data warehouses (PostgreSQL, MySQL, Aurora, RDS, and Snowflake).

Worked on Row level security for implementing multitenant applications/users.

Designed and optimized database architectures for multiple applications, ensuring scalability, high availability, and performance across diverse use cases.

Implemented table inheritance and partitioning strategies in PostgreSQL to boost query performance, enhance data organization, and reduce maintenance overhead.

Configured Foreign Data Wrapper (FDW) and DB-LINK to seamlessly access and integrate cross-platform databases, facilitating efficient data exchange between different systems.

Utilized OEM/PEM monitoring tools with Blue Medora plugin to monitor PostgreSQL database performance, providing deep visibility into key metrics and enabling proactive performance tuning.

Good exposure to the healthcare domain (Emergency Response System) and Banking & Financial domain.

Implemented build pipelines across AWS accounts to launch RDS instances based on customer requirements.

Responsible for installing, upgrading, and configuring PostgreSQL /MySQL Database clusters, including creating databases, storage structures, objects, and implementing backup and recovery strategies.

Successfully delivered on all assigned administration tasks, contributing to the seamless operation of databases at a large organization as a Senior Database Administrator

Extensive experience in query tuning and performance optimization for Oracle DBA / PostgreSQL /MySQL databases.

Experience in troubleshooting and enhancing existing stored procedures for efficiency and reliability.

Developed comprehensive data models to support business decision-making and strategic planning.

Managed PostgreSQL databases in a containerized environment using Docker, enabling efficient deployment and scalability.

Experience with Cloud SQL for PostgreSQL and MySQL, including provisioning, scaling instances, and managing database replicas.

Implementing HA / DR strategies based on application requirements.

Designed and maintained Cloud infrastructure highly available, scalable, secured, monitored and alerting network infrastructure

Proven experience assessing clients’ workloads and technology landscape for Cloud suitability, develop business case and Cloud adoption roadmap.

Having experience in handling huge volume MySQL servers with multiple instances.

Experience in different and day-to-day MYSQL DBA activities from MySQL 5.5 till the current version.

Having experience on multiple backup technologies using traditional mysqldump.

Good expertise Linux administration like handling high Swap usage, High CPU utilization, disk space issues, DB directory file permissions issue etc.

Implemented rigorous security measures across all Operating Systems to protect valuable company data.

Applied exceptional problem-solving capabilities to design, implement, and manage secure database systems

Applied expert knowledge in database design to streamline database management processes, reducing data redundancy.

Managed and delivered weekly status reports to stakeholders to ensure efficient operation of the database systems

Leveraged Agile principles in managing complex database systems, ensuring timely updates and upgrades.

Technical Skills:

Operating Systems:

Linux, CentOS, Ubuntu, Amazon Linux and Windows

Programming Languages:

SQL, PL/pgSQL, PL/SQL, PL/JAVA, Shell, PHP, Ajax, JavaScript

Databases:

Oracle, PostgreSQL, MySQL, AWS Aurora, and Gen AI

Cloud

Amazon, Azure and GCP

Tools:

Winscp, SVN Tortoise, GIT, Putty and Dockers

Utilities:

MySQL workbench, Pgadmin, DBeaver, Enterprise Monitor

Professional Experience:

1. Camp Systems Pvt Ltd – New York. Duration: Mar 2022 – Apr 2025.

Role: Senior Database Administrator.

Oversaw daily operations of Oracle DBA, PostgreSQL, MySQL and Aurora databases, managing installations, upgrades, and configurations, while implementing robust backup and recovery processes in both cloud and on-premises setups.

Responsible for doing POC for a newly introduced features, client requirements.

Planned and executed migrations with minimal downtime strategies, ensured data consistency, and conducted PostgreSQL version upgrades/patching for seamless compatibility.

Developed and maintained high availability (HA) and disaster recovery (DR)/ /business continuity(BC) strategies for database systems, ensuring resilience and uninterrupted operations.

Experience with Cloud SQL(GCP)/AlloyDB for PostgreSQL and MySQL, including provisioning, scaling instances, and managing database replicas.

Managed and resolved design issues during development stage. Interacting with developers closely.

Worked on Row level security for implementing multitenant applications/users.

Handling huge volume of data with different layers of DB as a Lead DBA.

Regularly optimized PostgreSQL, Trino, MySQL, and Aurora database performance, enhancing system efficiency and responsiveness.

Environment: Amazon/Azure/GCP Cloud, MySQL, Trino, PostgreSQL, RDS, Aurora, AlloyDB, TimescaleDB, Gen AI, Linux, Windows, Jenkins, Shell.

2. GE Healthcare/Power/Renewables/Corporate - United States Duration: Jun 2014 – Feb 2022.

Role: Lead Consultant.

Managed the setup, upgrades, and performance tuning for Oracle DBA, PostgreSQL, MySQL, and Aurora databases, ensuring high efficiency and optimal data handling.

Implemented and managed robust backup and recovery protocols for critical PostgreSQL, MySQL, and Aurora systems.

Regularly optimized Oracle DBA, PostgreSQL, MySQL, and Aurora database performance, enhancing system efficiency and responsiveness.

Planned and executed migrations with minimal downtime strategies, ensured data consistency, and conducted PostgreSQL version upgrades/patching for seamless compatibility.

Migrated databases from Oracle and SQL Server to PostgreSQL using AWS SCT and DMS.

Developed and maintained advanced reporting tools using PL/pgSQL and SQL for PostgreSQL, MySQL, and Aurora, facilitating strategic decision-making.

Experience with Cloud SQL(GCP) for PostgreSQL and MySQL, including provisioning, scaling instances, and managing database replicas.

Collaborated with development teams to swiftly resolve design issues, improving application performance and functionality across all database platforms.

Designed effective database schemas for PostgreSQL, MySQL, and Aurora to streamline data storage and retrieval.

Ensured stringent security and user access controls within PostgreSQL, MySQL, and Aurora databases to maintain compliance and data integrity.

Implemented automation of database provisioning and scaling operations using AWS CloudFormation, reducing manual work and potential errors.

Established high availability and disaster recovery/business continuity strategies for PostgreSQL, MySQL, and Aurora, ensuring continuous system operation.

Environment: Amazon/Azure Cloud/GCP Cloud, MySQL, PostgreSQL, RDS, Aurora, AlloyDB,Time Scale DB, Gen AI, Linux, Windows, Jenkins, Shell.

3. IBM India Pvt Ltd, USA/Bangalore. Duration: Jan 2010 – Jun 2014

Role: Technical Service Professional.

Led the installation, configuration, and upgrading of Oracle DBA / PostgreSQL/MySQL database environments, including database creation, object management, and performance tuning.

Implemented robust backup and recovery strategies for PostgreSQL and MySQL databases, ensuring data integrity and availability.

Conducted regular performance optimization and query tuning for PostgreSQL and MySQL databases to enhance system efficiency and response times.

Managed database cloning using scripts to facilitate efficient environment replication and testing.

Designed and implemented database schemas, including tables, indexes, and views, to optimize data storage and retrieval in PostgreSQL and MySQL environments.

Managed user access and security for PostgreSQL and MySQL databases, ensuring compliance with best security practices.

Handled extensive database migrations, both heterogeneous and homogeneous, to ensure seamless data transfer and system integration.

Environment: Oracle DBA, PostgreSQL, MySQL, Android, IOS, Java Script, Mobile Technologies, SQL, PL/pgSQL, PL/JAVA, Shell, RHEL, Windows.

Educational Qualification:

B.Tech from JNT University-2006, India.

Contact this candidate