Oracle and Sql Server DBA

SYLVAN CREACH

Arvada, CO *****

*************@*****.*** 720-***-**** www.linkedin.com/in/sylvan-creach

ORACLE DATABASE ADMINISTRATOR

Excellent Service Provider

Experienced IT professional with expertise in database management, with expertise in Oracle database administration, patch management and security. Also experienced at Microsoft SQL Server Administration and management. Adept at performing health checks and monitoring. Proven ability to develop backup and recovery strategies, ensuring safety of information. Build positive relationships with internal and external customers, offering excellent service and support. Great problem-solving skills that help get the job done. Work as team player focused on project success, and adaptable to challenging environments.

TECHNICAL SKILLS

Operation System: Windows, Windows Server 2003, 2008, and 2012, AIX, Linux

Languages: SQL, PL/SQL, Korn Shell, Python, PowerShell, perl, awk, sed

Tools: Oracle, SQL Server, SAP, Microsoft Office, SQL Developer, TOAD, vi, ServiceNow, SQL Server Management Studio

PROFESSIONAL EXPERIENCE

Created and managed up to 60 production Oracle databases, including implementing and maintaining backup and recovery strategies, troubleshooting performance, security, integrity, and connectivity issues.

Terumo BCT, Lakewood CO

Oracle DBA (April 2011- March 2018)

Installed and patched all versions of Oracle RDBMS software (9.2 through 12.2.0.1) as business requirement, reducing security vulnerabilities and any up-to-date software improvements.

On call rotation with DBA and SAP Basis team members.

Migrated databases from Oracle to SQL Server.

Set up connections between SQL Server and Oracle.

Worked on numerous projects, including migrating existing Oracle Databases from older AIX servers to new, supported hardware (AIX 8284-22), installing Oracle on new servers and swinging over database mounts, saving 30% maintenance costs over next 3 years.

Assisted in SQL Server DBA tasks, migrating databases from SQL 2008 to SQL 2014 to decommission unsupported Windows Servers and implementing “Always on availability group” for high accessibility.

Automated numerous day-to-day housekeeping scripts, cleaning up trace files, monitoring Unix drive space, stopping all Oracle cron jobs on all servers used during maintenance.

Caridian BCT, Lakewood CO

Oracle DBA (January 2007- April 2011)

Implemented Oracle Internet Directory (OID) for Oracle database (tnsnames) lookups, allowing transparent and centralized administration of this process.

Developed manual and automated RMAN refresh scripts for cloning databases, helping streamline application testing process.

Implemented Oracle High Availability (HA) option on the AIX servers.

Developed database and Unix monitoring scripts, enabling alerting on-call person when database / Unix errors or thresholds were reached.

Gambro, Lakewood, CO

Oracle DBA (1998-2006)

Developed in-house source control process used to audit production changes in Oracle.

Developed database and Unix monitoring scripts, enabling alerting on-call person when database / Unix errors or thresholds were reached.

Developed an in-house script to clone Oracle databases using manual backups.

Cobe Labs, Lakewood, CO

Mainframe Admin & Oracle DBA (1992 to 1998)

Promoted to Oracle DBA and with introduction of Oracle 7.3.

Developed in-house paging script on Unix that was used for critical notifications.

EDUCATION & PROFESSIONAL DEVELOPMENT

Completed courses at UNIVERSITY OF COLORADO DENVER, Denver, Co And RED ROCKS COMMUNITY COLLEGE, Lakewood, Co

Courses included: Unix, Database, Programming, Python

Contact this candidate