SUMMARY:

Experienced IT Consultant and Senior DBA team leader with long term expertise in engineering, implementing and supporting disaster recovery and high availability solutions based on Oracle, MySQL and SQL Server software on multiple OS platforms. Independent, self - motivated team player with over 20 years of working remote.

TECHNICAL SKILLS:

Oracle Database Administrator: Certified Professional (8i/9i/10g/11g) Oracle Certified Expert, Oracle Real Application Clusters 11g and Grid Infrastructure Administrator Oracle Database 11g Performance Tuning Certified Expert

Oracle E: Business Suite R12 Applications Database Administrator Certified Professional Cloudera Certified Administrator for Apache Hadoop (CCAH) MapR Certified Administrator for Apache Hadoop

Operating Systems: HP-UX 9/10/11/11i, HP MC ServiceGuard clusters, Veritas Cluster Server (VCS), Veritas Storage Foundation (SF v5.1), Veritas Oracle Agent, AIX, Solaris, Linux and Windows Server, Oracle Linux, Oracle Exadata and Oracle Database Appliance, VMWare

Software: Oracle 7/8/8i/9i/10g/11g/12c, Oracle 9i/10g/11g/12c RAC, Oracle Data Guard (standby db, both logical and physical), Oracle Advanced Replication, Oracle Streams, Oracle GoldenGate 11g/12c, RMAN, Oracle Enterprise Manager, 9i/10g/11g Application Server, Oracle E-Business Suite R12 DBA, Oracle Internet Directory (OID/ONS), MySQL, SQL Server 2005 and later versions, Oracle Retail (RMS), MySQL 5.0 and later versions, PostgreSQL, Hadoop (HDFS), Cloudera Enterprise Data Hub, MongoDB, Vertica, VoltDb, Amazon AWS/RDS, Azure

Programming Languages: SQL, PL/SQL, Perl, Shell scripting, Penatho BI/ETL, Tableau, Python, R, NoSQL, Informatica ETL

PROFESSIONAL EXPERIENCE:

Senior Oracle Database Administrator / Oracle Team Lead

Confidential

Responsibilities:

• Principal database engineer for business-critical production databases.
• Support, administer and maintain production and non-production database environments primarily running on the AIX and Linux platforms.
• Implement and maintain proactive database monitoring for space issues, database locking, performance issues, and other key metrics.
• Work with the development and application support teams to identify, triage and resolve performance issues using diagnostic tools such as AWR, ADDM, ASH and SPM
• Optimize and tune BI queries running on production databases and data warehouses.
• Create, build and maintain a Cloudera Hadoop cluster to support Informatica and BI Analysts.
• Analyze, optimize and tune advanced complex SQL queries and their associated execution plans using command-line tools.
• Deploy and maintain high availability & failover technologies such as Data Guard and Real Application Clusters and Golden Gate to maximize database availability.
• Create, clone and upgrade environments to support implementation activities as required.
• Define, implement and support Backup and Recovery policies using RMAN and/or storage level replication technologies.
• Perform database restore and recovery in the event of an outage.
• Define, implement, and enforce security standards for the database in compliance with company policies as well as compliance frameworks including SOX and PCI.
• Ensure sensitive data is appropriately protected via industry-standard encryption solutions.
• Work with the appropriate teams (Security, Compliance, Internal Audit, and External Auditors) to review security policies, participate in annual audits, and implement the appropriate remediation measures.
• Contribute to, and update systems documentation as required.
• Create, migrate and maintain Oracle and SQL Server databases to the cloud (AWS, Azure, Oracle Cloud)
• Provide MySQL production DBA support, performance tuning, replication and cluster support, troubleshooting and consulting to clients on an as needed basis.
• Oracle EBS R12 performance troubleshooting, patching and user maintenance
• Provide ongoing management, administration, installing and testing of patching and upgrade processes for Oracle E-Business Suite
• Perform change management and Oracle EBS application and database code migrations between environments
• Clone and refresh Oracle EBS environments to support projects and testing
• Develop and maintain backup and recovery strategies for Oracle EBS and non-EBS database, develop disaster recovery plans and execution for enterprise level databases and applications.
• Perform Microsoft SQL Server DBA support, performance tuning and troubleshooting tasks
• Participate in 24x7 rotation for both Oracle and Microsoft SQL teams

Senior MySQL/Oracle Database Administrator

Confidential

Responsibilities:

• Provide DBA support for McGraw Hill MySQL databases. Duties included resolving common issues with master-slave replication, backup and restores, performance tuning and maintenance of operating system environments. MySQL environments included several active/passive clusters and Linux HA clusters to provide high availability. Amazon RDS MySQL databases were also maintained as part of the infrastructure.
• Provide DBA support for McGraw Hill Oracle EBS databases. Duties included cloning EBS databases from production environments to development or QA environments. Common DBA tasks such as backup/restore tasks, performance tuning and change requests according to customer direction were part of daily tasks and responsibilities.
• Provide DBA support for McGraw Hill Oracle databases. Duties included support of several multi node RAC clusters with Data Guard, upgrading databases, applying oracle patches, performance tuning and backup/recovery tasks. Also included were routine change requests from McGraw Hill to be applied to the environments, and participation in monthly oncall rotation for DBAs to address critical issues across all McGraw Hill environments.
• Upgrade and patch Oracle RAC 11g databases to 12c. Provide post migration support for applications migrating to 12c.
• Provide DBA support for storage and data center migrations across McGraw Hill Oracle and MySQL environments.
• Provide DBA support for McGraw Hill SQL Server databases. Duties included installation, performance tuning, backup and recovery of databases across clustered and non-clustered environments. Setup and support SQL Clustering, Log Shipping, AlwaysON HA groups and SSIS/SSRS instances.

Database Practice Lead Consultant

Confidential, Larkspur, CA

Responsibilities:

• Provided consulting and implementation support for an Oracle Streams 11g to Oracle GoldenGate upgrade and conversion for a high volume online bookstore. Implemented a POC implementation of GoldenGate running on Oracle 11g.
• Provided Level 3 DBA Support for a large banking customer environment running multiple Oracle RAC 10g/11g clusters with Oracle Data Guard and Oracle GoldenGate replication. Duties included maintaining and updating Oracle GoldenGate installations, troubleshooting replication issues in both GoldenGate and DataGuard, performance recommendations, Oracle software patching of Oracle RAC clusters and backup/recovery of production, DR and development databases.
• Performed an Oracle migration and upgrade from 10g to 11g for databases running on HP/UX PA-RISC OS to Linux-x64 and PeopleSoft. Implemented Oracle Data Guard to support DR function for upgraded databases.
• Upgrade and patch Oracle databases running Oracle 11g RAC and EBS Suite to Oracle 12c RAC.
• Performed a SQL Server 2008 migration to a new Hyper-V environment and implement log shipping to provide a DR system for 60 databases.
• Performed a large scale migration from Oracle 10g to 12c RAC; created SQL baselines and profiles for several hundred queries moving off of 10g to 12c. SQL performance tuning and optimization of existing SQL and stored procedures.
• Created and implemented migration plans for a 10g standalone data warehouse and OLTP databases to consolidate to 11gR2 RAC running on an Oracle Database Appliance.
• Designed and Implemented an ETL process using Hadoop and Hive to provide aggregated data in SQL Server 2012 to support an online data provider's Tableau dashboards driven by demand.
• Performed Vertica DBA duties and implemented a new schema design with initial projections optimized for a Vertica database used for BI Analytics and reporting by a major online gaming customer.
• Architected and implemented a complete data center migration consisting of over 900 Oracle and SQL Server databases to new hardware consisting of Oracle RAC and VMWare HA clusters to replace legacy hardware hosting virtual machines running Oracle and SQL databases.
• Architected MySQL databases utilizing clustering and replication to provide highly available environments for production purposes.
• Provide MySQL production DBA support, performance tuning, replication and cluster support, troubleshooting and consulting to clients on an as needed basis.
• Architect complete data center migration for a large healthcare provider. Migration consisted of creating migration plans, providing detailed specifications and requirements, integrating enhanced security for database applications transmitting data over the wire, and multiple Oracle RAC to Oracle Exadata database platform migrations.
• Provide MongoDB/PostgreSQL/NoSQL consulting and DBA support to clients
• Provide MySQL migration and upgrade consultation to clients
• Provide consulting and pre sales support in Big Data and RDBMS technologies.
• Provide knowledge transfers and to internal technical staff and customers.

IT Consultant / Senior Oracle DBA

Confidential Palo Alto, CA

Responsibilities:

• Provide Oracle and SQL Server database support and consulting to Confidential ’s external trade customers. Support includes routine DBA tasks such as backup and recovery of full and partial databases using RMAN/NetBackup/DataProtector, performance tuning of SQL and PL/SQL code, system and database performance tuning of HP-UX multiprocessor shared database environments.
• Provide detailed architecture, consulting, engineering, implementation and support for database availability, backup and recovery, and performance tuning projects.
• Provide system DBA engineering, implementation and support for Siebel Applications, Oracle E-Business Suite R12, PeopleSoft and SAP using Oracle databases.
• Provide DBA implementation and support for E-Business Suite/SAP/PeopleSoft and Oracle migrations and upgrades, including environments using Oracle DataGuard.
• Provide Oracle Application Server and Oracle APEX implementation and support
• Provide support for Oracle Enterprise Manager Grid Control (10g/11g/12c) and Agents.
• Provide 3rd level support for Oracle RAC, including system architecture, applying patches, performance tuning, backup and recovery issues with RMAN/DataProtector, trace analysis, service creation, cluster and system management
• Implementation and support of 10g and 11g migrations and upgrades from Oracle 9i and 10g databases, including RAC (Real Application Clusters) databases on HP-UX and Linux.
• Engineering, implementation and support for high availability solutions using Oracle Data Guard, Real Application Clusters (RAC), Oracle Streams, Oracle Advanced Replication and HP specific network storage and clustering solutions.
• Engineered, implemented and supported Oracle 9i SAP environment (over 10Tb in size) to use Oracle DataGuard on HP-UX for over 4 years. Successfully engineered, implemented, documented and supported upgrade of the environment to Oracle 10g.
• Lead engineering effort, implementation and support a migration of an existing Oracle 10g RAC (64cpu/128gb RAM/60Tb ASM disks on HP-UX) environment worth over 10M in annual revenue to the customer to two (128cpu/192gb RAM/60b ASM disks on HP-UX) environments.
• Engineering, implemented, documented and support builds of new clusters to use Oracle 10g/11g RAC on HP-UX and Linux. Including installing clusterware, ASM (and shared disks) and creating new databases.
• Lead engineering effort, implementation, tuning and support of Oracle 10g RAC/Dataguard upgrades to Oracle 11g RAC/Dataguard. Designed a proof of concept environment to facilitate functionality testing and features, built a pilot environment which mirrored production to do in depth testing for all customers, and provided a detailed migration plan to migrate the current production cluster to the new environments.
• Lead engineering and implementation effort for migration of over 100 small to medium sized databases (< 2Tb) from HP PA-RISC based machines to HP Itanium and Linux based machines
• Lead engineering and implementation of OEM 11g upgrade for an enterprise consisting of over 1000 managed Oracle databases.
• Worked on implementation of Oracle GoldenGate to facilitate data migration from Oracle RAC databases to Oracle Exadata.
• Provide database architecture and consulting to Confidential external trade customer sites with Oracle, HP/UX and SAP environments
• Perform assessments on customer sites and report to management with recommendations on how to achieve a highly available production environment.
• Create and supervise change and configuration management processes for external trade customers.

IT Engineer/ Senior Oracle DBA

Confidential, Palo Alto, CA

Responsibilities:

• Provide database and system management for multiple HP-UX/NT servers running Oracle 9i RAC and Oracle Advanced Replication, and several Oracle 8i databases ranging in size from 500Gb to 1.5Tb+.
• Installation, upgrades, migrations, performance tuning, backup and recovery, schema management, SQL tuning, proactive monitoring and troubleshooting Oracle databases in a 7x24 environment.
• Primary DBA support for HP's primary E-commerce site, several related customer-facing OLTP and data warehouse systems. Databases were responsible for single sign on and profile information to over 3000 internal HP websites.
• Provide engineering, implementation, strategy and support plans to development teams for database related issues, including designing HA and redundant database systems and implementing advanced Oracle options for mission critical environments.
• Designed, implemented and supported highly available RAC clusters for companywide single sign on application, as well as other database solutions using advanced replication and standby (data guard) options.
• Provided Oracle RAC consulting and engineering to internal HP-IT organizations for planned implementations and migrations. Consulting included designing backup solutions (using RMAN), disaster recovery plans, and performance tuning advice for RAC implementations.
• Design, implement and support Oracle advanced replication and Oracle streams to provide a replicated database environment to support internal HP business sites.

Database Administrator /Developer

Confidential, Atlanta, GA

Responsibilities:

• Provide database and system management for multiple HP-UX/NT servers running Oracle 7.3/8/8i/9i, ranging in size from 200Gb up to 500Gb+ of data.
• Primary DBA support for HP's Pricing and Product databases, Enterprise Directory Service and multiple CRM applications.
• Implementation and support of Oracle standby databases, and multimaster advanced replication in an environment consisting of over 40 separate database environments.
• Implementation and support of backup strategies, providing database consulting and engineering to development teams within HP, creating custom SQL scripts, database monitoring and backup scripts, database performance tuning, writing support and documentation and investigating new database related technologies for use within HP.
• Develop stored procedures, functions and business logic in PL/SQL to support in-house database applications and websites.

REMOTE HIGH AVAILABILITY SPECIALIST

Confidential Atlanta, Georgia

Responsibilities:

• Provided remote technical consulting and DBA support for Confidential HA customers.
• Coordinated support plans for commercial customers with enhanced or premium support offerings.
• Scheduled requirements for analysts and developed a proactive change control management plan for customers.
• Designed tools to proactively report system availability in highly available environments.
• Provided remote technical support to Confidential customers with environments based on Confidential UNIX and Windows NT.
• Supported Microsoft server components including SQL Server, Exchange and SMS server, as well as the complete Backoffice suite.
• Duties included installation and configuration support, technical problem resolution, hardware and software assistance, and networking support for Confidential customer environments and clients.