We provide IT Staff Augmentation Services!

Lead Oracle Database Administrator Resume

Tampa, FL

SUMMARY:

  • 10+ years of diverse industry experience in Planning, Installing, Configuring, Managing, and Tuning Oracle databases on various UNIX and Windows Platforms.
  • Experience in designing and implementing right Backup and Recovery strategies using RMAN, and conventional Hot/Cold backup methods for Oracle 12c/11g/10g/9i databases on UNIX and Windows Platforms. Experience in guiding managed backup administrators in implementing backup.
  • Expertise in Oracle’s Data protection and high availability technologies such as Oracle RAC, Oracle Data guard, ASM, and Oracle goldengate.
  • Experience in administration and tuning of Oracle databases running on Windows and all types of UNIX platforms.
  • Experience in Oracle Grid Infrastructure implementation, administration, and performance tuning on ASM and implementing Third party clusterware file systems.
  • Experience in Data guard for different types of Standby Databases such as Active for reporting, Physical, Logical, and Snapshot Standby Databases on implementation, administration, and performance tuning.
  • Experience in implementation, configuration, troubleshooting, and performance tuning of Oracle Goldengate replication between Unidirectional, bidirectional, and cascaded Oracle Databases.
  • Experience in Performance Tuning of Oracle Databases with respect to all aspects of IT Infrastructure such as Network, OS, Storage, and Application.
  • Experience in Migrating and upgrading Databases from one platform to another and from one version to another version respectively, and applying various Oracle Patches for better security, performance, and health.
  • Experience in using various performance tools or utilities like EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR, ASH, and ADDM, and analyzing reports for tuning recommendations.
  • Experience in implementing Oracle Enterprise Manager Grid Control (11g) and Cloud Control (12c) for database monitoring/performance/diagnostics.
  • Experience in implementing desired database backup solutions based on environment, affordability, and other key IT Infrastructure aspects. Experience with Oracle RMAN backup utility and in traditional hot (online/cold (offline) backups, Experience in logical backups and Database migration tools such as DATA PUMP, Export/Import, and Transportable Tablespaces.
  • Experience in writing/modifying UNIX Shell Scripts for various scenarios and requirements.
  • Experience and knowledge in managing very large Data Warehouse databases.
  • Experience in implementing Oracle flashback Technology and utilizing it for various rollback purposes such as Critical Application bug fixes, Load Testing, and QA Testing.
  • Experience in Capacity Planning and Benchmarking.
  • Experience in leading and managing teams on multiple roles - Team Lead, Level 3/4 support.
  • Experience in managing Oracle EBS and SAP environment systems.
  • Effective communication skills, interpersonal skills, self-motivated, quick learner, team player.
  • Oracle Certified Professional and ITIL V3 foundation certified Professional.

TECHNICAL SKILLS:

Operating systems: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, 5.3,AIX, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.5 and Windows 95/98/ME/NT/2000/XP.

Databases: Oracle 9i, 10g, 11g, 12c. SQL Server 2005/2008/2012.

Oracle Database Tools: SQL*Loader, TKPROF, Toad, OEM, SQL Developer, Oracle warehouse builder and Grid Control.

Tools: AWR, ADDM, Export/Import, RMAN, Data Pump, ERWIN, TKPROF, Golden gate, EXPLAIN PLAN,STATSPACK, ASM, ODBC, RMAN, Tivoli Storage Manager and Oracle Management Service(OMS).

Languages: C, SQL, Unix shell scripts, PL/SQL.

Web Tools: HTML, XML, SQL NET, TCP/IP.

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, FL

Lead Oracle Database Administrator

Responsibilities:

  • Lead Database Administrator overseeing all things going in and out of Oracle Database platform right from reviewing Database changes to optimal maintenance of Databases and guiding team in making sure Databases are optimal all times and available 100%.
  • Performing review of below items and take the lead to implement, and otherwise making sure they are tested against all possible scenarios including performance and implemented by the team.
  • Oracle’s critical patch updates, Patches for Bug fixes.
  • Yearly Capacity Planning of all environments from Development to Production to DR.
  • Initialization parameter changes.
  • Operating system patching and Upgrades.
  • Changes to GoldenGate replication such as adding new tables or new schemas etc..
  • Weekly load testing results.
  • All changes in and out of Oracle Database in all environments (Dev/QA/UAT/Prod/DR).
  • Understanding requirements of various Database business use cases and designing the right and cost-effective infrastructure for Databases.
  • Documenting Standard Database operating procedures.
  • Implementing Oracle Data Guard and designing the Database Disaster Recovery.
  • Performing Switchover and Switchback of Data Guard Services.
  • Implementing Oracle RAC with Oracle Clusterware and Oracle HA with third party Clusterwares, Adding and removing nodes based on capacity sizing/restructuring.
  • Tuning different parameters of the Database for various reasons.
  • Configuring and administering Golden gate.
  • Designing Backups and Performing Recoveries when required using Recovery Manager (RMAN), Flashback, and Oracle Datapump.
  • Performing Flashback of tables and databases for various requirements and in case of any human errors.
  • Installation and Upgrade of Oracle Software, Applying CPU, PSU and Interim Patches.
  • Migration of Databases from one platform to another platform.
  • Uploading Data from Flat File, excel spreadsheets, and various other sources into Database by understanding, evaluating, and optimizing the best method of Data upload.

Environment: Oracle 12c/11g/10g databases on Linux servers, AIX 5.3, Windows 2000/2003 servers, Windows 2003 Server IBM DS8300 Storage. Oracle warehouse Builder, AWR, ADDM, Explain Plan, IMPDP/EXPDP, RMAN, Tivoli Storage Manager.

Confidential, Santa Clara, CA

Senior DB Administrator

Responsibilities:

  • Responsible for leading team providing critical production database support for Applied Materials customer.
  • Responsible for managing SAP databases using BR Tools.
  • Performance tuning, query tuning for various database issues.
  • Database backup, restore, recovery.
  • Responsible for doing database cloning, monitoring
  • Installation and configuration of Oracle 8i/9i/10g/11g databases on HP-UX, AIX, Sun Solaris, Linux and Windows servers.
  • Configuring & managing Oracle Grid Control.
  • Oracle standby management for high Availability (Data Guard)
  • Database Patching, upgradation & migration
  • Oracle Applications administration.
  • Performing DR-Drill Activities
  • Designing & implementing Disaster recovery plans.
  • Implementation of best practices.
  • Interaction with the application team to resolve various issues.

Environment: Oracle 11g/10g databases on HP-Ux, Solaris, Linux servers and Windows 2000/2003 servers, Windows 2003 Server IBM DS8300 Storage. Oracle warehouse Builder, AWR, ADDM, Explain Plan, IMPDP/EXPDP, RMAN, Veritas Volume Manager.

Confidential

Senior Database Administrator

Responsibilities:

  • Configure RMAN Backups to Tape with Media Management Library (TSM)
  • Responsible for Oracle Software (9i/10g/11g) installation on Linux, Sun Solaris, Aix, HP-Ux
  • Responsible for Oracle Application & PeopleSoft Applications database Administration.
  • Implementation & maintenance of Oracle Real Application Clusters.
  • Object re-organization & index rebuild in Oracle production databases.
  • Performance tuning, query tuning for various database issues.
  • Database backup, restore, recovery using Oracle RMAN.
  • Responsible for configuring & managing Oracle Streams.
  • Other activities like database Patching, cloning, monitoring.
  • Implementation of best practices.
  • Interaction with the application team to resolve performance issues.

Environment: Oracle databases on Sun Solaris, AIX and Linux servers on Windows 2000/2003 servers, Tivoli storage manager technology & IBM DS8300 Storage.

Confidential

Oracle DB Administrator

Responsibilities:

  • Responsible for providing critical production database support for HP Clients
  • Responsible Cloning, Patching, upgrade & migration.
  • Responsible for performing bank BOD and EOD activities related to database.
  • Data Guard Administration & cascaded standby database management.
  • Performance tuning, query tuning for various database issues.
  • Database backup, restore, recovery activities.
  • Other activities like database cloning, monitoring
  • Installation and configuration of Oracle 8i/9i/10g databases on HP-Ux & AIX servers.
  • Scheduling/monitoring/maintaining various jobs through autosys scheduling tool.
  • Implementation of best practices.
  • Interaction with the application team to resolve various issues.

Environment: Oracle 8i/9i/10g, Hp-Ux, EMC Storage.

Hire Now