We provide IT Staff Augmentation Services!

Senior Dba Resume

New York, NY

SUMMARY:

  • Confidential has over fifteen years of experience in all phases of design, development, and implementation of computer applications.
  • He has worked for clients within the manufacturing, banking, logistics, insurance, and healthcare.
  • His areas of expertise include Oracle database technologies including Administration, Performance Tuning, Data Modeling, Data Engineering, Data Warehousing, Oracle Enterprise Manager, RMAN, and PLSQL, Disaster Recovery / High Availability (with Oracle 9i, 10g, 11g, 12c, RAC and Data Guard).
  • Confidential is adept at database implementations, developing and delivering end - user training, creating and maintaining database project schedules, and preparing and presenting project briefings to executives.
  • He has database management experience and has successfully led performance tuning and planning architecture for mission-critical database implementations.

SKILLS SUMMARY:

  • Oracle 10g, 9i and 8i
  • Database Design
  • Database Technical Architecture
  • Performance Tuning
  • Backup and Recovery / RMAN
  • Capacity Planning
  • Oracle Enterprise Manager
  • STATSPACK, UTLBSTAT/ESTAT, EXPLAIN, SQL TRACE, OWI, AUTOTRACE, TKPROF, AUDIT
  • Quest Spotlight Diagnostics
  • Oracle 10g Grid Control
  • Disaster Recovery / Data Guard
  • Oracle 10g Real Application Clusters (RAC)
  • Configuration and set up of OCFS and Automatic Storage Management (ASM)
  • Configuration of ASMLib (on Linux)
  • Advanced skills like Conversion of a Non-RAC environment to RAC based and migration from Oracle 9i to Oracle 10g R2 RAC.
  • Disaster Recovery with Oracle’s Data Guard and Standby DB
  • Set up Data Guard with Max Availability and Max Performance architectures
  • Monitoring Enterprise GRID/RAC environments using Oracle 10g Grid Control and DB control utilities
  • OCFS
  • HACMP\GPFS
  • DB2 on AS400
  • SQL Server 2000
  • MS Access
  • SQL Loader
  • Export / Import
  • Support Cognos on Oracle
  • Physical Data Modeling
  • ERWIN
  • Logical Data model / ERD
  • Q-Designer
  • IBM AIX 5.2
  • Solaris 2.6, 2.8
  • HP-UX 11
  • Windows 2000, NT 4.0, Win 95/98
  • Red Hat Linux
  • SUN 5500, v250
  • IBM S-80, S-85, M-80 / Regatta servers
  • Compaq DL580
  • Intel / Linux

PROFESSIONAL EXPERIENCE:

Senior DBA

Confidential, New York, NY

Responsibilities:

  • Performed daily Oracle DBA production support and system users request.
  • Refreshed non-production environments from production using cloning and snapshots.
  • Completed “Health Checks” on production environments to find performance issues and implemented tuning solutions.
  • Configured and maintained multiple physical Data Guard standbys on production systems.
  • Ensured valid RMAN database backups were kept current.
  • Patched, upgraded, migrated databases on several different platforms and versions.

Contract DBA

Confidential, Charlotte, NC

Responsibilities:

  • Performed daily Oracle DBA production support and system users request for Banner.
  • Refreshed non-production environments from production using cloning and snapshots.
  • Completed “Health Checks” on production environments to find performance issues and implemented tuning solutions.
  • Configured and maintained multiple physical Data Guard standbys on production systems.
  • Re-wrote the standard RMAN backups in conjunction with reconfigured Veritas backup retention policies for better retention plans and efficient tape usage.

Contract Oracle DBA

Confidential, Charlotte, NC

Responsibilities:

  • Performed daily Oracle DBA production support and system users request.
  • Refreshed DIT, SIT, UAT, and LT environments from production using cloning and snapshots.
  • Completed “Health Checks” on production environments to find performance issues and implemented tuning solutions.
  • Supported a two site multi-master Oracle replication configuration and fixed several configuration issues.
  • Configured and maintained multiple physical Data Guard standbys for large production systems.
  • Implemented Grid Control into the production and test systems for metrics monitoring.
  • Performed database upgrades from 9i to 10G, 10G to 11g and help the application group solve upgrade issues.
  • Re-wrote the standard RMAN backups in conjunction with reconfigured Veritas backup retention policies for better retention plans and efficient tape usage.
  • Tuned numerous SQL statements and database parameters for maximum performance gains.
  • Mentored application developers on how to build better code to execute faster.
  • Architected the blueprint design and roadmap for moving databases to Sun M9000 systems under functional domains with Oracle RAC.
  • Selected by senior management to roadmap Merrill Lynch’s database systems into existing architectures.

Principle Consultant

Confidential, Charlotte, NC

Responsibilities:

  • Identified and corrected numerous database and operating system performance issues on existing systems.
  • Created a new database infrastructure for an Oracle Portal\Business Intelligence installation.
  • Participated in gathering business requirements for a Business Intelligence solution.

Principle Consultant

Confidential, Charlotte, NC

Responsibilities:

  • Identified and corrected numerous database and operating system performance issues related to a $20 million dollar state education system implementation.
  • Re-implemented Confidential on a 3 node Windows 2003 environment using Automatic Storage Management (ASM) on an HP storage system.
  • Recommended changes the application connection pooling configuration for enhanced performance and stability.
  • Installed Oracle Clusterware between the two Linux 486 nodes and tested. Conducted RAC pre-installation environment checks and pre-requisite packages and libraries. Set up Network IPs and configured addresses for the private, public and virtual IPs.
  • Created mount points and mounted using specific NFS mount options.
  • Planned design of Physical and Logical disk layouts to place Oracle RAC datafiles. Configured SUN / Oracle Clusterware, installed CRS, and 10g RAC and created databases using DBCA. Setup and configured RMAN and installed Oracle 10g EM Grid Control.
  • Installed Oracle Clusterware between the two SUN 490 nodes. Conducted RAC pre-installation environment checks and pre-requisite packages and libraries. Set up Network IPs and configured addresses for the private, public and virtual IPs.

Contract Architect

Confidential, Charlotte, NC

Responsibilities:

  • Created a new data model for a data warehouse pilot project using Erwin.
  • Participated in gathering business and user requirement for a pilot project.
  • Worked with business analyst and end users to resolve other programming defects as needed.

Contract Data Warehouse Architect

Confidential, Charlotte, NC

Responsibilities:

  • Created a new data model to augment and integrate into the existing data warehouse.
  • Created shell scripts and PL\SQL packages to load mainframe extract files into the new data model.
  • Recommended different coding methods and changing Oracle database settings to improve the data warehouse performance and load times.

Contract Oracle DBA

Confidential, Raleigh, NC

Responsibilities:

  • Implemented Oracle RAC on a 2 node UNIX AIX using HACMP\GPFS clustering.
  • Trained the DBA staff on Oracle RAC administration.
  • Developed test plans and documentation of Oracle RAC failover and installation.

Contract Oracle DBA

Confidential, Herndon, VA

Responsibilities:

  • Designed a data model to bring two different active payroll systems together for a seamless and consistent reporting view of revenue and cost.
  • Tuned portions of the existing data model for better performance.

Contract Architect

Confidential, Charlotte, NC

Responsibilities:

  • Created a highly visible and mission critical PL\SQL and Perl batch application to process premiums for loading into the General Ledger. Calculate cash reserves as require by law and calculated premium accruals to report future revenue projections.
  • Collaborated as a team to create system requirement specifications and implementation plan for use by the development team.
  • Worked with business analyst and end users to resolve program defects.

DBA\Data Warehouse Architect

Confidential, Valley City, OH

Responsibilities:

  • Developed a data model representation of data, including logical and physical data structures, for effective database processing required for decision support and transactional systems.
  • Installed and configured a multi-node 9i RAC one tera-byte database.
  • Excellent troubleshooting and error correction with systems, programs and data.
  • Upgrades from version 7 to 8.1.7.4 and from 8.1.7.4 to 9.2.0.4.
  • Work with developers and change management team to ensure smooth life cycle progress from development through testing and production implementation.
  • Manage partitioned databases on RedHat Linux and Windows 2000 platforms.
  • Managed Oracle iStore 10.1 application server.
  • Thorough understanding of the complete project life cycle including requirement analysis, database design, development, testing and implementation.
  • Monitored remote and local databases for performance and tuned accordingly.
  • Configured RMAN to interface with Veritas NetBackup for the RDBMS systems backups using Grandfather, Father, and Son (GFS) methodology.
  • Provided first level application support by working with the development staff and end user community to address functionality questions and data utilization inquiries.
  • Extensive programming experience in PL/SQL, SQL, Stored Procedures, Functions, Triggers and Exceptions.

Data Warehouse Programmer

Confidential, Beachwood, OH

Responsibilities:

  • Developed and maintained data warehouse PL/SQL procedures.
  • Created UNIX scripts to work in conjunction with an Oracle database.
  • Optimized existing database applications for improved performance.
  • Enhanced intranet web site to use ASP, JAVA applets, JAVA Script, VBScript and dynamic HTML.

Programmer

Confidential, Cleveland, OH

Responsibilities:

  • Performed systems analysis on many VB4 applications and then rewrote them into Oracle PL/SQL packages and procedures which tremendously improved nightly batch routines to ensure Service Level Agreements where met consistently.
  • Maintained and created critical Oracle PL/SQL database packages, triggers and procedure.
  • Supported daily operations by monitoring and troubleshooting the automated daily data imports, exports and reporting for the Financial Investment Services department.
  • Used Visual Basic to update and maintain custom client-server programs to meet user specifications and requirements.

Conversion Programmer

Confidential, Williamsburg, VA

Responsibilities:

  • Developed custom designed alumni fundraising software used by larger colleges, universities and hospitals throughout North America.
  • Used Visual Basic to convert various data sources into Oracle and MSSQL Server for a leading edge web based donation-tracking system.
  • Created custom Visual Basic and database application utilities to meet customer specifications and requirements.

Hire Now