Home

Madhu Ponugoti - Oracle DBA

[email protected]

Location: Alpharetta, Georgia, USA

Relocation: Yes

Visa: H1B

Madhu Ponugoti Phone:678) 707-2060 | Email:[email protected] PROFILESUMMARY Oracle, Postgres, DB2, SQL Serverand Azure Certified professional with over 14 years of experience in administration, development, architecture, designing and enhancement services. Excelled in Developer and DB administer roles. Skilled at defining data, DB and OS security, supporting users, improving accessibility, DB modeling, migrating data, and training staff. Primed to exceed expectations in roles demanding strong leadership, problem-solving skills, and excellent documentation. CORE COMPETENCE Database Administration PL/SQL, psql Development Performance Tuning Data Replication Data Security, Backup & Recovery Standby/Failover Administration DB vulnerabilities & Compliance Verbal & Oral Communication Leadership & Teambuilding TECHNICAL SKILLS Operating Systems: Sun Solaris,UNIX/ Red Hat Linux, Windows RDBMS: 10g, 11g,12C, 19c, DB2, Postgres 13.7, SQL Server NOSQL: Mongo 7.0 Languages: SQL, PL/SQL, PostgreSQL,NoSQL, Shell Scripting Tools: RMAN, OEM, SQL*Loader,Studio 3T, TOAD, Putty, WinSCP, Golden Gate, pgAdmin Tuning Tools: TKPROF, Explain Plan, SQL*TRACE, AWR, ADDM, ASH Others: Azure, OCI, OIM,Jira, SVN, Power BI, GitHub, Informatica, ServiceNow, SISS, SSRS WORK EXPERIENCE Client: AT&TMobility Alpharetta, GA Sr. Oracle Database Administrator Dec 2013- May 2024 Involved in database design, development, installation, configuration, upgrades, replication, cloning, backup/recovery, performance tuning and security for Oracle,Postgres, DB2 LUWand SQL server databases. Coordinated withfrontend and business teams to provide them with required stored procedures and packages and the necessary insight into data. Coordinated and planned with Application teams on Oracle, Postgres and SQL server capacity and data modelling/design for new applications/requirements. Implemented SQL, PL/SQL, PostgreSQL stored procedures/packages, shell scripting for business needs and database monitoring. Experience in working ETL tool ODI against different versions of Oracle databases. Responsible for designing, developing, and testing ETL strategy to populate data from various source system feeds using ODI. Creation of database objects like tables, views, Materialized views using Oracle tools like Oracle Toad and SQL Developer. Handled errors using exception handling extensively for the use of debugging and displaying error messages in the application. Extensively used EXPLAIN PLAN, SQL* Trace, TKPROF and AUTOTRACE for optimizing database queries for performance tuning. Check in developed code using version control tools like GitHub or SVN. Developed, debugged, and optimized PostgreSQL queries for reporting and app development. Ensured the timely application of patches and upgrades to Postgres, Exadata, Mongo and Oracle databases. Successfully set up Oracle Goldengate one-way and bi-directional replication with conflict detection and resolutions for Exadata and Teradata databases. All scripts (COBOL ,JCL) transformed into Linux reusable programs like Job Scheduler, Job Launcher, and Execution programme Oracle Database. Excellent experience with Golden Gate between Oracle and Postgres databases. Ensured compliance with AT&T data security policies by setting up FGA, data encryption, and restricting user privilege access. Created data definitions, specifying JCL files or datasets to be used as input or output for the job. Created Cobol copybook files (.cpy& .cbl files) using the extract specification templates and created source definitions. Implemented ETL processes to load data into reporting databases from upstream applications and Azure MI. Configured Oracle Enterprise Manager for database monitoring and maintenance activities including log checks, space management, undo management, and database statistics gathering. Collaborated with CSO teams to maintain compliance with AT&T CSO recommended policies and audit requirements. Maintained appropriate documentation for the Threat & Vulnerability Management Program, Policy, and Procedures. Managed user creation and maintenance of privileges, profiles, roles, schemas, table spaces, and other database objects in SQL Server, DB2, Postgres and Oracle Databases. Deployed database changes across multiple environments as per billing releases. Provided 24/7 on call support on a rotational basis. Environment:Azure,Oracle 19c/12C/11g, DB2, OCI, OIM, Teradata, Postgres, Mongo,UNIX scripting, GoldenGate, RAC, DATAGUARD, RMAN, Putty, WinSCP, Data Pump, Data warehouse, GitHub, ETL, SQL, PL/SQL, pgpool, psql, pgbouncer, Phyton, Linux, ora2pg, OEM, ETL, Toad, SQL Tuning. Client: Georgia Department of Transportation Atlanta, GA Database Administrator June 2012 - Nov 2013 Contributed to process improvement, Oracle DB installations/upgrades/patches, space management, capacity planning, backup & recovery, disaster recovery, database performance tuning, memory tuning, application tuning, security administration, data guard, real application clusters, and standby database configurations. Installation and configuration of Oracle 11g DB s and creation of multi-terabyte databases in Solaris and Linux environments. Installing and configuring 10g Real Application Clusters (RAC). Troubleshoot performance problems. Performed database monitoring and maintenance activities including log checks, space management, undo management, database statistics gathering, and cron job scheduling. Established and monitored database RMAN backup and data pumps. Troubleshot and resolved Oracle database issues through careful monitoring and analysis of alert logs and user trace files. Streamlined database startup and shutdown processes through automation for increased efficiency. Implemented multi-directional Golden Gate replication in non-prod & prod environments. Developed load scripts using SQL*Loader for efficient data loading. Created PL/SQL packages, stored procedures, and functions based on business requirements. Perfected performance tuning techniques to handle large-scale data processing. Developed shell scripts for monitoring, troubleshooting, and resolving issues with daily batch and other jobs. Environment: Goldengate, Oracle 10g/11g, MySQL, RAC, OEM (Grid Control), RMAN, Data Guard, Data Pump, Putty, Linux Client: AT&T Mobility- Alpharetta, GA Database Administrator/Developer Nov 2009 - May 2012 Coordinated with Development, Testing, WebLogic, and SA teams to fulfill job requirements. Performed import and export operations using Oracle Data pump utilities EXPDP and IMPDP. Installed and applied the latest patches to Oracle databases for enhanced functionality and security. Involved in Database upgrade from Oracle9i to Oracle 10g. Implemented recovery strategies through the establishment of a recovery catalog and regular backup testing using RMAN. Optimized data loading using SQL*Loader for seamless integration of various data types into the Oracle database. Installed and configured Oracle Enterprise Manager for database monitoring and performance tuning. Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR and ADDM reports. Created Unix Shell scripts to automate database operations. Created and maintained all databases required for development, testing, and production usage. Implemented standby database and database replication to ensure high availability. Implemented partitioning for large tables to improve performance and developed PL/SQL packages. Administered all database objects, including tables, clusters, indexes, views, packages, and procedures. Environment: Goldengate, Oracle 11g/10g, RAC, ASM, DATAGUARD, RMAN, Data Pump, Putty, SVN, Windows, Linux, GRID, DBMS_SCHEDULER, MySQL, T-SQL EDUCATION & PROFESSIONAL DEVELOPMENT Master s degree in computer science engineering from University of Bridgeport Jan 2007- Dec 2008 Keywords: business intelligence database procedural language Georgia Michigan