SUMMARY

• 18 years of IT experience as a production Oracle Database Administrator on various operating systems such as Linux, Solaris, HPUX, AIX, Windows and OpenVMS.
• Extensive knowledge and experience on Oracle database 8i to 12c.
• Very good knowledge and experience troubleshooting Oracle RAC databases.
• Strong knowledge and experience in Performance Tuning activities using tools such as AWR, STATSPACK, ADDM, TKPROF, SQL*Trace.
• Highly skilled and experienced in Oracle Golden Gate.
• Highly skilled and experienced implementing TDE.
• Extensive knowledge and experience in database cloning using tools such as RMAN, CTAS, data pump, SQL*Loader, Import/Export, BCV's and Snap clones.
• Strong knowledge and experience of Unix Shell scripting.
• Highly skilled in managing Oracle VLDB and DW databases with Informatica.
• Good experience and knowledge of other databases including SQL Server, DB2 and Informix.
• Good experience of Cloud operations, configured databases from Oracle Cloud.
• Good experience installing and maintaining databases using Delphix.
• Good experience in SQL and PL/SQL programming language.
• Good experience and knowledge of APEX web application.
• Basic understanding of NoSQL databases, Hadoop clusters, and Mongo database.
• Provided 24/7 On - call support for Production databases.

TECHNICAL SKILLS

Operating Systems: Linux, HPUX, AIX, Solaris, Windows, OpenVMS

Database Software: Oracle 12c/11g,10g/9i/8i, Informix, DB2, SQL Server

Languages: SQL, PL/SQL, Unix shell scripting, Perl basics, python basics

Database Tools: SQL Developer, SQL*Plus, TOAD, OEM, RMAN, FGA, SQL*Loader, Imp/Exp, Data Pump

PROFESSIONAL EXPERIENCE

Confidential

Senior Database Administrator

Responsibilities:

• Performed on-call duties in 24/7 Production and on-call rotation.
• Supported many Oracle and RAC databases during on-call rotation.
• Primary DBA for 15 different Database Projects on Oracle versions 9i to 12c with database sizes ranging from 5GB to 70TB.
• Supported a very busy Customer Application called Opus with 224 databases, on Linux, sizes ranged between 2TB and 10TB. All databases had Golden Gate and Standby configurations including a very busy 3 node RAC cluster.
• Responsible for coordinating October 2017 PSU patching for 224 databases, including coming up with a schedule and recruiting 4 other DBA to assist in patching all databases within 1 month's timeframe.
• Configuration of new project databases from cloud deployments including Data Guard Broker setup and troubleshooting.
• Provided support for 2 70TB Customer Databases. Assisted with prep tasks for ongoing migration to Exadata RAC environment. Adjusted space on these databases by working with the Application DBA's to drop partitions to free up space, by adjusting the partition retention values. This database had a 28TB table that grew 1TB per day. Ordered emergency storage of 20TB for these databases. Participated in ongoing performance tuning meetings.
• Responsible for resolving tickets and adjusting thresholds for OEM, Patrol and Custom Script alerts.
• Responsible for database backups. Scheduling, testing, troubleshooting and monitoring all RMAN backups and recovery activities for supported databases.
• Creation of shell scripts for automating export jobs, queries and space reporting.
• Troubleshoot and resolve database performance issues as needed.
• Automated weekly export of databases using Data pump and shell scripts.
• Implemented Character set changes in UAT database environments to change oracle database character set from ascii to utf8.
• Responsible for implementing Security policies and resolving Security violations in all databases by following standards set forth by Confidential &T. Types of security violations included revoking excessive privileges as needed.
• Responsible for general health of standby databases. Duties performed involved troubleshooting issues, resolve gaps, checking lags on standby logs, re-create standby using RMAN.
• Implemented FGA code changes in production databases as needed including re-writing instructions and automating changes in shell scripts.
• Responsible for setup and troubleshooting of custom Monitoring of DTV databases.
• Worked with Offshore Application and System DBA's as needed to resolve issues as needed and during on-call rotations and planned outages.
• Assisted Offshore DBA’s support Confidential databases.
• Performed Health checks on databases as needed.
• Worked on tickets and Change requests as necessary.

Confidential

Principal Analyst

Responsibilities:

• Performed on-call duties in 24/7 production environment and on-call rotation.
• Responsible for 55 dev, test and production databases on Oracle version 8i to 12c with database sizes up to 7TB.
• Performed upgrades from 8i to 12c on all supported databases.
• Automated and implemented partition maintenance scripts for range, hash and composite table partitions for 2 separate VLDB’s Database Projects (Paris and DTV Data Warehouse).
• Worked on Data Warehouse database migration to new storage of 4 TB Oracle Database with over 1500 datafiles.
• Troubleshooted Golden Gate and RAC issues during on-call rotations for busy Customer Facing Web Application ( Confidential .com).
• Responsible for refresh of dev/test environments from production using RMAN, NetBackup, BCV's, Snap clones, and CTAS scripting.
• Worked with Unix Admins on implementation of EMC BCV backup and recovery strategy for Data Warehouse and large Data Repository databases. Both databases had nightly sync and splits jobs.
• Responsible for PSU patching 2 times per year for all supported oracle databases. Including being the facilitator for entire group’s patching activities as chosen by DBA Manager.
• Performed health checks for all databases on regular intervals or upon request.
• Supported several SQL Server databases, including installation, troubleshooting and support for 7 years of SQL Server 2000 and 2005 versions. Also supported the Legal Department SQL Server migration which included a data migration upgrade. Applied quarterly rules for Legal Department which included a separate set of instructions to update their database. Supported this database for 7 years along with a few other critical projects on SQL Server.
• Participated in 3 separate Data Center migrations.
• Implemented Active Data Guard on the Change Management database production database for reporting purposes.
• Installation of Ingrian row level encryption software on Oracle and SQL Server databases.
• Implemented TDE on many tables for Fraud Management database using SQL and Unix Shell scripts.
• Provided support for many application upgrades including Informatica, OEM and OID, OBIEE and Weblogic Servers.
• Performed switchovers on Data guard databases for Data Center migration, or on request.
• Provided raw data for database sizing information for custom reporting in APEX application. This was a Team Project initiated by our DBA Manager to come up with accurate database sizing information.
• Support two very large databases with Informatica for several years, including database migrations to new servers, upgrades and complicated BCV restores from tape.
• Performed database SOX and PCI audits, provided database information to Auditors as needed/required.
• Participated in database restore exercises, including testing, documenting and performing RMAN restores.
• Worked with Delphix Support and other colleagues to setup and install Delphix to take advantage of storage savings, and fast refreshes for many reporting and test databases.
• Refreshed reporting and test databases with Delphix.
• Researched masking features of Delphix to apply to databases with PCI data.