We provide IT Staff Augmentation Services!

Senior Consultant Resume

Cincinnati, OH

SUMMARY:

  • Database administrator (DBA) with extensive experience implementing Oracle solutions in an enterprise environment.
  • Proficient in an assortment of technologies, including Oracle 9i/10g/11g, Solaris, Oracle Enterprise
  • Linux, Redhat Enterprise Linux, Apache Web Server.

DBA SKILLS INCLUDE:

  • Oracle 10/11/12 Database Administration Oracle RAC & ASM Administration/Installation
  • Performance Tuning & Capacity Monitoring SQL Tuning in an Oracle Environment
  • Backup & Recovery Data Guard Administration/Installation
  • Shell Scripting Oracle Grid Control 12c Implementation
  • Patching Migrations
EXPERIENCE:

Confidential, Cincinnati, OH

Senior Consultant

Responsibilities:

  • Manage Oracle, MSSQL, MySQL environment.
  • Provide architectural guidance for database operations and project planning
  • Mentor and guide DBA staff on best practices
  • Update management regarding ongoing issues and problems
  • Member of 7 person architectural SWAT team dedicated to fast - tracking problem resolution
  • Attend and communicate DB change activity with change management board
  • Administer Oracle RAC/ASM
  • Administer MSSQL

Centroid Systems, Troy, Mi

Senior Consultant

Responsibilities:

  • Manage Oracle database administration assignments for diverse industry clients. Enhance database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups.
  • Ensure technical and functional designs meet business requirements.
  • Oracle SME for Business Intelligence/Data warehousing implementation
  • Manage implementation of physical DB structures as per Dimensional Model
  • Recommend performance improvements of data warehouse (bitmap indexes, partitioning)
  • Administer user provisioning and security
  • Create database links
  • Manage backup and recovery

Confidential

Senior Consultant

Responsibilities:

  • Build multi - node RHEL 5 servers to house client MySQL enterprise application
  • Develop backup scripts that take advantage of LVM snapshots
  • Implement MySQL Master-slave replication
  • Implement MySQL Enterprise Monitoring

Confidential

Senior Consultant

Responsibilities:

  • Implement Oracle Grid Control 12c and configure monitoring templates for proactive monitoring of all Oracle environments
  • Administer 30 Oracle 10g and 11g stand alone databases (DEV/TST/PRD) in a Solaris 10 environment ranging from 20GB - 400GB)
  • Provide performance tuning recommendations based on AWR and ADDM utilities
  • Extensive communication with business analysts, engineers and management

Confidential

Senior Consultant

Responsibilities:

  • Implement Oracle Grid Control 12c and configure monitoring templates for proactive monitoring of all Oracle environments
  • Implement Data Guard physical standby
  • Administer 3 Oracle 11g RDBMS in AIX environment
  • Administer 2 Oracle 9i RDBMS in Windows environment
  • Backup and recovery
  • Develop scripts to automatically refresh environments based on last successful Level 0 PRD backup

Confidential

Senior Consultant

Responsibilities:

  • Implement 2 node 11g RAC Cluster in RHEL environment
  • Configure and implement RMAN backup and recovery strategy

Confidential

Senior Consultant

Responsibilities:

  • Migration of existing 10g custom application environment (RDBMS, reporting server, Apache) to 11g
  • Build and configure new RHEL servers
  • Build and configure Oracle HTTP, Oracle Reports and RDBMS environments
  • Administer 11g envIronment: performance tuning + backup and recovery
  • Implement Oracle Grid Control 12c and configure monitoring templates for proactive monitoring of Oracle environment

Confidential, Detroit, Mi

Senior Consultant

Responsibilities:

  • Assist client in assessment of ICD9 to OCD10 coding language upgrade to assess impact to reimbursement payments
  • Oracle SME for Business Intelligence/Data warehousing implementation
  • Implement Oracle Grid Control 12c and configure monitoring templates for proactive monitoring of Oracle environment
  • Collaborate with ETL on performance of ETL loads
  • Administer user provisioning and security

Confidential, Ann Arbor MI

Sr. Data Management Consultant

Responsibilities:

  • Develop UNIX menu system in ksh to call various Teradata utilities (multiload, fast export)
  • Develop documentation of our logical datamart update processing
  • Execute complex procedure of logical data mart across environments (DEV/TST/QA/PRD)
  • Troubleshoot problematic Teradata update statements in BTEQ

Confidential, Ann Arbor MI

Sr. Oracle DBA

Responsibilities:

  • Implement security through the use of roles
  • Implement system-wide efficiency through the use of profiles
  • Test and rollout Oracle Grid (10g) across all of our environments (DEV/TST/QA/PRD)
  • Build and configure Oracle servers
  • Build Oracle databases as per physical and logical specifications
  • Performance tuning of trouble queries utilizing ADDM and AWR reporting features
  • Oracle backup and recovery using RMAN
  • Application of quarterly CPU security patches
  • Application of patches as per Oracle recommendations to fix bugs
  • TAR creation and work with Oracle support when necessary
  • Implementation of Oracle Lite OC4J application
  • Review code prior to execution in any of our environments
  • Installation of Informatica server and user security
  • UNIX scripting in ksh
  • Basic SQL Server administration
  • Review Logical and Physical Design specifications
  • Logical modeling with ERWIN

Confidential, Chicago, IL

Oracle Apps DBA

Responsibilities:

  • Install, patch and clone Oracle Applications, EBS 11i in 4 node RAC cluster
  • Use of ADADMIN for patching
  • Use of RAPIDCLONE to clone environments
  • Troubleshoot n-tier architecture problems (Java logs, etc)

Confidential, Ann Arbor MI

Oracle DBA

Responsibilities:

  • Tablespace migration from dictionary managed to locally managed
  • Query development to provide reporting on Oracle user and role based security
  • Heaving exporting/importing using exp and imp
  • CPU quarterly patch applications
  • Member of Peoplesoft upgrade project

Hire Now