SUMMARY

• Senior level Oracle certified Database Administrator with over 9 years of solid hands - on experience in handling multiple oracle, Cassandra and DB2 databases in heterogeneous environments such as Solaris, HP-UX and Windows. Well exposed to state of the art RAC implementations, Data Guard, Golden Gate, routine DBA production support, development and related database technologies.
• Received best performance awards 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.
• Proactive and Reactive Database Health checks and server reviews for client database and suggesting changes.
• Expertise in handling 24X7 mission critical production databases, versions 11g/10g/9i primarily in AIX / UNIX/LINUX based environments.
• Expertise in managing and installation of 11g Data Guard.
• Successfully upgraded databases from 9i to 10g & 11g.
• Excellent 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 using conventional cold, hot and RMAN backups.
• Proficient in performance tuning using Explain Plan, SQL TRACE, TKPROF, AWR, ADDM.
• Experience in using 12c OEM cloud control, TOAD, Data Migrations using export/import, benchmarking using load testing tools
• Successfully Data migration 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 server database administrator functions including, configuring cold and hot backups, daily disk space monitoring, and database object creation and alters.
• Involved in sql server performance tuning using Performance Monitor.
• Upgraded SQL Servers from SQL Version 2000 to SQL 2005 and 2008.
• DB2 9.7 database administrator functions including, configuring cold and hot backups, daily disk space monitoring, and database object creation and alters.
• DB2 10.5, 10.1, 9.7 database administrator functions including, database object creation and alters implementation, reorgs, statistics collection and analysis.
• DB2 Recoveries, performance tuning, schedule and manage maintenance of production application databases, disaster recovery testing.
• In depth knowledge of architecture, core concepts and creating Cassandra database systems.
• Add/Remove nodes into Cassandra cluster.
• Monitoring Cassandra cluster through nodetool.
• Monitor Cassandra system logs, opscenter, opscenter-agent logs for errors.

TECHNICAL SKILLS

Operating Systems: Oracle Solaris10,Red Hat Linux, Windows 2000/2003/2008 Server, Windows XP,Windows7/8.

Databases: Oracle RAC ( Real Application Clusters) 9i/10g/11g, Oracle Standalone databases 9i/10g/11g/12c,Oracle Grid Infrastructure, Oracle ASM databases, Oracle Golden Gate, E-business suite, Microsoft SQL Server2005,2008, Cassandra, DB2 V9.5,V10.1,V10.5

Database tools: TOAD, Oracle Enterprise Manager, PlsqlDeveloper, SecureCRT, AllFusion Erwin Data Modeler, ETL, Microsoft Management Studio, DevCenter, OpsCenter, Data Studio, IBM Optim 11.3.

Database Utilities: RMAN, Data pump, Exp/imp, Sqlldr, SQLPlus, dbca, netca, NID.

Other Skills: VMWARE Server/Workstation, Web sites Development, Unix Shell scripting

PROFESSIONAL EXPERIENCE

Sr. Database Administrator

Confidential, Bloomington, IL

Environment: Confidential had a hybrid environment. Oracle 10g,11gR2,12c, RAC, ASM, Data Guard, Oracle OEM Grid Control 11g/12c cloud control, Cassandra database, Solaris10, Red Hat Linux.

Responsibilities:

• Oracle Database installation and Maintenance 10g/11g/12c
• Upgrading multiple databases to Oracle 12c databases on non-production environments.
• Oracle Database Upgrades (Single node, Cluster databases, ASM)
• Oracle Databases migration from old servers to new servers (Prod/Non-Prod).
• Data migration from file system to ASM.
• Implementing two and three node Oracle 11g RAC on Solaris10, using NFS and ASM File systems.
• Implementing and managing Oracle Data Guard 10g/11g
• Database Performance tuning and optimization.
• Running AWR, ASH and ADDM reports routinely to check for any potential database performance issue.
• Configuring and deploying of Physical Database Backups using RMAN using Net backup.
• Configuring and deploying Logical database backups using data pump utility for data migration from production databases to historical database.
• Installation, configuration and administration of 12c OEM cloud control on multiple servers.
• Daily Monitoring Storage Space at Database and OS level.
• Routine operational support for business queries.
• Creating and monitoring scripts for efficient database monitoring and troubleshooting.
• SOA installation and maintenance during testing and implementing of new application server.
• Creation and managing Oracle Application Profiles and users.
• 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.
• In depth knowledge of architecture, core concepts and creating Cassandra database systems.
• 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.
• Maintaining backups of all Cassandra databases.

Confidential, NJ

Oracle DBA

Environment: Confidential had a hybrid environment. Oracle 10g,11gR2,12c, RAC, ASM, Data Guard, Oracle OEM Grid Control 11g/12c cloud control, SQL Server 2005, SQL Server 2008, Oracle Solaris10, Red Hat Linux, Windows 2003/2008R2.

Responsibilities:

• Installation, configuration, administration and tuning of Oracle 9i to 11g Single Instance and RAC databases.
• Installation and administration of Oracle 12c CDB databases on multiple servers.
• Database Upgrade/migration from 9i to 10g and 11g on NFS and ASM file systems.
• 12c OEM cloud 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 Data guard (11g active DG) setup and administration.
• RMAN Backups setup and recommending performance improvement during hot backups.
• Deploying Logical backup scripts using export and data pump utilities on both Linux 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.
• Setup and maintain documentation as standards for future usage.
• Monitoring, identifying areas that need to be improved in the application and database using AWR, ADDM, ASH and 12c OEM cloud control Monitoring.
• Involved in different scenarios of OLTP as well as DSS databases.
• Database Security and Auditing through FGA.
• Performed backups using conventional cold, hot & RMAN backups.
• Performance tuning using Explain Plan, SQL TRACE, TKPROF, AWR, ADDM, ASH and 12c OEM cloud control.
• Prepare documents for Client specific and database specific as per requirements by different clients.
• Installation and managing of 3 nodes Cassandra cluster.
• Expert in Monitoring Cassandra cluster through nodetool.
• Monitor Cassandra system logs and CPU usage through opscenter.

Confidential

Sr. Database Administrator

Environment: Oracle 10g,11gR2, RAC, ASM, Oracle 10g-11gR2 Data Guard, Oracle OEM Grid Control 10g-11gR1,12c OEM cloud control, Unix 9,10, Red Hat Linux 5,IBM DB2 9.7

Responsibilities:

• Thorough knowledge of implemented TABS billing system.
• Planned and implemented 20 million subscriber upgrade project which includes migration of 14TB billing system to new data center along with its database upgrade to 11gR2 in minimal downtime
• Supervised the upgrade of 27 TB of Revenue Assurance database to increase storage capacity.
• Oracle Database Upgrades (Single node, Cluster databases, ASM)
• Oracle Databases migration from old servers to new servers (Prod/Non-Prod).
• Data migration from file system to ASM.
• Implementing two and three node Oracle 11g RAC on Solaris10, using NFS and ASM File systems.
• Planned and migrated 12TB CDR History database to Oracle 11g. It includes automated CDR transfer from live eliminating cumbersome manual tasks.
• Implementing and managing Oracle Data Guard 10g/11g
• Implementing Oracle Golden Gate on UAT server for testing purpose.
• Running AWR, ASH and ADDM reports routinely to check for any potential database performance issue.
• Configuring and deploying of Physical Database Backups using RMAN using Net backup.
• Configuring and deploying Logical database backups using data pump utility for data migration from production databases to historical database.
• Extensive use with Oracle Enterprise Manager Grid Control for monitoring, administration and performance tuning.
• Creating and monitoring scripts for efficient database monitoring and troubleshooting.
• SOA installation and maintenance during testing and implementing of new application server.
• Implementing, working and cloning oracle 10g Discoverers on multiple servers
• 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.
• 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.

Confidential

Database Administrator

Environment: Oracle 9i/10gR2/11gR2, IBM AIX 5.3, Window Server 2003/2005, Unix, Linux

Responsibilities:

• Oracle Database installation and Maintenance.
• Implement two and 3 nodes Oracle 10g/11g RAC databases.
• Installation and managing 10g Data Guard.
• Create test, development and production databases with assistance from Lead DBA.
• Physical Database Backups using RMAN.
• Logical database backups using data pump utility.
• Running AWR, ASH 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
• 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.