SUMMARY:

• A Senior Oracle Database Administrator and Architect
• Diversity gained from defense, manufacturing, media, eCommerce, and financial service industries
• Designed, implemented, and managed the company’s databases across multiple platforms, technologies, and locations
• In depth knowledge of Relational technologies, Data Modelling, Logical and Physical database Design
• Extensive experience working with Outsourcing companies (both onsite & offshore)
• Demonstrated capabilities include Database Administration, Design, Performance Tuning (ADDM, AWR, ASH), RMAN, ASM, RAC, Clusterware, Data Guard, Golden Gate, Cloud/Grid Control, Partitioning, Data Pump, Oracle Net, and Shell Scripting
• Oracle 10g DBA OCP (Oracle Certified Professional) Certified
• Database support for multiple large and complex databases (up to 10 TB) in production, QA, and development environments for various types of databases - OLTP and Data Warehouse - hosted on Unix and Linux platforms. Current database versions mostly 11g. Some 10g and 12c.
• Responsible for all standard database administrative tasks, such as proactive performance tuning and monitoring, troubleshooting, backup and recovery, space management, development and production 24x7 support, partitioning, replication, installations, patches, critical CPU patches, and upgrades.
• Logical and Physical Database design based on Relational Technology for OLTP and Data Warehouse applications.
• RAC: Installed 35+ two-node to seven-node Real Application Cluster (RAC) 11g & 12c databases hosted on RedHat Linux. Installed/ Managed 10+ RAC database instances hosted on AIX, Sun Solaris, and HP-UX. Database sizes up to 10 TB. Added and deleted nodes to/from an existing cluster.
• RMAN: Developed RMAN scripts for full and incremental database backups. Restored and recovered from a number of failure situations. New databases were created using RMAN Duplicate 40+ times.
• DR - Worked with Business Continuity group in establishing suitable Disaster Recovery (DR) plans. Installed multiple Data Guard and Golden Gate replications.
• OEM Cloud/Grid Control: Installed 11g Oracle Enterprise Manager (OEM) Grid Control for database monitoring, administration, and performance tuning.
• ASM: Installed 10g/11g/12c Automatic Storage Management for 60+ RAC and stand-alone databases
• Data Guard and Golden Gate Replications: Created a half-dozen standby databases. Implemented multiple Golden Gate replications.
• AWR/ADDM/ASH: Analyzing various AWR, ASH, and ADDM reports in 10g and 11g to identify potential bottlenecks. Also developed home-grown Unix shell scripts and utilized third party tools for tuning of SGA, Shared Pool, Library Cache, Dictionary Cache, Buffer Cache, I/O Tuning, and reducing Disk Contention.
• Applications Tuning Using EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE, HINTS etc.
• Utilizing Export/Import/Data Pump/SQL Loader for various data movements, loads, and conversions.
• Developing/ Modifying Unix Shell scripts to automate administrative tasks, backups, and monitoring.

TECHNICAL SKILLS

• Operating Systems: Win 2K/2K3/NT/XP/Vista/7/8, UNIX, Linux, HP/UX, IBM Massively Parallel Server (MPP), IBM P - Series/AIX, and Sun/Solaris.
• Languages/ Applications Software/ Tools/ Processes: C, ORACLE 7/8i/9i/10g/11g/12c servers, SQL, SQR, PL/SQL, OPS (ORACLE Parallel Server), OEM, ADDM, AWR, ASH, RMAN, ASM, 10g/11g/12c RAC, Oracle Clusterware (CRS), Data Guard, Golden Gate, Cllud/Grid Control, Partitioning, Data Pump, Data Warehouse, DSS, OLAP, Relational Database Design, Toad, Unix Shell Scripting, JavaScript, Web technologies, ATG eCommerce, Endeca, Websphere, EMC Avamar, EMC ddboost, ERwin, CMM, Six Sigma, SDLC, Infoman, Service Now, and Jira.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Databases Administrator, Consultant

Responsibilities:

• Part of a database team, managing 450+ Oracle Standalone, RAC, and Data Guard databases
• Platform - Linux, Sun Solaris
• Database versions - Mostly 12C, some 11g
• Performed dozens of PSU Patches, GI/ASM, and Databases upgrades from 11g to 12c
• Providing support to Development, PeopleSoft, and EBS (eBusiness Systems) teams
• Performance Tuning, Monitoring, Troubleshooting, and Root Cause Analysis, using AWR, ADDM, ASH, and home grown Unix shell scripts

Confidential

Sr. Databases Administrator

Responsibilities:

• Installed 50 + stand-alone and 2 to 5 node RAC databases (Grid Infrastructure, ASM instance, ASM diskgroups, Oracle Clusterware, and database instances) hosted on Linux. A half-dozen databases were hosted on HP-UX. Added and deleted nodes.
• Managing 10+ stand-alone and RAC databases hosted on Sun Solaris and AIX
• Created a half-dozen Data Guards/ Standby databases
• Implemented multiple Golden Gate replications
• Database versions - Mostly 11g; some 10g & 12c
• Upgraded a dozen RAC and stand-alone databases from 11.0.2.3 to 11.0.2.4 and 12c
• Applied security and quarterly patches 50+ times
• Environment: ATG eCommerce, Oracle RAC versions 11.2.0.3 & 11.2.0.4, 12c, Linux RedHat 6.4, ASM, EMC/SAN, EMC Avamar and EMC ddboost Tape backup, ATG, Jboss, WebSpehere, Endeca, and more.
• Unix shell scripting
• Implemented Huge Pages for 30+ Production and QA databases
• Performance Tuning, Monitoring, Troubleshooting, and Root Cause Analysis, using AWR, ADDM, ASH, and home grown Unix shell scripts
• Implementing Best Practices and enforcing company’s database Architectural Standards
• Working closely with End-Users, SA, Network, Operations, Development, PMO, and Release Management teams
• Extensive work with RMAN backup and recovery manager. Implemented 40+ RMAN Duplicate database creations. Successfully restored from a handful failure scenarios using RMAN.
• Assisting Development team with their SQL & PL/SQL & Shell scripting
• Performing all aspects of database administration for Dev/QA/Production environments … including installation, upgrades, performance tuning, Capacity Planning, AWR, ADDM, ASH, backup and recovery using RMAN, ASM, RAC, Data Guard, Golden Gate Replication, Grid Control (OEM 12c), Data Pump, Import/Export, SQL Loader, partitioning, monitoring, shell scripting, and more.
• Participated in implementation of various projects, Conversions, and Data Migrations (20+ databases) across multiple disciplines and departments

Confidential

Sr. Oracle DBA/ Assoc. Director

Responsibilities:

• Managing 200+ databases hosted on AIX and Sun platforms ... including multiple 2-node and 7-node RAC databases on AIX using Oracle Clusterware (CRS) and ASM. Some used for eCommerce. Some DB2, SQL Server, MySQL, and Sybase.
• Performing all aspects of database administration for Dev/QA/Production environments - including installation, upgrades, performance tuning, AWR, ADDM, ASH, backup and recovery using RMAN, ASM, RAC, Grid Control, Data Pump, Import/Export, SQL Loader, partitioning, monitoring, shell scripting, and more. eCommerce platform: Oracle, RAC, ASM, AIX, Linux, ATG, Endeca, and Websphere
• Supervision of DBA & eCommerce Operations staff, including offshore resources
• Providing technical and database architectural guidance to executives
• Database and Tools licenses and Vendor Management
• Led multiple database migrations, patches, upgrades, and consolidations
• Working closely with Development, QA, PMO, Change Management, Finance, and other business units
• Participated in implementation of dozens of projects and conversions across multiple disciplines and departments
• As an Associate Director in charge of Web Operations worked closely with the Outsourcing provider’s Relationship Manager (HCL America) and Onsite and Offsite Managers to ensure SLA’s are met, KPI’s were in check, ensured billing accuracies for all the technical disciplines (including Staff and Services for Database Admins, System Admins, Storage, Occupancies and Backups, Servers, Data Centers, Network, NOC, Help Desk), and more. A technical liaison between Confidential ’ senior management and HCL’s Onsite and Offsite Managers. Setup regular meetings to address quality and performance and made sure we received an excellent service from HCL.

Confidential

Lead Oracle DBA

Responsibilities:

• Performed all aspects of database administration for 300+ ORACLE Database Instances, hosted on AIX, Linux, and Windows platforms.
• Tasks included: Logical and physical database design, database creation and maintenance, Oracle software install / upgrades / migration /CPU patches, data conversions, space management, performance tuning and monitoring using Oracle & third party tools, capacity planning, troubleshooting, development and production 24x7 support, backup and recovery using RMAN, monitoring using Database Control and Grid Control, RAC, ASM, referential integrity and constraints, primary key / foreign key, database security and roles, maintaining database objects, Data Pump, Export / Import, SQL Loader, Data Warehousing, DSS, OLAP, Disaster Recovery, evaluating software and tools.
• Worked closely with business units to plan / evaluate / design / implement solutions based on sound technologies. Provided support to users and development team.
• Interfaced with the Outsourcing provider (Cognizant - aka CTS and Silverline) Onsite and Offsite staff. First Data’s relationship with Cognizant and Silverline was only for Development efforts. Managed a 60+ development staff at offshore. Checking the qualification of their staff to make sure they matched their positions in order to achieve First Data’s target, deliverables, and SLA’s.

Confidential, Melville, NY

Oracle Developer

Responsibilities:

• Developed ORACLE based applications for a manufacturing and order processing application in a Unix environment. Utilized, ORACLE, SQL, SQR, SQL Forms, SQL Reports, data normalization / denormalization, and Unix Shell programming.