We provide IT Staff Augmentation Services!

Senior Oracle Dba Resume

3.00/5 (Submit Your Rating)

SUMMARY:

  • Over 15 years of IT experience at leading corporations and consulting service providers with hands - on experience and success in Oracle database administration, disaster recovery, installations and upgrades, and high availability solutions.
  • Database Administration & Management
  • Database Security Management
  • Database Configuration and Installation Planning
  • Database Performance Monitoring & Tuning
  • Database Backup and Recovery
  • Database Physical and Logical Design
  • Database Monitoring and Alerts Automation
  • Database Backup and Recovery Scripts Design and Implementation
  • Project Coordination & Management
  • Consultation to Application Developers
  • Oracle Software Contracts Negotiation

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle DBA

  • Managed multiple production and non-prod Oracle DB systems (8.0 to 11g r2) on Solaris, AIX, and Linux from a few GB to 27 TB.
  • Tasks included database optimization and performance tuning, database sizing and growth projections, developing and implementing backup and recovery procedures, restoral testing, database installation, monitoring and maintaining the databases and resolve locking issues.
  • Utilized various tools and technologies like Dell and Sun servers, SANs, virtualization (Solaris zones/containers and VMware), VCS, ZFS pools, etc.
  • Used Oracle tools and related software including OEM Grid Control, AWR, Statspack, RMAN, Data Pump, SQL Developer, Spotlight, Toad, etc.
  • Authored scripts for backup and recovery, monitoring, performance tuning, reporting etc.
  • DBA Team Lead over 5 DBAs.
  • Our team managed 270 databases including DW, Informatica, Remedy, ESB, Sterling, Blade Logic, Avaya, ESB, CADTEL and ViryaNet databases.
  • DBs sizes range from a few GB to 27 TB.
  • Managed the daily tasks and projects of a culturally diverse team located in multiple locations.
  • Mentored and assisted team members with disaster recovery, tuning and troubleshooting issues.
  • Conducted interviews and participated in hiring decisions along with the DBA manager in order to acquire the best talent for our team.
  • Performance Tuning, stability and security
  • Experience tuning databases at all levels by optimizing server, storage, database and SQL.
  • Designed scripts that collected tuning metrics on all production databases.
  • Designed custom reports that pulled metrics from OEM on backups, DB growth, etc.
  • Authorized the standards for stability and security
  • Disaster Recovery
  • Performed backup and recovery using RMAN
  • Performed backup and recovery using SAN snap (Timefinder and SRDF) for databases.
  • Cloned and refreshed various database instances RMAN, Data Pump and EXP/IMP.
  • Designed scripts for backup/recovery, cloning and refreshes
  • Oracle Enterprise Manager Grid
  • Managed repository
  • Worked with team members on deployment of the OEM Agent and configuration in Grid
  • Developed reports to extract Oracle Management Pack usage in OEM
  • Oracle Licensing
  • Performed internal audit of our Oracle licensing.
  • Created scripts to track our Oracle licensable features usage on all our Oracle databases.
  • Work with company license officer to get approvals for deploying Oracle software.
  • Worked with team members to ensure compliancy.
  • Security
  • Authored Oracle database security policy.
  • Authored steps for implementing the security policy in new database builds.

Confidential

Senior Oracle DBA

  • Managed multiple production and non-prod Oracle DB systems (8.0 to 11g r2) on Solaris, AIX, and Linux from a few GB to 27 TB.
  • Tasks included database optimization and performance tuning, database sizing and growth projections, developing and implementing backup and recovery procedures, restoral testing, database installation, monitoring and maintaining the databases and resolve locking issues.
  • Utilized various tools and technologies like Dell and Sun servers, SANs, virtualization (Solaris zones/containers and VMware), VCS, ZFS pools, etc.
  • Used Oracle tools and related software including OEM Grid Control, AWR, Statspack, RMAN, Data Pump, SQL Developer, Spotlight, Toad, etc.
  • Authored scripts for backup and recovery, monitoring, performance tuning, reporting etc.

Confidential

Senior Oracle DBA

  • Managed 7 production and 23 non-prod Oracle DBs systems on Linux and Windows.
  • Managed databases ranging from a few GB to 1 TB which included OLTP, BI, Data Warehouse, Informatica and E-Business Suite (EBS)/Oracle Applications (11i, R12) databases on Oracle 10gR2 and 11gR2.
  • Utilized various tools and technologies like Dell and Sun servers, EMC CLARiiON and Isilon SANs, VMware, Evault, Extra Putty, Visio, etc.
  • Used Oracle tools and related software including OEM Grid Control, AWR, Statspack, RAC, Goldengate, Data Guard, RMAN, Data Pump, SQL Developer, Spotlight, Toad, etc.
  • Tasks included database optimization and performance tuning, database sizing and growth projections, developing and implementing backup and recovery procedures, database installation, upgrades and migration, database reorganization, table and index partitioning, monitoring and maintaining the databases and resolve locking issues.
  • Installed, upgraded and administered OEM Grid (10g and 11g) to monitor all database servers, databases and RMAN backup jobs.
  • Setup customized OEM alert schedules and rules with escalation paths for prod systems.
  • Spearheaded the evaluation, testing and installation of Oracle upgrades and patches including upgrades from 10gR2 to 11gR2 and 11.2.0.1 to 11.2.0.2
  • Administered ASM and Grid Infrastructure using ASMlib, oracleasm, svrctl and asmcmd.
  • Responsible for proactive and reactive monitoring and tuning of databases and apps.
  • Authored scripts for backup and recovery, monitoring, performance tuning, reporting etc.
  • Performed backup and recovery using RMAN for OLTP, BI, Data Warehouse and Oracle Applications databases.
  • Cloned and refreshed various database instances using RMAN and Data Pump.
  • Architected and deployed complete HA disaster recovery solutions using RAC, Golden Gate, Oracle Physical Data Guard and RMAN for local and offsite DR.
  • Administered two node RAC cluster.
  • Provided first and second level support for Oracle databases in a 24x7 environment.
  • Centralized management of all RMAN jobs inside of the OEM and RMAN repositories.
  • Managed the Wholesale High Availability project from end to end. Duties included develop business case, project plans, schedules, Visios and coordination with management, development, system administrators and QA.
  • Utilized RHAT, SUSE, Oracle Enterprise Linux and Windows operating systems.

Confidential

Senior Oracle DBA (Consultant)

  • Worked on Oracle 10gR2
  • Managed databases ranging from a few GB to 500 GB which included OLTP and Data Warehouse databases.
  • Administered two node RAC cluster.
  • Provided first and second level support for Oracle databases in a 24x7 environment.
  • Responsible for proactive and reactive monitoring and tuning of databases and apps.
  • Authored scripts for backup and recovery, monitoring, performance tuning, reporting etc.
  • Used Oracle tools and related software including OEM DB Control, SQL Developer, SQL*Plus, Oracle Performance Pack, Data Pump, RMAN, Statspack, TKPROF and custom designed scripts written in SQL and PL/SQL for monitoring and optimization.
  • Utilized RHAT, SUSE and Windows operating systems.

Confidential

President (Independent Consultant)

  • Worked with Oracle 9i and 10g databases.
  • Installation and configuration of Oracle database software.
  • Setup and administered two node RAC cluster.
  • Performed database optimization and performance tuning.
  • Developed and implemented backup and recovery procedures and scripts.
  • Responsible for proactive and reactive monitoring and tuning of databases and apps.
  • Cloned and refreshed various database instances using RMAN and Data Pump.
  • Tasks included database installation, upgrades and migration, monitoring of the databases.
  • Authored scripts for backup and recovery, monitoring, performance tuning, reporting etc.
  • Provided first and second level support for Oracle databases in a 24x7 environment.
  • Managed all Dev, Test and Production databases.
  • Headed up the evaluation, testing and installation of Oracle upgrades and patches including upgrades from 9iR2 to 10gR2.
  • Tasks performed using OEM Grid Control and DB Control, SQL Developer, SQL*Plus, Oracle Performance Pack, Data Pump, RMAN, TKPROF and custom designed scripts written in SQL and PL/SQL for monitoring and optimization.
  • Utilized RHAT and Windows operating systems.

Confidential

Senior Oracle DBA

  • Worked with Oracle 8.0, 8i and 9i databases on multiple Windows NT and 2000 servers.
  • Managed DBs ranging from a few GB to 700 GB which included Web and E Commerce.
  • DBA tasks performed included database optimization and performance tuning, developing and implementing backup and recovery procedures, database installation, upgrades and migration, monitoring and maintaining the databases and resolve locking issues.
  • Provided first and second level support for Oracle databases in a 24x7 environment.
  • Responsible for proactive and reactive monitoring and tuning of databases and apps.
  • Developed and implemented backup and recovery procedures and scripts.
  • Tasks performed using DB Artisan, Quest Toad, OEM Grid Control and DB Control,, SQL*Plus, DBA Studio, Server Manager, EXP, IMP, Developer/2000, RMAN, EBU, Netbackup, Veritax, PERL, TKPROF and custom designed scripts written in SQL and PL/SQL for monitoring and optimization.
  • Worked with SQL Server DBAs and system admins to implement clustering and SAN storage on production servers using MS and Veritas (VCS) Clustering on Windows NT.
  • Mentored SQL Server DBAs in Oracle DB admin and was backup DBA for SQL Server.
  • Utilized Windows operating systems.

Confidential

Senior Oracle DBA

  • Managed databases ranging from a few GB to 650 GB which included OLTP, Data Warehouse, Vantive (7 and 8) and Oracle Applications (10.7, 11i) databases.
  • Administered multiple Oracle 7.3, 8.0 and 8i (8.1) databases.
  • Performed backup and recovery of OLTP, Data Warehouse, Vantive (7 and 8) and Oracle Applications (10.7, 11i) databases.
  • Tasked with startup and shutdown of Oracle Applications processes when needed.
  • Utilized various tools and technologies on Sun Sparc 4000 and 6000 Servers.
  • Duties included database optimization and performance tuning, developing and implementing backup and recovery procedures, database installation, upgrades and migration, monitoring and maintaining the databases and resolve locking issues.
  • Tasks performed using Quest DBA tools (I Watch and Spotlight), SQL-BackTrack, SQL* Plus, Enterprise Manager, Sever Manager, Oracle Performance Pack, EXP, IMP, Developer/2000, RMAN, EBU, Netbackup, Veritas and custom designed scripts written in SQL and PL/SQL for monitoring and optimization.
  • Directed DBA team activities and helped mentor junior members.
  • Utilized Solaris operating system.

Confidential

Senior Oracle DBA (Consultant)

  • Managed multiple Oracle 7.3, 8.0 and 8i (8.1) DBs for Wild Oats on Sun Sparc 5000s.
  • Administered 25 different Peoplesoft (7.02 Fin and 7.05 HR/Payroll) databases and 1 JDA Data Warehouse database along with four other testing databases. These databases varied in size from 2 to 43 GB.
  • Tasks included database optimization and performance tuning, database sizing and growth projections, developing and implementing backup and recovery procedures, database installation, upgrades and migration, database reorganization, table and index partitioning, monitoring and maintaining the databases and resolve locking issues.
  • Utilized SQL*Plus, Enterprise Manager, Server Manager, Oracle Performance Pack, EXP, IMP, Developer/2000, RMAN, EBU, Netbackup, Veritas and custom designed scripts written in SQL and PL/SQL for monitoring and optimization.
  • Support and training activities included query optimization, code review, technical resource, and DBA techniques and training.
  • Offsite administration of Edmunds.com databases. Tasked with evaluation, setup and tuning of an Oracle 7.3, 8.0 and 8i databases on Sun Sparc Server 5000 and DEC Alpha.
  • For CorrLogic tasked with evaluation, setup and tuning of Oracle 7.3, 8.0 and 8i databases on Sun Sparc Server 5000 and IBM servers.
  • Utilized AIX and Solaris operating systems.

Confidential

Senior Oracle DBA (Consultant)

  • As a subcontractor to Accenture (formerly Andersen Consulting), tasked with administration of multiple Oracle 7.3 databases at Texas Instruments on multiple Sun Sparc Server 5000, 6000 systems and HP 9000s DBA for a major Data Warehouse project.
  • Managed five Oracle Data Warehouse databases from to 50 to 330 GB along with five Vantive 6 databases from 8 to 20 GB.
  • Tasked with the design and implementation of a Data Warehouse system estimated to grow to 2 TB. This system was fed by SAP and legacy databases.
  • Duties included designing optimal physical and logical layouts using a combination of striping (0+1) and JBOD disks schemas. Optimal layouts were designed and implemented for Oracle datafiles, redo logs, rollback segments, etc.
  • Tasked with database optimization and performance tuning, database sizing and growth projections, developing and implementing backup and recovery procedures, database migration, database reorganization, resolve locking issues, monitoring the databases.
  • Duties performed using SQL*DBA, SQL*Plus, Server Manager, EXP, IMP, Developer/2000, EBU/ADSM.
  • Utilized HPUX and Solaris operating systems.

Confidential

Senior Oracle DBA (Consultant)

  • As a subcontractor to Accenture (formerly Andersen Consulting) served as the team SAP ORACLE DBA for a major award winning SAP project at Bay Networks.
  • Administered nine SAP 3.0 (Ver C, E and F) databases ranging from 15 to 81 GB along with six WEB based databases ranging from 1 to 17 GB used for electronic commerce.
  • As the only SAP DBA assisted implementation of SAP 3.0c in nine months and upgrades to 3.0e and 3.0f, which received the technology award from the Smithsonian.
  • Tasks included database optimization and performance tuning, database sizing and growth projections, developing and implementing backup and recovery procedures, SAP database installs and upgrades, database reorgs, resolve locking issues and monitoring the databases.
  • Duties performed using SAPGUI, SAPDBA, SQL*DBA, SQL*Plus, Sever Manager and custom designed scripts written in SQL and PL/SQL for monitoring and optimization.
  • Tasked with testing and implementing optimal database layouts using RAID (i.e. 0, 1 and 5) and non-RAID layouts for load balancing of database I/O on SAP prod and dev systems.
  • Utilized Oracle 7.1 and 7.2 databases on Sun Sparc Sever 1000 and 5000.
  • Utilized Solaris and Open Windows operating system.

Confidential

Senior Oracle DBA (Consultant)

  • As a subcontractor to KPMG at Genstar Container, served as project DBA, managed Developer/2000 teams, Designer/2000 administrator.
  • Responsibilities included database optimization, developing and implementing backup and recovery procedures, installing/upgrading the database and Oracle toolset, resolve locking issues, monitoring and maintaining database environment, and administrating users.
  • Duties performed using SQL*DBA, SQL*Plus, Sever Manager and custom designed scripts written in SQL and PL/SQL for monitoring and optimization.
  • As Developer/2000 team lead, managed project resources and development staff
  • Utilized Oracle 7.1 on Dell NT servers
  • Duties performed using Oracle Designer/2000 and Oracle Developer/2000 toolset.
  • Utilized Windows operating system.

Confidential

Senior Oracle DBA (Consultant)

  • At Rocky Mountain News setup Oracle Parallel Server on a DEC VAX system.
  • Tasked with database optimization, developing and implementing backup and recovery procedures, installing/upgrading the database and Oracle toolset, resolve locking issues, monitoring and maintaining database environment.
  • Duties performed using SQL*DBA, SQL*PLUS, Sever Manager and custom designed scripts written in SQL and PL/SQL for monitoring and optimization.
  • Utilized Oracle 7.1 and VMS on DEC VAX system

Confidential

Senior Oracle DBA (Consultant)

  • At US West, served as the technical manager, Oracle DBA and Case Administrator
  • Tasked with administrating the development, test and production instance databases.
  • Responsibilities included installing/upgrading the database and ORACLE toolset, monitoring and maintaining database environment, cloning various database instances and administrating users on the system.
  • Duties included installing, and administrating the Designer/2000 (V 1.0 and 1.1).
  • Tasked with developing and enhancing logical and physical data models, functional models, high-level system designs, DDL generation and FORMS 4.5 generation.
  • Co-managed project with client manager, managed client and consultant staff
  • Utilized Oracle 7.1 on NT servers and HP VIEW on the HP 9000.
  • Duties performed using SQL*DBA, SQL*PLUS, Sever Manager and custom designed scripts written in SQL and PL/SQL for monitoring and optimization.
  • Utilized HPUX and Windows operating systems.

Confidential

Senior Oracle DBA (Consultant)

  • At Cyprus Amax Minerals, served as Oracle DBA and Oracle Programmer Analyst.
  • Designed, developed and maintained a large information system which included a multi-million dollar invoicing system.
  • Tasked with overseeing production and development databases on three different HP9000 machines in two different states.
  • Upgraded all databases from Oracle 6 to Oracle 7 using EXP, IMP, SQL script files, SQL*DBA and Unix script files.
  • Tasked with tuning database system parameters, table definitions and memory allocations.
  • Wrote multiple Unix and PL/SQL scripts to automate DBA tasks such as backup and recovery, changing to a different instance of the database, monitoring database environment. Managed all Dev, Test and Production databases.
  • Wrote interface between the invoicing system and SQL*TIME financials package using Oracle 7 DDO link utilizing database trigger, packages, procedures and functions.
  • Directed programming staff's responses to production support issues, such as program bugs and requests for program modifications.
  • Performed system administration tasks including system users administration, backup and recovery, adding new printers, bouncing the system, changing system parameters.
  • Tasked with designing and maintaining the entire Accounts Receivable system.
  • Supported and enhanced the Oracle based SQL*TIME accounting system and programs. This included programming in SQL*Forms, PL/SQL, SQL*Reportwriter and SQR.
  • Additionally tasked with designing a documentation tracking system using Oracle. This included ERD diagrams and SQL*FORMS all entirely produced from Oracle Case.
  • Utilized HP VIEW, X WINDOWS and HPUX on HP 9000.

We'd love your feedback!