SUMMARY:

• Over Sixteen years of professional experience in analysis, design, development, data handling, and performance tuning of databases.
• Ten years of database administration of large scale databases, Oracle server installation, upgrade and migration, and optimization, database design, data guard, backup and disaster recovery, 24x7 production database support, Client/Server and web applications, with strong working knowledge of ORACLE RDBMS.
• Good use of ORACLE 12c/11g/10g/9i, SQL*PLUS, PL/SQL, SQL*LOADER, TOAD, Erwin, Programming language Korn shell on a UNIX system. Expertise in MYSQL, Certified Postgres DBA, Mongo db. Ansible scripts automation.
• Exposure to AWS, Hadoop, Expertise in Oracle Encryption, Oracle Advanced Queues and Oracle Encryption. Leverage my extensive experience in oracle technologies to help organization gain maximum benefit from their ORACLE & MYSQL RDBMS investment and overcome their biggest challenges
• Senior Oracle DBA with RAC, Data Guard, Oracle Replication, Golden Gate, AWR, RAC, +ASM and Replication, Backup and Recovery using RMAN, Grid Control, Stream, queue/de - queue. Worked on Abinitio ETL, Informatic, SAS ETL tools.
• Experience in managing OLTP high transactional database and Data Warehousing databases, good understanding of Unix internal and system administration and Storage management and Networking concepts. Expertise in writing shell scripts and PL-SQL programming.

TECHNICAL SKILLS:

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.

Languages: SQL, PL/SQL, UNIX Shell Scripting, PERL, Ansible, puppet, AWS,, PHP, python, C, C++.

Tools: and Utilities: RMAN, OEM 12c, SQL*Loader, EXP, IMP, Data pump, TOAD, ADRCI Oracle SQL Developer.

RDBMS: Oracle 9i, 10g, 11g,12c, Postgres, MYSQL, DB2. Big data Hadoop.

Operating Systems: HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 7.1 6.1 RHEL 7, 6 and 5. Linux Enterprise Server 9, 10. Windows 95/98/NT/2000.

PROFESSIONAL EXPERIENCE:

Confidential

Database Administratior

Responsibilities:

• Experienced in database code planning and deployments
• Highly Experienced in Hot/Cold Backup and Recovery and Cloning of databases and backend Application Schema using RMAN.
• Upgrading and patching Oracle Database, Golden Gate setup. OEM agent installation and setup of OEM agent on each database.
• Expertise in building Standby databases and duplicate databases with different protection mode. Activated standby database and worked on failover and switchover of primary and standby database, worked on multiple destination standby databases.
• Migrated and build about 80 databases from 10g, 11g to 12c and applied Quarterly Patches using dbca, Oracle Installer and Silent Installation using response file.
• Restored several databases using RMAN features in Disasters Recovery Situation.
• Installed RAC Database and +ASM, Upgraded Single instance database to RAC
• Build Databases on Cluster Environment with failover and switchover logic using Veritas Cluster Services (VCS) and AIX P5 and P6 HACMP Cluster.
• Worked on Data transferring with export/import utilities and Data pump.
• Experience with oracle Transparent Data Encryption, TDE through HSM; Data scrambling of sensitive data for refresh to lower environment; very familiar with PCI security implementations for PCI personal data regulation.
• Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases and Cross Platform Transportable Tablespaces (XTTS) across Platforms.
• Expertise in implementing data refreshes (at database, schema and table level) using RMAN utility and Data pump, conventional Export/Import of Oracle 11g, 10g.
• Implemented Hot/Cold physical backups (Incremental and full), cloning, duplicating of databases using RMAN with VERITAS Net Backup & IBM TSM.
• Recovery of Databases from Media failure, Block Corruptions, User errors.
• Database and Grid Software Configuration and Installation for RAC and ASM
• Excellence in Performance Tuning using STATSPACK, TKPROF, EXPLAIN PLAN, SQL TRACE, AWR, ADDM
• Proactive monitoring, identifying areas that need to be improved in the application and database using AWR, ADDM and 10g OEM Grid Monitoring.
• Experience with writing Packages, Stored Procedures, Functions and Database Triggers.
• Proficient in Database Design (Physical and Logical Database Design) and Normalization.
• Extensively Implemented Datapump, conventional Export/Import (Oracle 12c, Oracle 11g, 10g) for migration and logical backup of database.
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “OPatch”.
• Good knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.
• Expertise in maintaining Database Security using auditing.
• Experience in Data Migrations.
• Managed large databases with Big Data
• Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 12c, 11g, 10g RAC servers for disaster recovery procedures.
• UNIX shell scripts for hot backups, SQL*Loader, export and import of database.
• Proficient with Database Cloning, Migration, and Patching of Oracle Databases.
• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
• Experience in doing upgrades including maintenance & monitoring implementation.
• Extensive knowledge in UNIX platforms includes HP-UX, SOLARIS, AIX, and LINUX.
• Knowledge in configuring ASM (Automatic Storage Management)
• UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.
• Beginner in configuring and setting up Oracle Virtual Database and creating VDB templates