SUMMARY

• I am a Senior DBA with over 10 years of aggregate IT experience with strong troubleshooting skills.
• I also have over ten years of extensive knowledge and proficiency in Oracle, 11g, 12c and 19c database design, administration and systems analysis, excellent communication skills and I am a great team player with a fast learning curve.
• I can work perfectly and effectively under stressful conditions where speed and accuracy are necessary for mission critical databases.
• My attention to detail and the ability to maximize system resources can be beneficial in the following areas.
• Oracle Installation, configuration, patching and upgrades
• Backup and recovery using RMAN
• Monitoring and Performance tuning (AWR, ASH, AADM, ADVISORS)
• Database Upgrade, patching and Migration
• Job Automation in ORACLE
• Data and database integrity and SECURITY
• Implemented different HA/DR technologies such Oracle RAC, Data Guard Golden gate
• Experience with data migration and ETL activities
• experience developing and testing Java applications
• Experience with relational databases, Web application development, and Web technologies
• Experience in Oracle Advanced Security include Transparent Data Encryption (TDE).

TECHNICAL SKILLS

Operating systems: LINUX, AIX, SOLARIS, MS - DOS, NT, Windows 2000, Windows Advanced Servers

Databases: Oracle 19c, 12c, 11gR2, 10gR2 RAC, SQL Server 2000, 2005 and 2008

Oracle Database Tools: SQL*Loader, TKPROF, Toad, OEM, Grid Control, External Table

Tools & Utilities: Export/Import, RMAN, Data Pump, Winscp3, ERWIN, DBCA, DBUA, ADDM, Remedy.

PROFESSIONAL EXPERIENCE

Confidential

Oracle Database Administrator

Responsibilities

• Database Installation and Configuration from Oracle 10g through 19c.
• Plan and implement Backup and Recovery of databases using RMAN, Database Migration and table spaces.
• Perform ongoing database maintenance, Patching and Upgrade for Oracle 10g, 11g and 19c databases.
• Performance Tuning for databases utilizing Oracle diagnostic tools like Explain Plan, TKPROF, SQL Trace, and the AWR/ASH to analyze timing and execution plan for tuning.
• Planning and implementing Disaster Recovery and High Availably solutions like Data Guard and RAC.
• Perform Data Refresh/Cloning from Production environment to setup QA/ DEV using RMAN Duplicate.
• Configure Oracle GOLDEN GATE for data sharing using EXTRACT, REPLICAT, DATAPUMP, and MANAGER PROCESS for Bidirectional, Unidirectional, Broadcasting and Consolidation topologies.
• Active participation in Software Development Life Cycle (SDLC) specifically waterfall and Agile Scrum methodology. Automatic Diagnostics Repository (ADR) Enhancements in oracle Database 12c.
• Design and implement standard and advance security enhancement and monitoring policies using Fine Grain Auditing (FGA).
• Extensively implemented Data Pump, conventional Export/Import, Transportable Table space (Oracle 10g, 11g and 12c) for migration and logical backup of database.
• Created and modified scripts for Managing and maintaining table space growth.
• Hands-on experience with Oracle Enterprise Manager (OEM) 11g/12c/13c including Management Agent setup, Oracle Management Console configuration, Cloud Control Plug-in and beacons, Dashboard setup and monitoring
• Created and granted users privileges and roles.
• Extensive experience in Data Warehouse. Proficient with ETL tools like SQL*Loader and External Tables.
• Multitenant: Manage Table space in a Container Database (CDB) and Pluggable Database (PDB) in Oracle Database 12c.
• Experienced in configuration of ASM for RAC and NON- RAC environments.
• Scheduled UNIX scripts in Crontab jobs to automate daily tasks like backups, monitoring the alert logs, backup logs, cleaning the old archive logs, old log files, table space monitoring to send notification emails.
• Created the database objects such as Tables, Indexes, Views, Database Triggers, Procedures, Functions, etc.
• Manage updates and configure alert responses for all database systems, ensuring optimal security and backup.
• Extensively manage the Oracle 12c multitenant Container and Pluggable databases
• Successfully Implemented key RMAN 11g features such as block change tracking, use of flashback recovery area and taking incrementally updated backup to meet backup and recovery goals.
• Audit database performance using ADDM reports, AWR snapshot and diagnostic SQL scripts. Identify and tuning of ad-hoc queries, PL/SQL code which are high intensive resources. Used explain plan and stats pack/TKPROF utility to Improve response time of query.
• Led Data Migration and Data conversion Projects involving Terabytes(TB) of Data from On-Premise Datacenter into AWS Cloud Based, OCI, and Virtualized (VMWare) Infrastructures
• Managing users and security.
• Performed incremental backups using Recovery Manager (RMAN). Created recovery catalog, performed complete and incomplete recovery using RMAN.
• Performed Databases Refresh and Schema level refresh as per the User request from Production.
• Implemented three node 11g RAC clusters on Linux platform and AIX LPARs having GPFS cooked SAN Storage.
• 24X7 production support and on call rotation.
• Designed and engineered the upgrade, re-architecture and migration of databases/applications
• Experience in maintaining Data Guard to provide high availability by implementing Physical Standby database and Snapshot Standby and Logical Standby.
• 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.
• Ability to troubleshoot the oracle alerts.
• Install ASM environment and migrated databases from NON-ASM to ASM.
• Perform Databases Refresh and Schema level refresh as per the user request from Production to UAT and DEV Environments for testing purposes.

Confidential

Oracle Database Administrator

Responsibilities

• Primary DBA for 10+ databases of Oracle 10g/11gR2 and GOLDEN GATE, RAC
• Administration on Linux REHL, HP-UX. Worked as per ITSM/Remedy Incident ticket/Critical Response Time (CRT) call.
• Perform ongoing database maintenance, Patching and Upgrade for Oracle 10g, 11g and 19c databases.
• Monitored Database growth and provide Database capacity planning for applications expansion or necessary re-organization of tables and indexes as and when required.
• Data guard - configure primary - standby using duplicate from active database.
• Performed SCN-based Incremental backup to sync standby after loss of Archive logs on primary. Measure data loss based on latency/lag. Cross-platform migration using Data guard.
• RAC- Administration/Trouble-shooting of 3 Node cluster ware on Oracle 10g/11GR2. Configuring Grid Infrastructure SCAN Listeners on 11gR2. Migrate OCR files to ASM.
• Managed ASM storage. ASM cloning. Prepare/Add/remove ASM disks. Tuning of I/O on ASM based databases. Troubleshoot ASM crashes & memory problem.
• Designed, Configured AWS Cloud Formation Templates and deployed stacks for fast provisioning of database operations environments
• Performed incremental backups using Recovery Manager (RMAN). Created recovery catalog, performed complete and incomplete recovery using RMAN.
• Installation of 3 nodes 11g RAC on Linux & Solaris with VERITAS cluster ware. Configured ASM, OCFS and RAW devices.
• Revamped Traditional Data Backup Strategy from Disk / Volume Storage to AWS S3 Storage via automation for efficiency, enhanced cloud capability and cost sustainment
• Expertise in the creation of databases, table spaces, tables, indexes and other database objects.
• Installed and manage Oracle Enterprise Manager.
• Installed and configure relevant network components to ensure database access as well as database consistency and integrity.
• Troubleshoot and resolve various Oracle connectivity problems.
• Provided network troubleshooting and administrative support for the development staff.
• Designed daily, weekly Backup and Recovery procedures for production, non-production databases using RMAN backups taking periodic Complete, cumulative and differential Incremental Backups.
• Audit database performance using ADDM reports, AWR snapshot and diagnostic SQL scripts. Identify and tuning of ad-hoc queries, PL/SQL code which are high intensive resources. Used explain plan and stats pack/TKPROF utility to Improve response time of query.
• Oracle GOLDEN GATE for data sharing using EXTRACT, REPLICAT, DATAPUMP, MANAGER PREOCESS for Bidirectional, unidirectional, Broadcasting and consolidation topologies.
• Monitoring the CPU, memory usage, I/O contention on servers using top, iostat, sar, glance, vmstat etc.
• Data Refresh/Cloning from Production environment to setup QA/ DEV using RMAN Duplicate.
• Scheduled UNIX scripts in crontab jobs to automate daily tasks like backups, monitoring the alert logs, backup logs, cleaning the old archive logs, old log files, table space monitoring to send notification emails.
• Implemented Point in time recovery using RMAN.
• Extensively used Oracle 11gR2 features - Real Application Testing, automatic SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Merge backup, Oracle Data Pump, big file table spaces, new OEM Grid Control, Database Control, Studio Control, AWR, ADDM, SQL Tuning/Access Advisors, SQL Performance Analyzer, Database Replay, SQL Plan Management.
• Performance Tuning of Oracle Database Objects using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, STATSPACK for optimized results.
• Support 24/7 on call rotation.
• Configuration and implementation of Oracle for high availability. Implemented downstream capture at the destination database using Oracle Streams.
• Installed and Configured Oracle OEM (Oracle Enterprise Manager) Grid Control.
• Extensively implemented Data pump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
• Experienced in Data Warehouse. Proficient with ETL tools like SQL*Loader and External Tables.
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “run Installer” and per based utility “opatch”.
• Experienced in configuration of ASM for RAC and NON- RAC environments.
• Configured Repository and clients for GRID Control and also implemented DB Control for some databases.
• Extensively worked on setting up auditing in many databases we supported
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Installed ASM environment and migrated databases from NON-ASM to ASM. Monitored different databases and application servers using Oracle Enterprise
• Manager (OEM) 12c Grid Control.

Confidential

Oracle Database Administrator

Responsibilities:

• Installed, configured, maintained and supported Oracle 11g and 12c (Multitenant and NON-CDB) Databases.
• Monitored backup procedures on a daily basis using scripts scheduled through Crontab. Performed Hot Backups and Cold Backups.
• Performance Tuning of Oracle Database Objects using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, STATSPACK for optimized results.
• Managed ASM storage. ASM cloning. Prepare/Add/remove ASM disks. Tuning of I/O on ASM based databases. Troubleshoot ASM crashes & memory problem.
• Data guard - configure primary standby using duplicate from active database command of 11g. Apply SCN-based Incremental backup to sync standby after loss of Archive logs on primary. Measure data loss based on latency/lag. Cross-platform migration using Data guard.
• Managed Data Guard using Data Guard broker.
• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
• Extensively implemented Data pump, conventional Export/Import (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”.
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Tuning performance using Advisors, AWR, ADDM, SQL tuning.
• Implemented Point in time recovery using RMAN.
• Defined and implemented database backup and security strategies, and tested the backups periodically for consistency and reliability.