SUMMARY

• 14+ years of IT experience as Oracle DBA, provided frontline DBA support for 24X7 production, testing and development support on Multi - terabyte 12C/11gR2/11g/10g/9i RAC and Non-RAC databases.
• First stabilizing critical and/or deteriorating situations then working toward permanent self-sufficiency, stability, and maintaining defined/expected service levels.
• Proficient in Oracle Database Design & Administration, Backups & Recoveries, Performance Tuning and Shell Scripting. Good experience in Oracle RAC, ASM, OEM and Data Guard implementation and administration.
• Migrated Oracle databases running on Physical AIX/Linux servers to internal cloud services
• Conducting POC for migrating oracle databases from On-Prem physical servers to Public cloud AWS EC2 servers and RDS .
• Exposure on internals of Cassandra, Mongo, AWS.
• Perform design, build and support of Oracle Golden Gate Solutions for real time replication of various critical application databases.
• Configuration of Oracle Enterprise Manager Grid control to monitor databases and report on events as defined by the DBA group.
• Advanced Performance tuning skills, resolved numerous performance issues, by analyzing trace, AWR base tables (to compare explain plans from previous executions) and AWR reports to identify the bottleneck and use SQL profiles/SQL plan baselines, Indexes and hints to optimize the performance issue.
• Efficient in Optimization, Disk Space management, performance analysis, capacity planning, sizing, analyzing performance statistics and Data modeling.
• Setting up daily monitoring jobs, automatic alert notification when database is down or preset thresholds have been exceeded, Installation of new database upgrades, patches, create databases, primary database objects like table spaces, tables, views, synonyms, snapshots, partitioning and sizing tables, indexes etc.
• Experience in cloning databases from hot backup, cold backup, RMAN backup, Active Duplication and EMC BCV splits.
• Experience in migrating Oracle databases from AIX to Linux and cross platforms database migrations (AIX, Solaris, HP-UX, Linux, and Windows).
• Database backup and recovery using hot and cold backups, RMAN backups and EMC BCV splits.
• Proficient wif the use of Oracle utilities like EXPDP/IMPDP, SQLLDR and data pump.
• Performs database re-organizations as required to assist performance and ensure maximum uptime of the database.
• Experience wif performance tuning using AWR/ADDM reports, Explain plan, SQL trace, and TKPROF, Analyze, Auto trace, STATSPACK.
• Experience in replicating data by creating and maintaining Materialized Views in a data warehousing environment in 11g.
• Managing security by creating and granting roles, profiles and privileges to users.
• Experience wif driving and delivering audit requirements defined by Information Security wifin an organization.
• Experience in planning, configuring and implementing Disaster recovery plan (DRP)/ Business Continuity plan (BCP), implementing the switch over, fail over using Oracle Data Guard.
• Extensive experience in 24/7 Production Database Support.

TECHNICAL SKILLS

Relational Databases: Oracle 8i, 9i, 10g, 11g,12C, MYSQL, MariaDB

Clustering: 10g RAC, 11g RAC

No SQL Databases: Cassandra, Mongo

Operating systems: IBM AIX 6.1/5, Linux 6.2, Solaris 8/9, Windows Server, 003/2000/NT,HP-UX

HA/DR Technologies: Oracle Real Application Clusters (RAC), Oracle Data guard, Golden Gate

Database Utilities: Data Pump, Grid Control, OEM, Export/Import, SQL Loader, Stats pack, TOAD, DB Artisan, Tkprof, AWR, OEM, ADDM, Session Tracing, RMAN, OPatch, and Oracle ASM,Sqllines,Monyog

Programming Languages: Perl, SQL, PL/SQL, UNIX Shell Scripting

Configuration management/Tools: Rational Clear Case, Resolve IT, Remedy, Infoman Change management for RFC,Vantive,Quality Center

PROFESSIONAL EXPERIENCE

Confidential, Irving Texas

Oracle DBA

Responsibilities:

• Planning, installation, configuration, management and troubleshooting of Oracle 10g, 11g and 12cdatabase on AIX, Linux and Windows OSUpgrade Oracle 10gdatabaseto 11g and 11g to 12c.
• Upgraded Oracle Grid and databases from 11.2.0.3 to 11.2.0.4 and apply Quarterly patches.
• Database configuration and creation. Data refresh across different environments using exude/impdp and exp/imp.
• Experience on database cloning using RMAN .
• Perform Continuity of business test using standby setup. Deploy recovery techniques during media failures. Extract and report database performance co-ordinates using Stats pack /AWR.
• Troubleshooting in Performance Issues and Tuning sql’s in Oracledatabaseby generating reports like AWR, ASH, ADDM, STATSPACK, OEM Grid Control and manual scripts Shell scripting to perform both regular and ad-hoc activities.
• Partitioned large tables for better performance and manageability.
• Setup and configuration, maintained of primary/standby databases for mission critical databases.
• Using Data Guard, Created COB environment for the production database as part of disaster recovery.
• Proactive space management. Creating and assigning roles meeting the Risk Assessment standards. Periodical review of Technology Review Assessment Matrix concerned wif database.
• Writing Basic Shell scripts for load monitoring and Housekeeping of Trace files Raising RFC for New implementation or for any major changes in database.
• Resolved the issues for Conflicts between Source and Target Golden Gate Databases

Confidential

Oracle DBA, Technical Lead

Responsibilities:

• As a Team lead to own DBA operations (Oracle) provide technical guidance, client interactions, team building, people management and ensuring strong handshake between onsite - offshore teams.
• Serves as escalation point for all issues wifin a group (infrastructure support/network) in a project.
• Responsible for maintenance and administration on, enhancements, following change management policies, report capacity and availability, updating of the ticketing system and KEDB.
• Installed OEM 12c agents, Administered, maintained for over 150+ Servers.
• Creation and maintenance of Oracle ASM instance and disk groups.
• Oracle Cluster ware monitoring, Health Checks and Diagnosis.
• Backup and Recovery of RAC database using RMAN.
• Planned Golden Gate setup to achieve unidirectional replication.
• Performed POC for testing DDL and DML replication across Databases
• Test impact of multiple Extract and Replicat processes on a Single Node
• Prepare Golden Gate parameter files for Extraction and Replication
• Install Golden Gate software in Test region to perform POC
• Expected to train and mentor junior administrators. Maintains a roster for shift management.
• Expected to participate in weekly operational meetings, change management meetings.
• Expected to lead the team from transition to delivery and also work wif Project manager for Infrastructure projects

Confidential, Irving Texas

Oracle DBA, Technical Lead

Responsibilities:

• Responsible for solving the Day today issues faced by the development users. Monitor locks and release locks.
• Carried out DB Cloning and provided the cloned database for development side.
• Installed OEM 12c agents, Administered, maintained for over 150+ Servers.
• Perform other regular DBA activities including space management and performance monitoring.
• Worked wif developers to provide queries and tuning the queries for better performance.
• Migrating and loaded several gigabytes of data from other Citi entities into our data warehouse using sqlldr.
• Export and Import of over terabyte of Oracle data from a Solaris server to an AIX server for a server consolidation effort.
• Perform other regular DBA activities including space management and performance monitoring.
• Loading of flat files generated from data on a DB2 database into our Oracle data warehouse to make it available for adhoc users to query.
• Migrated the database of oracle version 8.1.0.7 to 9.2.0.8 from windows OS to AIX for the Legacy Master Servicing application.
• As a Team lead to own DBA operations (Oracle) provide technical guidance, client interactions, team building, people management and ensuring strong handshake between onsite - offshore teams.
• Serves as escalation point for all issues wifin a group (infrastructure support/network) in a project.
• Responsible for maintenance and administration on, enhancements, following change management policies, report capacity and availability, updating of the ticketing system and KEDB.
• Mentoring junior administrators and maintaining a roster for shift management.
• Expected to participate in weekly operational meetings, change management meetings.
• Expected to lead the team from transition to delivery and also work wif Project manager for Infrastructure projects.

Environment: Over 1000+ databases in Oracle 11.2.0.3,11.2.0.4 on AIX 6.1,Linux, Shell Scripting, RMAN and OEM12c, Quality Center, Service Now Tool for Monitoring client issues.

Confidential

Responsibilities:

• Involved in 24x7 production database maintenance and on-call support.
• Responsible for administering and supporting production and development Oracle 8i databases. Migrated production and development environments from Oracle 8i to Oracle 9i environment.
• Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance.
• Designed backup and recovery procedures forOLTPsystem. Conducted periodic cold and hot backups.
• Instance cloning done to create test and training environments.
• Developed SQL,PL/SQL Programssuch as procedures, functions, packages and triggers
• Partitioned large tables to increase the performance.
• Configured scripts to monitor activity wif database.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.

Environment: Over 100+ databases in Oracle 9.2.0.8 Solaris 5.9, Windows platforms, Shell Scripting, RMAN.

Confidential

Responsibilities:

• Maintenance of Oracle Production, Development, Testing and QA databases.
• Installation and configuration of Oracle 9i, 10g databases.
• End-user requests in terms of assisting them in TEMPeffectively create tables, views, packages, sequences, schema refreshes.
• Worked wif developers to provide queries and tuning the queries for better performance.
• Issues related to Space Management, Locks, Database Hit Ratios, Backup failures and UNIX related On-Call alerts.
• Resource Management (Create and manage Indexes, Clusters, Tables), allocate and manage physical storage structures like Data files, Redo logs, Control files. Allocate and Manage logical storage structures like Table spaces.
• Databasebackup & Recovery.
• Load data using SQL*Loader.
• Alert monitoringandTicketing.
• Developed SQL,PL/SQL Programssuch as procedures, functions, packages and triggers
• Coordinated wif developers and users connecting to different databases, setting policy and procedures as they relate to database maintenance, security, backup & recovery, SQL coding guide lines.
• Coordinating Backup and Recovery operations over all databases.
• Creation of users and Granting them privileges and roles.
• Export and Import Data according to the users request.

Environment: Over 20 databases in Oracle 9i Solaris 5.9 platforms, Shell Scripting, RMAN.

Confidential

Responsibilities:

• Day to day activities includes database Backup,
• Database tuning, SQL Tuning and identifying bad Sal’s by reviewing AWR/ADDM reports.
• Serving Tickets (client request), Storage Management of Tablespace, rollback segments and data segments by writing scripts on DBA TABLESAPCE, DBA EXTENTS and DBA FREE SPACE.
• Created scripts for database monitoring (Table space usages, Alert log messages etc.).
• Managing rollback segments and temporary table spaces.
• CreatedUser accounts, Rolesand granting requiredaccess permissions and privilegesto the users.
• Periodically monitoring dynamic performance tables (v$) for best database performance.
• Periodically taking database performance statistics using STATS PACK.

Environment: Over 130 databases in Oracle 9.2.0.8, 10.2.0.3 and 10.2.0.4, 11.2.0.2 on AIX 6.1, Solaris 5.9 and Windows platforms, Use of Materialized views, Shell Scripting, RMAN and EMC’s BCV splits for hot backup

Confidential

Responsibilities:

• Loading the data into Oracle database from flat files through Sqlloader.
• Installation and configuration of Oracle databases.
• Maintenance of Oracle production and development databases.
• Creating databases as per the guidelines of OFA methodology
• Capacity and Storage planning for future storage requirements
• Managing Database Structure, Storage Allocation, Table/Index segments, and Rollback segments, Constraints, database security
• Checking Alert log & monitoring growth of the Tablespaces.
• Production Support DBA for BP, USA & UK
• Tuning database, applications, memory, and disk usage.
• Monitoring and optimizing the performance of the Database,
• Creation of Users through scripts under the Security Management. These scripts will do the creation/modification/deletion of users/logins and grant/revoke permissions.
• Automating DBA tasks using shell scripts as Cron jobs Backup, Export/Import and various database issues.