SUMMARY:

• Oracle Certified Professional (OCP) DBA.
• Over 15 years of experience in all aspects of database development, implementation, and database administration.
• Manage complex database environments with high availability and disaster recovery solutions for 24x7 business critical applications.
• Strong experience with data modeling, database design, installation/configuration, migration/upgrade and patching, security, monitoring, backup, recovery and restoration, RAC, data guard, replication, performance tuning and troubleshooting, SQL and PL/SQL programming.
• Strong experience on Installation/configuration, upgrade/migration Oracle Confidential .
• Relocation of data center. Migrated database from old data center to new data center.

TECHNICAL SKILLS:

• SQL, PL/SQL, Shell Scripting, C++/C, Java.
• SQL*Plus, Oracle Enterprise Manager, Quest - Toad, Spotlight, SQL Developer.
• Linux, HP-UNIX, Sun Solaris, IBM(XENIX)
• Window, MS DOS
• Oracle 12c Multitenant.
• Oracle 12c, 11g, 10g, 9i, 8i, 8. 7.
• Creation, upgrade, migration, patching and administrate Oracle database.
• Database security (Roles, Privileges, Profiles, Auditing, Transparent Data Encryption (TDE), Active Directory database account Integration, Thycotic Secret Server, etc)
• Create and Administrate Oracle Real Application Cluster (RAC).
• Create and Administrate Data Guard and Physical Standby database with FSFO.
• Automatic Storage Management (ASM).
• Oracle Golden Gate replication.
• Data Warehouse.
• Materialized view.
• Devised Backup strategies and various configurations of RMAN backup. Perform database recovery and restoration.
• Export/Import, Data Pump, SQL Loader.
• Database performance tuning (ADDM, AWR, ASH, etc).
• SQL and PL/SQL performance tuning (Explain plan, SQLT, TKPROF, stored outline, SQL Profile, PL/SQL Profile, etc).
• Grid/Cloud Control, Oracle Enterprise Manager.
• Table Partitioning, Advanced compression at table and tablespace level, Online redefinition, external table, ADO, In-database archiving.
• Data Masking.
• Database design and analyze capacity based on transaction volume and growth of the database.
• Data Modeling (Erwin, ER/Studio, Popkin System Architect CASER tool, etc).
• SQL and PL/SQL programming, storage procedures and functions, packages, triggers.
• Oracle text and spatial.
• Implement and administrate Oracle Advance Queue, Oracle Advance Replication and Oracle Streams.
• Support new Application releases and implementing in Development, Testing and Production environments.
• Data Migration from different legacy database system to Oracle environment.
• Writing Shell Scripts for database related activities.
• Creation and maintenance of database as per OFA Standards.
• Installation and upgrade and migration Oracle Software.
• MS-SQL Server
• Unify

EXPERIENCE:

Sr. Oracle Database Administrator

Confidential, New York, NY

Responsibilities:

• Provide 24 x 7 Production databases supports. Total about 100 databases with different configurations from 9i, 11g to 12c from standalone to RAC. Many of them are bigger than 20 terabytes.
• Maintaining all production databases high availability for supporting non-stop business operations for all applications.
• Implement, maintain and support Maximum availability architecture (MAA) for 24x7 business critical databases through RAC, Data Guard/Standby database and Golden Gate replication.
• Monitor database performance, storage, and many others using Oracle Enterprise Manager (OEM) Grid/Cloud Control.
• Tune and optimize database instances and queries for performance improvement. Proactively analyze database performance, identify top queries and make recommendations to development team for query rewrite.
• Designed, implement, and perform RMAN backup strategy.
• Recover tables or rows to a previous point in time and retrieve data for a time in the past by use Oracle Flashback. Recover truncated tables use TSPITR (restore and recover the tablespace to a pint in time). Database recovery for datafile corruption, and block corruption.
• Migrated/upgraded Oracle databases from 8, 8i, 9i, 10g, 11g, 12c multitenant with minimum down time. Consolidate databases with Oracle 12c multitenant.
• Involved and played important role in data center migration from old data center to new data center.
• Implemented and maintained archive database using Oracle Golden Gate.
• Manage database storage with Automatic Storage Management (ASM).
• Implement and administrate replication through Oracle Confidential, Oracle Advance Replication (Oracle Streams) and Materialized view.
• Protected Health Information (PHI/HIPPA) with customized scrubbing scripts, data masking and Transparent data Encryption (TDE)
• Converted production database from single instance (non-RAC) into RAC mode. Adding node to existing cluster.
• Worked with RAC using Raw Devices Shared Disk in a RAID configuration and Cluster File System.
• Configuration of Database parameters for optimal performance and database performance tuning. Performance tuning for optimized results using tools like Explain Plan, SQLT and TKPROF, ASH/AWR/Statspack and ADDM.
• Monitor database for storage management, fragmentation management. Maintain database for best performance.
• Creating and patching the database. Setting up the Disaster Recovery Server (physical standby).
• Installing, configuring, migration, upgrading and patching Oracle products on different platforms (Solaris, HP-UX, Linux, Window, etc)
• Apply different database patches, including interim patch, diagnostic patch, bundle patch, patch set updated (PSU) and security patch update (SPU).
• Scheduled application, database maintenance jobs using DBMS JOB, DBMS SCHEDULER, OEM, Cron job use Shell scripting, and BMC Control-M.
• Implement, maintained and support data warehouse and DSS report environment database use Confidential for Oracle database and Oracle to and from SQL Server databases, Materialized and other ETL tool.
• Data Migrations from different legacy database system to Oracle environment. Developing conversion packages, procedures, functions, triggers, database objects, and perform data conversion for the different claims.
• Capacity planning and monitoring the databases growth.
• Implement and administrate Oracle Advance Queue.
• Support both production and development activities. Working closely with application teams to resolve all database related issues. Support the application development lifecycle.
• Refresh schemas, objects and data from production to test and development database. Implement scrubbing process to secure Protected Health Information (PHI/HIPPA) when copied data from production to non-production database.
• Control and monitor development support users access to production database.
• Database movement from one machine to another machine.

Oracle Database Administrator

Confidential, Iselin, NJ

Responsibilities:

• Implemented architectural database design for JIT inventory across 5 distinct global warehouses.
• Utilized Erwin data modeling tool for ERD.
• Developing stored procedures, packages, triggers, and creating and altering database objects.
• Performance tuned the database for efficient access of data.
• Backup/Recovery strategy and implement.
• Loaded data from legacy systems into Oracle database using SQL loader utility.
• Administrate and maintain production database.
• Database Administration: create and modify database structures and objects, backup and recover databases, manage users, maintain database storage, and write SQL and shell scripts for database administration tasks.
• Database Performance Turning: thoroughly analyzed the physical and logical layout of the database, proposed and implemented changes associated with data files, tuning application and SGA configuration.
• Database Migration: migrated production database from Oracle 7.3.4 to 8.0.5.
• Data Warehouse Project: data modeling, database creation and maintenance, network configuration, database object creation and maintenance, data replication, data loading, support developers in modifying and enhancing existing features for applications.