Database Analyst Resume


Title
Database Analyst


Primary Skills
Please see resume for skills


Location
US-AR-North Little Rock (will consider relocating)

Posted
Jun-21-10

RESUME DETAILS

EDUCATION:

Baywood Technologies, Conway, Arkansas
Oracle Certified Database Administrator, June 2001

University of Arkansas at Little Rock, Little Rock, Arkansas
Master of Business Administration, emphasis International Business, December 1999
Bachelor of Applied Arts in Computer Information Systems, May 1997

Arkansas State University, Beebe, Arkansas
Associate of Applied Arts in Business Management, May 1995

SKILLS:

Oracle 8/8i/9i/10g UNIX/Sun/AIX Erwin 3.5.2 Backup Express 2.1.4 SQL Server Microsoft Office Epiphany Revolve EE
Mainframe Express COBOL JCL

EXPERIENCE:

Verizon Wireless / ALLTEL Communications, Little Rock, Arkansas
Lead Technical Analyst / Senior Database Analyst, September 2008 April 2010
* Provided user and technical support for Atlas, ALLTELs Asset Tracking and Lease Administration System, by means of code changes and data fixes.
* Monitored development code for team standards and inefficiencies, suggesting improvements where applicable.
* Acted as a liaison between users and development team, communicating requirements and monitoring progress of project requests.
* Key player in Oracle and application security lockdown project.
* Supported application implementation via documentation, testing, troubleshooting, and data migration.
* Developed procedures for developers and users in an effort to streamline the service request process.
* Conducted research and generated reports utilizing Oracle 9i and 10g databases to support management and stakeholder initiatives.
* Trained stakeholders in system functionality and best business practices.

Acxiom Corporation, Little Rock, Arkansas
Database Developer/Support Analyst, November 2004 April 2008
Systems Database Administrator, May 2000 November 2002
* Provided 24/7 functional troubleshooting assistance of Oracle anomalies, connectivity, UNIX processes, and SQL jobs to clients as well team members.
* Technical lead for upgrades, implementations, process changes, quality assurance, mentoring, and future planning for Oracle databases and campaign tools.
* Supported project manager in creation of project plan, time and resource estimations, assignment of resources, and project plan updates.
* Monitored and improved performance of database processes by analyzing extent usage, CPU usage, function type usage, parallelism, and explain plans for current production jobs.
* Restriped unevenly allocated tablespaces to increase database efficiency.
* Administered database and campaign tool security: created and maintained user accounts, created roles, granted privileges, prepared monthly security reports for client and management.
* Developed automated process to provide weekly and monthly CPU and space usage reports to the client and development team.
* Created automated backup system to do nightly exports of key production tables when modified.
* Led effort to change mirrored disks to a Raid 5 configuration for optimal space usage.
* Created, monitored, and projected needed space for tablespaces on UNIX file system as well as raw partition storage configurations.
* Supervised project to upgrade UNIX version 4.0F to UNIX version 5.1A.
* Formulated and implemented backup and retention plan per client requirements.
* Developed and maintained Erwin data model and Visio process flow diagram.
* Utilized SQL in conjunction with Vi and Korn shell editors to create and maintain production processes.
* Managed support for Citrix users: assisted in transition to new Citrix server; facilitated the creation and security of new user accounts; coordinated installation of new user software; aided in the publication of required user applications; killed hung user tasks and sessions.
* Supported Epiphany backend functions: executed upgrade of Epiphany 6.5.3 to 6.5.4; provided 24/7 on-call support; created automatic alerts for system and application failures; started and stopped web server, WebSphere, and Epiphany services; killed hung processes; resolved anomalies.

University of Phoenix, Little Rock, Arkansas (concurrent with other employment)
Information Technology Instructor, June 2006 October 2008
* Instructed Database Concepts, Database Management Systems, SQL for Business, Introduction to Operating Systems, Computers and Information Processing, Fundamentals of Business Systems Development, Business Systems, and Excel courses.
* Administered offsite corporate training to clients in the central Arkansas area.
* Developed classroom exercises, presented course material, and monitored student progress.

Pulaski Technical College, Little Rock, Arkansas (concurrent with other employment)
Information Technology Instructor, August 1999 December 2006
* Instructed Computer Concepts, Introduction to the Internet, Windows 2000, Desktop Operating Systems, Introduction to Computers, and web-based Introduction to Networking courses.
* Developed lesson plans and exams, presented course material, and monitored student progress.

Arkansas Blue Cross Blue Shield, Little Rock, Arkansas
(Consultant via Brightstar Information Technology Services, Pleasanton, California)
Project Lead/Lead Systems Analyst Programmer, November 2002 June 2004
* Collected requirements, completed analysis and design specifications for projects, developed project plans, assigned tasks to team members, and led weekly status meetings with management, clients, and vendors.
* Supervised implementation of Mainframe Express, Revolve Enterprise Edition, Winrunner, and Xpediter DevEnterprise for Arkansas, Florida, Maryland, and Georgia locations.
* Selected to represent Blue Cross in overseas Micro Focus client forum, giving Vice Presidents of Micro Focus constructive feedback in an effort to improve the Micro Focus products for end users.
* Key player in contract development and approval processes for Micro Focus, Mercury Interactive, and Compuware products.
* Developed database solution for computerized change control tracking in product releases.
* Consultant and REQL programmer for MVS and CICS data dictionary and documentation projects.
* Responsible for troubleshooting problems, expanding product offering, offering corporate training classes, and searching for enhanced efficiency opportunities for Blue Cross end-users.


Certifications
See above

CONTACT DETAILS

You must be logged in and have a current resume access subscription. Login or Register »

Related: Database Administrator Resumes | IT Resumes in North Little Rock, AR | IT Resumes in Arkansas