SUMMARY

• Oracle DBA/developer 10 years of experience in designing, implementing, maintaining and Oracle databases.
• Worked through multiple full life cycle projects in Oracle and multiple other DBMS technology on Solaris, Linux operating systems.

TECHNICAL SKILLS

RDBMS: Oracle 12C/11,10G RAC, KDB/Q2.4, Mysql5x with Infobright/ISAM Engines, SybaseIQ 15x/16x.

Programming: Perl/DBI/DBD/LWP/modules, Python, C/Korn Shell, PL/SQL, Sed/Awk

Software: Informatica, Erwin 8 - 6x, Tableau 8,7x, Tivoli TSM, Trillium, Forms/Reports, SQR report, C/C++, VB, Crystal Reports.

Exposure: Oracle Exadata, Tableau, Vertica, Spark/Hadoop, GoldenGate, SQLserver, Java 2, J2EE, Servlet, Jsp, Jdeveloper, Weblogic, SAS 8x,9.

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

Senior Oracle DBA/Developer

Responsibilities:

• Built/Administered on Oracle11g 12c RAC on Linux 6x,7x platform .
• Planned/Performed Oracle database patching, upgrade and migrations between data centers. Setup DR and backup using rman on Dataguard.
• Supported 12C, 11G, 10G databases on various Windows and Linux platforms. Performed Development DBA tasks, wrote/tuned Store SQL/PL/SQL and preformed code review and performance tuning. Performed table/index partitioning, defined physical database. Performed data analysis and trouble shoot data or coding logic problems.
• Performed Oracle instance tuning. Used AWR report and grid control for database monitoring. Wrote Shell scripts for cron jobs and partition management/manipulations.
• Performed Oracle SQL tuning with Dev/Test team and code reviews for performance. And perform Query performance spot check on regular basis.
• Directly involved with Data Modeling in both ODS and DataMart designs, and physical models and Database schema physical designs.
• Built data integrity dashboard using Perl and (LWP) Http & Data Modules, and routinely perform code reviews and data sanity check and data reconciliations among Oracle, Teradata, and kdb databases.
• Designed/Built Olap Cube in Dim-Fact Models and Built/Tuned BI/Tableau reports & dashboards with drill down capability.
• Built//Managed data reconciliation and data sanity check system for regional health data exchanges, and storage utilization monitoring using Perl/DBI/DBD/LWP modules across multiple database system between Teradata, Oracle, Mysql, KDB database system within teh Enterprise .
• Exposures to Vertica 3.x, Sybase IQ 15x, Exadata, GoldenGate and data replication, ETL software & processes.
• Good Exposures to Hadoop/Hive/Pig scripts/Sqoop & Java/Pyton.

Confidential, NYC,NY

Oracle/Teradata DBA/developer

Responsibilities:

• Built Oracle 11G, 10G, 9i databases using Linux and AIX on IBM XP SAN storage. Setup DR and backup solution using multiple dataguard near site and off site. Setup backup on standby database using integrated Snapvolt on Netapps R200 storage appliance.
• Implemented/Supported Phenix Risk Management System using 10G/9i RAC Linux on ASM and OCFS. Teh duties include SQL code review, capacity/performance measurement, tuning, RAC backup recovery and DR.
• Wrote SQL/PL/SQL store procs and shell scripts, reviewed SQL codes, performed SQL tuning, data partitioning, parallelism tuning, production release. Supported Oracle database 9i, 10G for various application in dev/qa/prod on Solaris/Linux/Windows platform. Database server tuning and capacity planning using Statspack and OEM and OS tools. Performed data analysis, schema design. Administered database replication using Shareplex5x.
• Setup/Supported Teradata 12.x, 13.x Data mart database. Performed physical implementation of teh physical database using proper PI, SI. and preform query tuning/monitoring. Implemented teh semantic databases using JI, macros, physical tables and views.
• Used Teradata manager and ARCmain for system monitoring and cluster archive/restore. Used fastload, mload and performed data copy between prod and dev/qa databases.

Confidential, NYC. NY

Senior Oracle DBA/Unix admin

Responsibilities:

• Designed/supported 10G, 9i Oracle database with 4TB data warehouse with 7000+ table/index partitions, Performed Oracle tuning. Wrote PL/SQL and Shell scripting and code reviews. Teh sustained peak through put on teh finely tuned parallel query can reach 250MB/sec.
• Supported/installed/Programmed/Tuned Trilium and Synsort batch jobs to cleansed and matched name&address and consumer master data into Oracle database.
• Implemented RAC on Linux for teh purpose of LDAP and consumer scoring review database with Apache with web cache enabled. Setup and administered Ldap server using OID.
• Build/Administered AIX 6.x on RS6000 P series machines for Oracle and SAS team, Build Fat-T700 and Fast-T900 (Mix of 17 TB FC and 10TB SATA storage) Storage Array and Build SAN fabric using McData Switches and setup fabric zoning and monitoring tools for both SAN and AIX hosts. Performed AIX administration, SAN administration and software installation.
• Built/Administered Tivioli Storage Manager and Unix backup and RMAN/Dataprotector integration. Implemented disaster recovery solution at off site data center using TSM and rman to perform bare-metal restore.