SUMMARY

• Over 24 years of experience in Project management, Cost/Benefit Analysis, Leading Teams of various technical/non - technical staff, Strategy, Infrastructure Design, Capacity planning, Procurement, SDLC, Backend Databases/Data Warehouse Design and Administration.
• Expert skills in Oracle RDBMS (12c Rls2/11g/10g) Installation, Upgrades, High Availability, Database Creation, Performance Monitoring & tuning and Backup & Disaster Recovery strategies.
• Strong Data modeling, Data Conversion, Data & Volumetric Analysis, Application infrastructure & enterprise model management experience.
• Worked in Oracle Financials/SOA middleware/COTS products interface. Extensive knowledge of Oracle functionality & internals.
• Worked with variety of clients in financial/public sector, federal/State government and E-commerce based organizations.
• Good consulting and communication skills, with knowledge of client-relationship building techniques and project methodologies with good team building skills.

TECHNICAL SKILLS

OPERATING SYSTEMS: Solaris 11/AIX/Linux 7 (64-bit), HP-UX, Windows 2014 Server (64-bit).

DATABASES: Oracle 12c Rls2/11g Rls 2/10g/9i/8i, Oracle 12c SOA/BPEL

APPLICATIONS: Oracle 11.0.3 Financials/HRMS, Siebel 6.3/7.8 eCommunications.

LANGUAGES: Java, XML, SQL, PL/SQL, PERL/UNIX Shell/Awk.

TOOLS: Erwin ERX 7.3, Informatica Power Center 8.6.1, DB Artisan 9.4

OEM: 13c/12c Cloud Control, TOAD 8.6, Golden Gate 12c

MR TOOLS: MS Project, Visio, MS Power point, Service Now, Remedy, Team track

HARDWARE: Sun Enterprise E10K Server, HP 9000 Blade Servers, EMC SAN, Net Apps

PROFESSIONAL EXPERIENCE

Confidential

Sr. Program Manager - Databases

Responsibilities:

• Serving as Official Point of Contact for the Government for daily operations, delegation, prioritization of tasks for all Oracle/SQL Server/MariaDB database management.
• Providing Weekly/Monthly tasks status to Branch Chief, and weekly touch point meeting for new projects level of effort, resource allocation and infrastructure requirements.
• Providing technical leadership for mentoring, managing the Operations/Management staff for Migration of Mission Critical data/Infrastructure using Golden Gate, Design and Architecture Definition for Upgrade and New Highly Available environments.
• Researching and Providing technical Solutions for Oracle Backup and Recovery in Oracle Cloud, for faster storing and retrieval of backup Data.
• Defining New Architecture, Implementation Strategy for SEC OIT Enterprise Systems, Backend Systems Upgrades to 12c Release 2/18c, Separation of Duties using Database Vault for OIT DBA staff and Application DBAs.
• Managing DBA afterhours/Weekend Support schedules for One time/Monthly activities, Standby DBA rotations, serving as Point of Escalation for all Database outages/troubleshooting issues.
• Serving as main liaison between the Govt COTR and VARIQ management for all Task related requirements, activities, concerns and escalations.
• Supporting Annual DR exercises, Data Center moves deploying longer Data retention techniques by moving larger volumes of Oracle Archival information in AWS during the Standby Data Center Site move.

Sr. Project/Database Solutions Manager

Confidential

Responsibilities:

• Production and Development Database Support for Oracle 12c Rls 2/11g/10g on Linux 7 (64-bit) with RAC/ASM environment and Windows 2003 Advanced Server (64-bit) and VMware with CGI -Momentum Financial ERP package and various COTS products as the front-end.
• Provided recommendations and Vendor product evaluation reports for latest Oracle technologies and background to compare features and to Client for fulfilling their business requirements for Data retention and high availability.
• Provided Project management support, Operations/Infrastructure/Development teams coordination, delegation of work and duties.
• Provided on- call support for multiple projects and well-versed with handling Critical systems errors troubleshooting and escalation procedures for Oracle and management, on high bridges and serving as the Point of Escalation.
• Technical Architect for Oracle 11g to 12c Rls 2 (64-bit) upgrade, configuring Grid Control and Advanced Security (ASO) configuration for TDE and Network encryption for financial data.
• Implementing Database configuration management procedures using Team track and Remedy for promotion of changes from development to test and production.
• Creating ASM instances and DATA/Flash Recovery disk groups (for storing full/incremental backups, flashback database logs and archive logs).
• Oracle 12c/11g RAC installation in multi-node Solaris/Linux Red Hat (64-bit) environment for Oracle Fusion/SOA/BPEL implementation.
• Responsible for research and deployment of latest 12c Rls 2 features including DB Vault, Golden gate 12c for Oracle to Oracle replication, SSL Listeners connectivity with SCAN.
• Setup Data at rest encryption using TDE Vault with tablespace level encryption; Data in motion encryption using Network encryption.
• Installed Oracle 12c/11g Grid/RDBMS Software, Capacity planning, Disk/Volume layout and Database creation for Strategic Acquisition Management (BPM) & Network Event tracking projects (16 tera bytes).
• Installing Oracle FailSafe 3.4 (64-bit) and testing failover in 4 node cluster using EMC SRDF for Disaster recovery.
• Advanced Performance Monitoring and Tuning using 13c/12c OEM Grid Cloud Control, AWR, Metric baselines and ADDM. Query tuning using SQL Tuning and Access Advisors.
• Configured RMAN backups using 12c/11g scripting and configure with Veritas Netbackup.
• Setup Oracle 12c/11g (Active Data guard) for physical and logical standby in Production environments, using RAC/ASM storage in multi-tenant architecture.

General Services Administration

Confidential

Responsibilities:

• Development and Production Database Support for Oracle 10.2.0.4 with Siebel 7.8.2 Call Center application on AIX server (64-bit).
• Upgrade Oracle databases from 9.2.0.8 to 10.2.0.4.
• System technical architecture definition, Capacity planning, SAN Disk Storage, defining RAID levels for Production databases and data warehouse.
• BCV backups/restores for the databases on EMC SANs. RMAN configuration using Vertias for Backups and Data Guard for physical standby.
• Configuring Oracle Fail Safe 3.4 with MS Clusters for Active-Active db nodes in Windows 2003 environment.
• Logical/physical data model definition using Erwin and Capacity planning for monthly/yearly data loads.
• Performance monitoring and tuning using STATSPACK, OEM and custom scripts.
• Supporting Rational tools administration and Siebel, Business Objects and Informatica administration.

Confidential

Sr. Solutions Architect

Responsibilities:

• Provided Oracle Solution architecture for Oracle 11g and 10g databases (24x7support), sizes over 5 TB, on HP 9000 and Windows 2000 advanced servers using Oracle Failsafe.
• Provided research and recommendation to the client for successful implementation of Performance monitoring and tuning techniques using BMC patrol and Statspack reports and implementing DB security procedures using User Roles classification and data encryption.
• Backup and Disaster Recovery strategy and procedures implementation using BCV backups and RMAN.
• Oracle 10g (Enterprise Edition) installation and research available methodologies for replicating data between MCD’s (Mobile Computing Device) and Master DB server on Windows 2000 Advanced Server.
• Re-architecture of current Oracle 9iAS Rel2 (Forms and Reports) configuration, for load balancing (active-active) using Web Cache (active-passive) and upgrade to 10gAS.
• Maintaining the existing data model in Erwin to conform to the Standard naming conventions and Abbreviations document. Mentoring other DBA's on Data modeling techniques & principles.
• Communication of issues/scope and requirements to Data warehousing/Reporting, infrastructure teams and end-user groups.