SUMMARY:

• Highly motivated, quick learner with over 12 years experiences working in the IT industry specializing in Oracle database, Oracle RAC, Exadata machine and Oracle GoldenGate administration and development.
• Proven ability to solve a wide variety of software and business issues.
• Excellent analytical, organizational, multi - tasking, planning and problem solving skills.
• Excellent project management, facilitation and leadership skills.
• Operate well independently or within a team.
• Eager to increase my knowledge and add to my technical skill set.
• Deal well under pressure and with rigorous deadlines. Looking for a challenge and love creative solutions to complex problems

TECHNICAL SKILLS:

DATABASE: Oracle 10g/11g/12c/ MS SQL Server

LANGUAGE: SQL, PL/SQL, Pearl, Korn/Bash Shell

PLATFORM: Oracle Exadata, Redhat Linux, IBM AIX, HP-UX, Oracle Solaris, FreeBSD and Windows

DATA REPLICATION: Oracle GoldenGate

MONITORING: Oracle OEM 12c/13c

TOOLS: SQL/Plus, Toad, SQL Developer, DBArtisan

STRENGTHS:

• A Senior Oracle DBA offering 12 years of progressive experience, specializing in high-volume, high-visibility production and development environments. Skilled in designing and preparing databases configurations for complex and resource intensive applications.
• More than 12 years experiences in Information Technology industry, especially in database and unix-like platform system administrator such as Linux / IBM AIX / HP-UX / Oracle (Sun) Solaris / BSD.
• More than ten years experiences in Oracle database administration, including design, development, implementation, migration, upgrading, maintenance and production support of complex database applications and huge data warehouse system.
• 6+ years solid hands-on experiences in Installation / Configuration / Performance Tuning / Trouble shooting Oracle GoldenGate ( Confidential ) in Oracle to Oracle homogeneous environments and heterogeneous environments (including Oracle to Oracle and MS SQL Server to Oracle).
• Three years experiences in Oracle Exadata database machine administration, patching, upgrading, performance tunning and trouble-shooting.
• First hands experiences in setting up Oracle Goldengate data replication with conflict detection and resolutions. Extensive skills in upgrading Confidential 11gR2 to 12c, configuring Confidential in RAC high available environment.
• Deep understanding Oracle Goldengate internal mechanism, Confidential new features such as Integrated capture, coordinate apply mode, multi-threaded replicat. Developed home-cooked Confidential lag monitoring scripts and configure Confidential monitoring plug-in in OEM (Oracle Enterprise Manager) 12c.
• First hands-on skills about Exadata hardware architecture including Storage, Grid and Infiniband. Deep understanding of key Exadata features including HCC (Hybrid Columnar Compression), Smart Scan, Smart Flash Cache, Storage Index and Storage Management.
• Proficient in Oracle database backup & recovery strategies plan and implementation such as user-managed backup, RMAN backup with/without catalog, cold and hot backup, full / incremental backup.
• Strong experiences with monitoring, troubleshooting, and resolving database issues in 24x7 production environment.
• Highly skilled in SQL and PL/SQL Tuning, TKProf, Explain Plan. Expertise in monitoring and performance tuning of Oracle database through tuning application, memory and disk by using Statspack/AWR/ADDM/SQL Advisor.
• Six years solid hands-on experiences and outstanding troubleshooting skills to Setup / Configure / Monitor / Maintain Oracle 10g/11g RAC / ASM / Data Guard environments.
• Experience with Oracle 11g/12c new features: Flash-Back Recovery, Data Pump, ASM, ASH, AWR, ADDM, ASSM, ASMM, Automatic Undo Management, Grid Monitoring and Recycle Bin.
• Project management, facilitation and leadership skills.
• Excellent English writing, verbal and communication skills. Strong team player and be able to work alone. Highly self-motivated and able to adapt and learn new technologies quickly.

EXPERIENCES:

Confidential, Baltimore, MD

Oracle Database Administrator & GoldenGate Specialist

Responsibilities:

• Oracle Exadata Databases 12c Administration, such as database creation, managing storage structures, users, objects, privilege, security, backing up and recovery by RMAN and Zero Data Loss Recovery Appliance (ZDLRA).
• Data movement by Oracle Data Pump Export and Import. Disaster Recovery (DR) using Physical Data Guard. Scheduled RMAN backups, purge jobs, maintenance jobs using DBMS SCHEDULER and Crontab.
• Worked with customer for different RAC related issue: hangcheck timer, split brain, RAC recovery, ASM, OCR corruptions, Voting disk loss & so on. Troubleshoot performance issues for the RAC instances (GC events).
• RAC Database Services creation for distributing the applications across multiple nodes. Added services to a database and assigns them to instances, relocating the switched over services. Managed the I/O resources through the Oracle Exadata I/O Resource Manager.
• Help to compress large volume partition table by using Oracle HCC (Hybrid Columnar Compression) techniques.
• Worked with storage, network, Oracle Data Integrator (ODI) and Oracle Business Intelligence Enterprise Edition (OBIEE) application teams to resolve performance issues, by means of OEM monitoring, SQL plan management (SPM), AWR, ASH, ADDM, SQL Tuning Advisor, parameter adjustment, stats gathering, index rebuild, invisible index, table shrinking to lower high water mark, capacity tuning, SQL modification,
• Setting up High Availability Oracle GoldenGate ( Confidential ) systems on Oracle 12c RAC with ASM environments. Confidential implementation between six source production systems and Exadata data warehouse environments. Oracle GoldenGate maintenance, such as resync, re-instantiation, or adding tables
• Oracle GoldenGate performance tuning of lagging by methods such as splitting replicats, Confidential parameter tuning, database tuning, application large table re-design, Linux/Unix kernel performance tuning, etc.
• Troubleshooting Confidential abending due to long running transaction, trigger firing, unique key violation; troubleshooting hang due to index unusable by means of GGSCI, report file or discard file ananlysis, logminer utility, sql monitoring.
• Oracle GoldenGate data validation by both procedures for row count comparison between source and target tables and by Veridata
• Auditing deletion operation of source tables through Oracle GoldenGate to replicate deleted rows specifically to deletion-auditing tables in addition to regular data replication
• Involved in implementing Confidential to deliver Confidential trail files to big data Hadoop Enterprise Data Lake by Confidential big data adapter, Kafka.
• Provide 24x7 on call support as part of a scheduled rotation with other team members

Senior Oracle Consultant and System Architect

Confidential

Responsibilities:

• Serve as Oracle, Oracle GoldenGate and Linux subject matter expert for migration and upgrade of 40T data warehouse from single instance 11gR2 to 12c RAC database.
• Set up High Availability Oracle GoldenGate ( Confidential ) systems on Oracle RAC environments for replication from enterprise data warehouse (EDW) to Proof of Concept (POC) reporting database
• Oracle Core DBA work on EDW implementation using Oracle 11g and 12c. Implementation of Backup, Recovery, Disaster Recovery (Using Physical Data Guard) and cloning database.
• Setup, configuration and administration of 11gR2/12c RAC Clusterware with ASM. Resolving RAC issues, such as OCR related issues, rebooting of faulty nodes, relocating the switched over services. Applied patches on Oracle Clusterware and RAC databases. Setup TDE for data encryption. Setup of OVD to support single sign-on.
• Production support by working closely with other database administrators/developers, OS engineer and subject matter experts to ensure the availability and integrity of databases and handled critical issues such as network failures and ASM DISK group errors and node failures in the RAC cluster.
• Performance testing and tuning of 12c RAC database after migration and upgrade from 11gR2 single instance by using AWR/ASH/ADDM/OEM 12c/SQL Plan Management, TKProf and home-cooked scripts, etc.
• Use Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries.
• Effectively decrease Confidential lag by using various technical methods such as database tuning, Confidential parameter tuning, application large table re-design, Linux/Unix kernel performance tuning. Upgrade Confidential from 11gR2 to 12c. Implement Confidential 12c new features in mission-critical production environments.
• Assist application team to ensure the functionality of softwares, such as Anthill Pro, NDM, and Autosys
• Manage operational readiness of new servers for 12c RAC databases, such as the OS configuration, the mounting of Confidential file systems, and the installation of Oracle clusterware and application softwares.
• Security check for database by SQL scripts and provide remediation suggestions to meet data security and compliance requirements.
• Support and maintain Oracle 12c RAC database building and migration documentation.
• 24X7 level 3 DBA support for the production systems.

Senior Oracle Exadata DBA and GoldenGate Administrator

Confidential

Responsibilities:

• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects. Assisted in integration of Exadata applications into current IT actionable events and solutions.
• Setting up High Availability Oracle GoldenGate ( Confidential ) systems on Oracle 11gR2 RAC environments (Front-end: IBM p770/AIX 6.1, Back-end: Oracle Exadata X4 Full Rack).
• Upgrade Oracle GoldenGate from 11gR2 to 12c. Implement Confidential 12c new features in mission-critical production environments.
• Troubleshooting typical Confidential technical problems such as unique key violation / long transaction abending by using GGSCI / Logdump / discard file analysis etc.
• Performance Tuning Confidential in extremely high data volume environments. Installing and configuring Confidential heterogeneous environments (from MS SQL Server to Oracle Exadata).
• Monitor and fully analyze performance issues in production Oracle databases by using AWR/ADDM/OEM 12c
• Daily development / testing environment baseline backup and restore, develop and maintain administration scripts by using Perl/Korn shell.
• Installed, configured and maintained Oracle 11g Real Application Cluster (RAC) / ASM on Redhat Enterprise Linux 6.x boxes.
• Application DBA leader for a large number of tuning projects. Working with third party developers on SQL code review and quality control. Performance load testing and tuning application, SQL code, and database instance by using a wide range of technologies including ADDM, AWR, ASH, OEM Performance Manager and home-cooked scripts by using Korn shell/Perl.
• Duplicate all the non-production databases on Exadata server according the Data Warehouse development project's requirement. Help to compress large volume partition table by using Oracle HCC (Hybrid Columnar Compression) techniques.
• Primary technical resources in SQL tuning in Exadata Production and Performance Testing environments by using statistics, hints, SQL tuning set etc.
• Software and firmware maintenance of the Exadata storage servers in the Database machine including routine health check, patching and upgrades according to the suggestions from Oracle support department.
• Integration of Exadata monitoring into our existing IT monitoring framework. Provide and implement performance and tuning recommendations of all components in the Exadata machines.
• Develop and record certified processes/procedures for all potential IT downstream support group to maintain and upgrade the Exadata servers.

Oracle DBA and GoldenGate Specialist

Confidential

Responsibilities:

• Supporting more than 20 Oracle 10g/11g development/testing environments on Solaris/SPARC and Linux/X64 boxes. Help the developers and QAs to do trouble shooting about database issues.
• Monitor and fully analyze performance issues in production Oracle databases by using AWR/ADDM, statspack/tkprof tools
• Daily development / testing environment baseline backup and restore, develop and maintain administration scripts by using Perl/Korn shell.
• Installed, configured and maintained Oracle 11g Real Application Cluster (RAC) / ASM on Redhat Enterprise Linux 5.x boxes.
• Implemented 11g DataGuard Physical using DG Broker, and experienced with 11gR2 Data Guard new features Active Data Guard and Snapshot Standby.
• Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.
• Partitioned tables Maintenance, adding new partitions, exchanging one year old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.
• Analyze data model in the existing databases and validate compatibility with Oracle GoldenGate ( Confidential ) replicated environment, use Confidential to setup the replicated implementation from MS SQL Server to Oracle 11g.
• Modified database structures including tablespace, tables, views, triggers, stored procedures as well as configuration and storage allocation to support application enhancement.
• Oracle database performance testing, monitoring and analysis by using LoadRunner.
• General DBA daily jobs such as disk usage monitoring, table/index rebuild and reorganization as needed

Confidential, New York City, NY

Oracle DBA

Responsibilities:

• Part of the Data Architecture team which supports development, test and production databases.
• Worked on RMAN duplication, Cross-platform Transportable Tablespace.
• Implementation and support of 9i and 10g migrations and upgraded from Oracle 9i to Oracle 10g databases, including RAC (Real Application Clusters) databases on IBM AIX and Linux.
• Performed oracle Software’s Installations, Creation of new standalone and clustered databases.
• Administering and setting up of 10g RAC and clusterware and instances.
• Resolved RAC issues, OCR related issues, rebooting of faulty nodes, relocating the switched over services.
• Database Services creation for distributing the applications across multiple nodes, extensively used all command line utilities SRVCTL, CRSCTL, ADR, ASMCMD.
• Redefinition of tables using DBMS REDEFINITION, partitioning the tables in the production, re-defining the columns data types, and moving the LOBS to different tablespaces
• Partitioned tables Maintenance, adding new partitions, exchanging one year old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.
• Developed RMAN Backup strategies for cloning the test databases with the production environment and worked on RMAN active-active duplication.
• Scheduled RMAN backups purge jobs, Maintenance Jobs using DBMS JOBS, DBMS SCHEDULER and crontab.
• Handled Chained Rows and Row migration, and solved the database performance issues.
• Experienced with ASM, adding, deleting disks to the disk group.
• Supported development teams for all the database related issues and handled the critical issues like network failures and ASM DISK group errors and node failures in the RAC cluster.
• Generated Statspack/AWR reports using OEM from Oracle 10g database and analyzed the reports for Oracle wait events, time consuming SQL queries, tablespace and database growth.
• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries
• Supported development teams for moving changes to different development, test levels and prepared documentations to move changes to the live production environment.
• 24/7 on-call support for the production environment

Confidential, Chevy Chase, MD

Oracle PL/SQL Developer

Responsibilities:

• Involved in Business Requirements, System analysis and Design of the Data warehouse application. Assisted in gathering requirements by performing system analysis of the requirements with the technology teams.
• Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats. Designed Physical and Logical Data model and Data flow diagrams and Designed database Relational and Dimensional models using ERwin
• Designed/Developed/Modified database objects like Tables, Indexes, Views, Materialized Views, Stored Procedures, Functions, Packages and Triggers.
• Worked on various tables to create indexes to improve query performance. Also worked on partitioning large Tables using Range/List/Hash Partitioning, creating Index Organized Table (IOT), Cluster Tables.
• Perl Scripting, Unix Shell Scripting and PL/SQL programming to resolve business problems of various nature
• Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required.
• Converted Oracle ETL Packages to Informatica Mappings and created workflows/Sessions.
• Developed Informatica Mappings using various Transformations and PL/SQL Packages to extract, transformation and loading of data.
• Filtered and Loaded data from different formats of data sources into Database Tables.
• Extracted required data from the database tables and exported the data to different sources in different formats.
• Created new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements
• Experience in Generating Reports with Oracle Forms& Report tools.
• Used hash/nested loop/merge joins, indexes effectively in where clauses for Query optimization