Prakash Reddy
Houston,TX
Summary
Dynamic Database Automation Engineer with extensive experience at Energy Transfer Partners L.P., specializing in Oracle Exadata administration and automated database management. Proven track record in SQL tuning and Ansible playbook development, enhancing system performance and reliability. Strong problem-solving skills complemented by a commitment to high availability and disaster recovery solutions.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Database Automation Engineer
Energy Transfer Partners L.P
06.2023 - Current
- Administer and support Oracle Exadata, Oracle ADB, Oracle 19c RAC , and mission-critical databases across Production and Non-Prod environments.
- Perform Oracle installations, patching, upgrades, RU/PSU cycles , health monitoring, and Exadata storage checks.
- Manage and optimize Oracle RAC, ASM, Clusterware, and Data Guard for high availability and disaster recovery.
- Conduct AWR/ASH analysis , SQL tuning, wait-event analysis, and performance troubleshooting for enterprise systems.
- Automate ADB operations, including refreshable clones, wallet management, metadata extraction, and OCI CLI-driven tasks.
- Develop advanced Ansible playbooks for patch automation, CMAN monitoring, backup validation, Data Guard checks, SQL execution, and environment provisioning.
- Build and maintain Azure DevOps CI/CD pipelines, integrating Liquibase, ADB scripts, automated testing, and multi-stage deployments.
- Use Liquibase for database schema governance, versioning, rollback, deployment validation, and automation.
- Implement TDE encryption , wallet rotation, and encryption compliance across RAC and ADB fleets.
- Manage RMAN backups , PITR operations, restore validations, and integration with automated Ansible workflows.
- Administer PostgreSQL databases for Liquibase DMC, ensuring stability and performance.
- Create and maintain shell scripts for health checks, log analysis, CMAN reports, AWR generation, and operational automation.
- Migrate applications and databases from on-premises to Azure using Kubernetes, Docker, and Azure DevOps.
- Manage incidents, change requests, and production deployments through ServiceNow .
- Participate in a 24×7 on-call rotation, resolving incidents for Exadata, ADB, RAC, backups, and performance issues.
DevOps Engineer
Berm Tec
12.2022 - 06.2023
- Built and maintained Azure DevOps CI/CD pipelines for Java microservices across Dev, QA, and UAT.
- Integrated Liquibase for schema validation, rollback, and automated DB migrations in pipelines.
- Developed Ansible playbooks for server provisioning, configuration management, log cleanup, patching checks, and deployments.
- Provided production support for Java microservices , including JVM monitoring, log analysis, performance debugging, and restart automation.
- Managed Git branching strategies, merge requests, and release pipeline workflows.
- Automated health checks using Bash, Python, and Ansible improve environment visibility.
- Supported Azure VM configuration, pipeline variables, environment parameters, and release orchestration.
- Coordinated deployments with QA, development, and release management teams for smooth go-lives.
Database Administrator
Outgrow.Today
01.2020 - 07.2021
- Installed, configured, and supported Oracle 12c/19c databases across development and production.
- Performed SQL tuning, AWR/ASH analysis , index optimization, and performance troubleshooting.
- Supported Oracle RAC and ASM clusters, including node failovers, disk group management, and performance tuning.
- Managed Data Guard for DR, monitored log transport, and conducted DR testing.
- Executed RMAN backups , restore validations, clone refreshes, and PITR operations.
- Developed SQL, PL/SQL, and shell scripts for health checks, backup reports, log cleanup, and automation.
- Built Azure DevOps pipelines for database deployments, and integrated database version control processes.
- Implemented Liquibase for schema versioning, controlled deployments, rollback workflows, and validations.
- Created Ansible playbooks for routine DBA tasks, including AWR jobs, health reports, and maintenance automation.
- Used OEM Cloud Control for monitoring, capacity planning, and alert triage.
- Provided 24/7 on-call support for production issues, and coordinated with Linux teams for OS-level troubleshooting.
Software Intern
Outgrow.Today
07.2019 - 12.2019
- Assisted in backend development using SQL, debugging, analytics reporting, and data validation.
- Supported deployment tasks in Linux environments, and documented internal procedures.
- Used Git for version control, and participated in Agile sprint activities.
Education
Master of Science - Computer Information Systems
Christian Brothers University
Memphis, TN12-2022
Bachelor of Science - Mechanical Engineering
JNTUH
Hyderabad, India05-2019
Skills
- Oracle Exadata administration
- Automated database management
- SQL tuning
- Ansible playbook development
Certification
- Liquibase Certified Administrator (LBE101, LBE102)
- Azure Administrator Associate
- AWS Cloud Practitioner
- Oracle ADB Specialist – In Progress
- OCI Foundations – In Progress
- Certified Kubernetes Administrator
Languages
English
Telugu
Hindi
Timeline
Database Automation Engineer
Energy Transfer Partners L.P
06.2023 - Current
DevOps Engineer
Berm Tec
12.2022 - 06.2023
Database Administrator
Outgrow.Today
01.2020 - 07.2021
Software Intern
Outgrow.Today
07.2019 - 12.2019
Master of Science - Computer Information Systems
Christian Brothers University
Bachelor of Science - Mechanical Engineering
JNTUH