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