Database Administrator
Resume:
James E. Jackson
Vancouver, WA. 98661
Phone: 509-***-****
Email: *************@*****.***
Summary
A highly motivated, career and goal oriented United States Air Force veteran. Airman Jackson received the Air Force Achievement medal in 1999, a United States and Military recognition for meritorious service to his country and the Air Force Sharp award, in recognition for his outstanding performance by the commander of his unit. He is currently seeking a career in Health Care Information Technology where he can advance his career working independently or as part of a team.
Skills Summary
Oracle Internals 8i, 9i, 10g, 11g, 12C and 18C
OS: Linux, HP UNIX, Solaris, AIX. RHEL
Database Performance Tuning
Security Administration
Database Design, Database Administration
System Analysis & Design
Server Technology
Data Modeling
Oracle Database Architecture
Oracle performance tuning
XML/CSS Web Technologies
JavaScript programming
MS SQL Server
Intermediate Network Administration
Crystal Reports
Standby Database Solutions
Oracle Enterprise Manager (OEM)
XML and Portal Design
PL/SQL, SQL
C++
VMWare
MS Access, Excel, PowerPoint
Recovery Manager (RMAN)
Project Management
Oracle 10g Application Server
Visual Basic.NET
Symantec Netbackup Administration
Major Demonstrated Strengths
Detail oriented, highly focused analytical and result-driven professional with years of experience working independently and as part of a team.
Work History
April 2014 – Present: Epic Cache DBA at Oregon Health Science University
Perform Cache Installs and/or Maintenance on UNIX System
Installs and Upgrades Cache database software
Monitors performance of Cache instances in a networked environment
Executes database refreshes, stop, restarts and recovery as required
Perform Special Update Loads
Manage 30+ Instances of Cache/Epic Environment
Implemented, maintains and schedules epic environment refreshes
Review environmental refresh logs for errors
Run Integrity Checks
Run and review Epic Administrative Script logs
Monitors and configures database start-up parameters
Create and manage user accounts, profiles, permissions and roles
RedAlert System configuration and monitoring
System Pulse monitoring
Responsible for capacity planning and space allocation for Epic Cache Databases and the OS file system.
Responsible for presenting the status of system health during daily managers meeting
Responsible for leading the Epic Cache DBA team meeting
Migrated Cache/epic from Solaris to RedHat Linux
Technical Lead for all Epic upgrades
Manage daily operations pertaining to Epic Cache DBA
Provide 24x7x365 after hour Cache DBA support
August 2016 – 11/1/2016 Epic Cache DBA at Health East St Paul Minnesota
Perform Cache Installs and/or Maintenance on UNIX System
Installs and Upgrades Cache database software
Monitors performance of Cache instances in a networked environment
Executes database refreshes, stop, restarts and recovery as required
Perform Cache Installs and/or Maintenance on UNIX System
Installs and Upgrades Cache database software
Monitors performance of Cache instances in a networked environment
Executes database refreshes, stop, restarts and recovery as required
Perform Special Update Loads
Manage 30+ Instances of Cache/Epic Environment
Implemented, maintains and schedules epic environment refreshes
Review environmental refresh logs for errors
Run Integrity Checks
Perform Special Update Loads
Manage 30+ Instances of Cache/Epic Environment
Implemented, maintains and schedules epic environment refreshes
Review environmental refresh logs for errors
Run Integrity Checks
January 2014- August 2014: Epic Cache DBA at Stanford University Medical Center (NVT 2012, 2014 certified)
Responsible for proactively monitoring Test and Production instances
Perform automated and manual environment refresh of development and test instances
Performed upgrades of Epic Administration scripts
Created logins for different types of access
Started and stopped Cache and Epic environments using both Epic and Cache utilities
Helped in supporting Epic Users in troubleshooting application issues
Responsible for the installation of Epic SUs
Provided support during downtime activities.
Created change control documents and reports for changes implemented in development and production systems.
March 2013 – January 2014: System Analyst/Epic Cache DBA (Certified Cache 2010 and NVT 2012) at Cedars-Sinai Medical Center
Responsible for proactively monitoring Test and Production instances
Perform automated and manual environment refresh of development and test instances
Performed upgrades of Epic Administration scripts
Responsible for the installation of Epic SUs
Performed Cache Database upgrades and applied patches
Utilize Data Courier to perform data migrations of files across environments
Created and managed Data Courier interfaces through Bridges
Assisted in training team members on various DBA functions
Created additional environments for testing and/or training as needed
Created logins for different types of access
Started and stopped Cache and Epic environments using both Epic and Cache utilities
Helped in supporting Epic Users in troubleshooting application issues
Assisted in setting up Epic Batch jobs
Created change control documents and reports for changes implemented in development and production systems.
Participated in Go-live activities in the supporting of new application modules or systems.
Nov 2009 – Feb 2013: Senior System/Application Analyst at Kadlec Medical Center
Cache Database Administrator
Certified in summer 2010 version
Certified NVT 2012
Built the existing production and non-production environments
Responsible for establishing and implementing Epic environment copy process.
Maintained Epic RedAlert, Trove, and nodeagent.
Responsible for Epic Installations and Upgrades
Performed Caché Installation and Upgrades
Managed Epic backup and recovery.
Assisted with storage allocation and file system expansion
Troubleshot, identified root cause, and documented problems of simple to high complexity for assigned applications and systems.
Collaborated with end-users across the enterprise to build strong relationships with IT; formed relationships with vendors to build on-gong partnerships
For Assigned systems, Led efforts to install and implement system patches, service packs and version upgrades as assigned and worked with the vendor in performing system database upgrades. through simple to complex system environment changes.
created new user accounts and assign system access
Functioned as Enterprise Backup Admin ( Netbackup) ensuring all application and server data was backed-up and archived offsite
Managed systems of simple to high complexity to ensure service level agreements (SLA) are being met.
Installed Netbackup agents on UNIX and Window Servers and established backup policies in accordance with HIPPAA and other compliance policies
Functioned as the project manager for the design and implementation of a new backup and recovery solution utilizing Data Domain and Netbackup.
Functioned as the system analyst for the Alaris (Care Fusion) IV pump system and acted as a liaison between clinical engineering and IT.
Functioned as the system analyst for the NDC Premise professional billing financial system.
Coordinated both application and server upgrades for critical systems throughout the medical facility.
March 2008 – Nov 2009: Oracle Database Administrator at Bechtel Corporation
Installed & Setup of Oracle 8i, 9i and 10g databases.
Performed nightly backups of databases
Maintained, monitors and tune production and development databases
Clone databases for test and development
Tested the use of new database technologies and its implementation
Replication job administration and troubleshooting
Performed database patch installation and upgrades
Modified the database structures
Monitor user access to the database
Maintained system Security
May 2006 – March 2008: Helpdesk/Application Support Technician at Banner Bank
Assist end-users in resolving problems concerning Morvision Real estate Application software.
Provides one-on-one end-user problem resolution over the phone for loan officers regarding problems with software plug-in for Fannie Mae or Freddie Mac.
Identifies, diagnoses, and resolves problems for users of the Morvision Real-estate Application Software.
Setup of new user accounts
Enhances the functionality of the application through the creation of custom macros.
Jan 2007 – July 2007: Incident Response Lead/Jr. Oracle Database Administrator at Regis University
Maintained multiple Oracle Instances on distributed Internet platform architecture
Modified SQL scripts to accommodate user changes
Maintained SQL code as required
Created databases and configure for compliance with schema requirements
Used OEM tools to remotely administer and maintain various Oracle Instances
Supported thin client interface to Oracle servers for web-based access
Managed work order support queue
Supported database component of e-commerce initiatives and applications
Troubleshoot TNS connectivity issues and maintain TNS files
Supported modifications to the Oracle OFA structure
Supported database users and various applications
Developed and maintain support documentation
Education
2008, MS in Computer Information Systems– Regis University, Denver, Colorado
2005, BS in Computer Information Systems– Walla Walla College, College Place Washington
References
Available Upon Request
Contact this candidate