IT MANAGER - DATABASES Resume

Title
IT MANAGER - DATABASES

Primary Skills
IT professional with 18+ years' experience leading and supporting large-scale database / system projects

Location
US-UT-Lehi (will consider relocating)

Posted
Jan-24-09

IT MANAGER - DATABASES

Solutions-focused, results-oriented IT professional with 18+ years' experience leading and supporting large-scale database / system projects in support of large firms across diverse industries. Impressive record of achievement in designing, building, implementing, maintaining, troubleshooting, repairing, and updating state-of-the-art databases, applications, and systems to meet organizational needs. Successful leveraging client relationships and emerging database technologies to maximize performance and efficiency across business functions. Outstanding communication skills; interface effectively with senior management, staff, peers, and users.

CORE LEADERSHIP COMPETENCIES / TECHNICAL PROFICIENCIES

* Database Administration * System Migrations & Integrations * Troubleshooting & Support
* Project Coordination & Execution * Application Design & Deployment * IT Processes & Procedures
* Database Solutions Development * Quality Assurance Testing * Systems Improvements

Databases: Data Analysis, Database Administration, Database Design, Database Development (Coding, SQL, T-SQL, etc.), Database Performance Tuning, Database Security and Recovery, Oracle 6-9i, Access 97 & 2000, MS SQL Server 97 & 2000, MySql 5.0
OS: SUSE Linux, Windows XP, Windows 2000, Windows NT, Sun Solaris, Windows 98, Windows 95
Software: Oracle 9iAS v9.0.1 & v 9.2, PL/SQL, Oracle Developer 2000, Oracle Designer 2000, Oracle Financials 10.7, Oracle Discoverer, Pascal, PeopleSoft, Microsoft Office 2000 & XP, SQL*Loader, SQL Navigator, TOAD, Visual Basic, HTML, Java, JavaScript, Crystal Reports, Citrix
Hardware: PC Hardware, HP, IBM & SUN Hardware
Management: Project Management, Requirements / Spec Writing, Microsoft Project


PROFESSIONAL EXPERIENCE

THE CHURCH OF JESUS CHRIST OF LATTER DAY SAINTS - Salt Lake City, UT 2004 - Present
Senior Engineer
Served as DBA Team Lead with accountability for eight direct reports providing database administration for a religious organization. Refined a database refresh script to support an automated database refreshed from a CVS code repository. Accountable for all database object changes including creating database packages, procedures, and triggers as well as database design and performance tuning. Work closely with management on proposed system enhancements. Manage employee performance reviews, staff recruitments and terminations.

Selected Highlights
* Reduced system downtime from several days to 1.5 hours by developing and implementing a process to migrate a church membership system to new more robust hardware, OS, and application versions.
* Cut system load times by 90% by successfully building an ETL process to move legacy data into a redesigned schema.
* Led database redesign efforts for a missionary assignment process that resulted in reducing processing times by 50%.

ROBERT HALF TECHNOLOGIES - Salt Lake City, UT 2003 - 2004
Developer / DBA
Provided database development and administration for a consulting / recruiting firm. Ensured scripts contained all business logic to properly convert legacy codes to appropriate Oracle code. Prepared error logs that enabled accurate completion of processes even if problems existing in data.

Selected Highlights
* Decreased system load times by creating SQL loader scripts used as part of a transformation process to migrate data from outside system.
* Generated new Oracle forms and reports including performing initial logic testing and peer review testing as well as correcting coding deficiencies.

GOLD SYSTEMS / VMC CONSULTING - Salt Lake City, UT 2003
Developer / DBA
Led installation and configuration of several databases used for testing and quality assurance. Debugged existing procedures, packages and triggers. Performed nightly database backups. Analyzed errors to identify and resolve database / system issues. Served as an onsite DBA and UNIX Administrator for a database development project supporting VMC Consulting. Installed and configured UNIX on Sun Sparc Server. Maintained and upgraded Apache Tomcat / WebSphere webservers. Developed and implemented database refresh procedures for QA server.


Selected Highlights
* Improved database / system performance by modifying existing client / server application forms to accommodate business requirements. Included building scripts and data files used for testing application.
* Wrote PL/SQL triggers and procedures to query and update database based on project requirements.
* Developed and implemented database backup and recovery procedures for all UNIX databases.
* Launched databases for QA testing and data processing used to import into production

COMPUTER SCIENCES CORPORATION - Falls Church, VA 1999 - 2002
Senior Consultant
Provided consulting leadership and support in developing and implementing applications supporting county government contracts. Directed up to four Consultants in supporting system development, testing, change control, and implementation. Assisted infrastructure team with networking issues. Collaborated with Business Analysts in customizing Oracle Financials 10.7 General Ledger and Accounts Payable modules. Wrote training manuals, user guides, and conducted end-user training.

Selected Highlights
* Created an application-based system using Microsoft Access and Visual Basic to track and manage compliance issues critical to meeting contractual requirements. Designed marketing strategies for application.
* Worked closely with client management on issues relating to network traffic, accessibility, hardware and software requirements and recommendations, and single vs. multi-tier server deployment.
* Led a project to develop a custom application to support performance analysis as part of an ERP implementation for San Diego's County agencies.
* Migrated application from NT development computer to HP 9000 UNIX production computer using FTP - working closing with client and deployment team to obtain final acceptance and resolution of countywide system issues.

ARIS CORPORATION - Falls Church, VA 1997 - 1999
Senior Consultant / Project Lead
Managed various projects supporting applications and systems for client organizations. Evaluated existing software for compatibility with client requirements. Utilized data gathered from user interviews to create logical designs. Coordinated project between Client team and Developers to produced final system design and made recommendations on final hardware configuration and network design. Configured desktop computers to access LAN and WAN through firewall and served as DBA for onsite development databases.

Selected Highlights
* Led the marketing, development, design, implementation, and training of Fish Catch collection software solution ot meet requirements for a client organization (NOAA).
* Managed up to 10 Consultants to rewrite entire legacy system into a customized Oracle system comprised of 40 forms and 50 reports. Wrote 15-20 SQL Loader scripts used to import legacy data. (PERA CV)
* Supported customization of Oracle financial applications to several standard Oracle application screens. (NIKE)

ORACLE CORPORATION - Falls Church, VA 1990 - 1997
Senior Consultant
Served as senior consultant on multiple application project enagements for clients across diverse industries. Interfaced with various users to coordinate Designer 2000 analysis and design sessions. Evaluated hardware, software and services for cost, reliability, and performance. Conducted user interviews to gather design specifications. Worked with Developers to create Entity Relationship Diagrams and logical design modules. Identified and resolved database changes / integration issues. Partnered with vendors supplying hardware and services to ensure compliance with project requirements. Accountable for network configuration, hardware evaluation and recommendations, and infrastructure coordination between client and Oracle teams.

Selected Highlights
* Directed team to reverse reengineer and capture existing Nomad, DB2, and Oracle custom applications for a new application that included installing, configuring, and integrating Oracle WebServer with Netscape Enterprise Server. (Lockheed).
* Headed a CASE 5.1 custom development project that successfully created a data warehouse to support the tracking and management of immigration records within a UNIX Sun Server Environment.
* Oversaw a custom development project with up to 12 Consultant that included interfacing with users in developing specifications, resolving application / testing issues, and facilitating database design decisions.


EDUCATION / CERTIFICATIONS

* Completed Courses in Computer Science, Brigham Young University, Provo, UT
* Certifications: Oracle 10g OCA, Sun Java Programmer

Certifications
See above


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

Resumes in Lehi, UT | Resumes in Utah

View other IT MANAGER - DATABASES resumes, IT Manager resumes