We provide IT Staff Augmentation Services!

Sr. Oracle Dba - Technical Sdm Resume

Reston, VA

PROFESSIONAL SUMMARY:

  • Over 10 years of experience as an Oracle DBA in Production and development environment and strong understanding of Oracle 12c/11gR2/10g/89i/8i/8.0/7.x on various flavours of Unix and NT/2000
  • Installation of Oracle 8i/9i/10g/11g/12c on UNIX/ VMware/Oracle Virtual Box & Windows NT and 2000.
  • Expert with the technical aspects of DBA such as Installation (RAC /Non RAC), Data guard (DGMGRL), Upgradation, applying patches, Data - Pump, Import/Export, RMAN, SQL *Loader, Fine Grained Auditing (FGA), Database Auditing.
  • Dexterously implemented Oracle 11.2.0.3 two node RAC, Installed Oracle 11.2.0.1 two node RAC on Sun Solaris10, Upgrade 10.2.0.4 to 11.2.0.3.
  • Strong in Implementation of 11G Grid Control setup and Agent Installation using Pull Method for multiple targets on different platforms.
  • Worked on Upgrades from Oracle 9i/10gR2 to 10gR2/11gR2. Applied Oracle Quarterly PSU/ Critical Patches and version upgrades when needed for Linux, Sun and AIX OS.
  • Managing RMAN Disk/Tape backups and ensuring the disk/tape backup being performed onto tape using NetBackup. Involved in restoring huge databases using RMAN.
  • Worked on storage Migrations from NetApp to ASM storage on EMC using Physical standby cutover methods.
  • Expert in Implementing High Availability solution, designed and implementation of database and application disaster recovery (DR) plans using Physical standby database, 2 nodes RAC and SRDF storage technology.
  • Expert in performing database refreshes (RMAN cloning) from Production to UAT, Test and DEV environments based on the requirements for testing and development.
  • Performing export/import of databases, schema or tables. Loading the data into the tables using SQL* Loader or import.
  • Performed/managed enterprise databases installation RAC, Data Guard, ASM on Linux, Sun OS.
  • Worked on proactive and reactive Performance Tuning ADDM, AWR and ASH. Performing SQL tuning and advising the developers. Creating indexes on tables and revising the PL/SQL code helped to running faster.
  • Database Sizing, Tablespace Management and Security Administration.
  • User and security administration. Managing the roles and privileges.
  • Conversant with the technical aspects of DBA such as Installation (RAC /Non RAC), Data guard (DGMGRL), Upgradation, applying patches, Data-Pump, Import/Export, RMAN, SQL *Loader, Fine Grained Auditing (FGA), Database Auditing
  • Working knowledge of various Oracle access tools like Toad, SQL Navigator, Solar Winds, OEM-Grid Control, BMC-Patrol, SQL-Backtrack, Site-scope
  • Having knowledge on shell scripts. Written and customized the shell/SQL scripts to monitor the database activity and also to automate the database tasks. File or data transfer using tools like SFTP, FTP and SCP.
  • Exposure to Taking Backup using BCV/P (Split Mirror), Used SQL*Trace, Explain Plan for SQL tuning, AWR, Stats pack
  • Strong experience on different flavours of UNIX like Linux, Sun Solaris, IBM AIX, Window NT and Windows 2000.
  • Proficient in design and development of Client/Server application using Oracle 7.x, 8.0,8i,9i,10g,11g/12c as Backend and Developer-2000 (Forms 5.0/6.0/6i, Reports 3.0 /6.0/6i) as front end
  • Having excellent verbal and communication skills.
  • Good Team Builder, worked with offshore team while managing them and written several technical SOP’s to guide the team.
  • 24/7 on-call support for production support.

TECHNICAL SKILLS:

Operating Systems: Sun Solaris, Linux, HP-UX, AIX, Windows NT/2000

Database Management Systems: Oracle 12c,11g,10g,10g XE,9i,8i,7.x (7.3.3.0.0)

Virtualization Software: VMware, Oracle Virtual Box

Programming Languages: UNIX Shell Programming, C, C++, Java, Access Programming

Fourth Generation Languages: Oracle D2K (Developer 2000) 5/6.0/6i, FoxPro.

Version Control Software: Clear Case, VSS (Microsoft Visual Source Safe), WinCVS.

Third Party Tools: Erwin (Data Modelling), SolarWinds, Toad, OEM-Grid, BMC-Patrol, SQL-Backtrack, Site-scope,NetBackup 4.5/5.x, Tivoli.

Scheduling Tools: Control + M, Autosys

Ticketing System: BMC Remedy, Kintana, Virtual Tickets, Infoman, and Jira.

Hardware: IBM eServer pSeries, IBM RS/6000, HP 9000, Compaq, Sun E6500, Sun E4500, Sun E3500, Sun E450, Sun Ultra10, 5, 2, Sun Sparc, DLT and LTO Tape drives.

Others: Knowledge of Six Sigma, Lean, IBM-GDF.

PROFESSIONAL EXPERIENCE:

Confidential, Reston, VA

Sr. Oracle DBA - Technical SDM

Responsibilities:

  • Performing database health checks, evaluating & troubleshooting Database performance and capacity related issues.Monitor, review and resolve database space management and capacity issues for all monitored environments.
  • Monitor and review of instance and Session Level Configurations parameters that may impact recoverability, manageability, and performance.
  • Managed/Monitored around 200+ DB’s across various Datacentre of Germany, US, Ashburn, Australia, China of various sizes from 1TB up to 40TB with INSIGHT monitoring system and Jira ticketing tool.
  • Installation and managing enterprise databases with RAC, Data Guard, ASM for high availability and scalability.
  • Capacity planning: Involved in adding Tablespaces, data files, monitoring space growth, tuning of memory, loading the data using SQL* Loader.
  • Successfully upgraded/migratedthe databases from 9i/10g versions to 10g/11gR2.
  • Successfully applied, oracle quarterly released CPU/PSU Critical Patches and version upgrades when needed for Linux and SUN.
  • Database Security: Enabling security policies and providing reports to SOX auditors.
  • Provide Root Cause Analysis reports and the problem resolution recommendations for all Sev1/P1 issues.
  • Involved in design and implementation of database and application disaster recovery (DR) and restoring using RMAN.
  • Developed and customized the shell/SQL scripts to monitor the database activity and also to automate the database tasks.
  • Performed Performance Tuning, ADDM, AWR and ASH. Performing SQL tuning and advising the developers. Creating indexes on tables and revising the PL/SQL code helped to running faster.
  • Recommendations for SQL statement tuning for SQL statements that are identified as impacting production performance.
  • Management of production databases in Primary/standby database environment and ensuring high availability. Also worked on replication tools like Golden Gate.
  • Managing RMAN Tape backups and ensuring the tape backup being performed onto tape using NetBackup/DD Boost. Worked extensively in restoring and recovering huge business critical databases using RMAN.
  • Successfully migrated the RMAN Backups from NetBackup to DD Boost Backup.
  • Database or table sizing, Tablespace management, Rollback (Undo) and Temp tablespace management.
  • Database instance cloning, database to be copied/cloned must be restored to server with the appropriate database software already installed.
  • Monitor and review all errors and events found in the database logs, trace files, and event logs as per the monitoring tool.
  • Customer facing role with end to end delivery, accountable for managing SAP (Success Factors) Production Cloud Database Environment as Technical Solution Delivery Manager for Oracle DBA Team.
  • Responsible for the delivery for Oracle Database support as single point of contact for all escalation or issues related to project and work across various Data centres.
  • Managed all outstanding help desk tickets to ensure timely resolution and coordinate all technical activities regarding and covered databases.
  • Primary contact for communication of any technical activities or problems, ensure the quality and timeliness of deliverables, and organize and conduct weekly status meetings with the client.
  • Advise the client on any Hardware or Software issues that prevent from fulfilling the responsibilities.
  • Participation in DB operational architectural review and Infrastructure upgrade reviews/evaluation on a monthly basis.
  • Communicating with Client on the progress of various task items.Production Support Management, SLA tracking
  • Review of Project documentation (e.g. solution design documents)
  • Managing the Team of 12+ FTE’s Oracle DBA’s.
  • Working as a DBA in 24/7 production database support environment.

Environment: 11gR2 RAC, RMAN, Data guard, ASM, Performance tuning, Auditing, PSU/CPU Patching, Upgradation, Database Cloning, Flash Back Technology, Critical DB Recoveries, Data Migrations, Storage Migrations, Golden Gate (GG), EM Grid Control, Solar Winds, Shell Scripting, Solaris, Linux, Unix.

Confidential, San Diego, CA

Sr. Oracle DBA - Senior Subject Matter Expert (SME)

Responsibilities:

  • Transitioning the new clients support like CricketWireless to Confidential DBA Support.
  • Performing database health checks, evaluating & troubleshooting Database performance and capacity related issues.Monitor, review and resolve database space management and capacity issues for all monitored environments.
  • Monitor and review all errors and events found in the database logs, trace files, and event logs as per the monitoring tool for various sized DB’s from 500GB to 14TB.
  • Implemented 11G Grid Control setup and Agent Installation using Pull Method for multiple targets on different platforms.
  • Performed performance Tuning, ADDM, AWR and ASH. Performing SQL tuning and advising the developers. Creating indexes on tables and revising the PL/SQL code helped to running faster.
  • Recommendations for SQL statement tuning for SQL statements that are identified as impacting production performance.
  • Performing database refreshes (RMAN cloning) and replication from Production to Test/UAT for analysis, reporting, testing and development as per the request.
  • Patches: Applying oracle patches on databases and version upgrades when needed for Sun and Linux OS.
  • Managing RMAN backup and generate backup report from OEM and restore when required.
  • Managing OEM Repository for Prod and Dev environment.
  • Developed and customized the shell/SQL scripts to monitor the database activity and also to automate the database tasks.
  • Interacting with the vendors - under critical situations for oracle technology.
  • Installation and managing databases on RAC, Data Guard, ASM for high availability and scalability.
  • Accountable for managing Confidential Production Database Environment as a Sr. Subject Matter Expert (SME) for Oracle DBA Team.
  • Code review for any code deployment in Prod/UAT and Work with application for deploying the code in required environment.
  • Provide Root Cause Analysis reports and the problem resolution recommendations for all Sev1/P1 issues.
  • Worked as anOracle DBA in 24/7 production database support environment.

Environment: 11gR2 RAC, RMAN, Data guard, ASM, Performance tuning, Auditing, PSU/CPU Patching, Upgradation, Database Cloning, Flash Back Technology, Critical DB Recoveries, Data Migrations, Storage Migrations, Golden Gate (GG), EM Grid Control, Solar Winds, Shell Scripting, Solaris, Linux, Unix.

Confidential, Boston, MA

Sr. Oracle DBA - Senior Subject Matter Expert (SME)

Responsibilities:

  • Performing day-to-day database monitoring, troubleshooting space and memory issues as per the OEM monitoring tool and customised shell scripts and resolved all the issues for the monitored environments of various sized DB’s from 30GB up to 18TB’s
  • Installed Oracle 11.2.0.1 two node RAC on Sun Solaris10 using VERITAS SFRAC and CFS for database data files and migrated single instance to two Nodes 11g RAC
  • Upgraded Oracle RAC 10.2.0.4 and 11.2.0.1 databases to 11.2.0.2 and 11.2.0.3 databases for Business Critical Applications.
  • Setting up the new database Infrastructure of Confidential as per the new requirements of Life cycle projects.
  • Successfully Deployed the Mass deployment of EM Agents Builds and automation of the same saving large amount of time for implementing the same
  • Automation of repeated complex tasks like Schema/Data Refreshes, database creation and Health Checks for the databases
  • Supporting RCA for all SEV1, Change Failure for the Service Level / technology
  • Setting and Automating the RMAN backups and Quarterly Testing Backups for critical Production databases
  • Setting up DR Physical standby database/Data guard and managing the same.
  • Documenting all the new processes implemented (Like EM agent build, 11gR2 upgrade, Streams setup, etc.).
  • Applying CPU/PSU and One-off patch set.
  • Upgrading 10.2.0.4 to 11.2.0.1 and 11.2.0.1 to 11.2.0.2 for Dev/UAT/Prod databases
  • Manually database failover using VCS during planned downtime.
  • Cloning Using RMAN, Converting single Instance database to RAC database Instances
  • Creating / Reviewing the Run Book or Tech plan for any change to be implemented on Prod.
  • Deep dive to resolve complex prod issues and perform the root cause analysis
  • Interacting with the vendors - under critical situations for oracle technology, Working with Oracle Support for Critical Production issues and maintaining the log of number of bugs faced and patches applied
  • Generating the SOX auditing related information to management.
  • Implemented Oracle 11.2.0.3 two node RAC on Sun Solaris10 for Business Critical Applications using VERITAS SFRAC and CFS for database data files
  • Implemented Oracle 11.2.0.1 Streams Bi-Directional replication setup, providing Update/Customs handlers for data conflicts
  • Implemented 11G Grid Control setup and Agent Installation using Pull Method for multiple targets on different platforms
  • Implemented Two nodes 10g RAC on Red Hat Linux with VMware on Windows and Oracle 11g Single instance Installation on Oracle Solaris with Oracle Virtual Box on Windows as POC.
  • Ascertaining adherence to transition process and smooth transition of all Oracle related activities to IBM.

Environment: 11gR2 RAC, RMAN, Data guard, ASM, Performance tuning, Auditing, PSU/CPU Patching, Upgradation, Database Cloning, Flash Back Technology, Critical DB Recoveries, Veritas, Data Migrations, Storage Migrations, SRDF, Golden Gate (GG), EM Grid Control, Shell Scripting, SME, Solaris, Linux, Unix.

Confidential

Sr. Oracle DBA - Team Leader

Responsibilities:

  • Monitor/Resolve the issues assigned through BMC Remedy ticketing system.
  • Managed/monitored around 500+ DB’s of various sizes from 5GB up to 17TB.
  • Implemented Oracle 9i (9.2.0.8) RAC on Sun Solaris9 using VERITAS CFS for database data files for client Confidential the Largest Telecom service provider of Australia and migrated single instance to two Nodes RAC.
  • Installed 9i/10g RAC and built databases for various requirements. Built over 12+ databases.
  • Involved in design and implementation of disaster recovery (DR) and successfully setup the DR (Disaster Recovery) using Physical and Logical Standby DB’s as per the client requirement.
  • Involved in setting up and testing the RMAN Backups for new Project builds.
  • Used Tape backups for databases using NetBackup. Involved in restoring huge databases using RMAN and NetBackup.
  • Performed QA for databases before the database go live.
  • Involved in proactive and reactive Performance Tuning using ADDM, AWR and ASH. Performed SQL tuning and advised the developers.
  • Developed and customized the shell/SQL scripts to monitor the database activity and also to automate the database tasks.
  • Implement Oracle Critical Patches and version upgrades when needed for 8i/9i/10g DB’s on Sun, Linux.
  • Successfully Deployed the Mass deployment of EM Agents Builds and automation of the same saving large amount of time for implementing the same.
  • Registering the EM agent with Repository and Troubleshoot / fix EM agent related issues.
  • Created / reviewed the Run Book or Tech plan for any change to be implemented on Prod.
  • Work with the vendors - under critical situations for oracle technology, Working with Oracle Support for Critical Production issues and maintaining the log of number of bugs faced and patches applied
  • Expertise in different flavours of UNIX like IBM AIX, HP Unix, Sun Solaris, Linux.
  • Served as the Member of Technical Interview panel
  • Technically managed Confidential Australian Telecom Project as Team Lead with 20+ member’s team of Oracle DBA with IBM.
  • Distinctively followed the IBM GDF processes and made sure project is compliant with all GDF processes.

Environment: 8i/9i/10/11gR2 RAC, RMAN, Data guard, ASM, Performance tuning, Auditing, PSU/CPU Patching, Upgradation, Database Cloning, Flash Back Technology, Critical DB Recoveries, Data Migrations, Storage Migrations, EM Grid Control, Shell Scripting, Solaris, Linux, Unix.

Confidential, NYC, NY

Sr. Oracle DBA Tech Lead, Senior Software Specialist

Responsibilities:

  • Monitoring and fixing the issues ticket using Remedy for production activities.
  • Monitoring and fixing the Alerts which send alerts to Mailbox/Mobile/cell using third party tool Alarm Point on Demand
  • Setting DR/COB servers - Physical Stand by Databases (Data guard) and Maintenance
  • Switch over and Switch back during any scheduled/unscheduled maintenance. Maintain the Data guard broker configurations (for any used environment). Maintain the standby database to ensure it is operational and being maintained.
  • Scaling down the response time of queries below the targets set (as per Organizational standards)
  • Involved in proactive and reactive Performance Tuning using ADDM, AWR and ASH. Performed SQL tuning and advised the developers.
  • Code review for any code deployment in Prod/UAT and Work with application for deploying the code in required environment.
  • Provide Root Cause Analysis reports and the problem resolution recommendations for all Sev1/P1 issues.
  • Developed and customized the shell/SQL scripts to monitor the database activity and also to automate the database tasks.
  • Designedand implementedtheRMAN backup strategies as per client requirements and monitoring the same.
  • Technically managed MetLifeproject as Tech Lead with 12 member’s team of Oracle DBA.

Environment: 8i/9i/10/11gR2 RAC, RMAN, Data guard, ASM, Performance tuning, Auditing, PSU/CPU Patching, Upgradation, Database Cloning, Flash Back Technology, Critical DB Recoveries, Data Migrations, Storage Migrations, EM Grid Control, Shell Scripting, HP-UX 11&11i, IBM AIX 4.3-5.1,Solaris, Red hat, Veritas.

Confidential, NY

Team Lead - Oracle DBA

Responsibilities:

  • Handled multiple databases for Citibank USA GWMDBA (Global Wealth Management) supporting various Applications like Business Intelligence, Single Sign On, Risk Reports, Project One, One Source, CARE, CCS, Info links, Plan View, Oreas etc.
  • Implemented Oracle 10g RAC on HP-UX 11i with Service guard Ex-tension For RAC (SGeRAC) using SLVM VG (Shared Raw Logical Volume Manager) for Oracle RAC database data files for client NRI (Nomura Research Institute Limited) Japan
  • Implemented Oracle 9i RAC on Sun Solaris10 with Veritas Storage Foundation for Oracle RAC 5.0 (SF RAC) using Veritas CFS for database data files for client Deutsche Bank.
  • Implemented Single Instance Oracle 9i Data guard on Sun Solaris10 for 2 Node RAC for the client Deutsche Bank. Successfully performed Switchover and Failover
  • Carried out the Offshorization of database activities by successfully transitioning Citibank USA GWMDBA - New York Project and setup infrastructure at offshore for supporting the activities
  • Performed Backup and recovery using Hot/Cold backup, exp/imp, RMAN.
  • Applying Security Patches and Patch set, upgradation for Dev/QA/Test/Prod
  • Unix Shell Scripting for automating the tasks
  • Setting DR/COB servers - Physical Stand by Databases (Data guard) and Maintenance
  • Scaling down the response time of queries below the targets set (as per Organizational standards)
  • Monitoring Tivoli Alerts, Ticket using VT (Virtual Ticketing system), Infoman and package release from change management team for production activities
  • Setting up the databases to support multilingual languages
  • Managed the team of Oracle DBA’s with Confidential for the clients Deutsche Bank and Citibank.
  • Served as the member of Technical Interview panel

Environment: 9i/10g RAC, RMAN, Standby Databases, Performance tuning, Auditing, PSU/CPU Patching, Upgradation, Database Cloning, Critical DB Recoveries, HP-UX 11&11i, IBM AIX 4.3-5.1,Solaris,Red hat and Veritas

Confidential, NYC, NY

Shift Lead DBA / Senior Software Engineer

Responsibilities:

  • Working as a shift lead, supporting the NBC (News Broadcasting Channel) and Universal Studios as Production DBA on behalf of Confidential (General Electric) for multiple location New York, Los Angeles and UK, Universal Studio is in Entertainment Business and their TV shows tops the rating in United Stated. There are approx. 300+ databases and availability of these databases for 24 x 7 is highly critical to their business.
  • Installation & Creation of Oracle Database Server with ASM, Real application Cluster (RAC) on Linux.
  • Monitoring and database health checks
  • Backup and recovery using Hot/Cold, exp/imp, RMAN, SQL-Back Track, CommVault Galaxy Backup & Recovery.
  • Applying Security Patches and Patch set Upgradation for Dev/QA/Test/Prod.
  • Unix Shell Scripting for automating the tasks.
  • Monitoring and coordinating Database Application Outage activities
  • Setting up the monitors for the databases using third party tools like BMC-Patrol, Site scope and Insight.
  • Setting DR servers - Physical Standby Databases/Data guard and Maintenance.
  • Scaling down the response time of queries below the targets set (as per Organizational standards)
  • Giving Support to various applications such as SAP Databases, People soft, JD Edwards Enterprise One ERPs and other internal application.
  • Involved in Transition from offshore for NBCUI.
  • Mentoring other team members.
  • Member of Technical Interview panel.

Environment: 7.x/8i/9i/10g RAC, RMAN, Standby Databases, Performance tuning, Auditing, PSU/CPU Patching, Upgradation, Database Cloning, Critical DB Recoveries, HP-UX 11&11i, IBM AIX 4.3-5.1,Solaris and Redhat, Veritas.

Confidential

Oracle DBA

Responsibilities:

  • Managed billing and non-billing databases with Data centre of Orange Hutchison Max (Telecom) as Production DBA.
  • Installation & Creation of Oracle Database Server on Solaris
  • Database Maintenance, Backup & Recovery, Application Performance Tuning On Solaris 8.0/Linux/AIX/HP-Unix/Windows
  • Network Administration & Trouble shooting
  • Troubleshooting and maintaining Database issues of users
  • RMAN Setup/Backup/trouble shooting and Scheduled Hot Backup through Cron.
  • Database Cloning Using RMAN
  • Production Database sizing, Creating and Testing of Database server
  • Cloning the QA databases from Prod Env, and Perform Schema refresh using export and import of data
  • Loading Data Using Oracle utility SQL-Loader
  • Query tuning using TKProf utility (Trace Kernel Profile) & Explain Plan Table for finding query statistics/performance
  • Proactively Monitoring the Database and its Alert Log
  • Proactively Monitoring the OS for Space Utilization and Database Archive Destination by setting up alerts
  • Backing the dump files & DB Backup to DLT, DAT
  • Applying Security Patches for Dev/QA/Test/Prod
  • Unix Shell Scripting for automating the tasks

Environment: 8i/9i DB’s, RMAN, Standby Databases, Performance tuning, Auditing, CPU Patching, Upgradation, Database Cloning, Critical DB Recoveries, DB refreshes.

Hire Now