SUMMARY:

• Over 5 years of strong experience in Oracle database administration in heterogeneous system environment including Solaris, UNIX, and Windows, supporting a variety of mission critical applications with Oracle 10g and 11g.
• The different DBA tasks include, production support, patch installation, database migrations, Installation and configuration, upgrades, backup and recovery, performance tuning, cloning, space management and security administration.
• My objective is to be a dynamic member of a challenging workforce where I can put in meaningfully to the overall goal of that organization, achieving self - fulfillment both as a professional and an individual in my chosen career (Oracle Database Administrator)

TECHNICAL SKILLS:

Databases: Oracle 10g, 11g, 12c

Database Tools: Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant) Toad, OEM Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Log miner, Statspack/AWR, DBCA, DBUA, ADDM, Oracle Migration Workbench, ERwin, QDesigner, Remedy

Operating Systems: MS Windows, UNIX (Solaris 8/9/10, AIX, HPUX), LINUX

WORK EXPERIENCE

Confidential, Sunbury, PA

Oracle Database Adminstrator

Responsibilities:

• Upgrade DBs from 11.2.0.4 to 12.1.
• Troubleshoot and resolve slowness or performance issues with extensive investigation and follow-up with respective application teams with RCA and proposed solutions.
• Resolve lock/latch and resource contention issues during production hours
• Configure Dataguard and Broker for administration of seamless switchovers.
• Upgrade GI and DBs from 11g to 12c with physical standby DBs in place
• Utilize SPM SQL Baselines, SQL Profiles and SQL Tuning Advisor for troubleshooting and providing tuning recommendations to application teams.
• Generate and analyze EXPLAIN PLAN, SQL*TRACE, TKPROF trace files to identify root cause of SQL performance issues.
• Analyze AWR, ASH and ADDM reports and draw conclusions that aid in troubleshooting performance issues.
• Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 10g and 11g environments. Applying upgradepatch, maintenance and interim (opatch)patches on all the databases.
• Monitoring and Troubleshooting GoldenGate Replication issues
• Day-to-day usage of Oracle 11gR2 features - Real Application Testing, automatic SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Merge backup, Oracle Data Pump, big file tablespaces, new EM Grid Control, Database Control, AWR, ADDM, SQL Tuning/Access Advisors, SQL Performance Analyzer, SQL Plan Management, SQL Tuning Automation, Flashback Database, compression techniques and several others. Resolved RAC issues, OCR related issues, rebooting of faulty nodes, relocating the switched over services.
• Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.
• Monitoring and Troubleshooting of Database Replication issues
• Working with Application Development team to address any issues they encounter and provide support and resolution action plan
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
• Oracle HA Stack: Install, Configure, Setup, Maintain and Support Oracle 11gR1, 11gR2, 12c RAC, Physical and Logical Standby database for Test, Development and Production for various home-developed applications like Portfolio Management Systems and vendor applications like SAP Business solutions
• Initial load - direct load, direct bulk load, file to replicat, file to database utility; avoiding and handling Collisions during initial load
• Configure and build Golden Gate Extracts/Replicate for multiple databases
• Data selection, filtering, transformation and column mapping, and Built-in functions in GoldenGate.
• Commit change number (CSN), checkpoint file and checkpoint table.

Confidential, Burffalo, NY

Oracle Database Administrator

Responsibilities:

• Running scripts and monitoring the load process to avoid any issues in ETL jobs running for a long duration.
• Monitored Database growth and provide Database capacity planning for applications expansion or necessary re-organization of tables and indexes as and when required.
• Performing Database Administration activities like space management, user and roles administration, schema management, checking alert log of all the databases. Installed Oracle 10g and 11g on multiple platforms.
• Performed up-gradation of 10g to 11g and to 12c
• Performed traditional Cold backup in appropriate environments via OS commands as well as logical exports.
• Automated routine DBA tasks like backup's and stats by using Grid control job's
• Provided Assistance to application team at the time of SQL tuning in applications. Administration of RAC and DATAGUARD databases in Oracle 11g.
• Oracle DB System Development Life Cycle (SDLC) planning and Oracle DB 3-Tier architecture.
• Setup RMAN solutions for all Oracle Databases -- created rman repository, provided best practices, optimizations and data guard and cloning techniques -- restore and recovery.
• Implemented and maintained Oracle 11g Data Guard/standby databases for switch-over and fail-over purposes. Created, relocated and removed Services as needed in an Oracle RAC configuration
• Adding and removing nodes to existing Oracle database RAC configurations closely with diverse application development groups and served as single point of contact for testing, tuning and implementing projects / solutions in production environment
• Cloned and maintained multiple Oracle Database environments for Development, Testing & UAT.
• Applied various database / applications PSU / CPU patches as required.
• Performed activities like monitoring the database and provide maximum uptime.
• Created and granted users the privileges and roles and resizing the datafiles to manage database growth.
• Defined and implemented database backup and security strategies, tested the backups periodically for consistency and reliability
• Identified long-running database queries, refining queries for better performance, and working with end- users to implement changes
• Created primary database objects (tables, views, indexes) once application developers have designed an application
• Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both Oracle 10g Grid Control & SQL*Plus, as well as UNIX shell scripts.
• Created the database objects such as Tables, Indexes, Views, Database Triggers, Procedures, Functions, etc.