Oracle DBA and PL-SQL development

VENKATA POTHURI (PRASAD)

*** ****** **, ***** **********, NJ 07080

732-***-**** (Cell); email: ********@*******.***

SUMMARY:

Over 23 years of IT experience, with 10 years of Core Oracle DBA with PL/SQL and Golden Gate, 6 years dedicated to System Testing and ensuring Software Quality, and 6 years of Tier (Production) Support and 1 year of Systems Engineering. Lead Application DBA with Golden Gate expertise for AT&T Provisioning Systems responsible for Database Integrity for every Release during Deployments per Corporate Guidelines and ensure security in replication of Databases using Golden Gate

Worked with business requirements to define test plans, write test cases and executing them manually and using Automated Tools. Applications worked on have been in IP Provisioning Services, HR and education training which involves order processing, payment, and customer service and Family Welfare. Software tool proficiency includes Automated System Testing Tools Win Runner, Load Runner, PowerBuilder, PL/SQL Oracle, Sybase, Perl and Unix.

Polite & dedicated Team Player with high tolerance & patience level, humorous nature and good in communication & interpersonal skills

Education: M.S. Louisiana State University, Baton Rouge, LA. Nov 1994

B.S. A.P. A.U, India. April 1984

Software: Oracle Golden Gate 12c, TOAD, Win Runner 7.0, Load Runner, Test Director, QTP, PowerBuilder, Crystal Reports, C, C++, Shell, PERL, JAVA, SAS, COGNOS Impromptu, Powerplay, Report Net, Visio, Adobe Photoshop, DreamWaver, SEO, Snowflake, Python 3.x, AWS Cloud

Operating Systems: Windows Vista, Windows NT/ 95/98, XP, Windows Vista, UNIX, MS-DOS

Databases: Oracle 7.3/8.0/9.0/10.0/11g,12c,18c; Sybase, Informix, DB2, Ms SQL, Watcom SQL

Oracle Certified Associate 11g

Status in US: U.S. Citizen

EXPERIENCE:

ORACLE APPLICATION DBA, PL/SQL Developer, MTA, Manhattan, NY (Oct ’18 – Oct ‘20)

Lead Developer for Oracle DBA (12c) with PL/SQL supporting small team of 10 people. DB Design for On Job Training (OJT) and Employee Compliance Reporting (ECR) for MTA Head Quarters and build the PL/SQL packages based on the business requirements for front-end GUI Developers. PL/SQL programs for Inspections and Observations for Observed Employees by Testing Officers based on the Courses offered by MTA to be in compliance with rules & regulations of LIRR & MNR planning, engineering and operations departments and building QUOTA for various Process Roles assigned. Responsible for Reference Data and Schema changes in Development, System Testing and UAT environments and load reference data using SQL Loader. Troubleshoots and resolves database, application, and development related problems. Rebuilt the existing Procs using Bulk Collect functionality with For All usage in PL/SQL in most of my programs for handling performance issues by reducing context switches. Generated XML data using standand dbms_xmlgen.getxml functions and populate Actual Data count for Testing Officers for their Rail Inspections using PL/SQL so it can be retrieved in front-end Power BI Reports and Dashboards.

As a DBA involved in Performance Tuning using AWR, ASH, ADDR & enhance Database Security via Redaction. Used extensively TKPROF utility to troubleshoot the SQL performance issues faced by user sessions. Besides, the responsibilities include but not limited to administration, installation, configuration, troubleshooting, monitoring, integration, backup/recovery (RMAN), optimization, and problem resolution. Responsible for compliance with Security Technical Implementation Guides (STIG).

Worked on POC on migrating the Oracle Database from on-premise to AWS Cloud

ORACLE APPLICATION DBA with Golden Gate, AT&T, Middletown, NJ (Feb ’08 – Jul’18)

Plan, coordinate, and administer database systems, including base definition, structure, documentation, requirements, and operational guidelines for AT&T Provisioning Systems.

Responsible for Reference Data and Schema changes in Development and IT environments for more than 100 projects with 120 developers every release and have DB INTEGRITY with SCME (Source Control Management Environment) and SVN. Responsible for DB Design & optimize the schema changes with integrity for efficient Environments. Troubleshoots and resolves database, application, and development related problems. Administers all database objects including tables, indexes, views, schemas, packages, and procedures. Recommendations are made to other DBA Teams to apply the Migration scripts in System Testing & UAT environments. Responsible for compiling PL/SQL programs and fix ORACLE errors for Development Teams on daily basis. Responsible for Performance Tuning of SQL scripts using TOAD Optimization Tools and SQL Tuning Advisors. Also responsible for fixing build failures related to INSTAR Database. Used Jenkins to make builds to integrate the migrations scripts.

Experience in installing, configuring Oracle Golden Gate heterogeneous environments, extensive experience in Golden Gate replication, database server configuration, installation and troubleshooting Extract and Replicat process issues. Involved in filtration and transformation at Extract level and Replicat level along with DDL replication. Configured Golden Gate security using credentialstore and trailfile encryptions, troubleshooting trail files using Logdump utility. Upgraded the Oracle 11g Database to Oracle 12c Database with Zero Downtime Upgradation and Migration.

Involved in ASM Grid Installation for RAC, backup and Recovery (RMAN), Catalog Recovery, Flashback, Patches and Upgrades, Managing Table Spaces, DB Monitoring using OEM, User Profile Management, INDEX Management, Materialized Views, External Tables, Global Temporary Tables, SGA, Shared Pool, Performance and Tuning, Arch planning via AWR, ASH, ADDR & enhance Database Security via Redaction

QA Lead System Tester, Production Support, AT&T, Middletown, NJ (Apr ’04 – Jan ‘08)

As a Lead System Tester for Global Integrated Management Tool (GIOM) which provides common user portal to AT&T Business Services’ service-specific order infrastructures (Data/IP, FR, ATM, Private Line, Ethernet, Network Based Virtual Private Networks, Network Based Firewalls) to facilitate customer centric ordering of both standalone and bundled services. Responsible for System Testing, Inter System Testing (IST), User Acceptance Testing (UAT) executing pertinent Test Plans, testing of real-time communication using SOAP/XML over HTTP and Unix environment and verification of end-to-end billing process functionality. Constructing of the high-level assessment plan with the project management team, system engineering team, and the developer team. GIOM NBVPN (MPLS) comprises VPN Access, Port, PVC, Logical Channel, CPE, Point to Point connectivity, International PVCs connecting different VPNs, VPN configuration, Network Performance Reports, Traffic Classification using various Class of Services ( CoS) Packages.

Tier3 Support, AT&T, Middletown and Bridgewater, NJ (Nov ’99 – Mar ‘04)

As a Lead Tier3 support for IPDepot and CUR (Customer Usage Reports) responsible for writing and executing Test Cases. Integration Testing and Pair-Wise Testing based on the Requirements for the IP Services to support design, development, and implementation of INSTAR applications and documenting Use Cases. Also responsible for Interface testing for data migration from the upstream systems like Universal Service Request Platform (USRP) and Clarify to INSTAR. Managed integrating testing process and procedures into their development projects in support of their business

Responsible for supporting and interacting with Development and System Engineering Group, Capacity Management, Network Care to define, write the Test Plans. Perform general system maintenance and troubleshooting functions - attempt to duplicate problems; identify specific problems using system logs & various test tools. Also closely work with Customer Care Support before and after every release to do complete Sanity Testing and prepare the Release Notes for their reference material. Create and Monitor the MR Status from System Testing group using Sublime System; and Training the Customer Care with the new release features. As a Lead Role in System Testing Group for coordinating the production related problems with Capacity Management, Network Care, System Engineers, and Development Groups. Wrote Guidelines for Sanity testing to verify the checkpoints during software releases. Used Automated Tools (Win Runner 7.01) to perform System Testing of Customer Usage Reports. Also used SQL, PL/SQL, Shell scripting to develop tools for system testing. SQL always used to test backend testing and data migration among various interfaces. Wrote test case scripts manually in WinRunner from invoking the application to the exit of the application in Web Testing.

QA Applications support for the following functional areas - Data maintenance for Customer; Premise and Site allocation; Access circuit information; Access Speed and Bandwidth Provisioning for Private Line, ATM, DSL, and Frame Relay Customers; Usage Billing; AR, GAR provisioning; Component Card Maintenance; IPAddress and Primary Domain Assignments; IP Address Management, Emerging Service Biller.

Worked as Data Analyst with Revenue Assurance Department to identify the potential gaps in the Billing Process. Played as SQL Server DBA for creating denormalized database from various databases – ESB, INSTAR, CLARIFY, POCITS in SQLServer2000 and created regular monthly feeds to the team for identifying the recovery/contra revenues of IP Services

QA Lead System Tester, AT&T Education Center, Somerset, NJ (Dec ‘97 – Oct ‘99)

As a Lead System Tester for Gemstar application developed test plans based on system requirements to test the entire application from end to end. Documented test cases based on Use Case verifications. Responsible for intensive evaluation of a UNIX-based Database Management System using Oracle database and Oracle tools such as SQL and PL/SQL in a Client/Server environment. Also, responsible for planning, implementation, and testing for Y2K compliance of these projects. Worked with System Engineers, developers, and end users throughout the project life cycle to implement the application.

The application supports the following functional areas -- student enrollment; data maintenance of students, instructors, and customers; course and session schedules maintenance; register or waitlist students for training sessions; generate correspondence; training site schedules maintenance; registration closeout activities maintenance; billing clients; security maintenance for the users.

Responsible for complete Web testing based on the guidelines stipulated by project management and documentation of Use Cases, Test Cases, and Test Plans for the Web applications - Gemstar, Library System, Catalog and Registration, developed in PowerBuilder, Cold Fusion and CGI/Perl. Also created several Shell tools for testing all these applications.

Software Consultant, Deloitte & Touche, Charleston, West Virginia (Jan '97 to Nov ’97)

Actively participated in system testing of Families and Children Tracking System (FACTS) project for Department of Human and Health Resources, West Virginia State Government. Target platform was PC/HP9000 based Client Server environment running HP-UX and Oracle.

The system was designed to support the following functional areas - Perform Intake Processing, Assessment, Placement, Investigation, Child Welfare Services. Performed Quality Assurance, Safety Plan, Maintenance of Policy and Procedures.

Developed test plan based on system requirements to test the entire application end to end. Documented the specifications and reported the discrepancies. SQL syntax from datawindows and procedures was tested using Database Administration painter after entering test data. End user problems were recognized and Error Tracking Reports were developed for the developers. Early in the project participated in Development for 4 months.

Programmer Analyst, US Department of Agriculture, Louisiana - (Nov '95 to Dec '96)

System tested a scientific application developed in Power Builder 4.0, which reported the quantity of pollutants in the environment under investigation. This may become the model for the US Department of Agriculture and many Government Scientific Projects to generate reports on a regular basis. Developed test cases based on system requirements in order to test the entire application end to end. Documented and reported when the software was not according to the requirements.

Programmer Analyst, Horn of Plenty, New Orleans, Louisiana – (Aug ‘93 to Oct ’95)

Involved in designing and system testing of a Client/Server Architecture for Sales Analysis Application. Reports involving monitoring of the inventory, sales details, and shipping details. Also, involved in testing Accounts Payable Application and Credit Application for the same company. This application allowed users to enter and change accounts, print invoices and checks, and to enter memos for credit requests, approvals and rejections.

Involved in designing, developing, and testing an application for a restaurant delivery service. Customer, Restaurants, Menu, Orders, Order Details, and other detailed information were stored in database. Reports were generated for Orders, Sales by Date, Sales by Month, Sales Summaries, Invoices and customer mailing labels using queries on different tables.

Designed, developed and tested (Unit, Integration, System) an extensive interactive hospital management application. The application was developed for a group of Hospitals. Several screens to be used by administrative staff in different situations were tested. The application provided several views such as the doctors in each facility, state, and hospital and lists such as daily appointments, clinical tests and patient enrollments.

References: Available Up on Request

Contact this candidate