We provide IT Staff Augmentation Services!

Sr. Oracle Dba (dba Architect) Resume

Detroit, MI

SUMMARY:

  • Having 16 years of experience as a Sr. Oracle DBA, provided supports to large retailers, online service providers, financial institutions, telecom service providers and other vertical customers in maintaining single & multimode RAC on Exadata database server, Golden Gate, Standby DR etc.
  • Received a “ Confidential Employee of Quarter 3 2012” award in CTS IT IS.
  • Received a “Best Team award of Q2 2011” from CTS IT IS for supporting McGraw - Hill Financial.
  • Awarded with “Junior Research Fellowship” from Indian Agricultural Statistical Research Institute 1999, Government of India to complete Master’s in Computer Applications
  • Worked as a team lead in the Construction/Platts Project of Mc-Graw Hills Financial.
  • Experience on installation and configuration two/three/four node Oracle 10g/11g/12c RAC on Exadata X3/X5/X6
  • Configured Data Guard/Standby and Data Guard Broker on Oracle 10g/11g/12c three nodes RAC.
  • Expertise of installation Automatic Storage Manager ( ASM ), ASM disk labelling, ASM diskgroup creation.
  • Configured shared SAN devices for Oracle 11gR2 RAC database installation.
  • Worked on DDBOOST, ZDLRA RMAN and Data Pump backup.
  • Configured Golden Gate 11.2.1.0/ 12.2.0.2.0 and replication for Oracle database.
  • Installed OSWatcher and created graph of server load using it.
  • Created several Oracle 11g R2 databases on Amazon Cloud server.
  • Performed several database migrations from 8i/9i/10g to Oracle 11gR2 and 12c three node RAC servers.
  • Experience on Oracle CSSCAN utility to see the impact of character set conversion.
  • Experience on RACcheck utility to verify the configuration of RAC, CRS, ASM etc.
  • Experience on Oracle Flashback database feature.
  • Performed database consolidation of two databases into one.
  • Expertise on CPU Patching of database.
  • Working on Remedy Incident Management tool.
  • Worked extensively on Toad 9 and Toad 11.
  • Applied JVM / Time ZONE DST patches on Oracle 9i/10g R1/R2
  • Worked with Oracle support 24*7 after creating SRV-1 SR till the final closure.
  • Expertise in cloning using RMAN, export/import, hot and cold backup.
  • Worked on Center for Information and Security (CIS) guidelines (to avoid any vulnerability).
  • Implemented Secure Sockets Layer (SSL) a feature of Oracle Advanced Security (OAS) to secure database.
  • Wrapping of Procedure, Packages and Function using Wrap utility provided by Oracle
  • Optimize query by generating explain plan, creating fake or real indexes and rewrite SQL queries.
  • Wrote documents on “Oracle 11gR2 RAC Installation and configuration”, “Securing Oracle Database Listener from unauthorized access”, “Minimizing Role and Privileges” and “Securing Oracle Account”.
  • Installed and configured OEM Grid Control 10g R2/12c .

TECHNICAL SKILLS:

Operating Systems: AIX 5.2,5.3 HP-UX, Sun-Solaris 5.8,5.9,5.10, Linux AS3, AS4 MS Windows XP/2000/NT.

Database Softwares/Tools: Oracle 8i/9i/10g/11g/12c, RAC, Golden Gate, Clusterware, ASM, RACcheck, Data Pump, SQL*Loader, Export/Import, RMAN, WRAP utility, Opatch utility, OEM Grid Control 10gR2, SQL Trace, Tkprof, Toad 8.0, Statspack, Dbca, Srvctl, Crsctl, Ocrconfig, Crs stat, Tivoli Storage Manager(TSM), Citrix, Marklogic 5, 4.5, Foglight Agent, Remedy etc

PROFESSIONAL - PROJECT EXPERIENCE:

Confidential, Detroit, MI

Technology: Oracle 10g, 11g, 12c, Data Guard, Golden Gate, RAC, Exadata X3/X5/X7

Sr. Oracle DBA (DBA Architect)

Responsibilities:

  • Design, install and configure 12c Oracle RAC DBs on Sun Solaris according to business requirement.
  • Install, Configure and troubleshoot Golden Gate.
  • Database migrations from 11g to 12c.
  • Performed Transport Tablespace refresh for Exadata DB servers.
  • Patched PSU patches on standalone or RAC dbs.
  • Clone two node RAC to two node RAC db.
  • Configured DataGuard/Standby and Data Guard broker on Oracle 11gR2 RAC (two nodes) using OEM & scripts.
  • Provided backup and recovery solutions using DD Boost, ZDLRA, RMAN and Data Pump.
  • Followed the Incident Management, Changes Management and Problem Management process through Remedy and closing all tickets within SLA.
  • Co-ordinated with application team to prepare the environment during the application testing
  • Generated AWR reports to analyze the test performance and resolve other performance issues.
  • Install and configure OEM 12C for monitoring Oracle databases.
  • Configure Standby DR build and switchover testing.
  • Flashback db/DR to a Flashback Guaranteed Restore point.

Confidential

Technology: Oracle 8i, 9i, 10g, 11g, 10g RAC and 11g RAC, Data Guard, Marklogic 5, Toad 9/11

Sr. Oracle DBA (Associate Operation Manager/Lead Oracle DBA)

Responsibilities:

  • Working as a team lead and managing team of three Oracle DBAs onsite and five at offshore.
  • Performed several database migrations from 8i/9i/10g to Oracle 11gR2 three node RAC servers.
  • Configured three node Oracle 10gR2 RAC databases for Dev/QA/Prod/DR servers on Linux 5.6 version.
  • Configured DataGuard/Standby and Data Guard broker on Oracle 11gR2 RAC (three nodes).
  • Expertise of managing Automatic Storage Manager ( ASM ) and configured ASM disks on SAN storage for storing RAC databases.
  • Worked on Toad 9 and Toad 11.
  • Configured ACFS for installing Golden Gate software for High availability.
  • Provided backup and recovery solutions using RMAN and Data Pump.
  • Configured Golden Gate 11.2.1.0.1 replications for two standalone prod Oracle databases.
  • Configured Golden Gate 11.2.1.0.1 on two node Oracle 11g R2 RAC environment.
  • Configured Oracle Advanced Replication for Oracle 10g databases.
  • Created several Oracle 11g R2 databases on Amazon Cloud server.
  • Performed database consolidation of two production databases into one.
  • Expertise on Patching of database using security patches like applied CPUJan2013, Network Interconnect bug fix patch.
  • Followed the Incident Management, Changes Management and Problem Management process through Remedy and closing all tickets within SLA.
  • Building and managing Oracle 11g R2 databases on Amazon Cloud Server .
  • Installed ER Studio, generated Data Model and created centralized Web Report
  • Worked on RMAN and Data Pump for full schema refresh as well as full database refresh.
  • Worked on optimization of SQL query.
  • Co-ordinated with application team to prepare the environment during the application testing
  • Generated AWR reports to analyze the test performance and resolve other performance issues.
  • Tracing the sessions to troubleshoot the production issues.
  • Monitoring of production database backup and resubmit in case of RMAN backup failed.
  • Worked extensively with Linux Team to tune OS settings, I/O and Network areas.
  • Implemented backup strategies, recovery procedures and disaster recovery testing.
  • Installed and configure OEM 12C for monitoring Oracle databases.
  • Installation and configuration of MarkLogic 5.0 on Linux 5.6 server (Cloud Environment)
  • Stopping and starting the MarkLogic database at the time of server maintenance.
  • Performed MarkLogic code deployment.
  • Maintained and troubleshooted MarkLogic jobs running from Maestro.
  • Troubleshooted Access Comtrol List (ACL) while connecting to MarkLogic database during Oracle 9i database migration.
  • Worked on setting up Database Replication and Flexible Replication.
  • Setup BitKinex to work on MarkLogic database.
  • Created MarkLogic Forests.
  • Created MarkLogic Databases.
  • Configured WebDAV, HTTP servers in MarkLogic environment.
  • Created users and assigned required roles to access MarkLogic database.
  • Enable auditing for MarkLogic database to provide more security.
  • Closely working with MarkLogic developers to provide optimum support.
  • Performed backup of MarkLogic databases.
  • Loaded PDF document into MarkLogic database using WebDAV Internet Explorer client.
  • Coupled and decoupled host in a MarkLogic group.
  • Performed Failover setup to get high availability for MarkLogic.

Confidential

Technology: 11g RAC R2 (Four Node RAC)

Sr. Oracle DBA (Associate Operation Manager/Lead Oracle DBA)

Responsibilities:

  • Worked with infrastructure team to design SAN shared disk layout for RAC installation.
  • Installed and configured an Oracle 11gR2 RAC Bell Lab for AT&T application testing.
  • Install grid infrastructure to configure Oracle 11gR2 Clusterware and ASM .
  • Added a new node to the existing three node cluster.
  • Provide the support, during first application load to the three node RAC database.
  • Migrated existing non Oracle database to a 11gR2 RAC databases.
  • Create recovery catalog and configure RMAN backup.
  • Wrote document Oracle gR2 RAC installation Documents.
  • Prepared run book for troubleshooting database on the daily basis.
  • Prepared document and knowledge transfer to the AT&T employees.
  • Provided training (Mentor) to the AT&T employees.
  • Was Involved in Cloning and Patching of Oracle databases on 9i and 10g using conventional method and RMAN.
  • Reviewed, determined and designed storage, memory and various other database components.
  • Coordinated with testing team for various database testing
  • Incorporated other database support procedures like daily backup status mail, disk and database usage alert mails and security status mails
  • Tune and redesign the SQL and Oracle database objects
  • Administered and install oracle critical patches ( CPU )
  • Monitor the alert logs and trace files and mirrored the control files and multiplexing the redo log files
  • Reorganize the database objects for managing the space usage.
  • Develop and implement monitoring scripts using UNIX shell for the database

Confidential

Technology: Oracle 9i/10g and 10g RAC R2 (Two Node RAC)

Sr. Oracle DBA (Associate Operation Manager/Lead Oracle DBA)

Responsibilities:

  • Worked as a team lead and managed team of six Oracle DBAs.
  • Following the Incident Management, Changes Management and Problem Management through Remedy and closing all the tickets within the SLA.
  • Expertise on installation and database creation for Oracle 11gR2 on SunOS 5.1.
  • Configure and troubleshoot Oracle GG version 9.0.2.8 (Golden Gate for real time data replication from one production database to other production database) for unidirectional.
  • Expertise of OEM installation and upgrade to 10.2.0.5 level.
  • Install and configure OSWatcher in Local Zone (Linux) and Global Zone (SunOS)
  • Supported two node 10g R2 RAC on SunOs database.
  • Provide performance and tuning suggestion to client to reduce high load or cpu utilization by setting Oracle parameters, find out high CPU consuming SQL statements and tune them if needed etc.
  • Provided architectural suggestion that eliminated errors and incidents up to 20%.
  • Created several SR (Service request of SRV 1/2/3 level) to Oracle support, and worked with them till SR is closed.
  • Worked on 9i standby databases and fix the issue if primary and standby databases are not in sync.
  • Provided support to multiple Oracle production databases at the time of build, maintenance and during new changes implementation.
  • Capacity planning for database growth in Q1/Q2/Q3.
  • Prepared knowledge transfer documents and provided KT to new candidates that helped them to adapt fast in new environment.
  • Prepared daily report using AWR/STATSPACK that includes number of transactions, archive log generated, backup failed, high load, top 5 SQL statements.
  • Fulfill all daily Oracle DBA activities, including user management (creating users, synonyms, privileges, roles, quotas, table, index etc.), monitoring (alert log, memory, disk I/O, CPU utilization, database network connectivity).
  • Worked on RMAN full, incremental and archive backup issues, resolved and resubmit through scripts.
  • Export/Import/Data Pump for schema refresh as well as full database refresh and fix sequences afterward.

Confidential

Technology: Oracle 10g R1 RAC (Three Node RAC)

Sr. Oracle Production DBA

Responsibilities:

  • Cloning of three node RAC 10g R1 on HP-UX database using RMAN
  • Export/Import for schema refresh as well as full database refresh.
  • Optimized query by generating explain plan, Creating fake or real indexes and rewrite the query, if required
  • Worked with application team to prepare the environment during base line test. Provide a hand to developers during baseline test to achieve their goals.
  • Generate AWR reports to analyze the test performance and resolve other issues.
  • Create Outline and import into production database.
  • Monitoring of production database backup and resubmit in case of RMAN backup failed.
  • Resolve the t ablespace related issues like adding/increasing datafiles size due to space crunch. Resolve others space crunch issues like archive folder or mount point getting full.
  • Optimized Cognos report query e.g. time taken reduced to 6 min from 44 min.
  • Find out the reason for listener or database down and start-up if needed.
  • Fulfill all daily Oracle DBA activities, including user management (creating users, synonyms, privileges, roles, quotas, table, index etc.), monitoring (alert log, memory, disk I/O, CPU utilization, database network connectivity).
  • Startup ASM instance, if shutdown or stopped working.
  • Communicate with other teams to support on different database problems.

Confidential

Technology: Oracle 10g RAC on AIX 5.3 ( Two Node RAC)

Sr. Oracle Core DBA/ Oracle Apps DBA

Responsibilities:

  • Support and install RAC 10R2 on AIX 5.3 server, that includes binaries installation for Cluster Ware, Automatic Storage Management, Oracle database binaries and finally creating seven instances on each node through response file and Perl scripts.
  • Reviewed Centre for Information Security Benchmark for Oracle (CIS) guidelines v 2.0, work-packages and implemented the work-packages
  • Wrote different types of documents like Design Document before implementing CIS guidelines, Test Document for the unit testing and finally RSEs. The document included, Securing Oracle Database Listener from unauthorized access, Minimizing Role and Privileges and Securing Oracle Account
  • Followed the Oracle guidelines & instructions to make Oracle Software and Instances OFA and OMF compliant
  • Applied Security Patches CPUJan2008
  • Securing Oracle account by enforcing password complexity and creating different profiles as per the user e.g. Schema Owner, Normal Users, Application Users
  • Configure OEM Grid Control 10gR2 for automating alerts and monitoring of db.
  • Wrote new scripts and supported multiple changes in existing Perl script as well as Shell Scripts
  • Wrapping of Procedure, Packages and Function using Wrap utility provided.
  • Resolved a number of issue while working with other PL/SQL Developer e.g. Creating Views, Rebuilding indexes, Analyzing Schemas, Creating tablespaces etc
  • Performed Export/Import using Data pump
  • Creation of Custom top and Apps DBA support for custom Applications.
  • Installation of Oracle software and 11i E-Business Suite.
  • Patching and cloning of Application 11i
  • Applying application patches, includes mini pack and family pack using adpatch utility and applying database patches using Opatch utility.
  • Cloning the E-Business suite environment using Rapid Clone method.
  • Configuration of printers as a part of System Administrative activities in 11i E-Business Suite.
  • Maintaining Business Intelligent services like Discoverer, OBIEE. Administrative tasks include start-up and shutdown, creating users and maintenance.
  • Implemented CRP1 and CRP2 Instance for phase 1 & phase 2 implementation.
  • Worked on system administrative tasks like concurrent processing manager creation and modification, concurrent request creation.
  • Troubleshooting Oracle Applications server Problems includes Apache issues and concurrent manager issues.
  • Upgraded application using maintenance pack 3480000.
  • Provided APPS DBA support for Finance, Payroll & HR module for CCC
  • Interacted with Oracle Support for technical assistance request depends on the severity of the Issue.

Confidential

Technology: Oracle 9i, 10g

Senior Oracle support DBA

Responsibilities:

  • Experience on large Oracle databases sizing > 2TB.
  • Working on Database setup containing around 1600+ Oracle Instances having versions 8i, 9i, 10g on various platforms AIX 5.1 & 5.2, Solaris 5.8 & 5.9, SUSE Linux and HP-UX
  • Binaries installation, patching & upgrading databases.
  • Working on Production CR’s ( Change Requests )
  • Apply JVM DST /Daylight Saving patches on 9i, 10g databases. Apply Critical Security patches. Last applied in Jan ( cpujan )
  • Refreshing Dev/UAT databases using Export/Import, RMAN and non-RMAN Hot and Cold Backup’s. Restoration of backup’s from TSM Servers. Recovery/Reparing corrupt databases.
  • Familiar with Shell scripts and PL/SQL scripts.
  • Excellent hands-on on unix platform with nearly all flavors AIX, Linux, Solaris & HP-UX.
  • Applying a proper Backup policy for all the environments. Backup failure management.
  • Installation of standard backup scripts designed specifically for DB databases. Installation of other utility and health checks scripts. Tuning of slow performing queries. Tuning memory allocation.
  • Oracle 10g RAC setup for dev instances. Experience in working on RAC servers.
  • Experience on Standby databases/Data Guard. Taking care of space management on Standby databases when the space is added on production.
  • Partitioning of huge tables using range partitioning. Experience in list, hash and other partitioning too.
  • Operating system and Oracle database performance monitoring. Installation of Third party tools viz Foglight on Database Servers. Preparing the SOP’s for the newly transitioned task authorized by Deutsche Bank US & UK DBA Support Managers.
  • Restoration of Backups from TSM Server-Active/Inactive Backups.
  • Remedy based ticketing system including Problem management tickets raised by failure on Database servers. International support for Deutsche Bank’s databases spread all over the world.
  • Co-ordination with Primary DBA’s and System Admin people in London and New York.
  • Co-ordination with application users/database owners all over the globe.

Hire Now