We provide IT Staff Augmentation Services!

Sr. Oracle Dba Resume

Bloomington, IL

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 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/12c CDB/non-CDB Active Data Guard.
  • Successfully upgraded databases from 9i,10g,11g and 12c CDB/non-CDB.
  • 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.
  • Solid understanding of Exadata Architecture.
  • 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
  • Solid exposure of Exadata hardware.
  • Problem determination and resolution for supported application databases and maintenance utilities.
  • Experienced in using Integration architecture of SOA Suite v 11.1.1.6.0 and Service Bus.
  • 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.
  • In depth knowledge of architecture, core concepts and creating Cassandra systems.
  • Add/Remove nodes into Cassandra cluster.
  • Monitoring Cassandra cluster through node tool.
  • 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/12c, Oracle Standalone databases 9i/10g/11g/12c, Oracle Grid Infrastructure, Oracle ASM, Oracle Golden Gate, Oracle Exadata, 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, Pl/SQL Developer, SecureCRT, AllFusion Erwin Data Modeler, ETL, Spotlight, Solar Wind, Microsoft Management Studio, DevCenter, OpsCenter, Data Studio, IBM Optim 11.3.

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

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

PROFESSIONAL EXPERIENCE

Confidential . Bloomington, IL

Sr. Oracle DBA

Environment: Oracle 11gR2,12c, RAC, ASM, Data Guard, Oracle Exadata, 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).
  • Online 12c data migration from NFS to ASM and non-Exadata to Exadata environment.
  • 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 RAC on Solaris, using NFS and ASM File systems.
  • Upgrade, Implementing and managing Oracle11g/12c Active/Physical Stand by Data Guard.
  • Manage Oracle Golden Gate databases.
  • Clearunderstandingof Exadata features like Flash cache, Storage Index, HCC and IORM .
  • Monitoring of Exadata using OEM 12c .
  • Upgrade and manage oracle 12c OEM cloud control to 13c OEM Cloud Control.
  • Database Performance tuning and optimization.
  • Responsible to manage OLTP as well as DSS databases
  • Running AWR, ASH and Real-Time ADDM reports routinely to check for any potential database performance issue.
  • Database migration from non-Exadata to Exadata using Data Guard.
  • 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.
  • 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 systems.
  • Add/Remove nodes into Cassandra cluster.
  • Upgrade, Installation and patches on multiple Cassandra clusters.
  • 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.

Confidential, Woodcliff Lake, NJ

Sr. Oracle DBA

Environment: Oracle 12c/11g/10g, RAC, Oracle Exadata, ASM, Data Guard, Oracle OEM Grid Control 11g/12c cloud control, Cassandra, Oracle Solaris10, Red Hat Linux, Windows 2003/2008R2.

Responsibilities:

  • 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 10g to 11g/12c Single Instance and RAC databases.
  • Installation and administration of Oracle 12c CDB 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.
  • Good understanding of Exadata Architecture.
  • 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 issues 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.

Hire Now