SUMMARY:

• An accomplished Database administrator with 8+ Years extensive experience in Information Technology. Intensively worked on various platforms. Core areas of skills are Oracle 9i, 10g, 11g &12c, Oracle RAC and Data guard, ASM, Golden Gate on UNIX, Linux and IBM AIX using various leading technologies.
• Proficient in Database Administration activities such as installation, Database Creation, Sizing, Backup and Recovery, Performance tuning and Capacity Planning.
• Experience in handling large sized databases, handled up to 15TB size databases for SAP/SEIBEL applications.
• Excellent experience as an Oracle DBA in various platforms such as HP - UX, AIX, Red Hat Linux, Windows.
• Plan, install, configure and perform upgrades of Oracle software on various platforms.
• Used Data Pump (expdp, impdp) to take backup at database level or table space level and also to accomplish table level and full database de-fragmentation.
• Expertise in setting up Oracle 12c Cloud Control Enterprise manager and handling end to end management of OEM 12c suite.
• Experience in setting up standby database using Data guard, configuration, maintenance, and administration for disaster recovery. Handled 10+ projects for DR Recovery Exercise and setting up DR sites.
• Expertise in Golden Gate Installation, configuration and end to end management/troubleshooting and tuning of Golden Gate replication technologies.
• Automated many common tasks using Crontab including Backups, exports and imports, archiving old records and verification of such processes.
• Experience in Upgrade and Migration of Oracle database to higher version installing patches and other platforms without/with using Oracle Data Upgrade Assistant (DBUA).
• Migrated number of databases from Non-ASM to ASM.
• Installation, Administration and Maintenance of SQL Server Instances.
• Expert experience in Hot and Cold Backup and Recovery, cloning of databases using RMAN, Commvault.
• Proactive monitoring, identifying areas that need to be improved in the application and database using AWR, ADDM and OEM Grid Control.
• Created and maintained Users and Roles with appropriate Privileges and Profiles.
• Hand on Experience in Oracle Enterprise Manager Grid Control.
• Backup of RAC Database using RMAN.
• Hands on Exp in Managing Cluster ware components using SRVCTL and CRSCTL utilities.
• Having good knowledge on Mongo DB.
• Responsible for managing the DBA team (15+) to work effectively in a business-critical production environment and in 7x 24 supports. Good history of bringing the DBA team and IT team to enhance the productivity.
• Attending incident bridges for any production issues and working with app team to solve the issues at earliest. Made sure that client SLA is maintained for all level severity issues.
• Directed the team to implement proactive database monitoring, and automation of database maintenance, diagnostic reports, databases reports ®ular database operation tasks.
• Kept the databases on track with regular DBA activities like database upgrades, applying patches, data model changes, new database server setup, backup/recovery, and security administration.
• Good co-ordination and communication with system administrators, business data analyst and development teams.
• Very good team player and also has the ability to work independently when needed and a quick learner of new technologies.
• Excellent written and verbal communication skills.

TECHNICAL SKILLS:

OPERATING SYSTEM: HP-UX, IBM AIX, Red Hat Enterprise Linux 3/4/5

RDBMS: Oracle 10g/11g/12c, SQL Server 2008/2012/2014

Tools: Recovery Manager (RMAN), Commvault, VERITAS Net backup, Exp/Imp, Data pump, dbforge, Delphix, foglight, SCOM,SQL*Loader, TKPROF, Dbverify, Putty, TOAD, Remedy8.1,Support Now Portal

Monitoring Tools: OEM, 12c Cloud Control, Scripts based Monitoring, Golden Gate Director

Replication: Data Guard, Golden Gate

PROFESSIONAL EXPERIENCE:

Confidential -Piscataway, NJ

Senior Database Administrator

Responsibilities:

• Implemented Automation of PSU Patching through OEM12c.
• Upgrading production and development databases from 11g to Oracle 12c.
• Configuring the databases in OEM12c cloud control and configuring the alerts by installing the agents on clients.
• Implemented Golden gate replication methods between multiple databases. Implemented Golden Gate Director for monitoring Oracle Golden Gate.
• Creating ASM Disk & Disk groups and Maintaining Oracle ASM instance.
• Converted single instance to RAC.
• Installation of Oracle Components like JVM, Oracle TEXT,XML DB on existing Oracle Database.
• Deployment of Plug-in's at the database level through OEM12c.
• Oracle Database backup's configured through Commvault.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Installation, configuration and maintenance of MS SQL Server 2008R2, 2012 and 2014.
• Developed scripts for Offline Database Report, Disk Space alert report.
• Applying the latest Service packs as per standards and if needed applying the hot fixes.
• Cloned the SQL Server instances from production to Development.
• Responsible for database backups and restoration, backup strategies and scheduling backups.
• Provided the requested reports to the SOX (Sarbanes-Oxley) Team.
• Creating the users at the database and server levels and assigning the appropriate permissions as per the request
• Refresh the database among different environments.
• Involved in troubleshooting and documenting database problems and resolutions.
• Responsible for handling around 180+ database servers.
• Directed a team of DBAs on activities like database upgrades, applying patches, data model changes, and security administration.

Environment: Oracle 12c/11g RAC, HP-UX and RHEL, AIX, Unix, Data Guard, RMAN, PL/SQL,OEM 12c,Commvault,Golden Gate, SCOM, SQL SERVER 2008R2,2012/2014

Confidential - St.Louis, MO

Database Administrator

Responsibilities:

• Managed appropriate use of free space within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
• Monitored the production Oracle alert logs for database errors.
• Upgraded 10.2.0.4 Two Node RAC ASM Database to 11g R2 Two Node RAC ASM
• Advanced Backup and Recovery using Oracle’s RMAN software; used offline/online for recovery in a production environment via Korn shell scripting.
• Mentor other DBAs in effective use of RMAN software, and my scripts.
• Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.
• We have converted Single Node Non-ASM Database to 2 Node RAC ASM Database. We achieved this using Data Guard.
• Supporting Data Warehouse Database i.e. over 13 TB in size.
• Currently helping client to use existing infrastructure to achieve Maximum benefit to reduce cost and maximum performance.
• Actively working with client for Server Consolidation & Database Consolidation.
• Changes were made dynamically whenever possible to fulfill high-availability requirements.
• Enforced need of regular data purging processes from production, design and development, to deployment.
• Implemented and maintained Oracle 10g Data Guard/standby databases for fail-over purposes.
• Propagation from primary to standby via automated scripts, and sometimes uses standby databases to immediately restore primary database.
• Experience with ‘graceful’ switchover and switchback between primary and standby databases.
• Replicated to a disaster recovery site for increased server manageability and availability.
• Participated in development of enterprise-wide security standard methodology, and ongoing deployment.
• Installation of RAC and Managing RAC Environment efficiently.
• Create and maintain materialized views.
• Implementing and maintaining database security (create and maintain users, roles and assign privileges)
• Monitored system resource availability and responded to system memory and data issues.
• Expert with OEM Grid Control.

Confidential - Atlanta, GA

Database Administrator

Responsibilities:

• Lead a team of 12 DBAs on Oracle 9i/10g/11g Upgrades, applying patches, and coordinated with the development team for implementing data model changes. Also, hands on experience with 11g upgrades.
• Responsible for reviewing the physical database design and provide the suggestions/modifications on physical design of the database for performance.
• Installed configured and maintained multiple Oracle10g RAC databases and Data Guard instances to increase high availability, scalability and disaster recovery. Also, implemented Golden gate replication methods.
• Involved and worked directly in migrating multiple Oracle Databases from Sun Solaris/HP-UX to AIX based system.
• Database SQL Tuning using SQL Profile/Outlines, ASH and AWR reports.
• Worked very closely in implementing Oracle OEM Grid control and mentoring all the database through the grid. Also, analyzed AWR reports daily and resolved the issues, if any.
• Worked with DBA team to perform database performance analysis, capacity planning, system sizing and ongoing maintenance/tuning to ensure maximum performance.
• Helped the DBA team to implement, tested and maintain backup and recovery procedures using RMAN
• Involved in troubleshooting and documenting database problems and resolutions.
• Instrumental in creating the backup/recovery and Disaster recovery strategies and helped the DBA team to follow them.
• Managed and worked with the DBA team to adhere the standard operating procedures, database standards best practices and published them in SharePoint location, which in turn produced consistent results.
• Keep updating the knowledge in latest technologies of Database Servers, Database features and provided the right direction for better cost effective solutions.
• Tracked the team on regular DBA activities like database upgrades, applying patches, data model changes, new database server setup, backup/recovery, 7 x 24 support, on-call rotation and security administration.
• Hands on experience in Oracle RAC, Data Guard, RMAN backup/Recovery, Grid Control, SQL tuning, PL/SQL, and Shell scripts.
• Responsible for the DBA team to get Sarbanes-Oxley (SOX) and PCI compliance, and for satisfying SLAs.

Environment: HP DL360/380 Linux Servers SUN SPARC/6500/V880, Oracle 8i/9i/10gR2 RAC, Oracle Grid Control, Data Guard, SQL*Loader, SQL, Veritas File systems, RMAN, Toad, Oracle TDE, DOM

Database Administrator

Responsibilities:

• Strong experience in installation and configuration of Oracle 9i/10g.
• Maintain and monitor the physical layout of Disk storage, table spaces, data files, and object extents.
• Monitor and analyze Oracle trace files and alert log for Oracle errors.
• Implementing the incremental, cumulative incremental and full RMAN backup for each database to have space management and effective recovery.
• Generation of AWR, ASH reports as per the customer Request.
• Granting the required privileges to the user.
• Configuration of table space and Archive utilization scripts through Crontab.
• Modifying Oracle parameter (init.ora) for Oracle performance and growth.
• Applied latest releases of the RDBMS patches from Oracle to the Production and test instances to resolve few technical challenges & issues.
• Proactive monitoring, Performance Tuning of Databases.
• Taking export backup of tables for future database recovery.
• Preparing daily health monitoring report
• Managing Databases, Table space / Data File management
• Root Cause analysis for Database failures and Oracle Internal Errors caused
• Automating DBA Tasks to simply management using Shell Scripts
• Schema backup and restoration on production and UAT environment using data pump
• Participation in regular team meetings including customer calls.
• Preparing documentation for the DBA activities.

Environment: Oracle 11g/10g/9i, RHEL, AIX, Unix, RMAN, Export/Import, OEM Grid Control, PUTTY.

Confidential -Santa Clara, CA

Database Administrator

Responsibilities:

• Managed appropriate use of freespace within tablespaces, reclaimed space whenever possible.
• Reorganized tables and indexes within databases when needed.
• Developing methods to install and create databases as per user request.
• Prepared the checklist for Patching, Migration& Upgrading of databases.
• Supported as a Development/Production DBA to 500 plus database on different servers including databases of TB in sizes.
• Monitoring the database growth on daily basis, Addition of table spaces, data files.
• Creation/Drop of Redo log files.
• Generating and analyzing AWR and ASH reports.
• Implementing and maintaining database security (create and maintain users, roles and assign privileges)
• Monitored the production Oracle alert logs for database errors and system resource availability and responded to system memory and data issues.
• Database Tuning using AWR SQL Reports, ASH Reports, ADDM, and Cloud Control
• Create/Drop tablespaces and user roles on Adhoc basis.
• Cloning/duplicate of database with RMAN (Recovery Manager) and user managed backups like hot or cold backups.
• Maintaining nightly backup, finding root of cause for failed jobs.
• Involved in Production, Development and Test support
• Hands on Experience in installing and configuring Oracle 10g, 11g RAC on Linux.
• Worked on Data Guard with Physical Standby configuration with hot backup and testing it for failover and switch over in different modes.
• Efficient in managing database server from command line, OEM (Oracle Enterprise Manager) Grid Control.

Environment: Oracle 11g/10g/9i, RAC,SOLARIS, HP-UX and RHEL, AIX, Unix Data Guard, RMAN, OEM Grid Control, PUTTY,OEM.

Confidential

Database Administrator

Responsibilities:

• Installation and implementation of the Oracle 9i,10g on different platforms.
• Manage the database for over 75G size.
• Created users, tablespace, roles and assign the privileges to them.
• Monitored the production Oracle alert logs for database errors and system resource availability and responded to system memory and data issues.
• Upgradation from Oracle 9i to Oracle 10g.
• Implement the automated Hot Backup scripts for the Daily full backup created in Korn Shell.
• Backup of Databases using Logical (Export & Import) & Physical (Online & Offline).
• Changes were made dynamically whenever possible to fulfill high-availability requirements.
• Documenting day-to-day activities, Changes and Development.
• Replicated to a disaster recovery site for increased server manageability and availability.
• Implementing and maintaining database security (create and maintain users, roles and assign privileges)
• Managed appropriate use of freespace within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.

Environment: Oracle 11g/10g/9i, RHEL, AIX, Unix, RMAN, Export/Import, OEM Grid Control, PUTTY.

Confidential

Database Administrator

Responsibilities:

• Installation of Oracle 10g software on LINUX Servers.
• Upgraded the Database from 10.2.0.1 to 10.2.0.4
• Applied CPU patches using Opatch for Every quarter.
• Cloning of production database to testing.
• Implemented Backup strategies (Hot & Cold backup).
• Implemented the concept of Data pump
• Interaction with client/users on various issues.
• Troubleshooting server configuration files such as tnsnames.ora and listener.ora.
• Resolving user issues like long running sessions and locks.
• Taking care of all other daily routine DBA tasks like creating users, roles, table spaces,addressing alerts triggered from monitoring tools etc.

Environment: Oracle 11g/10g/9i, RHEL, AIX, Unix, RMAN, Export/Import, OEM Grid Control, PUTTY.