SUMMARY

• 12+ years of progressively responsible positions in diversified and very large production and development environments in various domains like Finance, Health Care and Manufacturing with database implementation in various platforms which includes
• Extensive experience in Upgrading and Migrating Oracle Databases on Various Unix/Linux Platforms: Sun Solaris, HP - UX, RHEL- Red Hat Linux.
• Strong technical expertise with Oracle DBA support on-premises and on cloud environments.
• Exposure to No-SQL Databases (Raven DB, Couch Base), MS-Azure and Oracle Cloud environments
• Upgraded Oracle Databases from 9i to 10g, 10.2.0.3 to 10.2.0.5, 10.2.0.5 to 11.2.0.3, 11.2.0.3 to 12.1.0.2
• Experience in applying Oracle PSU patches on Oracle Homes on quarterly basis both on production and test environments.
• In-depth knowledge of Oracle Enterprise Database Architecture and Design
• Experience in Cloning/Refreshing Databases from Production to Test/Dev environments on daily basis.
• Experience in working with DBA teams (on-shore/off-shore/virtual teams) on daily basis for 24/7 support.
• Experience in Designing High Availability solutions - RAC (Real Application Clustering)using ASM for Oracle databases
• Experience in implementing backup /restore /DR using HOT standby, RMAN(Recovery Manager)
• Worked on various Database Consolidation Projects
• Experience in Installing/Configuring/Monitoring Oracle Databases / Oracle Database Performance Tuning/Optimization using OEM - Oracle Enterprise Manager 12c/13c environments.
• Experience in troubleshooting Oracle performance tuning using AWR, TKPROF, Statspack, Explain plan, SQL Trace, Index Hints and SQL Queries Optimization etc.
• Self-motivated, strong troubleshooter, energetic and results-oriented individual
• Experience in SQL/PLSQL stored procedures, Functions and Database Triggers.
• Project Documentation, creation and adhering to standards of Implementation and Project management
• Experience in developing Oracle PL/SQL based applications using Oracle Stored Procedures, Functions Packages, Triggers, Materialized views.

TECHNICAL SUMMARY

Programming Languages: SQL, PL/SQL, Shell scripting, PerlOperating Systems Solaris 8/9/10, HP-UX, Digital UNIX, IBM-AIX, SVR UNIXRedhat LINUX, Windows - 95/98/NT/XP/7/10

Database Environments: Oracle 7.x/8.x/8i/9i/10g/11g/12c, MS-Access, ODBC, JDBC

Software Tools & GUIs: Power Builder, Visual Basic, Pro*C, SQL*Plus, OEM, TOADPL/SQL Developer, DB Audit, ViaTil/Remedy, VeritasCluster Manager

Case Tools: Logic Works Erwin/ERX

Planning/Presentation Tools: Microsoft Project, Microsoft Office and Visio.

Hardware Platforms: Sun Sparc v880/v440, HP9000 E45/E55, DEC-Alpha1200/2100A/DS20, HCL-Magnum, HP

Storage Systems: NAS/SAN (NetApp, HP, 3-PAR)

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Sr. Oracle Database Administration

Responsibilities:

• Worked with a group of 5 SR.DBA’s. Responsible for supporting Oracle Databases including the Hardware (Sun Sparc Systems). Helped to team grow from supporting production systems to a value and to the projects by optimizing the processes, automation of daily routines and offloading tier tasks to offshore teams.
• Established Oracle Databases and standardization policies and procedure globally. Worked with 24/7 teams with staff in Europe, Ireland, Asia for “follow-the sun” support model by delivering 99.99% systems uptime.
• Ensured best practices followed for the Database Installs/upgrades/Administration. Data Security and periodic auditing was given priority and passed both internal/external audits with no high/medium findings.
• Always participated with team for following projects (Hands-on) for on-time delivery of database support.Oracle DB Upgrades
• Implemented Oracle PSU Patching model on every quarterly basis for both test/prod environmentsOracle Platform Migration
• Migrated Data using Data pump and other Export/Import Utilities
• Manifest Implementation to get the Linux environment to the latest Oracle 12c Database
• Supported Various Data Centers upgrades/moves
• Supported Oracle Cloud implementation and Data sync between on-premises and on cloud basisOracle Golden Gate
• Firsthand experiences in setting up Oracle Golden Gate one-way, two-way/bi-directional, active-to-active and active-to-passive data replication with conflict detection and resolutions. Extensive skills in upgrading OGG 11gR2 to 12c, configuring OGG in RAC high available environment.
• Primary technical resources to upgrade Oracle Golden Gate from 11g to 12c in Exadata machine environment. Design Golden Gate HA solutions by using Oracle 11.2.0.4 Clusterware functionality.
• Deep understanding Oracle Golden Gate internal mechanism, OGG new features such as Integrated capture, native DDL capture, coordinate apply mode, multi-threaded replicate. Developed home-cooked OGG lag monitoring scripts and configure OGG monitoring plug-in in OEM (Oracle Enterprise Manager) 12c.
• Installed and Configured Oracle Golden Gate JAgent to work with OEM Golden Gate Plug in.Oracle Multitenant Databases
• Creation of Container Databases in Oracle 12c
• Connect to a CDB and PDB - Plugin Database
• Manage PDB’s by creating Local and Common users / roles
• Dropping / Shutdown PDB’s from CDB when databases are ready for decommissioning
• Cloning PDB’s from One PDB to another PDB.Oracle Backup and Recovery
• Created Database Backup groups (Daily / Weekly / Monthly / Yearly) on EMC Legato Networker tool
• Configured all database backups using RMAN with Incremental and Full Backup modes
• Refresh Databases using production backup copies to test/dev environments on daily basis
• Purging Archive log files on weekly basis on disks once the backups are completed.Oracle Performance Tuning
• Scheduled AWR Reports for critical databases and closely monitoring on daily basis
• Implemented Oracle Enterprise Manager 12c/13c to monitor and troubleshooting performance issues for critical databases
• Deeply involved in configuring OEM Daily Reports like (Tablespace Management / Database status / Database alerts / Incident reports etc.
• Experience in troubleshooting Oracle performance tuning using AWR, TKPROF, Statspack, Explain plan, SQL Trace, Index Hints and SQL Queries Optimization etc.Oracle Cloud:
• Created / Managed Oracle 12c database on Cloud (DBCS)
• Start/Stop Database on Cloud
• Applying patches on Cloud Database
• Created users and groups for cloud Services Console
• Worked on Oracle Cloud tools like DBCSCLI. DBass Monitor and EMExpress

ENVIRONMENT: Oracle 12c/11g/10g, Oracle Cloud, Oracle RAC (11gR1, 11gR2), OEM, and Data guard, SQL Developer, RMAN, Data Pump Confidential

Confidential, WI

Sr. Oracle Database Administration

Responsibilities:

• Upgraded Oracle Databases from 11gR1 (11.1.0.6) to 11gR2 (11.2.0.2) to 11gR2 (11.2.0.3)
• Upgraded Oracle Databases from oracle 9i to 10g (10.2.0.3) and 10.2.0.3 to 10.2.0.5 and 10.2.0.5 to 11.2.0.4Oracle RAC Administration and Support
• Designed and implemented Oracle Real Application Clusters (RAC) on Solaris for an OLTP application with Transaction Application Failover and high transaction volume.
• Responsible for migrating Core databases into a 2-node RAC
• Have good experience in administering ASM disk Groups
• Successfully added a new node in cluster in order to configure 3-node RAC.Oracle Database Auditing
• Implemented Database Auditing on Production Databases
• SOX Compliance & Remediation - Implemented password control and aging in Oracle Apps.
• Implemented DB Audit Tool to resolve SOX SOD issueOracle Database Support
• Experience in installing Trigger based DDL capture.
• Building test strategies, backup & recovery models for Oracle. Refreshing test databases
• Going through the day-to-day user requests and troubleshooting the database related problems
• Implemented partitioning and materialized views for Oracle 10g and 11g Databases
• Responsible for Online/Offline database backups and managing Database recovery with RMAN.
• Worked withOracleSupport during ORA-600 and ORA-7445 issues.
• Involved in implementingLoad balancing and testing failoveron3-Node RAC Database.
• Wrote scripts to improve the performance ofimporting indexes.
• CreatedMaterialized viewson big tables.
• Cloning of database for development and test environments.
• Responsible for implementing cold/hot/logical backup procedures using shell (LINUX) scripting and also usingRMAN. Developing, testing & implementing strong backup and recovery strategy. Also responsible for monitoring backups.
• Responsible for creating RMAN catalog Database and Registering the Databases in Catalog Database.
• Responsible for storage management - Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary.
• Configured scripts in Crontab for Production Environment
• Design, Install, Tune and MonitorOracledatabases

ENVIRONMENT: Oracle 11gR2, RHEL, IBM AIX, SQL*Plus, SQL*Loader, OEM, PL/SQL Developer, Import/Export, TOAD.

Confidential, Chicago, IL

Oracle Database Administration

Responsibilities:

• Responsible for Installation and administration of Oracle RAC 10gR2 and Oracle RAC 11gR1 production and development databases
• Responsible for migrating Core databases into 2-Node RACOracle Database Support
• Provided 24*7 with an on call pager.
• Performed cloning using RMAN to set up development and test databases from Production database.
• Upgraded the database from 10gR2 (10.2.0.5) to 11gR1 (11.1.0.6).
• Involved in database migration from single instance to 3 nodes RAC Database.
• Creation and Configuring Services using SRVCTL and CRSCTL.
• Managing databases using Oracle 10g Grid Control.
• Responsible for installing and maintaining the Standby database.
• Hands on experience in administering Tablespace Management, User Management, UNDO management etc..
• Used Data Guard broker to monitor Data Guard configurations on standby database.
• Good working and implementation knowledge on Data Guard and Stand-by databases for fail-over and recovery.
• Configured Net Backup with RMAN for database backups and restore.
• Also implemented logical, cold and hot backups.
• Applied patches whenever necessary by downloading them from Metalink.
• Involved in De-fragmenting data blocks of Tablespaces for optimized performance. Also partitioned large tables to increase performance.
• Rebuilt indexes for better performance of Oracle database.
• Worked extensively in Performance Tuning at various levels including instance tuning, Query tuning, Database performance tuning.
• Performance tuning using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, STATSPACK for optimized results.
• Performed database object sizing (performance tuning of database objects) and space allocation.

ENIRONMENT: RDBMS (10g,11g), Solaris 8 (SPARC), RHEL4, TOAD, EXPALIN PLAN, TKPROF, EXPORT/IMPORT, SQLLDR, RMAN.