Senior Consultant Resume
5.00/5 (Submit Your Rating)
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
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 ConsultantResponsibilities:
- 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 ConsultantResponsibilities:
- 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 ConsultantResponsibilities:
- 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 ConsultantResponsibilities:
- Implement 2 node 11g RAC Cluster in RHEL environment
- Configure and implement RMAN backup and recovery strategy
Confidential
Senior ConsultantResponsibilities:
- 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