JAMES K. HOLLEY

ORACLE **G ADMINISTRATOR CERTIFIED ASSOCIATE

405-***-**** adayto@r.postjobfree.com https://www.linkedin.com/thejameskholley

IT PROFESSIONAL/DATABASE SQL/LINUX ADMIN

Database Administrator (DBA) with hands-on experience and training designing coding, testing and supporting next generation database solutions in Oracle Enterprise and SQL Server environments.

SQL Server Developer

SQL

T-SQL

Microsoft Office 2013

Oracle

Database Design

Visual Basic

PLSQL

Excel

Research & Analysis

SSRS

Enterprise Manager

Linux

Crystal Reports

Skype (Lync)

Toad

EDUCATION AND IT TRAINING

1)Moore-Norman Career Technology, Norman, OK Graduate: Nov. 2016

DATABASE ADMINISTRATION

Certifications:

Oracle 11g 1z0-051: SQL Fundamentals

Oracle 11g 1z0-052: Administration

MOS: Excel 2016 77-727: Core Data Analysis, Manipulation and Presentation

MOS: Access 2013 77-424

MOS: Word 2013 77-418

MOS: PowerPoint 2013 77-422

MTA: 98-364: Database Fundamentals

MTA: 98-361: Software Development Fundamentals (Visual Basic)

Courses:

Oracle DB Design & SQL, 120 hours

Linux, Red Hat, Fedora, 120 hours

Oracle PLSQL, 240 hours

Database Administration, 120 hours

2)Oklahoma City Community College, Oklahoma City, OK 4.0 GPA Graduate: 2016

Associates of Applied Science in Database Management, Business Technology

Notable Achievements:

Placed in the Top Ten in Microsoft SQL at BPA National Leadership Conference

2016

Placed 2nd in Microsoft SQL Server at the Oklahoma State Leadership Conference

2016

Placed 2nd in Database Application at the Oklahoma State Leadership Conference

2015

President’s Honor Roll, Oklahoma City Community College

2016

WORK EXPERIENCE

IT Help Technician I

Love’s Travel Stops July 2019 to Present

Troubleshoot software, hardware, POS issues

Using and troubleshooting Microsoft applications (Office, Skype, etc.) SalesForce, Cisco, Active Directory

Major Incident Management October 2018 to Present

Apex Systems/ Dell EMC Oklahoma City, OK

Leading management of incidents, affecting the company’s productivity

Leading support of over 2500 applications, servers, and databases.

Organizing team meetings aimed at incident handling and support management

Coordinating the process of working out a solution for handling incidents, supervising solution implementation

Composes summaries and executive reports of all meetings and the process of incident solving.

Making sure the solution is precise, logged, audited, and archived for executives.

Enterprise Help Desk Technician

Apex Systems (Dell EMC)

Helping customers on the phone with technical problems. Ex.: changing Windows password, checking server status, fixing Microsoft applications, and troubleshooting VPN, Lync (Skype) troubleshooting, network troubleshooting..

Identifying trends and updating solutions. Shadowed SQL person-ran daily stored procedures and modified them. This included many what-if situations for key metrics that affected daily operates.

DameWare, HP Service Manager, Internet Explorer, Windows (7 & 10), Active Directory, VPN, Outlook, Firefox, Microsoft Office support, low-level network T/S, Lync (Skype), hardware issues.

DATA ANALYST August 2017 to December 2017

Apex Systems (LexisNexis Risk Solutions) Oklahoma City, OK

Running queries and stored procedures in MS SQL. Developing and implementing the database. Identifying exceptions, performing root cause analysis, create recommendations for data inconsistencies.\

Running various commands in Excel (Pivot Tables, Charts). Identifying, analyzing, and interpreting data trends and patterns.

Interpreting data trends, updating the database, updating business rules, analyzing results. Filtering, cleaning, and validating the data

VOLUNTEER WORK EXPERIENCE

INFORMATION TECHNOLOGY ASSISTANT August 2015 to August 2016

Sam Noble Museum of Natural History Norman, OK

Linking various applications together, such as Microsoft Access, Excel, and Microsoft SQL Server. MS SQL Server-migrating, merging, joins, aggregate functions, views, stored procedures.

Transferring actual website to virtual machine using WordPress due to system being hacked.

Publishing database to the internet to be able to share information with public and with other museums.

RESEARCH TECHNICIAN August 2015 to August 2016

Moore-Lindsey Historical House Norman, OK

Designed and implemented a database to track and maintain inventory information.

VOLUNTEER RESEARCH TECHNICIAN July 2013 to January 2015

OKLAHOMA HISTORY CENTER Oklahoma City, OK

Update and maintain newspaper listings; proofread and correct database entries; maintain digital archives.

Index, document and transcribe for upcoming exhibits, preparing for future access by future researchers.

Digitize and catalogue Living Legends and Hightower Collections using Pro Tools.

Discover inaccuracies during second pass research and suggest changes to facilitate future inquiries.

Community Involvement

Oklahoma City SQL Server Users Group (OKCSQL) member

Contact this candidate