SUMMARY:

About 20 years of experience as a team lead of Database Application Developers and Administrators who provide application database life cycle support including database design, development, implementation, maintenance, and 24x7 on - call production support in multiple environments of varying sizes and complexities.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, SQL Loader, C, Java, XML

Operating systems: UNIX (Solars, HP-UX, AIX), Linux, Wintel, z-os

Databases: Oracle 12c,11g, Oracle RAC 12c,11g, Exadata X3-2, X4-2, X5-2, MySql 5.5, MS SQL Server 2008, 2012, DB2.

BI & DW: IBM Information Integrator,Informatica, Cognos

Web Related: WebLogic Application Server, IIS

Tools: Oracle Goldengate (Replication),Veritas Suite, Erwin4.0/3.5.2, DBArtisan,Oracle EM Cloud Control,Oracle RMAN, Oracle Data Guard

Big Data: Hadoop, Hive, Mongo, Pig, Sqoop, HDFS.

PROFESSIONAL EXPERIENCE:

Senior Database Developer / Oracle DBA

Confidential, Atlanta, GA

Responsibilities:

• Worked on supporting GHMP. The application is DataWarehouse. GHMP is a 20 TB database and resides on a 4 node RAC cluster .
• Monitored database using EM cloud control.
• Worked on performance tuning.
• Worked on database code deployment.
• Supported migration of database from commodity hardware to Exadata.
• Make use of Exadata features like HCC, cell offloading, storage indexes, pinning objects to flash cache, enabling and disabling write back flash cache, to improve overall performance of database.
• Worked on data purge modules.
• Supported ETL process to move data from Teradata to Oracle.

Senior Database Developer / Oracle DBA

Confidential

Responsibilities:

• Worked on migrating applications from AS400 to Oracle.
• The application is Policy database for health care providers.
• Monitored database using EM cloud control.
• Worked on performance tuning.
• Worked on ETL modules to move data from OLTP to Datawarehouse.
• Worked on Data Modeling and Data Normalization techniques.

Senior Database Developer / Oracle DBA (Consultant)

Confidential, Atlanta, GA

Responsibilities:

• Designed and developed a Fraud Application Detection System for healthcare claims (FADS). FADS resides on 10 oracle instances and 5 servers.
• Worked on ETL process for claims data. Worked on Fraud Reporting system. Worked extensively on PL/SQL procedures.
• Monitored database using Enterprise manager. Worked on Backup and Recovery. Worked on Materialized views.
• Worked on DataGuard. Performed import/export using Datapump. Applied oracle patches. Installed, configured databases on Exadata.
• Keeping Exadata machines up to date to the latest Exadata software versions which includes applying QFSDP, BP, firmware upgrades and bug fix patches.

Senior DBA (Consultant)

Confidential, Alpharetta, GA

Responsibilities:

• Worked on a migration project to build and deploy Oracle on IBM servers.
• This include Dev/QA/Production environments.
• There are around 70 instances on 5 servers.
• Installed and configured 4 node Oracle RAC. Applied Oracle patches on RAC environment.
• Performed day to day operations on RAC maintenance.

Senior Oracle Developer / Oracle DBA (Consultant)

Confidential, Alpharetta, GA

Responsibilities:

• Designed and developed a Time and Labor Management system (TLM5). TLM5 consolidates around 250 oracle instances of TLM4 into one large instance. resides on a 4 Node RAC cluster.
• Worked on ETL process for vending data to the BI project.
• Worked on the performance tuning using Enterprise Manager, AWR, ADDM, ASH. Worked on Shell, SQL scripts, and PL/SQL procedures.
• Worked on Data Modeling and Data Normalization techniques.
• Worked on Oracle DataGuard.
• Implemented Backup and recovery methods, using RMAN.
• Worked on Datapump and SqlLoader utilities.

Senior Database Developer / DBA (Consultant)

Confidential, Alpharetta, GA

Responsibilities:

• Designed and developed a commerce platform that allows multiple reward programs to be used in various combinations and spent like cash (rewards points aggregation).
• Designed the consumer information management system, points gateway transaction system, and settlement system.
• Data vending is done using PL/SQL.
• Extensively worked on Shell, SQL scripts, and PL/SQL procedures.
• Created oracle stored procedures, functions, triggers and packages.
• Performed Database performance tuning. Worked on Data Modeling and Data Normalization techniques.
• Architect, deploy, and support database systems with high availability to support high volume transactions.
• Worked on Oracle datapump and sqlloader utilities.

Senior Database Developer / DBA

Confidential

Responsibilities:

• As a Lead for the distributed systems DBA / Development team which manages all the company wide databases (ORACLE, SQL SERVER).
• Specific tasks include Setting up a global financial data warehouse.
• This database holds information regarding cash positions, corporate actions, global fund transfer, stock loan, and other custody and non-custody. The warehouse resides on Oracle 10g database.
• Worked on Datapump and SqlLoader utilities. Worked on build scripts for creating database objects.

Senior Database Developer / DBA (Consultant)

Confidential, Warren, NJ

Responsibilities:

• As a Oracle Developer for a major telecommunications company, was responsible for designing and developing a Sales Server Platform ( SSP).
• Worked on extraction, transforming and loading (ETL) data.
• Developed data conversion scripts using SQL*Loader, PL/SQL scripts and UNIX shell scripts.