SUMMARY

• Oracle Database Administrator with 7+ years of experience with 9i, 10g, 11g, R2, and (12c databases and agents) servers with RAC, ASM, Data Guard and Grid Control
• Recently migrated 10g to 11g and 11g to 12c databases from Linux to OVM servers with RMAN option with a minimal downtime and I was involved with the upgrade of agents on 12c version from 11g.
• Extensive experience setting up Maximum Availability Architectures and Capacity on Demand Architectures using various products, protocols and methodologies from Oracle including 10g Real Application Cluster (RAC), Data Guard, ASM, Grid Control, (ADDM), RMAN, Materialize view along with Golden Gate replication
• Among primary DBA day to day tasks, I am regularly involved in development activities during the SDLC phases which includes development, testing and QA. Also worked closely with clients on an average of by weekly basis, in which we plan and gather stats on new projects I - e ASM migration, taking backups and scheduling, Database upgrades and memory allocation planning, changing the INIT parameters to new versions of oracle for upgraded databases in tables, finding data guarded and golden gate databases and making a list from different data centers, Patch Set Updates scheduling and giving reports and Application On-Boarding.
• I am familiar with many new features of 11g. I have exposure on Active Data Guard and worked with new features of ASM. For database monitoring and day to day maintenance, I have used OEM, DB Console, Grid control and scripting.
• Databases upgrades onto 11g R2 and ASM onto 12C grid homes.
• Performance Monitoring using Oracle EM Console Cloud and scripts for database.
• Migration Monitoring and documenting the Dry Runs.
• Overall 7+ years of experience as Oracle DBA on 9i, 10g, 11gR2 and 12c database servers and agents with RAC, ASM, Data Guard, Grid Control, Oracle Streams - Data Integration and Replication experience along with the independent handling of short projects as a primary DBA.
• Oracle Backup and Recovery (Cold backup / Hot backup / RMAN backup).
• Handled individual project for ASM (Automatic Storage Management) migration in every 2 months for Linux servers.
• Primary DBA on Quarterly Patches project based on Linux, HP-UX and AIX operating systems.
• Application on-boarded process handled as a primary DBA, new applications requirement gathering from application team and then updating in a SharePoint.
• Changing INIT parameters to 11g compatibility for upgraded databases on the whole inventory.
• Independently analyzed the old RDBMS homes sitting and need of its removal presented to clients.
• Independently identified the memory issues on a database and given the recommendations about SGA, large and shared pools for performance.
• Primary on given suggestions to backups scheduling team on what time backups of what servers should take place in a 3rd party tool AUTOSYS.
• Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export/Import).
• Maintain Oracle fail over databases (Physical and Logical standby databases- Data Guard)
• Proficient in Oracle RDBMS - including SQL, PL/SQL and all areas of database Administration.
• Experience monitoring Oracle RDBMS availability, database exports, tablespace, and extents reports.
• Automated Storage Management (ASM) for 10g databases and 11g.
• Experience in setting up Grid Control.
• Comfortable with both command-line and GUI interface.
• Installation, up gradation, configuration, administration and maintenance of very large Oracle data bases on most flavors of Unix namely Sun Solaris, AIX, HP-UX, Linux and also on Windows 2000/NT/XP servers.
• Managed different sizes of database ranging from 100GB to 3.5TB.
• Experience in on-call support and 24x7 DBA for production environment.
• Extensive experience on providing solutions to developer/user requests.
• Extensive experience in resolving issues and bugs related to databases.
• Proficient in performance and maintaining large volume of data.
• Migration, upgrade and maintenance of Oracle databases (12c, 11g, and 10g,).
• Excellent command in creating Backups & Recovery procedures and Implementing BACKUP and RECOVERY strategies for hot and cold Backups.
• Hands on experience of database Backup and Recovery using RMAN.
• Strong experience in OEM (Oracle Enterprise Manager), Oracle Data Guard, Autosys, SQL* Net, SQL Loader and SQL*PLUS, STATSPACK, Explain Plan and TOAD.
• Experience in Application tuning using session trace file and TKPROF utility.
• Hardworking, result oriented good interpersonal and communication skills.
• Extensive experience in supporting multiple production databases running 24 x 7 mission-critical / OLTP applications demanding high availability and increased performance
• Created and managed remote server for Materialize Views
• Team Lead coordinator between technical operations team (DBA) and applications users/information systems/processing specialists.
• Timely monitoring of key tables to collect statistics on row-chaining/migration and implement methods to avoid redundancy thus eliminating performance bottle-necks.

PROFESSIONAL EXPERIENCE

Confidential, Orlando FL

Senior Oracle DBA

Responsibilities:

• Lead the project and finished the migration of entire data warehouse from 10g to 11g.
• Migrated and Upgraded databases from 10g,11g to 12c non-pluggable.
• Migration of 10g database to Oracle virtual machines.
• Database upgrade to 11g R2 on OVM servers.
• Performed Dry runs on multiple databases, ranging from 1 to 3.4 TB each.
• RMAN Backup and Restore using Catalog option.
• Duplication of databases on OVM servers from Active databases.
• ASM Disk management and configuration.
• ASM DISKGROUP creation from provisioned LUNS.
• Server cleanup, file cleanup and disk cleanup after dry run.
• Supported more than 200 servers during Disaster recovery with team.
• Standalone ASM servers managed.
• Patches applied to Grid home and 11G homes.
• Latest PSU applied to Database for 11.2.0.4.8 and Jan 2016 version
• Monitoring the Migration of database, command line and EM Console.
• Stats Gathered with the oldest partitioned tables from 1999.
• Network throughput monitoring while backup and restore using EM-CONSOLE and netlogs -d with 5 seconds of interval.
• DROP databases and Cleanup server and ASM DISKGROUPS.
• CRONJOB scheduling for DAILY FULL and HOURLY ARCHIVES every day.
• Conversion of SMALLFILE TABLESPACE to BIGFILE using EXP/IMP UTILITY.
• Stats gathered through 12C OEM for multiple Schemas.
• Created DBLINKS and PUBLIC Database links for repository schemas.
• Supported server and kernel upgrades.
• Server reboot activities and CRS resources stop and open work done.
• Relink oracle 11g homes.
• Updated the OPatch version for GRID and 12C home 12.1.0.1.
• Applied Home and Database level patch for c.
• Database patch applied to standalone databases 12c, using datapatch verbose.
• User accounts created with service requests and grant them SUID grants.
• Server Cleanup i-e Drop database, remove contents.
• Drop Disk groups, unlink and remove RDBMS and Grid Homes.
• Remove and Add 12c Agents for OEM Monitoring.

Confidential -Wilmington, DE

Oracle DBA/Application Tech Lead

Responsibilities:

• Application Support from front and back end
• PL/SQL development work on client requests
• Backup weekly jobs and prepared documents
• Performed Maintenance on Oracle Servers
• Coordination of SAP and Unix team
• Primary on Multiple applications and take 24/7 user requests on application issues
• Worked closely with offshore team and attended meetings
• Quarterly PSU applied.
• Grid patching and Opatches.
• Primarily handled the Adding/removing ASM LUNS and worked on VNX and VMAX storage disks.

Confidential - Milford, OH

Oracle DBA

Responsibilities:

• Supported more than 1500 databases for more than 289 production servers for 24/7 support.
• Upgraded 10g to 11g, 11g to 12c and applied latest PSU every quarter.
• Installed and configured new Quarterly ORACLE HOMES for the 10g and 11g versioned servers.
• Primary DBA for all databases in DEV/TEST/PRODUCTION on 11g and 12c (Agents and Databases monitoring).
• Handled individual project for ASM (Automatic Storage Management) migration in every 2 months for Linux servers.
• Handled as a Primary DBA on Quarterly Patches as a shift lead for Linux, HP-UX and AIX operating systems, assigning making schedules and delivering the results to end client.
• Application on-boarded process handled as a primary DBA, new applications requirement gathering from application team and then updating in a SharePoint.
• Supported the upgrade of RHEL and Hard work are diagnostics on various servers.
• Worked in all shifts and 5 days SNAP (production maintenance) at the maximum handovers.
• Documented all the incidents and presented in a form of report.
• Conducting meeting as a host on various occasions, preparing RCA (root cause analysis) as shift coordinator for several months.
• Supported the agent patching for 12c server transformations.
• Regular work on 12c OEM for Monitoring the system databases and applications for availability and maintenance.
• Conducting shift weekly team meetings and involved in giving sessions on topics to the new folks, trained new team members in the team including 12c upgrade and monitoring support in OEM cloud control.
• Experience in ITIL with Incident tracker maintenance and SLA agreement following.
• Making sure the backups and file system usage is up to date.
• ASM is enabled and auto rebalancing is on.
• Supported the quarterly reboots for multiple servers and involved in Data guard home relinking as well as RAC Relinking.
• Prepared the document for applying quarterly UNIX patch over several databases.
• Tablespace management including, adding/resize data files, allocated quotas to user and managed disk space
• Help developers writing database triggers, packages, procedures, functions, utilities for application development.
• Export and Import of User, Tables and Database using exp/imp and Data Pump.
• Installed GRID Patch for 11.2.0.4 and moved ASM to newer homes.
• Installed the fresh homes for 11.2.0.4 on Linux servers.
• Supported SAN Migration and ASM migration, allotted new candidate disks.

Confidential - Nashville, TN

Oracle DBA

Responsibilities:

• Supported more than 30 databases including development/production sizes up to 2 TB for 24/7.
• Designed, Installed and configured the Oracle server software and related products. Upgraded databases from 9i to 10g, 10g to 11g and 11gR2.
• Scheduled meetings with application team for database migration review to gather legacy information such as type of application, database options, current oracle configuration, capacity and oracle outstanding tasks.
• Developed, revised and implemented policies, standards, procedures and guidelines necessary to effectively administer the database environments.
• Ensure databases adhere to corporate standards and policies. Worked with application team, developers, change management team and DBA team to ensure smooth life cycle progress from development through testing and production implementation.
• Monitoring and maintaining 2/3 node RAC database on Red Hat Linux. Providing support to the development team and handling release schedules.
• Maintaining sound backup and recovery policies and procedures using RMAN. Monitoring the scheduled backup procedures for daily basis using crontab.
• Database refreshes using export /import and datapump. Used RDA, ADDM and AWR reports to monitor the database performance.
• Used power designer, E/R Studio for data modeling and to estimate the database size, database design reviews.
• Developed and maintained PL/SQL Stored Procedures, Packages, Functions and Database Triggers. Developed and maintained shell/Perl scripts for setting up batch jobs and managing release scripts.
• Implemented SQL outline to get the better execution plan for the offending queries. Setting up analyzing scripts and coordinated with development team to gather table statistics.
• Perform Database Tuning & Performance, Storage Management, Plan growth and changes (capacity planning), Database Monitoring, Security Management and Tuning SQL queries.
• Day to Day General Administration Tablespace Management, Undo Management, Managing Users, Resources, Managing User Privileges and Roles.
• Diagnosed Oracle bugs and coordinating with Oracle support through metalink to resolve them in timely manner.
• Performed various tasks like Administering RAC using SRVCTL, adding nodes and instances, Administering Storage Components, Parameter Management, and Configuring High Availability Features for RAC.
• Primary DBA for 1GB - 2.5TB database for 24/7 support.
• Upgrade Data Warehouse Database from 8K block size to 32K block size to optimize performance.
• Worked on OLTP and Data warehouse farms.
• Refreshed multiple databases for Development and Testing upon short request.
• Served as part of a 7-member DBA team which was involved in the maintenance of the Oracle 9i/10g database for the Production as well as the development environments.
• Actively involved in designing/Testing of Disaster Crash recovery.
• Improving the performance of the database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and SQL Tuning Advisor in Oracle 10g.
• Performance Monitoring and Tuning of Oracle Application Servers using Statspack, TKPROF, and OEM for tuning on 9i and on 10g using SQL access manager, SQL tuning manager.
• Performed database cloning/exp/imp to setup identical databases in the production and development environments.
• Created and maintain users, roles and privileges.
• Used Microsoft Visual studio 2008 for creating projects and forms.
• Involved in discussions with the management regarding the advantages/disadvantages and upgrade plans.
• Perform Backup and Recovery thru RMAN.
• Strong exposure in Installing / configuring / maintaining RAC, Dataguard, Physical / Logical Standby environments.
• Applied Quarterly CPU (CRITICAL PATCH UPDATES) on the entire database farm.
• Performed Export/Import through Data Pump.
• Build Grid control for Monitoring 40+ database.
• Provided technical troubleshooting and give consultation to development teams.
• Performed Database Refreshes and Database Copies for Development, Test and Production databases.
• Implemented basic replication through Materialized Views.
• Involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering statistics.
• Initiated cronjobs to review alert logs and dump files to check for any ORA- errors.
• Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
• Performed Database Administration using TOAD, Oracle Enterprise Manager and SQL scripts.
• Installed, migrated, configured and tested Oracle 11g databases in various environments.
• Extremely dedicated, self - motivated, Pro-Active and willing to assume responsibility.
• Updating/Altering Data in SQL Server 2008.
• Handled multiple databases on SQL Server 2008 and 2012.
• Used Microsoft Visual studio 2008 for creating projects and forms.
• Handled SQL server business intelligence studio 2008 and 2012 for connecting SQL server and creating reports/ dataset to form table and running reports.

Confidential - Chicago, IL

Oracle DBA

Responsibilities:

• Configured and Managed ASM disks and disk groups thru both Grid Control and ASMCMD utility.
• Configure ASM for Oracle 10G R1 installation with RAW devices which include clustered file system for RAC.
• Conducting Installations of Oracle9i and Oracle 10g, Oracle 11g, sizing/capacity planning efforts for the Oracle database applications on varied platforms like Solaris, Windows and Linux Servers
• Data modeling / Logical database design and implementation (including index design)
• Migration of system and applications from Oracle 9i to 10g, 10g to 11g using Database
• Configuring and using the Oracle Enterprise Manager in 10g for Performance, Maintenance and Administration tasks
• Create and maintain multiple databases.
• Create multiple 11g databases on RHEL5 in development.
• Schedule backup in 11g using db console.
• Improving the performance of the database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and SQL Tuning Advisor in Oracle 10g
• Using TCP/IP Protocol Configured SQL*Net files on server / client machines, and resolved client connectivity issues.
• Constant monitoring of database space and space management
• Setting up Oracle Standby Data Guard.
• Setting up of Oracle and Application user accounts and passwords, monitoring application security
• Responsible to improve the performance by Using the Hints, Indexes, Explain Plan
• Performance tuning of SQL statements using STATSPACK, TKPROF, Explain Plan and SQL Trace
• Devised an efficient backup and recovery strategy and implemented it in line with Business requirements (SQL Backtrack and RMAN)
• Automating the backup processes using shell scripts. Performing recovery in cases of system crashes.
• Worked with RAC implementation team. Added nodes.
• Help developers writing database triggers, packages, procedures, functions, utilities for application development.
• Export and Import of User, Tables and Database using exp/imp and Data Pump.