PROFESSIONAL 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,11gExadata X3-2, X4-2, X5-2MySql 5.5, MS SQL Server 2008, 2012, DB2.

BI & DW: Confidential Information Integrator,Informatica, Cognos

Web Related: WebLogic Application Server, IIS

Tools: Oracle Goldengate (Replication)Veritas Suite, Erwin4.0/3.5.2, DBArtisanOracle 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 Confidential 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. TLM5 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.