PROFESSIONAL SUMMARY:

• Oracle DBA with 8 years of Exposure on Production, Systems Analysis, Design, Development, Implementation and Testing of Relational Database Management systems for Business solutions.
• Learnt basics and the architecture in Hadoop and the Hadoop eco system
• Responsible for management and support of all Production and Development Databases. Actively participated with the design teams in planning hardware and the software implementation for present and future needs of clients and the company.
• Experience in Application Development, Database development and 24x7 production system support handling large databases using Oracle 12c, 11g, 10g, 9i on various platforms like AIX 7.1., Solaris /RedhatEL 7.0/ /UnixWare / Confidential UNIX and WinNT 2003/2008
• Experienced as an Oracle Senior DBA and proficient in Oracle 9i, 10g, 11g, 12c software installations, database Capacity Planning, Backup Implementation, Tuning Oracle 9i, 10g, 11g on UNIX, Linux platform and VERITAS cluster ware.
• Skills in High Availability technologies like RAC, ASM.
• Experienced in maintaining the Replication of DB through Oracle Golden Gate.
• Experienced in maintaining Oracle Data Guard & Standby Database and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods
• Involved in the Database Cloning.
• Experienced in upgrading databases from 9.2.0.8 to 11.2.0.3 and 10gR2 to 11gR2 and 12c. Faced challenges in resolving issues while upgrade.
• Created Unix shell scripts for startup/shutdown, monitoring, backups and maintenance of database using Unix CRON.
• Skills in Oracle features like Data Guard, experienced in planning and implementing Disaster Recovery Strong interpersonal, time management and organizational skills. Proven team player with strong ability to multitask and Working closely with clients to provide delivery on time.
• Automated startup/shutdown scripts for Database applications.
• Provide technical support and assistance to all database end - users and Creating users, allocation to appropriate tablespace quotas with necessary privileges and roles for all databases
• Skills in Oracle Installations and Upgrades
• Skills in RMAN utility, export-import, Data pump, OS backup for backup and recovery databases.
• Created User and Roles and granted appropriate Roles, Privileges and Profiles
• Maintained 500+ databases in 100+ servers of more than 10TB of DB space.
• Experienced in Incident Management, Change Management, and Problem Management.
• Implementing 4-eye check process in implementing scheduled Changes.
• Has effectively handled all of Customer/end user requests like user creation, refreshes & other L1/L2 tasks by strictly adhering to defined SLAs/SOWs.
• Initiatives and Achievements
• Got appreciations for the performance in DR activities
• Got appreciations for refreshing databases in one of the critical clients.
• Got appreciations for completing switchover process from source to target cluster working with apps team.
• Certified in ITIL V3

TECHNICAL SKILLS:

Programming Languages: PL/SQL, C & Data Structures, Java

Databases: Oracle 12C/11G/10G/9i, Teradata, MS Sql Server 2008

Oracle High Availability: 10G/11G RAC, ASM, Data Guard, Golden Gate

Oracle Tools: GUI,DBCA,DBUA,NETCA,OEM(10G/11G/12C),SCP

Incident Management: Citrix, Confidential OpenView

Oracle Utilities: Data pump, RMAN, export-import, srvctl, cluvfy, crsctl, olsnodes, ADDM, AWR, SQL*Loader, Toad, and tkprof

Operating Systems: Windows, Mac OS, Linux, Sun Solaris, AIX, Confidential UX.

Languages: SQL, PL/SQL, Unix Shell Scripting

Other Tools: SFTP,XMANAGER.

PROFESSIONAL EXPERIENCE:

Confidential, Stamford, CT

Senior Oracle and GoldenGate DBA

Responsibilities:

• Involved in analyzing the AWR, ADDM, and ASH reports to make out the performance issues in the database and making the changes respectively for the continuous improvement.
• Worked on performance tuning in the production environment with keen observation and continuous monitoring for the better future of the databases if any alerts or warnings raises due to customization in applications.
• Auditing and performance of database in different situations
• Involved in installing OSWatcher, Orachk, and TFA for the better performance and monitoring.
• Worked for the RAC databases with scan listener administration and infrastructure.
• Performed the RAC database build with 4 nodes from development servers to production.
• Involved in 12c installation and fixed all the errors came across on linux environment.
• Worked extensively on CRS communication related issues with proper understanding.
• Involved in ASM related issues and performed numerous number of tasks on adding/dropping disks to the diskgroups.
• Raised so many SR’s with oracle on various issues related to CRS and ASM.
• Involved in migration of single instance database to RAC nodes on 11gR2
• Written templates for the upgradation of 11gR2 database to 12c
• Worked extensively on database refresh from one environment ot another using RMAN and Datapump.
• Involved in upgrading 10g database to 11gR2
• Applied required patches from oracle metadata site as per the organization requirement
• Worked on Oracle GoldenGate to implement Change Data Capture(CDC) and replication between the primary and secondary databases.
• Involved in implementation of different high availability solutions using Oracle 11g RAC, Physical and Logical Standby database using Active Data Guard and Oracle GoldenGate.
• Performed GGSCI commands using the utility ggsci to setup, manage, monitor and troubleshoot the different components of the goldengate replication configuration.
• Involved in making the GoldenGate parameter files for Extraction and Replication Setup for GoldenGate Database User with necessary privileges
• Performed RMAN duplicate database refresh multiple times and expertise.

Environment: Oracle GoldenGate, Oracle 12C Clusterware, OEM 12c, Oracle 11gRel2, Oracle 10g Rel2, OEM Grid Control, Oracle data guard, AIX 7.1, 6.1, crsctl, cluvfy, srvctl, oracheck, oswatcher, SQLTXPLAIN, Autosys.

Confidential, Overland Park, KS

Senior Oracle DBA

Responsibilities:

• Performed CORE DBA tasks such as Database Administration on Oracle 10g, 11g environments, performance tuning, Schema creation, maintenance, and troubleshooting.
• Implement physical database changes, testing, and performance tuning.
• Plan and Design Backup/Recovery solutions using shell scripts and Import/Export.
• Experienced in creating users and roles.
• Handled database server tuning, application tuning, maintaining documentation and capacity planning.
• Applied PSU and CPU patches for databases and on the RAC nodes.
• Created Tablespaces and data files and monitored them for any space issues
• Configured LISTENER & TNSNAMES files & Troubleshooting
• Rebuilt the indexes to improve the performance.
• Security Administration including the management of profiles, roles, users and their privileges.
• Monitoring and maintain the database using Oracle Schedulers, and Unix Cronjob scripts for package startup/shutdown and backups.
• Monitored databases using oracle enterprise manager.
• Applied BUG patches which are caused by Ora - 600 and Ora - 7445 and a few other issues.
• Resolving the locks on the database.
• Monitoring performance using AWR reports.
• Used Recovery Manager (RMAN) and Enterprise Manager for various maintenance tasks like backing up of database, restoration and recovery of database.
• Provide technical support and assistance to all database end-users and Creating users, allocation to appropriate tablespace quotas with necessary privileges and roles for all databases
• Communicated with Oracle to get the necessary patches required to fix up the database changes needed using Oracle SR Support and coordinating the patches and implementing the necessary changes.
• Provided 24x7 on-call supports. Worked beyond regular hours based on business demands.
• Used RMAN scripts to take backup of the ASM files and delete the archive logs based on the sysdate.
• Performed switch over and fail over on Standby database.
• Performed RMAN duplicate database refresh multiple times and expertise.
• Performed addition of services using srvctl and modified a few services by concentrating keenly on monitoring.

Environment: Oracle 11g/10g, RMAN, RAC, Redhat Linux, Data Guard, IBM AIX Server Environment

Confidential: Southlake, TX

Oracle DBA

• Involved as an oracle database management professional and support over 400 Oracle database clients running on 9i, 10g, 11g.
• Involved in regular day to day activities for production databases.
• Installation of Oracle databases.
• Applying PSU and CPU patches for databases.
• Creating and managing Table spaces and data files
• Configure LISTENER & TNSNAMES files & Troubleshooting
• Rebuilding the indexes to improve the performance.
• Security Administration including the management of profiles, roles, users and their privileges.
• Monitoring and maintain the database using Oracle Schedulers, and Unix Cronjob scripts for package startup/shutdown and backups.
• Monitored databases using oracle enterprise manager.
• Resolving the tickets by meeting the SLA.
• Refresh the Database using RMAN and exports/imports.
• Applied BUG patches which are caused by Ora - 600 and Ora - 7445 and a few other issues.
• Monitoring the CPU utilization and troubleshooting if it crosses the threshold value.
• Resolving the locks on the database.
• Supported various Clients in assisting and resolving the issues.
• Created Quarterly Health check reports for production database.
• Monitoring performance using AWR reports.
• Used Recovery Manager (RMAN) and Enterprise Manager for various maintenance tasks like backing up of database, restoration and recovery of database.
• Involved in taking logical backups using EXPORT, IMPORT and DATA PUMPS.
• Provide technical support and assistance to all database end-users and Creating users, allocation to appropriate tablespace quotas with necessary privileges and roles for all databases
• Communicated with Oracle to get the necessary patches required to fix up the database changes needed using Oracle SR Support and coordinating the patches and implementing the necessary changes.
• Provided 24x7 on-call supports. Worked beyond regular hours based on business demands.
• Used RMAN scripts to take backup of the ASM files and delete the archive logs based on the sysdate.
• Performed switch over and fail over on Standby database.
• Audit of the Data/Database objects for auditors.
• Created Oracle best practices document, Database monitoring scripts used for day to day Monitoring.

Environment: Oracle 11g/10g/9i, RMAN, RAC, CRS, Linux, Sun Solaris, Confidential UNIX and Windows

Confidential

Oracle DBA

Responsibilities:

• Involved in installation and configuration of Oracle 8i/9i
• Performed tablespace and user level tasks by monitoring for any kind of severity issues.
• Responsible for configuration of client installations on the client server
• Worked on backup and restore activities on DR and standalone database servers
• Management of users including creation, alter, grant of system/db roles and permissions on various database objects.
• Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, daily maintenance activities and clearing up old alert log files which are no more necessary and occupies space.
• Experienced in design & maintenance of Oracle Data Guard & Standby Databases.
• Hands on experience in troubleshooting high availability scenarios involving Clustering, Database Mirroring, and Replication.
• Involved in switchover activities communicating with the Apps DBA.
• Involved in design and maintenance of Oracle Data Guard & Standby Databases.
• Performed locking and unlocking of users when ever needed depending upon the clients requirement.
• Involved in the tasks related to database refresh using exp and imp.

Environment: Oracle 9i/8i, Confidential -UX, Linux 7.3, Windows NT