Resume

Sign in

Engineer Oracle

Location:
San Marcos, California, 92078, United States
Posted:
December 10, 2018

Contact this candidate

Resume:

*** ********* ** ****: 760-***-****

San Marcos, CA 92078 E-mail: ac7xam@r.postjobfree.com

I am a motivated self-starter with an aptitude for quickly learning new tasks and working well under deadlines. My extensive experience providing technical assistance and troubleshooting services in conjunction with managing the key aspects of database administration has enabled me to successfully support real world business strategies.

Verimatrix, Inc., San Diego CA 2015 – OCT 2018

Sr. Database Administrator

Operational responsibility for integrating on premise SAAS Analytics platform with public cloud (AWS) infrastructure. SnowFlake Data Warehouse, StreamSets (ETL, Kinesis, Firehose), Looker Dashboard, ControlM scheduler.

Supported Data Analytics Development team warehouse running in AWS; including AWS EC2, S3, Kinesis and RDS Databases.

Maintained database structures and code for over 850 worldwide clients of VCAS software applications.

Created and maintained multiple RAC/RAC/DG Systems using Oracle 11g & 12c to support geo redundancy of VCAS software for global and Tier 1 Telco companies.

Wrote internal and customer-facing documentation for best practices, configuration and deployment (11R2 and 12c RAC and RAC Data guard).

Created and maintained software development best practices for Agile standards in product development.

Estimated, planned, and implemented improved processes and tools to meet corporate targets for development tasks.

Troubleshooting with focus on Root Cause analysis.

CoreLogic 2015 - June 2015

Randstad Technologies, San Diego CA 2014 - Jan 2015

(Contractor to CoreLogic)

Sr. Database Administrator

Senior level team member for migration of multiple mission critical CoreLogic database systems to new vendor data center.

Administered and supported enterprise, high profile, dynamic 24x7 large-scale Oracle environments with high availability and scalable performance requirements.

Maintained and provided day to day production support of databases with 1,000+ concurrent users in 8+TB or greater databases, multi node and multi-tier environments.

Assisted with annual Disaster Recovery failover test using Oracle Data Guard.

Data Center migration of over 40 TB of data including 3 Productions, QA and DEV systems with minimal down time.

Installed and configured Oracle database on Linux using ASM and EMC SRDF.

Documented processes and best practices for database administration support.

ServiceNow, San Diego, CA 2013 - Sept 2014

USG Operations and Support

Sr. Database Engineer

Senior level member of the Federal Cloud Infrastructure Group chartered to provide core technical customer service and support, maintenance, and overall management of the ServiceNow platforms to Government, State, and Tribal clients.

Provided troubleshooting of the ServiceNow Platform supporting the ITIL v3 process (Incident, problem, change, CMDB, asset management, service catalog and runbook/automation management).

Assisted clients in debugging custom JavaScript issues, workflows, database issues (MySQL, Oracle), and performance troubleshooting at the system level on Red Hat/CENTOS.

Trained and monitored second shift junior team members on client incidents, processes, and general database functions.

Deployed new releases and enhancements to ServiceNow cloud based infrastructures and client self-hosted sites.

Assisted internal ServiceNow DBA groups on character set migration and index redundancy.

Subject Matter Expert for MySQL and Oracle RDBMS for the USG team.

Documented processes and trained USG engineers on performance effectiveness and index creation testing methods.

Obtained adjudication clearance to service and support US Government client base.

The State of Tennessee, Nashville TN

Department of Finance and Administration

Information Systems Technical Consultant 2011 – June 2013

Database Administrator supporting the State of Tennessee’s ERP Division Oracle/PeopleSoft installation, Department of Health and Department of Human Services using SOA, JEE and .NET based applications in an 11g Real Applications Cluster configuration running on Linux.

Managed over 100 databases in Production, Test and Development environments and all aspects of database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery. Productions Database average size was 3 – 5 terabytes.

Maintained efficient backup/recovery strategies with goal for High Availability and Disaster Recovery with zero RPO and minimal RTO using RMAN.

Performed application tuning using ADDM, AWR, SQLT, OEM and other 3rd party packages.

Provided 24x7 production and operational support including proactive database monitoring, and issue resolution

Installed and maintained Oracle Enterprise Manager 10gR2, 11g and 12c for monitoring of all databases.

Successfully installed and configured Oracle RAC ASM and non-RAC database on Linux, implemented data files using either ASM or on raw devices for some projects.

Mentored Junior DBAs and Developers with database fundamental concepts of database management and performance tuning methodology.

Developed and maintained Linux shell scripts for efficient management and cloning of Production databases.

Installed and managed Data Guard implementation.

Department Admin for Sharepoint site.

FICO, San Diego, CA

Product Support Lead DBA 2009 – July 2011

Worked with a team of developers, quality assurance engineers and product support to build new applications supporting high-throughput, high availability customer environments and support existing software applications that are tightly integrated with Oracle (9i, 10g, and 11g) and DB2 LUW (9.1 and 9.5) databases. The application ran on Websphere 6.x, Tivoli Directory Server 6.x and IBM HTTP Server.

Extensive experience in SQL tuning and optimization of Oracle database performance to meet high-throughput, high availability deployment requirements.

Performed diagnostic problem solving and solution development.

Actively participated in Oracle 9i, 10g and 11g installations, administration, design and development.

Installed, configured, and upgraded Oracle server software and related products in a UNIX environment.

Worked cross-functionally with development and QA on database requests and issues.

Provided technical assistance and mentoring to staff.

Knowledge of ASM and RAC installations; Report writing using OBIEE.

Accelrys, San Diego, CA 2002 – May 2009

MIS Database Administrator

Oracle Apps DBA. Performed daily routine encompassing cloning, patching, migrating systems, and backup and recovery using RMAN for internal Corporate Apps servers.

Two years hands on experience as Oracle Apps production DBA doing user support, trouble shooting, patching, cloning, code and object promotions and backups

Work performed in: Oracle RDBMS 8 to 11g, Oracle Apps 11i (11.5.9 and 11.5.10.2).

Increased the average speed of database searches for several different company products (DS SeqStore, DS Atlas Store and Chem Informatics databases)

Worked with the Chem informatics team on a selectivity issue with their 2 dimensional chemistry structures.

Enhanced query performance for several applications built by different Accelry’s development teams

ALLTEL, San Diego, CA 1999 – 2001

Database Administrator

Responsible for comprehensive Oracle 8.0.5, 8i database configurations, implementation, and maintenance relating to Alltel’s commercial banking software.

Proficient in tuning Oracle PL/SQL, Enterprise Manager, Spotlight on Oracle, SQLab Expert, TOAD and Erwin.

Performed special projects including benchmarking and recommendations for system performance and application tuning in Windows Client-Server environments directly and via Citrix/Windows Terminal Server.

Consistently improved existing Alltel database configurations, availability, recoverability and system performance.

HNC SOFTWARE INC., San Diego, CA 1997 – 1999

Technical Support Engineer

Lead Technical Support Engineer for predictive modeling and case management software applications in Fortune 100 financial institutions located worldwide.

Executed problem solving with Oracle database sizing, tablespace management, instance creation and data integrity; analyzed connectivity issues involving ODBC and direct TCP/IP connections.

Administered the SQL Server 6.5 database for the Applix call tracking/bug-tracking application; completed an independent migration of the system from SQL Server 6.0 with several applications upgrades

.

BLUEBIRD SYSTEMS, Carlsbad, CA 1996 – 1997

Technical Support Analyst/Implementation Engineer

Worked in a team environment to implement and maintain a document management system.

Experience includes RDBMS (Informix and Oracle)

Working knowledge of SCO UNIX, AIX, Windows 95 and NT 4.0, workflow products, LAN’s, WAN’s, and TCP/IP.

Responsibilities included installation of components, including databases, scanners, viewers, faxes, and optical jukeboxes.

Analyzed and diagnosed system performance in the operating system and database environment.

Responsible for enterprise-wide migration from Novell to NT 4.0, systems administration of both NT and UNIX servers

ZYBEX, INC., San Diego, CA 1989 – 1996

Director of Operations

Managed coordination of all marketing projects and sales activities with sole responsibility for support and training of on-line systems for a California based medical management system. Responsibilities included technical support, system analysis, software and hardware troubleshooting, system documentation and design.

Supervised and coordinated in-house billing service, which included staffing, troubleshooting, training of staff and clients, software and hardware support.

Performed design and documentation of a disaster recovery plan for over 200 medical practices.

EDUCATION

National College of Education, General Studies towards Special Education Major, Evanston, IL, 1979-1981

University of California San Diego UCSD Extension, Specialized certificate in Oracle Database Administration, Spring 2000

Oracle University, Oracle 8 Certified Database Administrator, January 2001

Oracle University, Oracle 8i Certified Database Administrator, January 2002

Oracle Data Block Internals and Data Access Optimization, March 2004

University of California San Diego UCSD Extension Leadership and Management Program May 2011

ServiceNow Certified System Administrator February 2014

SAFe® 4 Certified Practitioner

Personal references and credentials available upon request.



Contact this candidate