SUMMARY:

• 19+ years experience in Database & Applications Administration, Architecture, Performance Tuning, Production Support, Data Migration, Disaster Recovery & Data Center Activities.
• Experience in Oracle E - Business Suite R12 & 11i, Exadata X3-2 & X2-2, SQL Server R2008, SAP, Peoplesoft, Siebel, Telecom Billing, Retail Management Systems Implementations and Operations.
• Expertise in Retail, Banking, Telecom, ISP, Healthcare and Software Domains.

TECHNICAL SKILLS:

RDBMS: Exadata X3-2, X2-2, Oracle 11g, 10g, 9i, 8i, Sql Server 2008& 2005, MySQL 5.0

Operating Systems: SUN OS, IBM-Aix, HP-ux, Oracle Enterprise & Redhat Linux, Windows

Utilities and Tools: Exachk, Flash Cache, Smart Scan, Real Application Clusters (RAC), CRS, ASM, GoldenGate v11, AWR, ADDM, RMAN, Dataguard, Grid Control (OEM), Shareplex, Foglight, Advanced Replication, Streams, Remedy, Autosys, BMC Patrol, DB Vault, TD Encryption, Wallet (OWM)

Applications Oracle Applications: R12, 11.5,x, Amazon Web Services (AWS), SAP R/3 4.6c, PeopleSoft CRM, EPM Systems, Siebel 8.0, JDA Allocation, Banking Mortgage and Loan Management Systems, Retek (RMS, SIM, RPM, Reim, RTM), Precise i3, ATG E-Commerce Merchandise, Content Management, Kenan Arbor Order Management, BP (FX) Billing System, Portal Infranet Telco Billing Systems

Languages: C, Pro*C, SQL*Plus, PL/SQL, T-SQL, Unix and Perl Scripting

Hardware: Exadata X3-2, X2-2, Vmware, Oracle Virtualization Manager, SUN Servers (M5000, M4000, E15K, E10K), HP-XP512 Enterprise Storage, HP 9000 Servers, IBM RS6000 Server, Intel Servers, Tivoli ADSM, EMC Storage, Veritas NetBackup

PROFESSIONAL EXPERIENCE:

Confidential, Plymouth, MN

Senior DBA Architect

Responsibilities:

• Manage EXADATA X3-2, E-Business, AWS and Mission critical applications databases on 24*7.
• Handle Oracle 12c, 11g & 10g RAC, CRS, ASM, Sql Server Installations, Disaster Recovery Center Setup, DataGuard Physical & Logical Standby database, Grid Control & Agents Setup, DB Upgrades, Migrations, DB and Apps Patches apply, RMAN Backup & Recovery Strategies, Database and Applications Performance Tuning Review and Datacenter Policy Adherence.
• Handle EXADATA Patching, Maintenance, Upgrades, Migrations, DB Architecture Design, Golden Gate Setup, SOX Database Compliance Audits, DB & Users Security Setup, Capacity Planning.
• Lead On-Site & Off-shore DBA team and Infrastructure teams on 24*7 follow the Sun (FTS) model.
• Co-ordinate with Internal and Third Party Vendors for Database & Application Systems upgrades.
• DBA Team peer review, Training, Budget, Time and SLA Management Processes reviews.
• Co-ordinate with Unix Systems and Storage Administrator Teams, Change Control committee Infrastructure Changes Reviews and Approvals, Co-ordination with Applications users and Business Users for all deployments, issues and changes, Systems documentation control.
• Report to Infrastructure Director about Daily & Weekly Status, Issues and Escalations.

Environment: EXADATA X3-2, Oracle 12c, 11g, 10g, Sql Server 2008R2, Amazon Web Services (AWS), Linux, Sun Solaris, ASM, RMAN, Golden Gate, Oracle EBS R12.2.3, 11.5.10, Foglight, OEM 12c

Confidential, Minneapolis, MN

Principal DBA Architect - Oracle Apps/Core

Responsibilities:

• Manage multiple clients E-Business applications PROD & Non-PROD databases on 24*7 support.
• Handle EXADATA X2-2, Oracle 11g RAC, CRS, ASM, Sql Server Installations, Disaster Recovery Center Setup, DataGuard Physical & Logical Standby database, Grid Control & Agents Setup.
• Oracle 10g to 11g Upgrades, Deployments, Migration, DB and CPU Patches apply.
• Continuous Performance Tuning Review and Management using Grid Control, AWR, ADDM, SQL Analyzer, Explain Plan, Tkprof, Trace Events and RMAN Backup & Recovery Strategies.
• Handle DB Character set conversions for multiple currencies (MRC) in Oracle Apps.
• Lead & Manage On-site and Off-shore DBA teams on 24*7 model Including Infrastructure Support.
• Review DB Monitoring and Capacity Planning Processes, Budget, Time and SLA Management, Training sessions to DBA team, Shift schedules, Job Allocations, Datacenter Policy Adherence.
• Daily and Weekly Status and Issues Escalations to Senior Director (ISS) & Global DBA Manager.

Environment: EXADATA X2-2, Oracle 11g, 10g, Sql Server 2005, Linux, Sun Solaris, DataGuard, Golden Gate, Netapp, Remedy, Oracle E-Business Suite R12, 11.5.x, Precise i3

Confidential, Minneapolis, MN

Principal DBA Architect - Oracle Apps/Core

Responsibilities:

• Support E-business suite applications modules, Patching, Cloning on on-call rotation (24*7) model.
• Perform Oracle 11g and 10g RAC, CRS, ASM, Sql Server Installations and Administration, Patching, Replication, Performance Monitoring & Tuning, Query Optimization & Database Security.
• Perform Datamodeling, Logical & Physical database design, Physical & Logical Standby database Dataguard Setup, Enterprise Grid Control (OMS) and Agents setup, Nightly Scheduled Jobs Setup.
• Perform 11g Upgrades, Migrations, RMAN Backup and Recovery, Streams, Golden Gate Setup.
• Large Data extracts and Data loads in Production, Reporting and Data warehouse databases.
• Oracle SR Creation and Follow-ups, Performance Tuning using Grid Control, AWR, ADDM, Explain plans, SQL Analyzer, Tracing Events, DB Architecture Design, Recovery contingency tests.
• Perform VPD Setup, Database and Application Audits, Users Security, DB Monitoring, Capacity Planning, Training sessions to DBA team, Off-shore Team Co-ordination, Change Management Control, CRONTAB and Oracle Job Scheduler Setup, DB Process documentations.
• Status Reporting and Issues Escalation to DBA Manager and Senior Delivery Manager.

Environment: Oracle 11g, 10g, 9i, Sun Solaris, Redhat Linux, HP-Unix, DataGuard, RAC, ASM, RMAN, Streams, Golden Gate, Veritas NetBackup, OEM Grid Control, Remedy, Oracle E-Business 11i, SAP.

Confidential, Indianapolis, IN

Principal DBA Architect - Oracle Apps/Core

Responsibilities:

• Oracle 10g & 11g Upgrades and Database Migrations at different data center locations.
• Participated in Exadata X2-2 Implementation, Exadata Patching and maintenance, Oracle 11g, 10g RAC, CRS, ASM Installations, Oracle Enterprise Manager 12c (OEM) setup.
• Manage Laboratory Management (LIMS) & Clinical Applications databases.
• Datacenter Architecture, DB Architecture Design, SOX Database and Application Audits.
• Disaster Recovery contingency tests and High-Availability Setup at Disaster Recovery Center.
• Review Users Security, DB Monitoring, DB Capacity Planning and DB Performance monitoring, DB Patches Apply, DB Cloning, RMAN Backup & Recovery Strategies,
• Co-ordination with System Administrators, Business, Applications users & Change control process.
• Lead Off-shore/Near-shore DBA team, Defining standard operating procedures, Mentoring to DBA team, 24x7 Production Support, Budge & Time Management, DB Process documentations.
• Weekly Status updates and Issues Escalation to Senior DBA Manager.

Environment: Exadata X2-2, Oracle 11g, 10g, 9i, Redhat Linux, Sun OS, DataGuard, RAC, ASM, RMAN, Golden Gate v11, DB Vault, NetApp, OEM Grid Control, Remedy, LIMS, Clinical Applications.

Confidential, Bentonville, AR

Principal Oracle DBA Architect - Oracle Apps/Core

Responsibilities:

• Oracle E-Business Suite 11i applications Installation and Administration, Patching, Cloning.
• Oracle 11g, 10g RAC, CRS, ASM, Sql Servers Installations, Disaster Recovery Center Setup, DataGuard Physical & Logical Standby database Setup, Enterprise Grid Control & Agents setup.
• GoldenGate Implementation & Replicaton Setup, Database creations, Schema & Transportable tablespaces Management, Patch Upgrades, Cloning, Space Management, Nightly Jobs schedules.
• Oracle 9i to 10g & 10g to 11g Upgrades, Deployments, Migration and 24x7 Production Support, Setting up of Oracle Streams, Advance Queueing, RMAN backups, DB Vault and TD Encryption.
• Performance Tuning using Grid Control, AWR, ADDM, SQL Autotraces, Explain Plan, Tkprof
• DB Architecture Design, Recovery contingency tests, Disaster Recovery (DRC) operations, VPD Setup, SOX Database and Application Audits, Users Security, DB Monitoring, Capacity Planning.
• DBA Team Management, Budget, Time and SLA Management, Training sessions to DBA team, DBA Shift schedules, Job Allocations, Co-ordination with System Administrators, Business and Applications users, Change control & Data center policy adherence, DB Process documentations.
• Status Reporting and Issues Escalation to Senior DBA Manager and IT Director.

Environment: Oracle 11g, 10g, Sql Server 2005, Sun Solaris, Linux, DataGuard, RAC, ASM, RMAN, Streams, TSM, VPD, OEM Grid Control, ERWIN, Remedy, Oracle EBS 11i, ATG E-comm, JDA, SAP

Confidential, St. Louis, MO

Senior Oracle Apps DBA

Responsibilities:

• 24x7 Database Production Support, On-call Rotation, and Offshore DBA team coordination.
• Disaster Recovery (DRC) operations planning, budgeting, work break-down structures.
• Architecture and Design Logical, Physical databases, Physical & Logical Standby setup at DRC.
• Datawarehouse database creations, STAR schemas and User management setup.
• Oracle Applcations 11i & Siebel CRM 8.0 Installations, Configuration and Patch Management.
• DB Creations, Configuration Changes, Patch Upgrades, Grid OMS and RMAN Backup setup, Monitor Database and System Security, I/O status, network status and CPU Utilization.
• Continuous DB Performance monitoring and Tuning, DB Sox compliance, DB Audit trails, Change control management, Backup schedules and management, Quarterly DRC Database Recovery contingency tests, DBA peer mentoring, DB Process Improvements and Documentations.
• Daily status meeting with Offshore DBA team, Technical discussions with Business users, escalation and report of Weekly status to DBA Manager.

Environment: Oracle 10g, 9i, 8i, IBM-Aix, Oracle E-Business Suite 11i, Siebel CRM 8.0, RAC, ASM, RMAN, Veritas Netbackup, OCFS2, Dataguard, OEM Grid Control, Precise i3, Foglight, Spotlight.

Confidential, Dallas, TX

Senior Oracle Apps DBA

Responsibilities:

• Oracle & Sybase Software Installations, RAC, CRS Installations, ASM & Database Creations, Oracle E-Business Suite 11i Installations, Cloning, Patch Upgrades.
• Database Monitoring, Upgrades, Schema Management, Space Management, Performance Tuning, SQL Tuning, Database Backup, Recovery, Data Replication and Database Refresh.
• Setup Physical and Logical Standby Databases for High availability and Reporting services.
• On-going Maintainence, Weekend Production Support, Datawarehousing support.
• Siebel CRM 7.8 Installations, Configuration and Patch Management, Database Deployments.
• Handle Directory Assistance, Internet Directory, Peoplesoft CRM Product Catalog, EPM Repository, SCM Product Catalog, Subex RANGER Fraud Mgmt, Billing Data Formats, Outside Collections, Print Vendor Data, Experian Data feed, Mass Adjustments, Rejected CDRs feed, POS, EFT and Credit Card Payment Data Interfaces.
• Legacy Billing Systems Data conversion into Kenan Billing Systems
• Detailed status reports to Senior Project Manager, Process enhancements and documentation.

Environment: Oracle Apps 11i, Oracle 10g, 9i, 8i, Sybase ASE 12, MySql 5.0, Sun OS, HP-UX, Windows, T-SQL, PL/SQL, Shareplex, Dataguard, RMAN, TOAD, Clearcase, Kenan Arbor BP, Siebel CRM 7.8

Confidential, Livingston, NJ

Senior DBA Consultant

Responsibilities:

• Production and Development Support for mission critical Databases and Applications effectively.
• Setup & Manage Offshore Production Support DBAs Team, Shift schedules and Work allocations.
• Database Creation, Performance Tuning, Capacity Planning, Ad-hoc DB User requests, Cloning, Replication, Configuration changes, Patch Upgrades, RMAN Backup, DB Restoration, Schedule Batch and Nightly jobs using CRONTAB and Enterprise Manager.
• DB and SQL Performance Tuning using Statspack Reports, Explain Plan, Autotrace and Tkprof.
• Co-ordinate Data center consolidation and DB Servers movement with Data center Manager.
• Setup Physical and Reporting Logical Standby databases, DB Failover and Switchover testing.
• Interact with Operational Customers, Product Developers and Corporate IT Team to support all business units, DB Support process improvements, On-site team meetings and on-budget delivery.
• Escalation of Operational, Applications and Database Support issues to Vice President IT.

Environment: Oracle 9i, 8i, 7.x, Sybase ASE 12, Sun OS, Windows, SAP R/3, PeopleSoft CRM, OEM, SQL*Plus, PL/SQL, Shareplex, Dataguard, RMAN, TOAD, Sql*Loader, Veritas Netbackup, CVS, Peregrine

Confidential, Grapevine, TX

Senior Analyst

Responsibilities:

• Kenan Arbor Telco Billing System Migration from version 10 to 11, Develop new Interfaces for Payments, Collections, Customer Care, Fraud, Inventory management.
• Analyze Billing/CRM dataflows, Control Points, Data sources, formats, Data Transfer methods.
• Oracle Installations, Database Creations, Upgrades, Database Sizing.
• Online and Offline Backups, Restore and Recover databases using RMAN for contingency tests.
• Setup and Manage Materialized Views Replication, Logical and Physical Standby databases.
• Monitor and Tune Database Performance and Security, adhere Change control procedures.
• Unit Testing, Integration and System Testing of New Applications, Interact with Architects and Business Analysts to enhance existing processes and procedure.
• On-call, Weekend and Monthend Production Support activities in 24x7 model, Issues Escalation and Status Reporting to Senior IT Manager.

Environment: Oracle 9i and 8i, Sybase ASE 12, Sun OS, HP-Unix, Windows, PL/SQL, T-SQL, Dataguard, RMAN, TOAD, EMC, Shareplex, ClearCase, IPAC Ordering Inventory system, Kenan Arbor BP

Confidential

Assistant Manager - IT, DRC and Billing Support

Responsibilities:

• Manage Disaster Recovery Center, Kenan Arbor Telco Billing Operations, Capacity Planning, Database Security, Kenan Order Management, Production Support operations.
• Perform Oracle Installations, Database Creations, Upgrades, Daily Backups, Nightly Jobs Schedule, Creation of Tablespaces, Datafiles, Tables, Views, Indexes, DB Links.
• Plan and Implement Disaster recovery solutions for all production databases, Logical and Physical Standby Databases and Replication setup, SLA and Change management processes.
• Led Data Migration from TIMS (EHPT) Billing System to Kenan Arbor Billing System
• Kenan Tables and Product Catalog Configurations, Monitor Application security and standards.
• Hire DBAs, Mentor Billing Applications and DBA teams, Schedule work assignments, Identify Operations problems and Key Issues, Investigate alternate solutions and resolution.
• Define Billing and DRC standard operating procedures, Build and Maintain positive work relationships and new approaches for best performance, Manage Budget and Time management.
• Interact with Business Users, Application Users and Management Team for current systems and processes enhancements, Vendor Management for required Hardware and Software, Prepare MIS and Status reports timely and submit to Chief Information Officer.

Environment: Oracle 8i, 8 and 7.x, MS SQL Server 2000, Sun OS, Tru64, Windows, SQL*Plus, PL/SQL, TOAD, RMAN, Veritas Netbackup, Peregrine, Kenan Arbor BP, Kenan OM, ARCGIS system.

Confidential

Oracle DBA Consultant

Responsibilities:

• Implementation and Data Migration in RETEK merchandising system at TOPS Retail chain and THE CLUB STORE in Jakarta (Indonesia).
• Oracle Production databases Administration at MAXIS GSM service provider at KL, Malaysia.
• Oracle Database Instances and Objects creation, Memory Configurations, Privileges setup, DB Performance Tuning, SQL Tuning, System, Hot and Cold Backups and Logical backups.
• Data Mapping, Data Extraction, Acquisition, Transformation, Data Migration and Validation.
• Comparison of New and Existing application systems, Audit Production Database user transactions, Database monitoring, Product Testing activities.
• Creation of TARs with Oracle Support for critical bugs, patch fixes and problems.
• Report to Technical Director about Project Plans, Executions and Status of the Projects.

Environment: Oracle 8i and 7.x, Sybase 11.5, Sun OS, IBM Aix, Windows, SQL*Plus, PL/SQL, CVS, BSCS Telco Billing system, RETEK management system, SQL*Loader, RMAN, SQL Developer.