SUMMARY:

• More than 7 + years of IT experience, mainly Oracle Database Administration experience including Oracle9i, 10g, 11.2.0.4 & 12.1.0.2 on both Standalone, RAC and RAC Exadata running on X3,x4 & X6s, Oracle Enterprise Manager Cloud Control 12c & 13c Release 2, 11gR2 RAC on LINUX and Sun Solaris, Installation, Upgrading, Patching, sizing, creating Oracle Databases, and Oracle database Objects, data migrations, Troubleshooting, Performance & Tuning, Backup & Recovery, and Database integrity and Security.
• Experience in translating business requirements into conceptual, logical, and physical data models.
• Experience with ETL tools like Talent and Looker
• Experience in configuring RMAN on both Control file & Recovery Catalog.
• Performance Tuning of database by optimizing SQL and PL/SQL codes and instance
• Used stats pack report, AWR report, ADDM, explain plan and Tuning advisor.
• Excellent experience in installation, setup and configuration of Oracle 10g,11g and 12c on Linux both RedHat & OEL, Unix Flavor like HP - UX & Solaris, Windows and IBM AIX environments
• Proficient at performing major Database Release Upgrade (manually as well as using DBUA) along with applying various PSU patches using Opatch for 10g|11g|12c databases.
• Experience in database cloning, database backup, recovery procedures and security.
• Experience in application Support, SQL Loader, Data pump, Data Guard, Fine Grain Auditing (FGA), performing Flashback, transportable tablespaces.
• Worked on TDE (Transparent Data Encryption) 12C KeyStore on Tablespace/Columns Master Encryption.
• Experience in designing and configuring high-availability systems using DATAGUARD with physical standby. Effectively used DATAGUARD BROKER utility.
• Experience in Tables Partitioning
• Hands on experience in installation and maintenance of enterprise manager 12c and Grid Control 11g and addition of targets for database Monitoring/Performance/Diagnostics purposes.
• Implemented and maintained 12c multitenant architecture using container and pluggable databases and performed conversion of non-container databases to pluggable databases.
• Experience in Performance Tuning, tuned various large critical OLTP and OLAP databases using various tools like AWR, STATSPACK, ASH, SQL-TRACE, TKPROF, ADDM, and Explain Plan Utilities.
• Experience in the management and implementation of database models, data flow diagrams, database schemas, database scripts, to support a robust data management infrastructure.
• Adept at installation of OEM Database Control, OEM grid control and Deploying Agents.
• In-depth knowledge and understanding of Oracle Database features such as RMAN for backup and recovery, Materialized Views, Export/Import, Data Pump and Data Guard. Working knowledge of Auditing and Database Security.
• Experienced in Designing, Installing, Configuring and Maintaining Real Application Cluster (RAC) on Exadata., OCFS, Automatic Storage Management (ASM) and SRVCTL utility.

TECHNICAL SKILLS:

And Ticketing: Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DBA Configuration Assistant) Toad, OEM Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Statspack/AWR, Top, DBCA, DBUA, ADDM, SERVICENOW,IPcenter, Active Directory, SRVCTL CRSCTL.

Operating Systems: LINUX, UNIX (Solaris, AIX, & HP-UX) and WINDOWS

Hardware: Solaris, HPUX, Windows, Hitachi, EMC, Dell Servers Red Hat Linux 6.5,6.7, 6.9 & 7.0

Middleware: BEA Weblogic 10.2.3, ODI

Tuning Tools: Toad, Oem, Tkprof, Explain Plan, Awr, Addm &Ash

Backup Media: Netbackup, Emc and Commvault

File transfer between platforms tool: WinSCP, Filezilla, PSCP, PSFTP, SCP

Remote Installation and Database management tools: Putty, MobaXterm

Data Analysis: Power BI

PROFESSIONAL EXPERIENCE:

Confidential, Indianapolis, IN

Oracle Database Administrator

Responsibilities:

• Support many Exadata databases running Oracle12.1.0.2 on X6s, Linux 6.9 & Standalones running Oracle11g, 2.0.4 running on Linux 6.7 VMs servers and using Cloud Control 12C for monitoring.
• Provide Oracle DBA support for applications, including developing data migration scripts, data validation queries, and a maintenance plan for the various development versions of these applications.
• Provide documentation and support for all aspects of maintenance and development.
• Work with application development team staff to develop & test database architecture and approve all production schema changes.
• Constantly refresh from Production to Training, Test and UAT environment.
• Tune database instances and applications and recommend changes to improve database performance.
• Migration of data from sql-server to Oracle12C.
• Upgraded Oracle 11.2.0.4 to 12.1.0.2 on Exadata, running on X6s, Linux 6.9
• Mange RAC databases, instances, ASM and the clusters with the use of ASMCMD, SRVCTL and CRSCTL
• Handle all the aspects including new projects, manage existing databases, performance and tuning, contact for vendors, and internal/external customers.
• Maintain backups.
• Support databases that interface with ODI and SCI applications
• Successfully performed migrations from Oracle 9i to 11gR2 RAC (Real Application) Database.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
• Constantly monitor the dynamic performance Views (V$) at peak load of the Databases and checking RAC background processes log files & Trace files to troubleshoot performance
• Apply PSU to all the Oracle databases
• Use shell scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
• Maintain the data integrity and security using integrity constraints and database triggers.
• Part of on call of 24X7 support for all the production and development databases.

Confidential, Indianapolis, IN

Oracle Database Administrator

Responsibilities:

• Managed and supported a 4 Node Exadata on X4 & X6s from Development, Testing, UAT to Production environments.
• Involved in daily database administration on all databases running on Red Hat Linux 6.7,. Database sizes range from 2TB to 12TB (in instaVIN, LiveBlock & Autoniq, SCI & EDW environments).
• Table & schema refreshes using Datapump, expdp and impdp .
• Database refreshed using expdp, impdp, RMAN Duplicate and cloning .
• Experienced in cloning the databases using HOT and COLD backups.
• Used RMAN Duplicate and EXPORT/IMPORT data from 9i to 11.2.0.4.
• Created a standby database by using RMAN Duplicate in order to reduce the down time for the PROD database during the migration process.
• Planned Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
• Installation of oracle enterprise manager 12c, oracle management repository and deployed agents.
• Configuring administration groups and creating template collections in OEM 12c.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).
• Worked closely with the Oracle developers for the better performance in Applications, in writing the Packages, Triggers and Indexes on the tables.
• Used Secure SCP & FTP extensively for the File transfers from machines to remote server.
• Cloning & duplicating databases using scripts as well as RMAN for test and developments instances.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
• Responsible for setup and implementation of 2 Node RAC on Linux in 11g R2.
• Implemented Data guard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.
• Worked closely with Systems Analysts, Systems Engineers/Admins & Application Developers through the SDLC from Development to Production, via Tech-Test in Needs Assessment, Requirements Gathering (Server hardware/OS specifications for Oracle Installs), Database Designing (Physical & Logical) and Implementation, database user creation and database access both at role & table levels, as well as final Project Performance Assessment/Evaluation.
• Created database Objects, Tablespaces, Schemas as needed.
• Schema migrations from Development to Production via Tech Test environments.

Confidential, Indianapolis, IN

Oracle Database Administrator

Responsibilities:

• Performed Installation and configuration of Oracle 11.2.0.4 database on HP-UX platform.
• Successfully performed migrations from Oracle 10g/11g to 11gR2 RAC (Real Application) Database.
• Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 11g R2.
• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 11gR2.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
• Supported off-hour on call support for database related issues.
• Created logical and physical design installed and upgraded databases.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage Area Networks (SAN) and Network attached storage (NAS).
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 11gR2.
• Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
• Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
• Applied patches 11.2.0.3 and 11.2.0.4 DATA GUARD running on a 4 Node RAC
• Used to run the scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
• Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Provided 24X7 supports for all the production and development databases.

Confidential, Indianapolis, IN

Oracle Database Administrator

Responsibilities:

• Configured. Implemented & Deployed Oracle 11g (11.2.0.4) & Oracle 12C, single instances on Linux Red hat Solaris
• The work involved overall Maintenance of Oracle Database, Backup, Recovery and other database related activities.
• Taking Backups on scheduled time and Monitoring Scheduled Backups.
• Creating and dropping of users, granting and revoking rights as and when required.
• Checking of Oracle files for abnormal behaviors.
• Day to day Performance Monitoring and tuning of database.
• Diagnose and Troubleshoot Database Problems and failures
• Involved in the Design (Logical & Physical) of Databases
• Preparing Backup and Recovery Plan.
• Involved in the installation of Oracle 11g (11.2.0.4) on both Solaris and LINUX platforms.
• Creation and maintenance of database.
• Handling day-to-day activities.
• Monitoring of database for growth and performance.
• Defined backup procedures using daily hot backups and weekly cold backup.
• Storage and space management including table spaces and data files.
• Creating Databases and all database objects. Database Designing, Designing Tablespaces and Rollback Segments.
• Management of table space growth, monitoring data files additions, extent growth.
• Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.
• Using TKPROF, EXPLAIN PLAN for the Better performance.
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.