SUMMARY:

• Senior Oracle DBA with 9+ years of experience as Oracle database administrator, providing 24/7 support for mission critical production 12c/11g/10g/9i/8i databases on various platforms.
• Oracle Database 11g Certified Professional (OCP)
• Excellent experience in installation and configuration of Oracle 12c/11g RAC/10g RAC/ 9i/8i in UNIX/Linux/AIX/Solaris and Windows environment
• Proficient in Database Administration activities such as Installation, Configuration, Upgrades, Patches, Performance Tuning, Backup & Recovery, Cloning, Auditing, Troubleshooting, TAR Support, Documentation.
• Implementation of High Availability Solutions using Oracle 11gR1/R2 RAC, 10g RAC, Standby database (Data Guard), GoldenGate.
• Experience in UNIX Shell Scripting for automating the DBA tasks.
• Good experience in Hot/Cold Backups, and Cloning of Databases
• Good Knowledge of RMAN backups.
• Skilled in developing scripts for database back ups including hot and cold backup options
• Extensive Knowledge of ASM and regular file system usage.
• Good knowledge and hands on experience in using oracle utilities like Flashback, Oracle Data Pump.
• Proficient in using OEM Grid Control agent versions 12c, 11g and 10g, setting up alerts, templates and metric thresholds on database parameters.
• Proficient in Performance Tuning the applications and database proactively using STATSPACK, TKPROF, SQL TRACE, EXPLAIN PLAN, AWR, ADDM.
• Good experience in creating, managing and merging Partitioned Tables.
• Good experience in SQL performance tuning using Cost Base Optimization (CBO), gathering stats and determining most efficient execution plan.
• Extensive knowledge in working with the tools like OEM, TOAD, SQL*Developer, SQL*Loader, SQL, DB Artisan and Erwin Data Modeler.
• Working knowledge of key Exadata features such as SmartScan, HCC (High Columnar Compression), Smart Flash Cache and Storage Indexes.
• Experience in loading data from flat files to database using external tables and SQL*Loader.
• Good knowledge of object - oriented programing and application development tools using Microsoft VB.Net, C, .Net, ASP.Net; Python and VBA.
• Excellent written and verbal communication skills.

TECHNICAL SKILLS:

DBMS & RDBMS: Oracle 8i, Oracle 9i, Oracle10g RAC, Oracle 11g, Oracle 12c RAC, MS - Access, SQL Server 2008,2012.

High Availability: Oracle 10g RAC, Oracle 11g RAC, Oracle 12c GI, ASM, Data Guard, Golden Gate, Grid Control (OEM), Tkprof, Statspack. AWR, ADDM, ASSM

Operating Systems: Solaris 9/10, Linux RHAT 3/4/5, HP-UX 10.x/11.x, AIX 5.2/5.3, Windows 2000/2003/2005

Tools: & Utilities: Oracle SQL Developer, TOAD, Erwin Data Modeler, RMAN, Export/Import, EXPDP/IMPDP, SQL*Loader, Golden Gate, Oracle APEX, SAP BRTools, Apache Tomcat, JVM, EMC software.

ETL & Reporting Tools: Informatica 5.1 Power Center 8.5/8.0,Data Stage6.0, 1.0, Business Objects Xi R26.1, Oracle Data Integrator.

Backup Tools: VERITAS NetBackup, SQL Backtrack, RMAN, FDR, EMC TimeFinder

MS Office Tools: Excel, Word, PowerPoint, Outlook, Visio

Programming Languages: C, ASP.Net, XML, HTML, DHTML, CSS, Python

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Sr. Oracle Database Administrator

Responsibilities:

• Joined back as an SME for Oracle databases and senior database administrator for the project on request of manager.
• Supported 24 x 7 production databases and helped in resolving immediate issues.
• Developed strategies to overcome recurring database issues.
• Created Method of Procedure for upgrading all the databases and Grid Infrastructure in the environment from 11.2.0.4 to 12.1.0.2.
• Scheduled meetings and coordinated with teams to lead the database upgrade activity.
• Upgraded the all the databases some of them at 100TB size.
• Created backup plans and strategies for the large databases.
• Worked on performance issues on the database and brought down the response times on the database to 70% of original response times.
• Created Oracle Enterprise Manager environment complete with OMS, Repository database.
• Created rules and setup monitoring through OEM for the production databases.
• Worked on Oracle database bugs and scheduled maintenance windows for applying the patches.
• Participated in MongoDB training and helped in resolving some of the issues while setting up the environment.
• Designed and Created a replica database for offloading the production load using Golden Gate. Database was used as a reporting database.
• Extensively worked on performance tuning with application DBAs and end client teams.
• Resolved bad performance of the database which was causing high CPU usage on the server.
• Worked with SAN team and System Admin teams to resolve bad throughput on ASM.
• Resolved performance issues with SEG$ contention on the database by applying Oracle provided one off patches.
• Resolved critical Oracle bugs causing outages with heat map feature in 12c.
• Trained as MongoDB administrator and completed mongo db course from the mongo university.
• Worked on basic setup of MongoDB and resolving some administration issues.

Environment: Oracle 12c, OEM 12.1.0.2, Sun Solaris, MongoDB 3.4, GoldenGate.

Confidential, San Antonio, TX

Sr. Oracle/MSSQL/Sybase Database Administrator

Responsibilities:

• Worked as a senior database administrator in Operations Risk Management Team.
• Supported monitoring of database security, user access, vulnerability patching, user roles on multiple database platforms.
• Participated in CVSS scoring of patches to the various databases on different platforms to determine the vulnerability.
• Create PL/SQL scripts to gather roles, privileges granted on critical objects, system level privileges and instance level configurations.
• Created reports in OEM to monitor the violations using the PL/SQL scripts created in the monitoring databases.
• Used power shell to create a script to gather Oracle and Sybase user information for monitoring the expired users and account statuses.
• Created a shell script to gather database information throughout the environment for Book of Records.
• Worked on MSSQL server 2012 and windows 2012 environments extensively.
• Combined powershell scripts with MSSQL scripts to gather AD group information thus determining the authorization of the users in the AD group.
• Ran the MSSQL jobs every month to gather violations and reported to senior level management.
• Worked on Centrify and the associated MSSQL database, tuned the database for performance issues by modifying the database parameters.
• Worked with Centrify vendor and created indexes in the centrify mssql database tables.
• Created and scheduled jobs to monitor the MSSQL database performance, database size, concurrent session.

Environment: Oracle 12c, OEM 12.1.0.2, Sun Solaris, MSSQL Server 2012, Centrify, Sybase 15.6, TOAD 12.8, Oracle Ebiz Suite R12.

Confidential, Dallas, TX

Sr. Oracle Database Administrator

Responsibilities:

• Supported production database.
• Worked as a consultant supporting projects between Netscout (telecom vendor to ATT) and ATT.
• Fixed bugs common to 11.2.0.3 database version by installing patches.
• Supported massive databases with almost 90TB of data.
• Worked on SQL Loader data loading with direct path loading as default.
• Resolved database fragmentation by creating triggers that would load data into temporary tables and then merge back partitions later.
• Migrated ASM diskgroups that were created with Normal redundancy to External redundancy using renamedg.
• Worked on database upgrade from 11.2.0.3 to 11.2.0.4
• Created test environment databases.
• Reduced the control file wait events by creating a new diskgroup for control files.
• Worked on various other performance issues depending upon wait events on the database.
• Generated SQL execution plans and suggested changes where necessary.
• Created and maintained scripts for automation of database jobs like backups and cron jobs.
• Performed point in time recovery of the database.

Environment: Oracle 11gr2 RAC 4 nodes, Sun Solaris, SQL Loader, TOAD 12.6

Confidential, Dallas, TX

Sr. Database Administrator

Responsibilities:

• Supporting production database system 24*7
• Acted as Senior DBA and primary Point of Contact for client for production database support, performance issues and availability issues.
• Installed and configured Oracle 10g/11gr1, 11gr2 RAC and standalone database both on ASM and normal file system.
• Helped in documentation of installing new Oracle 12c clusters.
• Worked on cross platform Oracle database migrations such as zLinux to AIX using transportable tablespaces and export/import utilities.
• Setup Developer Environments, supported RMAN Cloning and data refreshes using PL/SQL procedures.
• Created UNIX shell scripts and created cron jobs for automating database refreshes utilizing export/import utilities.
• Used RMAN for backup and recovery.
• Performed backup validations using RMAN
• Implemented Hot, Cold and Logical backup plans.
• Performed Database patching on both standalone database and RAC databases in a roll-over fashion without any down time to the end users.
• Installed the new 12c Oracle Enterprise Manager Cloud control version agent on the AIX 6.1 and RHEL 5 OS versions.
• Upgraded the older versions of OEM agents including 10g and 11g to OEM 12c.
• Setup proactive database monitoring using new 12c Oracle Enterprise Manager Cloud control.
• Worked on discovering, promoting, adding and monitoring of new targets and Oracle homes in 12c Oracle Enterprise Manager.
• Involved in switch over and continuity of business tests which included opening the standby database in read write mode with flashback option.
• Installed and Configured Logical and Physical Standby databases using DataGuard.
• Ensuring that all databases are backed up on a regular basis by monitoring full, differential, transaction log backups for OLTP, Data warehouse, and Business object repositories. Fix backup failures, address and implement resolutions.
• Supported databases for IBM WebSphere Portal Server.
• Created database, schemas and tablespaces necessary for IBM WebSphere Portal server setup such as RELEASE, LIKEMINDS JCR, COMMUNITY, CUSTOMIZATION, JCR, and FEEDBACK.
• Conducting sizing & capacity planning for Oracle databases
• Monitored and managed database space using automated cron jobs to check tablespace size.
• Management of table space growth, monitoring data files additions, extent growth.
• Used SCAN IPs for building the 11gr2 database and setting up connection strings for 11gr2 databases.
• Worked on database builds including 10g, 11gR1 and 11gR2 versions on AIX 6.1, RHEL 5 and Sun Solaris environments.
• Upgraded and migrated Oracle 10g databases to 11gr1 and 11gr2 versions.
• Monitored Growth of normal and partitioned tables and worked on necessary re-organization of database objects as and when required.
• Loading the database with external files such as text files using SQL*Loader and reviewed the generated log files information.
• Worked on performance issues, fixed row lock contention issues with huge inserts and tuned long running SQL queries.
• Tuned SQL queries like select for update statements and insert statements that were using functional based indexes that were causing high contention.
• Worked closely with development teams to tune the SQL response time based on the stats gathered and execution plans generated.
• Tuned the SQL queries that were doing full table scans as predicate was indexed but the histogram was preventing the index to be used.
• Management of schemas objects partitioning the tables & indexes and fixing invalid objects.
• Restored and recovered corrupted databases using point in time recovery.
• Considerably reduced the I/O performance migrating the databases from regular storage to Oracle Exadata thus utilizing some of its key features such as SmartScan and Storage Indexes.
• Fixed grid control alerts on the database and monitored the database using grid control including managing of templates.
• Installed and configured SAP BRTools 6.4 for managing Oracle database instances.
• Used SAP BRTools character based GUI for setting up backup jobs, managing database instances and for database space management.
• Used Oracle Advanced Security Features (ASO) with Oracle Internet Directory (OID) for User maintenance, schema mappings and Single Sign on Authentication (SSO).
• Installed Golden Gate 11.2.0.1, configured and implemented replication on databases that required Business Continuity.
• Monitored the extract and replicate process and in case of abends fixed the replication issues.
• Used Veridata for data comparison and fixing out of sync data issues.

Environment: Oracle 10g/11gr1/11gr2 RAC, OEM 12.1.0.2, 11.2.0.3, 11.1.0.1, 10.2.0.5, SQL, IBM AIX, Sun Solaris, Unix, Red Hat Linux, Windows 2003, Dataguard, Oracle Exadata Half rack, Golden Gate 11.2.0.1, SAP BRTools 6.4, SQL Loader, 12c OEM cloud control, TOAD

Confidential, Dallas, TX

Oracle Database Administrator

Responsibilities:

• Involved in 24x7 support for Production database and applications with on-call pager
• Installation and creation of 11g RAC, 10g RAC and for Testing, Development and Production
• Supported upgrades from Oracle 9i to 10g, 10g to 11g.
• Installed and configured Oracle 10g/11g RAC for high availability
• Creating and Managing Table spaces with different block sizes to prevent row chaining
• Data Refresh from Production to Test and Development environments using manual method and RMAN Duplication.
• Involved in Golden Gate installation, configuration and testing on Dev and Test environments.
• Created user accounts on the database for the Golden Gate and granting privileges.
• Worked on issues raised while replicating the data using GoldenGate.
• Cloned environments to create patch test, development and QA environments.
• Setup of Standby Database (Data Guard). Performing Failover and Switchovers
• Worked on Database/Schema/Table Re-Organization for faster performance using export/import & datapump procedures.
• Daily Health Check Up of the Database using AWR and ASH reports.
• Rebuilt Indexes for better performance, maintenance of Oracle Database.
• Monitored and tuned system resources associated with the database performance, hit ratios, I/O, lock, and latch contentions using OEM.
• Used OEM for creation of tablespaces, users, and tables and taking backups.
• Maintained Oracle databases that used EMC storage on Symmetrix VMAX series.
• Worked closely with System Administration teams in setting up EMC PowerPath and helped in testing load balancing and failover.
• Performed conversion of an Oracle single instance into an Oracle RAC database.
• Created a RAC physical standby database for a RAC primary database.
• Partitioning large objects for better performance.
• Created scripts for Cold Backup, Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Worked on ETL tasks including data migration between various databases such as MS SQL Server 2008 and Sybase.
• Created BCV clones - LUN based replication using EMC TimeFinder.
• Tested recovery of databases using RMAN and the Oracle database image made using the EMC TimeFinder.
• Used Symmetric Command Line Interface (SYMCLI) to maintain BCV copies of data.
• Installed and configured Oracle Client software and 3rd party tools.
• Created Scripts to query performance views to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and the PGA.
• Created shell/SQL scripts to monitor Table spaces and Extent growth
• Written UNIX/Linux shell scripts for backup and recovery, import and export procedures using grep, awk and sed OS utilities.
• Worked on extracting data and loading xml data into Oracle and MS SQL databases using Informatica.
• Worked on data migration from one database to another database on a different platform using transportable tablespaces.
• Gathered database requirements from client calls and planned database storage capacity and ASM capacity.
• Created Star and Snowflake schemas per user requirements.
• Worked on creation of separate database services for batch loads.

Environment: Oracle 11g RAC/10g RAC/9i, MS SQL Server 2008, Sybase Advantage Database Server, TOAD, ASM, HP-UX, AIX, GoldenGate, Dataguard, Solaris, OEM, Explain Plan, Tkprof, SQL*LOADER, EMC software and storage solutions