SUMMARY:

• To provide quality and innovative Data management, Data Governance, Data Quality and Security principles for Enterprise applications including Amazon Web Service(AWS), Exadata, Oracle RAC, Hadoop Big Data and AWS Cloud applications. Leverage the experience in IT Service/Delivery support, Process Control, Protection of information assets, Disaster recovery, Leadership and development experience to enhance the productivity of the company.
• Over twenty years of IT experience, Data Architecture, Development, Data management, Hadoop Big Data and Data Warehouse architecture experience including multi terabyte databases.
• Over five years of leadership experience with significant focus to data management, administration and data warehouse management.
• Working Software Support knowledge on Banking and Financial Instruments including modules like General Ledger, Fixed Deposits and Billing.
• Experience with multiple development methodologies including Waterfall, Agile and DevOps.
• Expert knowledge on data modeling including Dimensional (OLAP) and Online Transaction Procession (OLTP).
• Expert know on database migration from on premise to Amazon Web Services (AWS) Cloud.
• Strong interpersonal skills with focus on team work and customer service. Ability to work on multiple projects and prioritize the tasks.
• Support over fifteen highly critical NSS enterprise applications with data administration, data security, disaster recovery, design review, backup and recovery scenarios.
• Worked with Audit team and make sure the databases comply with CPI - 810 Audit requirements. Take immediate corrective actions for applications which need security improvements.
• Successfully setup both Horton Works and Cloudera the Big Data Environment and participated in proof of concept (POC) for various tools within Big Data Eco-system.
• Researched into various new tools for Big Data and other Database systems and provided report to upper management.
• Experience in Issue tracking, organizing change management meetings, opening bug reports and effectively tracking the resolution mechanics.
• Strong knowledge in designing, project planning and implanting data architecture procedures for very large databases.
• Strong analytical skills and problem solving with the ability to execute multiple complex tasks in fast-paced, rapid environments. Excellent communication skills and good organizational skills.

TECHNICAL SKILLS:

Databases

Tools: and Applications

Operating System

Hardware

Oracle 18c/12c/11g

Oracle Apps 11i/12.1/12.2

SUN Solaris 10, 9, 8

Exadata-x3-2

Oracle 10g/9i/8i

Amazon Web Service

Linux RHEL 5.0/4.0/3

Exadata-x5-2

MongoDB 3.6/4

Oracle Discoverer 3i / 4i

HP/UX 11

Sun-Fire-V220

SQL Server 2016

TOAD data modeler

HP/UX 10.01

RS 6000

SQL 2005,2012

Cognos 7.0 / 8.1

AIX 4.3

HP/UX 11

MySQL 5.7

Tableau

Windows XP/NT/98

HP/UX 10.01

Informatica 7.2 /8

CA Erwin

EXPERIENCE:

Confidential, Southlake, TX

Sr. Database Admin / Platform Support Lead

• Manage twelve members offshore team and lead the platform support for mission critical Confidential database which includes multiple Oracle and SQL Server databases.
• Set up Knowledge Transfer (KT) sessions with out going support team with new twelve members team to take over the platform support effort.
• Install and configure databases on new Oracle ODA X7-5 environment and migrate data from existing X5-2 environment.
• Enable Data Guard between new and old prod server and migrate the database from existing environment to new environment.
• Conduct weekly meetings with Offshore and Onsite team members and review issues and changes.
• Provide 24x7 support for databases as needed for mission critical Confidential databases.

Environment: Oracle ODA X7-2, Oracle ODA X5-2, Windows, Linux, CherWell, Oracle 12.1.0.2, Oracle Cloud Control 13c, SQL Server 2016/2017

Confidential, Southlake, TX

PMTS - Sr. Database Admin / Architect

• Support and Lead multi-Terabyte Exadata Environment for Network Support Applications.
• Lead the POC for Hadoop and Gluent Solution as part of identifying possible alternate solution to current Exadata Applications.
• Configure multiple RDS PostgreSQL databases on AWS Cloud for new project requirements.
• Supported migration of databases from on premise MySQL and Oracle databases to Amazon Aurora using AWS Database Migration Service (DMS) and Schema Conversion Tool.
• Proficient in AWS services like VPC, EC2, S3, ELB, AutoScalingGroups(ASG), EBS, RDS, IAM, CloudFormation, Route 53, CloudWatch, CloudFront and CloudTrail.
• Worked with application teams who follow agile project methodologies. Lead and Participated in regular calls as required.
• Created Design Documents for multiple projects during the design phase of the project. Present the document in the weekly design review meetings.
• Created data model for High volume Dimensional data warehouse (ALPT) application and helped to migrate database from Exadata to Hadoop environment.
• As architect, gathered data source for ALPT system and reverse engineered the legacy platform.
• Modeled the application for migration to Hadoop environment which feeds data to other related application across the enterprise.
• Looked into various internal databases and created data model for single source of truth as reference point for Hadoop data conversions.
• Work on Verizon Lean Six Sigma Green Belt and Black Belt process enhancement projects.
• Generate Database usage metrics report using Tableau BI Tool.
• Upgraded multiple Production servers from 11.2.0.4 to 12c Multitenant databases.
• Configured Oracle Golden Gate 12.2 and upgraded replication environment from Oracle Streams.
• Effectively implement the CPI-810 audit requirements for multiple production databases. Participated in SOX audit meetings and made sure the databases comply with the audit requirements.
• Successfully installed and configures Hadoop Big data environment and participated in proof of concept for database migration tools and Hadoop tools.
• Attended Tableau and Aster tools training and provide support as needed in the data storage and performance areas.
• Installed and configured Oracle RAC database within minimum amount of time and resource. Worked with vendor to make sure required parameters are configured for Oracle RAC databases.
• Evaluated Massively Parallel processing architecture database HP-Vertica and provided feedback to the management.
• Monitor multiple databases using Grid Control, Quest Foglight and custom shell scripts. Used Remedy software to manage and co-ordinate database issues.
• Provided 24x7 support as needed for mission critical NSS databases.

Environment: Exadata X3-2, x5-2, Oracle 5440, T2000, HP 9000, Solaris 11, 10, HP-UX 11, RHEL 7.0/6.0, Oracle 18c/12g/11g, Hitachi SAN, Sun Fiber Channel Arrays 6180 and 6580.

Confidential, Fort Worth, TX

Senior Oracle Apps DBA

• Production support for Oracle E-Business Suit 11.5.10 multi-node installation. Supported modules include Order Management (OM), Inventory, BOM, Accounts Payable and Receivables (AP/AR), General Ledger, Fixed Assets and Cash Management.
• Support Workflow and Oracle Application administration as part of E-Business suite support.
• Support RedPrairie Warehouse management software including refresh and upgrade of software. Resolve issues with locking, ensure the warehouse operation is performed without interruption.
• Installation and configuration of Oracle 11g on HP 9000 server for new data warehouse initiatives.
• Provide support with new schema setup, star schema table design for data warehouse operations.
• Troubleshooting issues including creation/follow-up of Oracle Service Requests (SR), Conduct code reviews, promote code to production.
• Monitor and work on issues created by users via Track-It and Test Track work order management system.

Environment: HP 9000, HP-UX 11, Oracle E-Bus 11.5.10, RedPrairie 10, Oracle 11g/10g, EMC SAN.

Confidential, Southlake, TX

Senior Oracle DBA / Architect

• Work with vendors and ensure deliverable and service level agreements are met for various vendor supplied software components.
• Provide architecture and design document to convert the Oracle Multimaster Replication to GoldenGate based architecture for high available 12 way replication.
• Arrange and co-ordinate meetings between various vendors including Qualcom and Bridgewater Systems and support application related issues, bug fixing and issue tracking.
• Mentor the junior DBAs and other technical users with various application support tasks including Replication issues, configuration issues and issues related to databases.
• Provide development and maintenance support for 1 terabyte OLTP Databases with 8 way multimaster replication.
• Involved in development and deployment support for mission critical 24x7 AAA wireless authentication application with 85 million wireless users.
• Provided Performance tuning and architectural suggestion to maintain and achieve mandatory 3 second response time for incoming wireless connections.
• Deploy new Databases nodes with GoldenGate 10.4 environment and provide mechanism to send data between GoldenGate and AR environments.
• Install, configure and implementation two node Oracle RAC environment for Brew Application. Setup advanced features like creation of services, TAF and test various fail over scenarios for Oracle RAC environment.
• Benchmark GoldenGate and Oracle Streams and provided recommendation to the management.
• Responsible for installation, upgrades, patches, database tuning for Segmented Database Migration project.
• Provided 24x7 support for mission critical AAA databases and implemented method of procedure (MOP) during late night maintenance hours.

Environment: SunFire 5900, 5440, 5220, T2000, HP 9000, Solaris 10, 9, HP-UX 11, RHEL 5.0/4.0, Oracle 11g/10g RAC, 9i, Hitachi SAN.

Confidential, Dallas, TX

Sr. Oracle Applications DBA / Lead Architect

• Lead architect to setup High Availability and Disaster recovery solution for multiple oracle databases between Denver and Santa Clara office.
• Provide Production and implementation Support for Oracle Applications environment 11.5.10 and data warehouse databases up to 3 terabytes of space.
• Setup Dataguard and Streams replication for multiple Oracle instance between Denver and Santa Clara offices.
• Researched into R12 upgrade requirements as per Oracle upgrade documents and developed upgrade path for R12 upgrade.
• Upgraded Oracle Application database from 8.1.7.4 to 10.2.0.3
• Resolve issues with Workflow, Concurrent programs, ADI, printer setup and other system administration activities for E-Business suite.
• Cloned multi node system from PROD to DEV and QA instances.
• Upgrade support and applied various patches for modules including GL, INV, OM, AP, AR, i Procurement, iSupplier, Contracts, IB and BOM.
• Provided post upgrade support for implementation and development team and applied required patches and worked with Oracle support to resolve issues.
• Designed and setup four node Oracle RAC architecture. Worked with UNIX Admins to setup inter connects, HBAs and networks.
• Installed Clusterware and Setup Automatic Storage Management (ASM) as part of RAC implementation.
• Responsible for installation, upgrades, patches, SR support, database tuning, concurrent manager administration, cloning and Oracle Apps SYSADMIN functions.
• Expertise in setup, maintenance and troubleshooting of Oracle RAC instances.
• Expert in locating performance issues, SQL level waits data using Oracle Wait Events (OWI), Active Session History (ASH) and Automatic Workload Repository (AWR).
• Optimize SQL and PL/SQL performance, shared memory tuning, I/O tuning, wait events tuning.
• Monitor and tune Cache Fusion, determine RAC specific wait events and ADDM for Cluster database tuning.
• Production support for huge data warehouse database with 3 terabytes of storage.
• Apply various patch requests for Oracle applications 11.5.10 environment.
• Vertex support for Oracle Financials and tax updates.
• Design and Develop Disaster recovery scenarios for multiple instances.

Environment: Sun Blade 8000, SunFire 5220, Solaris 10, 9, RHEL 5.0/4.0, Oracle 11g/10g RAC, 9i, 8i, Oracle Applications 11.5.10, Hitachi SAN.

Confidential, Denver, CO

Senior Oracle DBA / Team Lead

• Lead DBA for Seven member DBA team including Sybase and SQL Server environment with over 200 databases.
• Mentor and provide guidance to junior DBAs and support 24x7 mission critical operations databases including Oracle E-Business Suite and Data warehouse databases.
• Lead architect for Enterprise Information Mart (SMART) data warehouse for HR, Sales and Inventory data warehouse initiatives. Manage four member data warehouse team and provide guidance with implementation of ETL operations using Informatica and Cognos BI Tool.
• Conceptual design, data modeling and convert logical model to physical model for Enterprise Information Mart(SMART) data warehouse.
• Implementation and upgrade support for application modules including GL, AP, AR, INV, OM BOM, WIP and HR/Payroll for Jeppesen Marian operations.
• Installed Oracle 10g, 9i and 11.5.10 CU2 with multi node option. Provided database support for over 200 databases.
• Support full development life cycle of Oracle Application Implementation including the

Environment: SunFire 5210, T2000/1000, Solaris 10, 9, RHEL 4, Oracle 9i, 8i, Oracle Applications 11.5.10, EMC CLARiiON SAN

Confidential, Mauldin, SC

Oracle DBA / Enterprise Architect

• Provided DBA support for multiple production, development, and test environments running on Oracle 9i Parallel Server (OPS) with 10 nodes with database size of 2 terabytes.
• Responsible for standards and design of physical data storage, maintenance, access and security administration for huge data warehouse environment.
• Involved in performance tuning of data warehouse queries, backup and recovery strategies, define data repository requirements and warehousing requirements.
• Helped to build two new data warehouse databases, Customer Data Warehouse(CDW) and Item Data Warehouse(IDW)
• Created PL/SQL packages, procedures and functions to improve data loads.
• Researched, tested and introduced new features of Oracle8i to development team.
• Built korn shell, awk and SQL scripts for space management and integrated data load scripts.

Environment: IBM RS6000, EMC SAN, Oracle 9i Parallel Server.

Confidential, Hatfield, MA

Oracle Applications DBA / Developer

• Involved in Oracle Application 10.7 Network Client Architecture (NCA) support and multiple Oracle 8 and Informix 7.x Servers.
• Tuned PL/SQL and SQL scripts using EXPLAIN PLAN and TKPROF.
• Upgraded Oracle Applications 10SC to 10.7 NCA and setup web application server 3.0.
• Designing and development of interfaces of legacy system with Oracle Apps OE module.
• Developed multiple reports for OE and INV modules using Oracle reports 2.5
• Customized forms for OE Modules registered forms in Oracle Apps using Forms 4.5
• Performance tuning of UNIX for Oracle, including Kernel tuning, separating different tablespaces in different disks.
• Writing UNIX Shell Scripts using Korn-Shell and C-shell.
• Implemented backup and recovery procedure for Legato back-up system using RMAN.

Environment: HP-9000, Oracle Applications 10.7 NCA, Oracle 7.3.4/8i, Forms 4.5, Reports 2.5, EMC SAN.

Confidential, Durham, NC

Oracle Applications DBA / Developer

• Involved in full life cycle implementation of Oracle Applications 10.7 on HP/UX with Oracle 7.3.2.2.
• Installed oracle application 10.7 with modules including GL, OE, PO, INV, AP, AR, WIP, MRP, BOM, PA, FA and FND.
• Involved in registering custom reports, forms and provide security administration and user creation.
• Developed reported and customized forms for OE, GL, BOM and INV modules.
• Involved in Database Administration and maintenance of Oracle Servers and Implementation support for Finished Goods Inventory System (FITS).
• Provided support for production databases, backup and recovery, setup automation backup using DAT device, writing interface programs using shell scripts, setting up UNIX cron jobs for daily processes.

Environment: HP-UX, Oracle ERP 10.7, Oracle 7.3.2

Confidential

Oracle DBA

• Installation, configuration of ORACLE databases.
• Installation and production support for Works And Store Program (WASP) software.
• Creation of schema, controlling privileges and user creations.
• Performance testing and fine-tuning of the system.
• Participated in Code walk through of the system and provided suggestion to improve the performance in SQL statements.
• Written system utilities to monitor the system.
• Production support for WASP System 24 X 7.