Database Engineer/architect Resume
Columbus, OhiO
SUMMARY:
- Information systems professionalwith experience in large heterogeneous corporate environments.
- Experience supporting and working with Oracledatabase, application and middleware teams in production (mission critical)and dev/test environments.
- Adept multitasker able to bring a high number of simultaneous projects to completion with accuracy and professionalism.
- Comfortable providing 24X7 on - call support to maintain databases up and running in production environment.
- Expertise in Oracle 11g/12c installation, administration, production support, configuration, upgrades,switchover, failover, patches, space management, database security, performance tuning, UNIX shellscripting and documentation.
- Installed Oracle database server in unix/linuxenvironments, upgrading of Oracle serverand applying patches to database and applications.Expert in implementing Oracle Data Guard 10g and active Data Guard in 11g/12c.
- Experience working with large OLTP databases of 3-4TB size.Proficient in RMAN backup (full, incremental and cumulative) and recovery: incompleteand DR. Familiarity with SQL, PL/SQL, stored procedures and functions, packages and database triggers.
- Conversant with concepts of DB architecture, SGA/PGA, listener, TNS Names, V$ and DBAviews. Expertise in hot/cold backup, recovery and cloning of databases using RMAN.
- Expertise in performance tuning, SQL tuning services with Explain Plan, STATSPACK,SQL TRACE, OEM ASH, AWR, ADDM to collect and maintain performance statistics and improve DB performance.
- Installed ASM environment, migrated database from NON-ASM to ASM. Knowledge of Flashback.
- Installed other RDBMSs on various platforms including DB2 on AIX and Linux.
TECHNICAL SKILLS:
Database: Oracle 10g,11g,12c; Oracle ASM (storage), Oracle Golden Gate, Oracle OEMTools/GUI SQL Plus, RMAN, SQL Developer, Toad, Oracle Grid Control, Data Pump, Tuning Explain Plan, Statspack, AWR, ADDM
Scripting: PL/SQL, bash, ksh, Perl, sed, awk
OS: Red Hat Enterprise Linux under VMWare, ESX versions 3/4/5
Oracle Linux, Oracle VM and virtualization tools: Familiarity with PCI, SOX, HIPAA and GxP compliance requirements.
PROFESSIONAL EXPERIENCE:
Confidential, Columbus, Ohio
Database Engineer/Architect
Responsibilities:
- Created performance and resiliency assessment at Confidential site.
- Study concentration consists of performance and storage management, general inventory of implemented best practices (Linux, Oracle/RAC; DB2 HADR/pureScale) and recommendationof changes to configurations or infrastructure.
Confidential, Atlanta, Georgia
Database Engineer/Architect
Responsibilities:
- Participated in site resiliency assessment at Confidential in Atlanta and Minneapolis.
- Interface with senior DBA staff and IT management; developed, presented and implemented recommendations with regard to best practices for DB2.
- Environment is virtualized Linux (RHEL) with performance sensitive instances deployed on pSeries (AIX).
Confidential, San Mateo, California
Systems Engineer
Responsibilities:
- Provided USPS San Mateo Data Center Level 3 support of Oracle and Oracle apps deployed on SuSeand enterprise storage (SAN/EMC, NAS/NetApp).
- Environment consisted of approximately 8300 servers (HP hardware), databases reside on physical hardware with other servers virtual (VMware).
- Acquired operational knowledge of Cassandra database physical layout design, monitoring solutions, backup and high availability strategy for Cassandra.
- Exposure to Oracle Golden Gate 10g/11g replication to remote sites for disaster recovery. Acquired knowledge of GG installation, configuration and performance troubleshooting.
Confidential, Foster City, California
Systems Consultan
Responsibilities:
- Responsible for supporting all aspects of data infrastructure for Linux (RHEL) including server provisioning, performance tuning and troubleshooting and functioning as liaison to groups and special projects companywide such as those responsible for data center build up and moves, implementation of SAS on a grid model, etc.
- One of two people in the company with deep unix/Linux skills resulting in high-demand work environment.
- Pastexperience with both system and database administration led to multi-faceted task assignments spanning system administration, Oracle database management and tuning activities.
- Managed and maintained Oracle OEM and Oracle Data Guard/standby databases for fail over purposes.
Confidential, Auburn Hills, Michigan
Systems Architect
Responsibilities:
- Aided in development of private cloud (Tivoli) at Confidential .
- Duties included scripting (bash, ksh) and working closely with cloud architects to automate processes for provisioning and management of assets.
- Environment composition included AIX 7100-01, SLES 5 and various Windows operating systems. High profile client required weekly travel.
Confidential, Phoenix, Arizona
Systems Consultant
Responsibilities:
- Transitioned successive database and application tier migration(s) of Confidential ’ hosted databases and apps in data center to newly constructed 500,000 square foot facility in Greensboro, North Carolina.
Confidential, Campbell, California
Systems Engineer
Responsibilities:
- Leadership role in conversion from Solaris to Oracle on AIX.
- Direct interface with senior management on Oracle and AIX related issues.
- Direct interface with database, applications and systems architects to manage increasing demand for resources and bandwidth in highly competitive business climate.
- Supporteddatabase and applications architects to resolve performance issues with Oracle on AIX.
Confidential, San Francisco, California
Systems Engineer
Responsibilities:
- Responsible for providing support for PeopleSoft financial applications and UCSF academic research community, consisting of approximately 500 users campus wide.Responsible for RMAN backup and recovery, hot and cold. Added and managed backup scripts; monitored backup jobs. Maintainedrecovery procedures for each application database.
- Performed regular database preventative maintenance activities (index rebuilding, analyzing the database, tune buffer cache, chain rows)Worked on import/export, export data pump/import data pump.
- Applied CPU and PSU to Oracle databases.Responsible for installation and upgrade of Oracle Enterprise Manager agents.