PROFESSIONAL SUMMARY:

• Senior level Oracle certified Database Administrator with Around 8 years of solid hands-on experience in handling multiple oracle databases in heterogeneous environments such as Solaris, HP-UX and Windows . Well exposed to state of the art RAC implementations, DataGuard, GoldenGate, routine DBA production support, development and related database technologies. Highly proficient in performance analysis and tuning. A goal oriented, well disciplined, client focused and team player with good leadership and inter personal communication skills. Received best performance award on numerous occasions.
• Professional experience in Oracle Installation, administration, performance tuning, backup recovery with proven ability at Server side Client side responsibilities.
• Expertise in Oracle RAC, Replication, Standby databases, and database designing.
• Expertise in handling 24X7 mission critical production databases, versions 11g/10g/9i primarily in AIX / UNIX/LINUX based environments.
• Successfully upgraded databases from 9i to 10g 11g.
• Excellent communication skills, versatile team player and adaptable for new technologies.
• Expertise in working with High volume, and High Transaction databases.
• Oracle DBA experience including building objects and maintaining production environments.
• Experience in Database Security and Auditing.
• Performed backups and tested crash recoveries using conventional cold, hot and RMAN backups.
• Proficient in performance tuning using ExplainPlan,STATSPACK, SQL TRACE, TKPROF, AWR, ADDM.
• Experience in basic and advanced replication using Oracle Streams and experience in using OEM, TOAD, Data Migrations using export/import, benchmarking using load testing tools
• Creating and managing Database schemas statistics gathering scripts.
• Successfully Data migration on from old ASM disks to new ASM disks.
• Problem determination and resolution for supported application databases and maintenance utilities.
• Perform change management activities using standard change processes in support of application database related changes.
• Prepare documents for Client specific and database specific as per requirements by different clients
• Sql serverdatabase administrator functions including, configuring cold and hot backups, daily disk space monitoring, and database object creation and alters.
• Involved in sql serverperformance tuning using Performance Monitor.
• Upgraded SQL Servers from SQL Version 2000 to SQL 2005 and 2008.
• Create Linked servers to communicate between servers.
• DB2 9.7 database administrator functions including, configuring cold and hot backups, daily disk space monitoring, and database object creation and alters.
• As a DB2 Database administrator daily monitoring alert file for diagnosing all problems.
• Use and learn standard DB2 utilities and DBMS related products to perform DBA tasks.
• Job scheduling utilities, and database management tools and utilities.
• In depth knowledge of architecture, core concepts and creating Cassandra database systems.
• Experience with data modeling best practices for Cassandra or other NoSQL platforms.
• Add/Remove nodes into Cassandra cluster.
• Monitoring Cassandra cluster through OpsCenter.
• Starting, stopping and restarting of OpsCenter and agents.
• Monitoring Cassandra cluster through nodetool.
• Stopping, starting, and restarting of Cassandra server and cluster.
• Monitor Cassandra system logs, opscenter, opscenter-agent logs for errors.
• Manage and setup alerts in opscenter monitoring tool.

Tools and Technologies:

Working Experience:

Confidential Environment: Eisai had a hybrid environment. Using Oracle/ SQL Databases with various Db versions. Oracle 9i,10g,11gR2, RAC, ASM, Data Guard, Oracle OEM Grid Control 10g-11gR1, SQL Server 2005, SQL Server 2008, Oracle Solaris10, Red Hat Linux , Windows 2003-2008R2.

• Responsibilities as an ORACLE DBA: Working as Senior Oracle DBA and providing consulting services to a wide variety of clients having diverse environments and database sizes, requirements, configurations and corporate cultures. The routine tasks include dealing with:
• Installation, configuration, administration and tuning of Oracle 9i to 11g Single Instance and RAC databases.
• Database Upgrade/migration from 9i to 10g and 11g.
• OEM Grid control installation, configuration and administration.
• Proactive and Reactive Database Health checks and server reviews for client database and suggesting changes.
• Write and maintain generalized scripts to create databases, to get definition of the existing databases, to monitor and maintain databases and their alert logfiles and listener log files, startup scripts, shutdown scripts, RMAN backup and restore scripts.
• Oracle 10g-11g Dataguard setup and administration.
• RMAN Backups setup and recommending performance improvement during hot backups.
• Deploying Logical backup scripts using exp and datapump utilities on both windows and Unix environments
• Writing Unix Shell scripts for different database monitoring tasks.
• Applying latest security patch sets on Databases.
• Providing 24/7 support to client databases. Coordinating and executing maintenance tasks on weekends and on-demand.
• Creating SR with Oracle Support on any issue as and when needed.
• Managed/Monitored Junior team on any issue with Other Clients.
• Setup and maintain documentation as standards for future usage.
• Proactive Monitoring, identifying areas that need to be improved in the application and database using Statspack, AWR, ADDM, and 10g OEM Grid Monitoring.
• Involved in different scenarios of OLTP as well as DSS databases.
• Data warehousing and ETL.
• Database Security and Auditing.
• Performed backups and tested crash recoveries using conventional cold, hot RMAN backups.
• Performance tuning using ExplainPlan, STATSPACK, SQL TRACE, TKPROF, ADDM.
• Basic and advanced replication using Oracle Streams and experience in using OEM, TOAD, Data Migrations using export/import, benchmarking using load testing tools.
• Prepare documents for Client specific and database specific as per requirements by different clients.

Responsibilities as a SQL DBA

• Responsible for providing 24 X 7 dedicated production support for approximately 80 applications, Across 225 instances, 130 production instances,800 databases and 400 production databases at enterprise level, secure, highly available systems to ensure cost effective and high performing applications to our internal and external customers.
• Involved in performance tuning using Performance Monitor, SQL Profiler, SQL Query Analyzer and Database Engine Tuning Advisor, Dynamic management views DMV, Rebuild or Defrag indexes and update stats on timely basis to improve the performance and to use best query plan.
• Installed and configured SQL 2005, 2008 on WINDOWS 2003 and 2008 systems.
• Experienced with Data Extraction and Loading using DTS, SSIS and Import and Export Utility from in and out of the SQL Servers.
• Configured and maintained Log shipping for DR and for Reporting Servers.
• Created maintenance plans for database consistency, optimization and Backup jobs.
• Document server and database policies and procedures.
• Involved in Change Management, Problem management activities using Remedy software before implementing database changes in production and development activities.
• Created the backup and restore strategy to production, development and test environments.
• Involved in Disaster recovery and created the documentation.
• Taking care of Space Management, Disk Estimation, and Monitoring Log files space issues.
• Create and Schedule jobs for Full backups, Log backups, Rebuild Indexes, Update stats and Database Consistency.
• Create Linked servers to communicate between servers.
• Install Database Mail and create operators to send job failure notifications.

Responsibilities as an ORACLE DBA: Working as Senior DBA in this organization performed following tasks:

• Implementation latest frontend application TABS7
• Oracle Database installation and Maintenance 10g/11g
• Oracle Database Upgrades Single node, Cluster databases, ASM
• Oracle Databases migration from old servers to new servers Prod/Non-Prod .
• Data migration on from file system to ASM.
• Implementing two and three node Oracle 10g RAC/11g Grid Infrastructure on Solaris10, using ASM
• Implementing Oracle Data Guard for standalone10g/11g
• Implementing Oracle Golden Gate POC .
• Database Performance tuning and optimization.
• Running AWR and ADDM reports routinely to check for any potential database performance issue.
• Configuring and deploying of Physical Database Backups using RMAN.
• Configuring and deploying Logical database backups using datapump utility.
• Daily Monitoring Storage Space at Database and OS level.
• Routine operational support for business queries.
• Creating monitoring scripts for efficient database monitoring and troubleshooting.
• SOA installation and maintenance during testing and implementing of new application server.
• E-business suite installation.
• Implementing, working and cloning oracle 10g Discoverers on multiple servers
• Creating and managing Database schemas statistics gathering scripts
• Expertise in working with High volume, and High Transaction databases.
• Oracle DBA experience including building objects and maintaining production environments.
• Experience in Database Security and Auditing.
• Problem determination and resolution for supported application databases and maintenance utilities.
• Perform change management activities using standard change processes in support of application database related changes.
• Creation and managing Oracle Application Profiles and users.
• Setup and maintain documentation as standards for future usage.
• DB2 9.7 database administrator functions including, configuring cold and hot backups, daily disk space monitoring, and database object creation and alters.
• As a DB2 Database administrator daily monitoring alert file for diagnosing all problems.

Responsibilities as a SQL DBA

• Responsible for providing 24 X 7 dedicated production support for approximately 70 applications, Across 245 instances, 150 production instances,900 databases and 600 production databases at enterprise level, secure, highly available systems to ensure cost effective and high performing applications to our internal and external customers.
• Installed and configured SQL 2008 on WINDOWS 2008 systems.
• Involved in performance tuning using Performance Monitor, SQL Profiler, SQL Query Analyzer and Database Engine Tuning Advisor, Dynamic management views DMV, Rebuild or Defrag indexes and update stats on timely basis to improve the performance and to use best query plan.
• Created maintenance plans for database consistency, optimization and Backup jobs.
• Document server and database policies and procedures.
• Install Database Mail and create operators to send job failure notifications.
• Involved in Change Management, Problem management activities using Remedy software before implementing database changes in production and development activities.
• Created the backup and restore strategy to production, development and test environments.
• Creating the documentation.
• Taking care of Space Management, Disk Estimation, and Monitoring Log files space issues.
• Create and Schedule jobs for Full backups, Log backups, Rebuild Indexes, Update stats and Database Consistency.
• Create Linked servers to communicate between servers.

Responsibilities as an ORACLE DBA: Working as DBA and providing consulting services to a wide variety of clients having diverse environments and database sizes, requirements, configurations and corporate cultures. The routine tasks include dealing with:

• Oracle Database installation and Maintenance.
• Create test, development and production databases with assistance from Lead DBA.
• Physical Database Backups using RMAN.
• Logical database backups using datapump utility.
• Running AWR and ADDM reports to check for any problems in database.
• Supported the developers and end-users for accessing the database.
• Rotating log files to release space at OS level.
• Monitoring Storage Space at Database and OS level.
• Documentation of all tasks performed on Production databases.
• Daily monitoring of tablespaces and adjusting space by adding datafiles
• Monitoring system performance DB and OS through AWR reports
• Daily monitoring of alert log files and checking and correction of errors found
• Creation of new partitions and analyzing the tables
• Creation and maintenance of new tablespaces and assigning quota on those tablespaces to users
• Purging of archived data from database if any
• Applying any required patches and fixing database issues
• Migrated Shell scripts and Perl programs from single instance servers to new RAC servers.
• Correspondence with System analysts and DBA group for creating required directory structure for daily batch operations.
• Deployment of complete batch on RAC servers and manual execution of jobs for testing.
• Participated in database stress test session along with DBA group.
• Prepare documents for Client specific and database specific as per requirements by different clients.