SUMMARY

• As an Oracle PL/SQL Developer and Database Administrator Over 20 + yearsof professional and proven experience in Design, and Development of applications; including Administration, Maintenance, Installation, Tuning, and support of oracle RDBMS, such as GRID, RAC(real application cluster), Oracle Exadata, Standby, and ASM databases, for DWH, and OLTP applications in development, Testing, and Production, environments using PL/SQL, UNIX Shell script, AWK, SED, ERWIN, Oracle Designer, OEM, RMAN, Export/Import, Data Pump, SQL Loader, Data Guard, ADDM, AWR, ASH, ASMCA, SRVCTL, DGMGRL, ADRCI, Oracle packages, and OEM 11g/12C/19C in Windows and Unix platforms
• 24/7 Production support for Oracle hosting PeopleSoft applications.
• Activities include database/application optimization and OS troubleshooting, Shell scripting.Experiencedin software development life cycle using enterprise process and tools in delivering goals
• Knowledge of Oracle RAC 10g/11g/12.2/19C and GRID architecture, configuring and implementing
• Knowledge of using GRID,OEM standard, diagnostic & Tuning packs to administer, monitor and tuning oracle databases and applications
• Experience in SQL, Application and database performance tuning using OEM, ASH, ADDM, AWR and other third - party tools
• Involved in identifying requirements, design / development of architecture and code reviews
• Installing, configuring & Tuning and Migrating oracle 10g/11g/12c/19c on Windows/Unix/Linux servers
• Knowledge of disaster recovery setups & configuration using data guard and Golden Gate replication
• Developing procedures, functions, triggers, PL/SQL packages, Materialized views
• Excellent conceptual knowledge ofOracle 10g/11g/12c/19c, PL/SQL and SQL.
• Rich experience in writingSQL queries, Views, Materialized views, PL/SQL procedures, Packages, functions, packages, triggers, cursors, collections, Ref cursor, cursor variables, System reference cursor, Dynamic SQL.
• Experience in developingExternal Tables, Joins, Indexes and sequences.
• Experience in query optimization, performance and tuning (PL/SQL) usingSQL Trace, Explain Plan, Indexing, Hints,
• Expertise in loading data from legacy systems usingSQL*Loader, IMPDP, IMP, EXPDP and EXP Bulk Binds, Bulk Collect, Creation of global temporary tablesandtable partitioning.
• Involved Exadata migration from 12c to 19c
• Involved Exadata DbaaS databases like export and import data migration
• Developing logical and physical database layouts & Database sizing and capacity planning
• Database auditing, performance tuning and gathering statistics
• Knowledge of data purge, defrag and re-org techniques for improved data storage
• Using Informatica For data loading, extracting and transformations
• Knowledge of creating, maintaining and enforcing database standards and policies

TECHNICAL SKILLS

ETL Tools: IBM Web-sphere DataStage 5/6/7(Designer, Manager, Director, Admin), SQL*Loader, Informatics 6.2, SAP BW, Ab-Initio, Kettle etc.

Modeling Tools: Power Designer, Erwin 4.0, Rational Rose etc.

RDBMS & Tools: Oracle DBA, Oracle 8i/9i/10g,11G,12C,19C RAC, Oracle Exadata, Oracle Streams, OEM,Data Guard, RMAN, Import, Export, DataPump, ADDM, AWR, SYBASE,DB2 UDB,Teradata, MS Access 2000, SQL Server 7/2000/2005,TOAD 7.5/8.5/9.5/11.5/13.3 , SQL Navigator 4.3,Cognus, Swing Bench, GoldenGate 11g/12/19C/21C

Operating Systems: Windows NT/XP, SunOS, UNIX, Red Hat Linux, AIX

Languages: UNIX Shell Scripting, SQL*Plus, PL/SQL

Testing Tools: Win-runner, Load-runner, Test Director and Manual Testing.

Data Warehouse: OLTP, OLAP, Star Schema, Snowflake Schema

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Senior Oracle DBA

Responsibilities:

• Generating Utlbstat, Utlestat, Statspack and AWR Report & finding the root cause.
• Finding HIT/MISS Ratio for all SGA Related Areas.
• SQL Statement Tuning with tkprof, sqltrace.
• Well understanding of Optimizer & its statistics collection.
• Seeing the execution plan by us EXPLANE PLAN Utility .
• Checking the root cause of the problem using ADDM report.
• Using wait events, finding out which session is utilizing high CPU consumption.
• Checking the Temp tablespace size, if the users execute high load of SELECT statement script.
• Creating the INDEXES on tables as per the requirement.
• Reading the top 10 wait events in AWR report to know cause of performance.
• Install, Configure, Upgrade software: server, tools, applications
• Migrate DB between software versions, platforms, DB products
• Configuring & implementing backup strategies and automation of backup
• Database Administrator - Data Administration - Administers databases
• Data management systems that allow for the storage, query, and utilization of data. (Operate and maintain)
• I will be supporting Exadata databases machines
• Created host programs using UNIX shell scripting for remote database access and ftp of files to the supplier site database.
• Generating Utlbstat, Utlestat, Statspack and AWR Report & finding the root cause.
• Finding HIT/MISS Ratio for all SGA Related Areas.
• Developed interface for item data conversion to load items from flat file to Oracle Inventory using SQL* Loader, PL/SQLand import items program.
• Patching, Monitoring, tuning, cloning Oracle 11g instances and building test instances.
• Install, Configure and implement 11gR2/12c/19c nodes TEST, DEV and PRODUCTION RAC on Linux RH 5/6/7Designed and developed various custom packages triggers and forms.
• PerformedSQL and PL/SQLtuning and Application tuning using various tools likeTKPROF, AUTOTRACE and DBMS SQLTUNE.
• Review functional and design specifications to ensure full understanding of individual deliverables.
• Troubleshooting implementation issues and performance issues on RAC.
• Configure backup using RMAN on ASM enabled disk systems for storage.
• Troubleshooting and Tuning Database, SQL and applications. Reasonable disaster recovery setups & configuration
• Oracle RAC Exadata DMA working Knowledge
• I have implemented OGG on Exadata databases
• I have implemented Oracle RAC GoldenGate all kind of topologies
• I have implemented bi-directional with Oracle RAC GoldenGate AUTO-CDR for Never down databases
• I have very good understanding debugging trails and identify the problem
• I have implemented Oracle RAC GoldenGate MSA(Micro services architecture)
• In-depth knowledge data mine whenever issues with OGG trails files
• Responsible tuning OGG lag issues
• Installed OGG different versions and applied required patches.
• I have installed OGG MSA and applied the patches
• Working knowledge oracle Exadata DbaaS databases.
• I have installed and configure OEM agent for OGG monitoring
• In-depth knowledge OGG logdump for debugging issues

Confidential, Houston, TX

Senior Oracle DBA

Responsibilities:

• Database Administrator - Data Administration - Administers databases
• Data management systems that allow for the storage, query, and utilization of data. (Operate and maintain)
• I will be supporting Exadata databases machines
• Created host programs using UNIX shell scripting for remote database access and ftp of files to the supplier site database.
• Generating Utlbstat, Utlestat, Statspack and AWR Report & finding the root cause.
• Finding HIT/MISS Ratio for all SGA Related Areas.
• Developed interface for item data conversion to load items from flat file to Oracle Inventory using SQL* Loader, PL/SQLand import items program.
• Patching, Monitoring, tuning, cloning Oracle 11g instances and building test instances.
• Install, Configure and implement 11gR2 nodes TEST, DEV and PRODUCTION RAC on Linux RH 5/6/7Designed and developed various custom packages triggers and forms.
• PerformedSQL and PL/SQLtuning and Application tuning using various tools likeTKPROF, AUTOTRACE and DBMS SQLTUNE.
• Review functional and design specifications to ensure full understanding of individual deliverables.
• Troubleshooting implementation issues and performance issues on RAC.
• Designed and developed various custom packages triggers and forms.
• Extensively usedfor allandbulk collectto fetch large volumes of data from table.
• PerformedSQL and PL/SQLtuning and Application tuning using various tools likeTKPROF, AUTOTRACE and DBMS SQLTUNE.
• Review functional and design specifications to ensure full understanding of individual deliverables.
• Execute and evaluate manual or automated test cases and report test results.
• Hold and facilitate test plan/case reviews with cross-functional team members.
• Debugging and Fixing Production Data.
• Converted open purchase orders from legacy system to Oracle Purchasingusing SQL* Loader, PL/SQL, Packages/Procedures.
• Created host programs using UNIX shell scripting for remote database access and ftp of files to the supplier site database.
• Oracle RAC Exadata DMA working Knowledge
• I have implemented OGG on Exadata databases
• I have implemented Oracle RAC GoldenGate all kind of topologies
• I have implemented bi-directional with Oracle RAC GoldenGate AUTO-CDR for Never down databases
• I have very good understanding debugging trails and identify the problem
• I have implemented Oracle RAC GoldenGate MSA(Micro services architecture)
• Working knowledge oracle Exadata DbaaS databases
• Developed interface for item data conversion to load items from flat file to Oracle Inventory using SQL* Loader, PL/SQLand import items program.
• Patching, Monitoring, tuning, cloning Oracle 11g instances and building test instances.
• Install, Configure and implement 11gR2 nodes TEST, DEV and PRODUCTION RAC on Linux RH 5/6/7

Confidential, Chicago, IL

Senior Oracle DBA

Responsibilities:

• Designed and developed various custom packages triggers and forms.
• Extensively usedfor allandbulk collectto fetch large volumes of data from table.
• PerformedSQL and PL/SQLtuning and Application tuning using various tools likeTKPROF, AUTOTRACE and DBMS SQLTUNE.
• Review functional and design specifications to ensure full understanding of individual deliverables.
• Execute and evaluate manual or automated test cases and report test results.
• Hold and facilitate test plan/case reviews with cross-functional team members.
• Debugging and Fixing Production Data.
• Worked Built complex queries using SQL and wrotestored proceduresusing PL/SQL.
• DevelopedStored Procedures, Functions, Packages and SQL ScriptsusingPL/SQL.
• Developed interface programs to import parts information to inventory base tables.
• Converted open purchase orders from legacy system to Oracle Purchasingusing SQL* Loader, PL/SQL, Packages/Procedures.
• Created host programs using UNIX shell scripting for remote database access and ftp of files to the supplier site database.
• Developed interface for item data conversion to load items from flat file to Oracle Inventory using SQL* Loader, PL/SQLand import items program.
• Patching, Monitoring, tuning, cloning Oracle 11g instances and building test instances.
• Install, Configure and implement 11gR2 nodes TEST, DEV and PRODUCTION RAC on Linux RH 5/6Reasonable disaster recovery setups & configuration
• Implementing the rolling Partitions for tables with multi million records for better maintenance, performance and data management with complete knowledge of Partition Tables, Partition Indexes, Partition splitting etc
• Responsible database administration all the database by using grid control (OEM)
• Responsible using out-of-place upgrade method
• Responsible writing complex SQL queries and checking explain plan
• Responsible for creating index/rebuild index for tuning purpose
• Familiar with Toad and SQL Developer tools.
• Responsible created triggers for implementing public synonyms for objects
• Monitoring status of Databases using Grid Control
• Measure, identify and optimize the queries, stored procedures and other data processes for better performance
• Responsible for creating and maintaining shell scripts required to monitor database disk (space), CPU and memory utilization and send alerts as and when required
• Managing and administering multiple databases in development, testing and Production environments
• Defining, documenting and maintaining database standards for the applications to ensure consistency in database creation and other database objects
• Responsible for planning and evaluating the use of Oracle RAC for various applications
• Creating duplicating database by using RMAN for testing and recovery purpose.
• Estimating and forecasting the resources like storage, CPU and memory required
• Responsible for Configuring Golden Gate for data replication and administration
• Install, Configure and implement 12C RAC TEST, DEV and Production RAC on Linux RH 6.5

Confidential, East Moline, IL

Senior Oracle DBA/Developer

Responsibilities:

• Designed and developed a Data Decimation application for summarizinglarge statistical data sets.
• Provided technical support to the development team for developing the complex reports
• Built complex queries using SQL and wrotestored proceduresusing PL/SQL.
• DevelopedStored Procedures, Functions, Packages and SQL ScriptsusingPL/SQL
• Developed interface programs to import parts information to inventory base tables.
• Converted open purchase orders from legacy system to Oracle Purchasingusing SQL* Loader, PL/SQL,
• Created host programs using UNIX shell scripting for remote database access and ftp of files to the supplier site
• Used Data Junction for loading huge volume of legacy application data into iWarranty application by adapting iterative approach of ETL process and Customized process using PL/SQL
• Lead a team of 10 in an effort to identify poorly performing queries on customer site and resolving them that provided accolades to the product.
• Provided production support by remote troubleshooting to resolve customer’s onsite issues.
• Generate/Create DB scripts and installation documents to be sent to clients along with application installations.
• Developed and maintained UNIX shell scripts/ Windows batch scripts for DB backup and other DB related daily routine activities.
• Measure, identify and optimize the queries, stored procedures and other data processes for better performance
• Document data mapping, data dictionary, database schemas, entity relationships and data flows
• Converted and loaded data from flat files to temporary tables in Oracle database using SQL*Loader.
• OEM Administration for Database Administration.
• Designed complex stored procedures for data loading in data warehouse and Reports.
• Improved the performance and data manageability by table partitioning, using global and local indexes, materialized views, and bitmap indexes.
• Fine Tuned (performance tuning) SQL queries and PL/SQL blocks for the maximum efficiency and fast response using Oracle Hints, Explain plans and Trace sessions.
• Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
• Maintain the Oracle 10g RAC environment and troubleshoot performance problems.
• Maintain the Oracle 10g and 11g RAC Administration for all services.
• Configured Data Guard and Create physical stand-by DataGuard.
• Created duplicate database by using RMAN for testing and recovery purpose.

Confidential, Chicago, IL

Senior Oracle DBA /Developer/ETL Developer

Responsibilities:

• Worked extensively with STATSPACK and TKPROF reports for performance problem. Also worked with a variety of corporate performance monitoring tools to identify bottlenecks with memory and disk contentions.
• Providing DBA support for Production environment, which involves Database tuning such as Oracle Stored Procedures/Functions/Packages optimization using advanced PL/SQL features and dynamic SQL.
• All the daily database administration tasks including backup and recovery thru RMAN, Import/Export, grants and roles etc.
• Configured Data broker for Data Guard and Create physical stand-by DataGuard.
• Database Reorganizations for better space management.
• Performed Database Refreshes, copies for Development, Test and Production databases.
• Refresh schema level and full level production to non-production databases.
• Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
• Upgrading OEM Repository and Installing OEM 10 Grid Control to monitor all the databases.
• Provided technical support to the development team for developing the complex reports.
• Extensively used UNIX shell scripts for various DB related tasks.

Confidential, New York, NY

Senior Oracle DBA/Developer

Responsibilities:

• Worked extensively on Data warehousing and to move data from source to target database-using Data Stage.
• Extensively Used DataStage Universe Basic Commands in Performing DataStage Administrative Task.
• Worked extensively on oracle data forms and MQ messages on UNIX box and loading data into Oracle.
• Designed, Developed DataStage Jobs oracle Plug-in Stages invoking oracle Load Utilities.
• Developed UNIX Shell scripting for file manipulation operations and data loading procedures, created CRON jobs for automate tasks etc related to the application.
• Involved in both hot and cold data backup.
• Developed procedures, functions, triggers for complex business needs which cannot be done using tools.
• Interacting with User Groups/ Corporate Testing Groups/Business people.

Confidential, Atlanta, GA

Senior Developer/Data Analyst

Responsibilities:

• Worked extensively on Data warehousing, extensively used DataStage an ETL tool to design mappings to move data from source to target database-using Stages.
• Extensively used all the Stages like sequence, hash file, transformer, link collector, Aggregator
• Involved in performance tuning on the source and target database for querying and data loading.
• Worked on the database schema by creating database objects.
• Developed Job Automation Process, To Run DataStage Jobs Using Global Parameter File.
• Strong Skills In Coding (Stage Variables, Derivations and Constraints) Business Logics In Transformation Stage.
• Developed Built-In & Custom Defined Transform Functions & Routines.
• Extensively Used DataStage Universe Basic Commands in Performing DataStage Administrative Task.
• Worked extensively Sourcing data form Oracle & Sybase on Unix Box and Loading Data into Teradata on OS/390.
• Designed, Developed DataStage Jobs Using Teradata Plug-in Stages invoking Teradata Load Utilities.
• Made extensive use of Unix Shell scripting, setting Unix cron jobs, maintaining user profiles, archiving log files etc.
• Fine-tuned SQL’s for optimum performance
• Worked on retrieving data from different legacy systems
• Interacting with User Groups/ Corporate Testing Groups/Business people.
• Developed shell scripts to automate file manipulation and data loading procedures.

Confidential

Oracle Programmer/DBA

Responsibilities:

• Involved in analysis, design and development of MPMS (Material Purchasing Module).
• Responsible for business analysis, data analysis and developing functional flow and data flow diagrams.
• Lead the project team for developing HR/PS (Payroll System).
• Responsible for coordinating the team activities for data analysis, design, code development, testing and implementation.
• Involved in system architecture, infrastructure and capacity planning.
• Responsible for designing and implementing OEMS (Order Entry Management System).
• Involved in database physical and logical design, developing administrative procedures, making backup and recovery policies and preparing operating metrics for production database and making security policies.

Confidential, Fairfax, VA

Oracle Developer/DBA

Responsibilities:

• Database Administrator supporting multiple applications/database instances including development, testing and production in OLTP and Data warehouse environments in a Mission Critical highly available 24X7 environment on Aix and HP servers on databases varying from 500GB to 2TB
• Installing, upgrading/migrating and configuring of 9i and tuning the SQL using SQL Trace, tkprof and Explain Plan utilities. Used rule and cost-based optimizers to get better throughput and optimization. Used database hints to drive the best access path and better throughput. Used Stats pack for overall health check of the database like cpu usage, memory usage, finding performance bottlenecks and for system wide tuning.
• Ensure performance related database activities are performed on all instances like
• Gather schema statistics, rebuild indexes, reorganization of database objects like
• Tablespaces and big tables having around 50 million rows.
• Bulk loading of data using SQL*Loader and PL/SQL and Merge feature in 9i. Automated the loading jobs using pl/sql and Unix (ksh) shell scripts.
• Refreshing test databases using data from production using Export/Import utility. Used the Transportable Tablespace feature to migrate data from one database to another.
• Implemented the oracle partitioning feature for large tables and indexes. Created range/list partitioning. Maintaining partition tables and indexes by truncating, dropping, exchanging and merging partitions.
• Developing Unix shell scripts (Ksh) and Oracle procedures for automating the batch jobs at OS level and at Database level using Cron jobs and DBMS jobs.

Confidential, Columbus, OH

Oracle Programmer

Responsibilities:

• Designed and developed various custom packages triggers and forms.
• Extensively usedfor allandbulk collectto fetch large volumes of data from table.
• PerformedSQL and PL/SQLtuning and Application tuning using various tools likeTKPROF, AUTOTRACE and DBMS SQLTUNE.
• Review functional and design specifications to ensure full understanding of individual deliverables.
• Execute and evaluate manual or automated test cases and report test results.
• Hold and facilitate test plan/case reviews with cross-functional team members.
• Debugging and Fixing Production Data.