PROFESSIONAL SUMMARY:

• Having hands on experience over 11 Years in IT industry as Oracle,OEM, Confidential, MongDB and MS SQL Database administrator, having exclusive experience in database administration, production support, installation, configuration, upgrades, migrations, patches, performance tuning, backup and recovery, cloning, space management, database security, auditing, troubleshooting, database design, TAR support, Unix shell scripting and documentation on Oracle Software 8i/9i/10g/10gRAC/11g/11gRAC/12C on Sun Solaris, Red Hat Linux, HP - UX, AIX, and Windows Platform.
• Installing/maintaining/upgrading MS SQL Server instances/databases of SQL Server 2008R2, 2012, 2014 and 2016 stand-alone/cluster servers.
• Maintain and troubleshoot multiple types of high availability/DR techniques such as clustering, database mirroring, Log shipping, hot standby servers, etc., fail over and DR testing in MS SQL database.
• Experience in Managing Security of MS SQL Server by creating Database Users, Roles and assigning proper permissions according to business requirements.
• Extensively worked with DB2 Explain, Runstats , REORG and other ONLINE and Offline utilities .
• Extensively worked with DB2 Z/OS 6.x/7.x/ 8.x/9.x on Z/OS system on mainframes.
• Experienced in (24 x 7) Production Support
• Build new MS SQL database instances and databases by following standard build process
• Maintain MS SQL database backups - full backups and transaction backups for database recovery
• A strategic planner with competency in conceptualising efficient Database strategy and executing the same with a view to achieve highest availability and performance.
• Experienced in Oracle 11g databases on various flavours
• Experienced in Oracle (Grid Infrastructure / Cluster Ready Services) on RAC
• Experienced in Oracle Grid Home 11gR2, Oracle Confidential, Oracle Data guard with RAC Setup
• Experience in Database Upgradations of Production environments (8i to 9i/10g & 10g to 11g) with RAC and DATA GUARD Setup.
• Experienced in UNIX Servers.
• Experienced in Red Hat Enterprise Linux5.8 and 6.2 servers
• Upgraded 10gR2 RAC to 11gR2 RAC
• Experienced in OCR and Voting Disk Movement to new Storage.
• Having 12C Architecture/New Feature knowledge
• Having exposure/knowledge on Oracle Exadata X2-2 server .
• Experience in OLTP database systems, managing large Oracle databases.
• Performed database tuning (SGA & I/O) on various production Databases
• Oracle Database Administration experience in variety of different environments like Unix (HP-UX, Sun Solaris, AIX, Red Hat Linux) and Windows (2000/2003/2005 Server)
• Hands on experience with Installation, Configuration, Upgrades, Migrations, Administration, Oracle Data Guard, Backup and Recovery using RMAN, Disaster Recovery and Patching of Oracle Databases.
• Planned and implemented DR & high availability solutions using Oracle 10g/11g Data Guard, Configured and maintained Standby Database in OLTP environment to automatically synchronize with production database.
• Excellent knowledge in logical backups, Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Experience in complete recovery, incomplete recovery, recovering data files, table spaces, control files, block corruption.
• Experience in monitoring of database space requirements and adjust for future needs.
• Creation of database in versions 8i/9i/10g/11g/12C on all flavours of UNIX ( Red Hat Linux, Solaris, Hp-Unix) and Windows (2000 /2003.. etc)
• Working with business to define requirements and build the data architecture to support the business, establish development standards, and recommend best practices in all areas of data i.e. data modelling using TOAD, SQL Developer.
• Experienced managing multiple Production and Development Oracle environments of different releases.
• Experienced with cloning of Oracle Databases from Production to Test, Dev
• Experienced on all the Oracle DBA related functions - Monitoring, Cloning, Patching, performance tuning, troubleshooting DB issues in a 24x7 environment.
• Experienced in database patches with Opatch utilities.
• Good knowledge and experience of the Oracle 10g, 11g, OEM,12c OEM (CLOUD), ASM, and Grid Control
• Performed database Performance Tuning and Network Trouble Shooting using TNS configuration; Designed and Created primary structures such as tablespaces, tables, views and indexes; Created Database Links and Synonyms
• Database Performance Tuning using SqlTrace, TKPROF, Explain plan, Statspack, AWR, and ADDM.
• Assisting Development team to tune the queries and creating Materialized Views, Snapshots.
• Experienced in using 10g features Data Pump, Flash-Back Recovery, Grid monitoring, and Recycle bin.
• Experience using OEM (Oracle Enterprise Manager), TOAD, Data Migrations using export/import
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Performed all daily Maintenance tasks, interacting with Oracle Customer service (Metalink Support) as and when required.
• Monitored the database growth on daily basis, Modification of databases, Addition of tablespaces, datafiles and Modification of tablespaces, datafiles. Modification and addition of primary storage objects.
• Database start-up and shutdown, alter database parameters, tablespace management, space monitoring and analyses, alter and move data files, table reorganization, index rebuild, export and import, manage database statistics, manage flashback database.
• Implementation and maintenance of Confidential Replication Technology.
• Configuration and troubleshooting of Bi-Directional Confidential Replication for homogeneous setup using GGSCI.
• Experience in Oracle Confidential Upgradation 10g to 11g/11gR2 and 12C.
• Writing scripts for the system and database for the effective functionality and report generation.
• Scripts for Start-up and Shutdown, Health Check of Databases, Analysing of Tables, Cold Backups.
• Knowledge on Oracle Support processes for technical requests with Metalink.
• Good Skills in SQL, PL/SQL, Shell Scripting, Partitioning, Logical and Physical Design, Backup and Recovery Procedures.
• Use dynamic performance views (data dictionary views) for the daily activities of the databases. Monitor the alert logs for Oracle internal errors
• Maintain the security and access to the database by granting and revoking roles to and from users. Individually performed full database off-line backup weekly.
• Good understanding of ITIL framework mainly Change, Problem, Release, Incident, Security Management.
• Expert in supervising the team members and communicate effectively by maintaining healthy relationships with them.
• Got the best performer award for my prompt response and the way I handled various responsibilities.

TECHNICAL SKILLS:

Operating Systems: Unix (Solaris, IBM-AIX, HP-UX), Linux, Windows NT/2000/XP

Web Technology: Shell Scripting

Databases: Oracle8i/9i/10g/11g/ RAC/12C, MS SQL 2008,2012,2014 and 2016

Programming Languages: Basic Concepts of C++

Database language: SQL, PL/SQL

Tools: Dataguard, Dataguard-Broker, SSMS (Sql Server management Studio) RMAN, Datapump, Grid-control, AWR SQLPLUS, TOAD, sqlloader, TKPROF, SQLTRACE, RDA, DBCA, DBUA, Export/Import, Oracle Confidential

WORK EXPERIENCE:

Senior Oracle Database Administrator

Confidential, Dallas, Texas

Environment: Oracle 11g, 12c on UNIX (Red Hat Linux, Solaris & Aix) environments

• Installation of RAC Cluster on Multiple nodes and Managing RAC Environment efficiently.
• Scheduling and performing all clones from different Divisions.
• Installation, Upgradation, Configuration and Troubleshooting Confidential 12c software.
• Installed and configured Confidential JAgent to work with OEM Confidential Plugin.
• Configured Confidential Downstream Mining and Integrated components for Active-Passive and Active-Active replication.
• Configuring Oracle data guard Standby databases on Multiple Nodes Across Different Data Centres.
• Apply the latest patches on Oracle databases on Single and multiple Rac nodes.
• Install, configure Confidential for Capturing live data Across multiple databases.
• Provide on-call support 24/7 on rotation.
• We have converted Single Node Non-ASM Database to Multiple Node RAC ASM Databases.
• Migrated Large databases over 40+ Terabytes of Databases from Aix to Linux Environments.
• Refresh Non-Prod environments and oracle applications on regular basis to support development team.
• Configuring Multiple Heterogeneous ODBC setups and Creating listeners to pull data from Multiple Database Sources (Netezza, Seibel, Microsoft, MemSQL etc.) to Oracle databases.
• Facilitate and Support Development teams with Performance Issues.
• Setup database servers for new applications and whenever we migrate/upgrade our servers
• Co-ordinating with Oracle support for any Production issues which affects business.
• Upgraded Multiple databases from 10g and 11g and 12c versions with Minimal Downtime.
• Provisioned EC2 instances in the AWS cloud, Patching EC2 servers and databases in AWS cloud
• Allocate S3 buckets and create databases on AWS cloud
• Create roles, groups, multi user authentication with (IAM) AWS services
• Cloning oracle Database/Applications (11.5.10.2 and 12.1.3) through Rapid clone methods.
• Cloning Database/Applications through Rapid clone methods.
• Applying Application patches using Auto patch utility ad patch and ringmaster tool. Performing RDBMS patches using Opatch. Trouble shooting Workers related issues while applying patches.
• Resolved Concurrent requests & Concurrent Managers issues.
• Deploy the .ear files in WebLogic server and managing WebLogic components.
• Apply the latest PSU patches to the RDBMS Oracle Home.
• Configuration of workflow setup for EBS R12 and resolving the issues.
• Used Ad admin to generate jar files, forms and compiling the invalid objects and validating Apps Schema and relinking executables and also, performed generate and compile forms manually.
• Installed and Configured OEM 12c Console for Monitoring and configured around 500 databases agents on multiple platforms (Aix,Linux,Solaris and Windows Servers).

Senior Oracle Database Administrator

Confidential, Auburn Hills, Michigan

Environment: Oracle 11g, 12c on UNIX (Red Hat Linux & Aix) environments

• My responsibility includes database testing as well as handling the Oracle databases, handling Database maintenance and Oracle / MS SQL DBA tasks etc.
• Configured 11g RAC on 5 node Cluster.
• Worked as a Build DBA where we have task like Installation, Configuration, Upgrades, Migrations, Administration of Oracle Databases.
• Installing/maintaining/upgrading MS SQL Server instances/databases of SQL Server 2008R2, 2012, 2014 and 2016 stand-alone/cluster servers.
• Tested Database upgradations from 5 Node 11.2.0.2 RAC to 11.2.0.4 with 5 Node RAC (DR)Data Guard
• Hands on experience on Cloning of MS SQL Database.
• Maintain MS SQL database backups - full backups and transaction backups for database recovery
• Experience in Managing Security of SQL Server by creating Database Users, Roles and assigning proper permissions according to business requirements.
• Provided 24/7 Support on Oracle production instances for their esteemed clients.
• Cloning and Refreshing Oracle Database Instances.
• Applied Oracle Database Patching and Patch set updates (PSU).
• Supported RAC instances using SRVCTL and CRSCTL utility.
• Worked on configurations of Voting Disk, OCR and ASM.
• Created New Disk group and Disks added in ASM using ASMCA.
• Taking periodic backup of the databases on 11g and full environments using extensive shell scripts.
• Implemented Backup & Recovery procedures.
• Solid experience in Oracle Recovery Manager (RMAN), and standby database using Data Guard, DG Broker.
• Implemented Hot, Cold and Logical backup plans, Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Worked on all various features of Oracle like Import/Export, Oracle OEM, Impdp/Expdp, ADDM and AWR.
• Performance tuning for optimized results using tools like Explain Plan, SQL*Trace and TKPROF, Statspack.
• Performed regular database cloning and refreshes to setup test and development database
• Installed 12c Confidential .
• Configured Bi-Directional Confidential for replication.
• Performed Confidential Process stop and start.
• Used various tools for monitoring and general database management like SQL Developer, TOAD, OEM
• Experienced in maintaining high availability of databases for global operation using Oracle RAC and Data Guard/ Standby databases.
• Upgraded Confidential 11g to 12c.
• Continuous Performance monitoring and tuning of the databases and application using OEM Tuning Pack Diagnostics Pack, STATSPACK, etc.
• Installation and configuration of Oracle Client software and Tools.
• Handling general Database maintenance, looking for tablespace level checks, memory issues etc.
• Using data dictionary views for the daily activities of the databases. Monitor the alert logs for Oracle internal errors
• Maintain the security and access to the database by granting and revoking roles to and from users.

Consultant - Oracle Database Administrator

Confidential

Environment: Oracle9i/10g/11g RAC on UNIX (AIX/Sun Solaris) and Windows

• Administration of 50 Production Databases ranging from 200GB - 4 TB in size with RAC and DR setups
• Primary DBA for the Capgemini one of the MOST CRITICAL ZERO downtime database which is the base for BMC-Remedy Ticket tools
• Performed various activities, such as database recovery, performance monitoring and tuning, structured query language, operating systems and relevant tools.
• Implementation of Database Security as per the Company Global policies.
• Regular Maintenance activities like Loading, unloading of data, repairing of databases, Purging of data, Reorganization of data, Database Refreshes.
• Database upgradations from 10.1.x.x to 10.2.0.4/11.2.0.2.
• Database re-organizations and Capacity planning for critical databases
• RMAN Backup configuration for Full DB, Archive-log
• Restore and Recovery validations of the RMAN backups
• Database Switchover tests using both DGMGR & Manual methods
• To ensure the availability of the database after SAN Migration Projects
• Writing the Technical Articles for the Capgemini Knowledge DB Management
• Monitoring and performing health check through Grid-control
• Optimizing the Performance of the databases
• Worked on multiple projects simultaneously, met project deadlines and worked under pressure. Worked independently with little or no supervision.
• Assisting Application Development Project Lifecycle through migration to Production, as well as SQL optimization and post-implementation strong support.

Engineer - Oracle Database Administrator

Confidential

Environment: Oracle9i/10g RAC on UNIX (AIX/Sun Solaris) and Windows

• Installing and Creating Oracle RAC databases in UNIX and Windows
• Managing Database Performance using (Statspack, TKPROF, AWR, 10046 Event Trace, Hang analyze)
• Automated gathering statistics of segments (using DBMS STATS analyze).
• Creation and Maintenance of Materialized Views.
• Refreshing development databases using RMAN and normal hot/cold Backup.
• Maintaining and administering Oracle 9i and Oracle 10g database.
• Configuring and Scheduling RMAN Backups
• Daily Hot Backup and logical backup for production database.
• Implemented and Administering Oracle Data guard
• Managing the Partition tables and indexes.
• Database Migration from Oracle 9i to 10g.
• Planning for Production Storage
• Critical Patch update for a live database.
• Monitoring the Databases with application support working on Oracle 11i.
• Reorganization of tables and indexes.
• Tuning SQL and PL/SQL procedures to improve performance (Involved in Billing process with Application team and fine-tuned high resource consuming procedures)
• Perform database tuning and performance monitoring includes SGA tuning.
• Designing backup policies and implementing the same.

Engineer - Oracle Database Administrator

Confidential

Environment: Oracle 8i/9i/10g,11g on UNIX (AIX/Sun Solaris) and Windows

• Installing and Creating Oracle 8i/9i/10g/11g databases in UNIX and Windows
• Managing Database Performance using (Statspack, TKPROF, AWR, 10046 Event Trace, Hang analyze)
• Automated gathering statistics of segments (using DBMS STATS analyze).
• Creation and Maintenance of Materialized Views.
• Refreshing development databases using BCV and normal hot/cold Backup.
• Maintaining and administering Oracle 8i, Oracle 9i and Oracle 10g database.
• Configuring and Scheduling RMAN Backups
• Daily Hot Backup and logical backup for production database.
• Implemented and Administering Oracle Data guard
• Managing the Partition tables and indexes.
• Database Migration from Oracle 8i to 10g.
• Planning for Production Storage
• Critical Patch update for a live database.
• Monitoring the Databases with application support working on Oracle 11i.
• Reorganization of tables and indexes.
• Tuning SQL and PL/SQL procedures to improve performance (Involved in Billing process with Application team and fine-tuned high resource consuming procedures)
• Perform database tuning and performance monitoring includes SGA tuning.
• Designing backup policies and implementing the same.