SUMMARY:

• Senior level Oracle certified Database Administrator with over 10 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 Confidential 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 Confidential, 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/12c Confidential /non- Confidential Active Data Guard.
• Successfully upgraded databases from 9i,10g,11g and 12c Confidential /non- Confidential .
• 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 13c/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

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

Database tools: TOAD, OEM Cloud Control and OEM Grid Control, PlsqlDeveloper, SecureCRT, AllFusion Erwin, Data Modeler, ETL,Spotlight, 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

WORKING EXPERIENCE:

Confidential

Sr. Database Administrator

Environment: Oracle 10g,11gR2,12c, Confidential, ASM, Data Guard, Oracle OEM Grid Control 11g, 12c cloud control, Apache Cassandra, Solaris10, Red Hat Linux.

Responsibilities:

• Oracle Database installation and maintenance of 11g and 12c Multitenant on NFS and ASM file systems.
• Upgrading multiple databases from 10g and 11g to Oracle 12c Multitenant/non-Multitenant databases.
• 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.
• Installation and manage oracle 11g database Vault.
• Upgrade of 27 TB of Revenue Assurance database to increase storage capacity.
• Implementing three to five nodes Oracle 11g/12c Confidential on Solaris10, using NFS and ASM File systems.
• Upgrade, Implementing and managing Oracle 11g/12c Multitenant/non- Multitenant Active/Physical Standby Data Guard.
• Upgrade and manage oracle 12c OEM cloud control to 13c OEM Cloud Control.
• 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.
• Extensive use with 12c OEM cloud control for monitoring, administration and performance tuning.
• 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.
• 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.
• As Cassandra DBA responsibilities:
• In depth knowledge of architecture, core concepts and creating Cassandra database systems.
• Add/Remove nodes into Cassandra cluster.
• Upgrade Cassandra Cluster and single node databases.
• Installation and patches of Cassandra clusters and single node databases.
• 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

Environment: Oracle 10g,11gR2,12c, Confidential, 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.

Oracle DBA

Responsibilities:

• Installation, configuration, administration and tuning of Oracle 10g to 11g/12c Single Instance and Confidential databases.
• Installation and administration of Oracle 12c Confidential databases on multiple servers.
• Database Upgrade/migration from 10g to 11g/12c 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 Active/Physical Data guard 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.
• 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, Confidential, 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:

• 100% involved for implementation TABS billing system.
• Planned and implemented 20 million subscribers 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 23 TB of Revenue Assurance database.
• 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 Confidential 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 Active Data Guard 10g/11g
• Implementing and maintaining Oracle 11g Golden Gate.
• 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 Confidential 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 Confidential servers.
• Correspondence with System analysts and DBA group for creating required directory structure for daily batch operations.
• Deployment of complete batch on Confidential 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.