Database Administrator Resume

Title

Database Administrator

Primary Skills

Database Administrator, Report Writer (SQL), Application developer, Network Admin, PHP Developer

Location
US-UT-Taylorsville

Posted
Apr-26-12

RESUME DETAILS

SUMMARY

Over 15 years professional experience as a Database Administrator/Developer. Database disciplines include MS SQL Server 2008/2005/2000/7, MS Access, FoxPro, Paradox and MySQL.. Experience moving Access databases to SQL Server. Able to recognize changing needs and effectively modify systems while maintaining workflow for seamless transitions. Designed processes and procedures, which also included Back-up, Replication, Restore and Security. Writing SQL code (stored procedures, triggers, functions and database scripts) to implement business logic, warehousing and database maintenance. Possesses a broad range of experience in all aspects of Database Administration and have excellent written, verbal and presentation skills. Skilled and experienced in SSMS, SSRS, SSIS, SSAS, T-SQL, Reporting Services, DTS, SQL, Visual Basic, PHP, systems analysis/design, and networking. Comprehensive knowledge of software programs in areas including programming, database, tracking, spreadsheet, and word processing. Analytical, detailed, and methodical in approach. Disciplined with a strong work ethic. Also CCNA certified, which includes: OSI reference, WAN protocols, Cisco IOS, network protocols, routing, network security, and LAN switching.

TECHNICAL SKILLS
* SQL Server 2008/2005/2000/7, MS Access, FoxPro, Paradox, MySQL, T-SQL, VBA, PHP, systems analysis/design, networking, MS WAN protocols, Cisco IOS, network protocols, routing, LAN switching, MS Project, Time Lines, Primavera, AutoCAD

PROFESSIONAL EXPERIENCE
Sr. Database Administrator - Jul. 2011 - Apr. 2012
Xennsoft, Draper Ut.
DBA Responsible for all aspects of (8)live, (8)beta and dev environments. Monitoring and Maintenance improving performance of all sql environments. Code review for sql scripts.
* Maintain ETL, Data SSIS, Mirroring and application interfaces for 18+ servers.
Setup failover processes for 8 databases. Migrate from broken clustered environment to new mirrored environment.
Setup and manage security polices for all databases and SQL server environments
Establish routine maintenance processes and scheduled jobs for backup, restore for auto and manual failover environments.
Standardize databases (remove unused objects- procs, tables etc...)
Install setup client instances on beta and test. Then move online.
Setup performance and critical process monitoring.

Sr. Database Administrator - Dec. 2010 - Jul. 2011
Datamark, Westvalley Ut.
DBA responsibilities for all 12 servers (4 Mirrored Environment's 1 Data Warehouse 3 QA/Dev 4Production).
* Maintain ETL, Data Warehouse, SSRS, SSIS, Mirroring and application interfaces for 12 servers.
Setup failover processes for 8 databases.
Setup and manage security polices for all databases and SQL server environments
Establish routine maintenance processes and scheduled jobs for backup, restore, truncate of dev. Environments
Document database processes, procedures and security on intranet wiki. Lay ground work for new data warehouse.

Data Migration - Jul. 2010 - Dec. 2010
Thin Data 1 to 1, Murray Ut
Creating data dictionary and migrating database to new server as well as new ontological structure
* Querying system tables and views in order to build data dictionary
* Using reporting service to create a Data dictionary in a pdf format.
* Uploading data through stored procedures and SSIS.

Database Specialist Team Lead - May 2009 - Jan. 2009
Unisys, Salt Lake City, Ut.
Team lead over 12 SQL developers in setting up tier 2 support for 7-Eleven Production Support, while on Emergency Recovery Team in process of building Access (front-end) Data Project on a SQL Server 2008 backend for system recovery process.
* Import spreadsheet data using SSIS to build SQL Server 2008 recovery-tracking database for all of the 7-Eleven stores, which run on SQL Server 2005/2000.
Using reporting services build reports and automated E-mail for recovery process.
Troubleshoot database and software anomalies

Report Writer and data migration specialist. - Jun. 2008 - Feb. 2009
Fresenius Medical Care, Ogden, Ut
* Wrote and modified several ADP applications - Access front-end with a SQL Server back-end.
Migration from MS SQL Server 2000 to 2005 project.
Using T-SQL creating scripts to build tables, views, stored procedures, data schema, user groups and permissions.
Writing reports in Crystal Reports XI and MS Excel in order to replace an Access ADP Application.
Using Integration Services to build scripts for migration of data.
Setting up backup and restore processes on SQL Server 2005.
Combinin

SQL Developer - Jan. 2007 - Apr. 2008
Natures Sunshine Products, Provo, Ut.
Data warehouse developer/ analyst
* Building a Star Topology data warehouse using query builder to create DTS packages for Staging, Dimension and Fact tables.
Analyzing 16 international markets across six languages to create reports and normalize data across all markets in order to join data in Domestic markets.

SQL Developer - Feb. 2006 - Nov. 2006
American Express, Murry, Ut.
Increased accuracy in forecasting projects by designing and implementing an Access Data Project (Access front-end with a SQL Server 2005 Backend), for day-to-day project tracking and forecasting available hours.
* Moved several access databases to Access Data Project (ADP).
* Wrote and modified several Access Data Project (ADP) applications - Access front-end with a SQL Server back-end.
* Tune Databases by creating more efficient stored procedures and T-SQL statements.
* Set up links to MS Project and other databases to eliminate duplicate data entry.

Database Developer/IT Support - Mar. 2005 - Aug. 2005
Educators Mutual Association, Murray, Ut.
Designed and implemented Database systems.
* The first system improved Tracking of purchases and moved their process from MS Excel to MS Access enhancing speed accuracy and the ability to create reports.
* The Second was an asset tracking system as well as software tracking which resulted in savings for the new computer software.
* The third was a Telecommunications database for the Harris phone system which improved the ability to change phone lines from 60+ minutes to under 5 minutes. Built an inventory application on a PDA which shortened the time to inventory physical assets and trace phone lines. Expanded the capabilities of an existing SQL server 2000 database in a test environment by altering and populating existing tables.

Database Developer/IT Support - Jan. 2005 - Apr. 2005
Performance Plus Employment Services, Murray, Ut.
Designed and implemented Database system to track temporary employee's wages, time worked, as well as client information.
* Consolidated a three-step process into to one step, saving time and increasing accuracy.
Moved from Excel to Access.
Rebuilt the network hardware infrastructure.
Enhanced the speed and operation of the desktop PC's.

Database Administrator - Mar. 1996 - Oct. 2004
Primary Children's Medical Center, Salt Lake City, Ut.
Performed DBA responsibilities on SQL Server 2000/7, Paradox and FoxPro. Coordinated leadership in design and implementation of engineering program data management systems. Analyzed needs, requirements and scope of information system. Developed and maintained documentation tools and data collection instruments that generated program outcome reports. Integrated EMMA, AS4000, and Kronos database information.
* Migrated from Access 97 to SQL Server 7 using RDBMS, ODA, ODBC, and SQL while maintaining work flow.
Wrote programs that interfaced with Database through PDA's for preventative maintenance and infection control.
Modified and documented program code to correct errors and to enhance program capabilities.
Instructed the majority of engineering department in basic computer skills.
Prepared reports on status, operation, and maintenance of system software.
Decreased the amount of time on the

Senior CAD Draftsman - 1994 - Apr. 1996
Primary Children's Medical Center, Salt Lake City, Ut.
Produced blueprints for remodels and new construction. Maintained, upgraded, and troubleshot computers hrough ACAD and engineering software. Prepared presentations using desk top publishing practices and procedures that incorporated perspective renderings, floor plans, spreadsheets, and other pertinent technical information.
* Created an estimating program for in-house construction and maintenance, decreasing the average estimate time from 1 day to 20 minutes. Setup, help maintain and trained coworkers on MS Project.
Built and maintained as-built drawings in Auto-Cad for entire hospital for facility management and finance, which increased accuracy of facilities management and brought in increased revenue from per square foot charges.

EDUCATION
Computer Information Systems (CIS) - Aug. 1998
Mountain West College

Computer Aided Drafting (CADD) - Apr. 1992
ITT Technical Institute

Certifications

See above

CONTACT DETAILS

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