Summary
Overview
Work History
Education
Skills
Websites
Accomplishments
Selected Highlights
Timeline
Generic
Praveen Kumar Nandagiri

Praveen Kumar Nandagiri

Mechanicsburg

Summary

Database Administrator and DB Automation Engineer with 18 years of experience in database management and cloud solutions. Expertise in optimizing database performance and enhancing data security, contributing to organizational growth. Strong communication and presentation skills enable effective team collaboration. Focused on utilizing advanced technologies to implement innovative database solutions.

Overview

20
20
years of professional experience

Work History

Senior Database Engineer/DB Automation Engineer

Acclaim Systems INC.
Reston
02.2017 - Current
  • Worked on and supported multiple flavors of relational databases as well as NoSql Databases. Supported both OLAP and OLTP database systems.
  • Databases: Oracle (11g, 12c, 19c), Postgres, sqlserver, Sybase, MySql, Redshift, Mongo DB, Dynamo DB
  • OS: AIX, SLES, Windows
  • Tools: Oracle Enterprise Manager, Toad, Dbeaver, MongoDB Compass, Sql Server management studio
  • Oracle Products: RAC, ASM, RMAN, Data Guard, Golden Gate etc..
  • Managed AWS database services like EC2, S3, EBS, VPC, Amazon RDS, Amazon DynamoDB, Amazon Aurora, Redshift.
  • Managed AZURE SQL Server databases ensuring 99.99% uptime.
  • Migrated databases on Oracle On-prem to Oracle RDS, EC2 instance, Redshift and Aurora PostgreSQL using AWS DMS (Database Migration Service).
  • Migrated onprem SQL Server databases to Azure using Azure Database Migration Service.
  • Experience using DMS (Database Migration Service) for ongoing data replication. (Homogeneous & Heterogeneous Environment).
  • Migrated Oracle On-Prem database to Oracle RDS in AWS using Goldengate.
  • Migrated Oracle On-Prem database to EC2 instance in AWS using Data guard.
  • Setup AWS Glue to read the file from S3 bucket and load into Redshift table.
  • Involved in managing database deployments, configurations, and upgrades in AWS cloud environment.
  • Involved in monitoring database performance and implementing proactive measures to prevent downtime.
  • Experience using CloudWatch in monitoring AWS services.
  • Automate routine database tasks using AWS Lambda, AWS CloudFormation, and other AWS services.
  • Monitor and optimize database costs by selecting appropriate instance types and storage options.
  • Use AWS Cost Explorer and Trusted Advisor for cost management and optimization.
  • Handling day-to-day DBA activities using db utilities and tools, monitoring space and memory requirements and Memory tuning. Checking Alert Logs, Archive Logs, Trace files and backup verifications.
  • Managed and monitored Oracle onprem databases using enterprise databases using Oracle Enterprise Manager. Also administrated Oracle Enterprise Manager by installing Manager as well as agents in db hosts, upgrading OEM as well as Agent homes.
  • Database performance tuning and query tuning, including working with sql profiles, sql baselines and sql patches. Created several sql profiles, patches, and baselines to resolve performance of time-sensitive jobs in production environment.
  • Applying PSU Patches and interim patches whenever required to make the database software up to date.
  • Planned and implemented DR & high availability solutions using Oracle Data guard.
  • Implemented and maintained Oracle Active Data Guard for real-time data replication and disaster recovery, ensuring high availability and minimal downtime for mission-critical databases.
  • Configured and managed Oracle GoldenGate for real-time data replication across heterogeneous systems, ensuring high availability and seamless data synchronization with minimal latency.
  • Participated in database engineering activities by exploring and performing proof of concepts for new database versions and releases, testing new features, database automation, Upgrading databases to new versions/releases, testing new database products etc..
  • Used lambda and step functions and integrated them into APIs for automation of AWS RDS database activities like, start & stop to optimize the cost, taking snapshots, point in time restores, snapshot restores, switchover to replica etc..
  • Developed Python-based automation scripts to streamline database operations, reducing manual workload.
  • Implemented Oracle ACFS snapshot clone process to rapidly provision space-efficient database clones, accelerating development and testing cycles while reducing storage overhead.
  • Leveraged Delphix to create virtual Oracle database clones, enabling rapid, space-efficient environment provisioning and reducing refresh time from days to minutes.
  • Extensively worked on logical backups and restores using Datapump utilities (EXPDP and IMPDP). Also automated the expdp and impdp process to restore prod database into lower environments including scrubbing customer secured data like names, ssn etc.
  • Installed, configured, and administered PostgreSQL databases across multiple versions, including 9.6, 10.11, 11, 12, 14, and 15.
  • Led cross-platform database migrations from Oracle to Amazon RDS for PostgreSQL using AWS Schema Conversion Tool (SCT).
  • Performed routine database maintenance activities such as VACUUM, VACUUM FULL, autovacuum tuning, REINDEX, and ANALYZE.
  • Optimized PostgreSQL performance through effective indexing strategies and query tuning, significantly reducing query response times.
  • Diagnosed and resolved performance issues including slow-running queries, index fragmentation, and table bloat.
  • Conducted detailed query performance analysis using EXPLAIN, EXPLAIN ANALYZE, and pg_stat_statements.
  • Developed shell scripts to monitor PostgreSQL logs, perform daily full backups, schedule weekly vacuum jobs, and track replication lag between primary and standby nodes.
  • Executed major PostgreSQL version upgrades using the pg_upgrade utility with minimal downtime.
  • Managed and monitored PostgreSQL environments using pgAdmin.
  • Performed backup and recovery operations using pg_dump and pg_dumpall.
  • Implemented PgBouncer in session and transaction pooling modes to optimize database connection management.
  • Designed and managed PostgreSQL streaming replication using repmgr to ensure high availability and failover readiness.
  • Configured repmgrd for automated monitoring, failover handling, and standby promotion.
  • Deployed and maintained Pgpool-II to provide load balancing, connection pooling, and high availability for PostgreSQL clusters.
  • Worked with application team on setting up CI/CD pipeline to automate database modifications as part of releases.
  • Supported NoSQL databases like MongoDb, Cassandra, Dynamo DB.
  • Delivered exceptional customer service while managing client relationships, resulting in a high satisfaction ratings.
  • Client: Fannie Mae | Reston, VA

Senior Database Architect

Acclaim Systems INC.
Harrisburg
11.2011 - 02.2017
  • Administrated Oracle databases of Commonwealth of PA Department of Child Welfare Information Solution(PA-COMPASS) and Unemployment Compensation System of Department of Labor and Industries.
  • Products: Oracle RAC (3 Node Cluster), Dataguard, Goldengate, RMAN
  • Operating system: AIX
  • Tools: Oracle Enterprise Manager, Toad
  • Handling day-to-day DBA activities using db utilities and tools, monitoring space and memory requirements and Memory tuning. Checking Alert Logs, Archive Logs, Trace files and backup verifications.
  • Database performance tuning and query tuning, including working with sql profiles, sql baselines and sql patches. Created several sql profiles, patches, and baselines to resolve performance of time-sensitive jobs in production environment.
  • Applying PSU Patches and interim patches whenever required to make the database software up to date.
  • Successfully Performed RMAN point in time recovery of Production database to overcome a data corruption issue.
  • Planned and implemented DR & high availability solutions using Oracle Data guard.
  • Implemented Active Dataguard for real-time data replication and reporting database purposes.
  • Participated in database engineering activities by exploring and performing proof of concepts for new database versions and releases, testing new features, database automation, Upgrading databases to new versions/releases, testing new database products etc..
  • Worked on database automation using unix shell scripts.
  • Managed and monitored Oracle onprem databases using enterprise databases using Oracle Enterprise Manager.
  • Mentored and trained Commonwealth of PA employees in Oracle RAC, ASM, Dataguard, RMAN backup and recovery.
  • Delivered exceptional customer service while managing client relationships, resulting in a high satisfaction ratings.
  • Client: Commonwealth of PA | Harrisburg, PA

Database Administrator

Wells Fargo Bank
Des Moines
10.2010 - 11.2011
  • Supporting the test and development databases of Wellsfargo Home Mortgage Core Application.
  • DB Environment:3 Node RAC Setup OSVersion: Linux x86-64 DB Version: 10.2.0.4
  • Participating in stress tests, Identifying performance bottlenecks deadlocks and other lock contention issues during stress tests and resolving them during stress tests.
  • Proactively pulled and tested bad sql’s which take significant amount of database time to execute in production and optimized them.
  • Proactive tuning, suggesting recommendations to avoid performance problems.
  • Implemented Oracle Advance security using TDE at both column level.
  • Upgrading and patching RAC and Non RAC databases.
  • Wrote Unix shell scripts & PL/SQL scripts for daily system performance & health checks.

Senior Software Engineer

Oracle India Pvt Ltd
Bangalore
01.2007 - 10.2010
  • Worked as a Global database support engineer for Oracle Database products like Real Application Clusters(RAC), Automatic Storage Management(ASM, Dataguard, Failsafe, HP and SUN Exadata machine.
  • As a Global Support DBA, troubleshooted and resolved several types of production issues of global customers in a 24
  • 7 environment.
  • Troubleshooted and Resolved issues related to Clusterware, RAC Databases, Data guard, ASM and Exadata.
  • Worked with Oracle Development teams in resolving Bugs with Oracle 9i/10g/11g on Oracle products RAC, ASM, Dataguard, Exadata, Failsafe.
  • Reproducing customer’s test cases with different DATABASE environments and on various platforms.
  • Authored several MOS(My Oracle Support) Notes.

Software Engineer

Genpact Software Services
Bangalore
11.2005 - 12.2006
  • Worked as DBA for GE Real Estates (Europe) and GE Money (U.S, Europe, Asia Pacific) application databases.
  • Maintained 20 Databases (includes Development, Testing and Production on Solaris and Linux Environments).

Education

Master’s - computer application

B.P.University of Technology
India

Skills

  • RDBMS: Oracle
  • DB2
  • Sqlserver
  • Sybase
  • MySql
  • PostgreSQL
  • SAP Hana
  • Redshift
  • Oracle Real Application Cluster (RAC)
  • OEM
  • Goldengate
  • Data Guard
  • Import and Export
  • Data Pumps
  • Data Masking
  • Oracle Wallet Management
  • Automatic Storage Management
  • Oracle Exadata
  • RMAN
  • Transparent Data Encryption
  • AWS
  • Azure
  • PL/SQL
  • UNIX Shell Scripting
  • Python
  • JSON
  • YAML
  • MongoDb
  • Cassandra
  • DynamoDB
  • Oracle Linux
  • RHEL 7
  • AIX
  • SOLARIS
  • Jenkins
  • CloudFormation
  • Terraform
  • Ansible
  • Docker
  • Kubernetes
  • GitHub
  • Bitbucket
  • AWS CloudWatch
  • Prometheus
  • Grafana
  • Dynatrace

Websites

Accomplishments

  • AWS Certified Solutions Architect Associate.
  • Certified APPS DBA. Oracle 11i Applications Database Administrator Certified Professional.
  • 11g Oracle Certified Professional.
  • 10g RAC Oracle Certified Expert.
  • Linux Administration For 10g Oracle DBA Certified.
  • Received Star Performance Award for the year 2006 from Vice President of Genpact Data Management Services for Exceptional Customer support To Ge Money Databases and implementation of 10g Grid control.

Selected Highlights

  • Migrated hundreds of Oracle and PostgreSQL databases from on-premises into the Cloud. To accomplish that goal established a process to deploy using infrastructure as code (CloudFormation) with automation tools (Terraform).
  • Experience in migrating oracle, DB2, Sql Server, Mysql databases to AWS Aurora PostgreSQL.
  • Migrated on-premises SQL Server databases to Azure using Azure Database Migration Service (DMS) with minimal downtime.
  • Built Infrastructure as Code (IaC) pipelines using Terraform and Azure Bicep to deploy and manage Azure database resources.
  • Successfully accomplished database migrations from OnPrem to RDS as well as EC2 instances with minimal downtime efforts using DMS CDC and Oracle Dataguard.
  • Developed Python-based automation scripts to streamline database operations, reducing manual workload.
  • Experienced in using Jenkins, terraform tools to eliminate repetitive and manuals processes for the provisioning of hundred servers & databases on an IaaS and PaaS model.

Timeline

Senior Database Engineer/DB Automation Engineer

Acclaim Systems INC.
02.2017 - Current

Senior Database Architect

Acclaim Systems INC.
11.2011 - 02.2017

Database Administrator

Wells Fargo Bank
10.2010 - 11.2011

Senior Software Engineer

Oracle India Pvt Ltd
01.2007 - 10.2010

Software Engineer

Genpact Software Services
11.2005 - 12.2006

Master’s - computer application

B.P.University of Technology

Similar Profiles

CREATE PROFILE
Praveen Kumar Nandagiri