Sql Server Dba
Resume:
SHANE F. LOBSINGER
Danville, CA **526
**************@*******.***
SUMMARY: SQL Server DBA with 20+ years’ experience in database design, development, and administration. Proficient in SQL Server 208 and higher, and scripting with PowerShell.
EXPERIENCE:
Nov 2012 – Present Chevron (contract assignment)
Senior SQL Server DBA San Ramon, CA
Expertise in MSSQL.
Created Azure SQL databases for cloud project.
Created, modified, and analyzed queries, stored procedures and performed other database engineering tasks for security applications.
Performed backups, restores, and recovery of databases.
Performed disaster recovery exercises to verify database backups.
Performed annual login and user security checks, creating and tracking domain groups instead of individual users. Performed annual password changes.
Diagnosed performance issues with SQL Profiler and Perfmon.
Implemented transactional replication.
Wrote and refined queries from ServiceNow data warehouse.
Created PowerShell scripts to retrieve data and schedule SQL tasks.
Wrote and maintained documentation for SQL installation, backup/restore processes.
Used Task Scheduler and SQL Agent to automate backups and tasks.
Feb 2011 – Oct 2012 UnitedHealth Group (contract assignment) Plymouth, MN
Senior SQL Server DBA
Acted as lead DBA to migrate 250+ SQL Server servers containing 4,000+ databases between datacenters using backup/restore and bcp.
Acted as lead DBA to install, configure, and support SQL Server and security measures for Dept of Defense (Tricare) healthcare project.
Implemented and supported high availability SQL clusters.
Performed multiple tasks with several DBAs on a team.
Worked with large databases, 4TB+.
Optimized databases with indexes and analyzing queries and stored procedures.
Aug 10 – Feb 2011 The Lacek Group Minneapolis, MN
Database Developer (contract assignment)
Created SQL queries for marketing campaigns.
Administered SQL servers.
Jan 07 – July 2010 UnitedHealth Group Plymouth, MN
Database Administrator (contract assignment)
Created SSIS solutions to extract data from 400+ databases on 20+ SharePoint servers, inserting into Oracle for chargeback model based on site usage.
Created custom log-shipping solution.
Migrated/upgraded SQL Server 2000 databases to SQL Server 2005
Supported SQL Server 2000, 2005, 2008 high-availability implementations, including Windows & Veritas clusters, mirrors, and replication.
Oct 06 – Jan 07 Long Term Care Group Woodbury, MN
Database Analyst (contract assignment)
Converted data between two SQL Server 2000 databases using T-SQL (stored procedures, user-defined functions, queries)
Gathered and translated business requirements into design documents and T-SQL
Performed audit of conversion to ensure data consistency.
Apr 06 – Oct 06 UnitedHealth Group Plymouth, MN
Database Administrator (contract assignment)
Performed database backups, restores, and maintenance.
Diagnosed performance issues with SQL Profiler and Performance Monitor.
Maintained databases on high-availability SQL Server clusters.
Installed/configured/maintained SQL Server 2000 and 2005.
Aug 05 – Apr 06 Carlson Companies Minnetonka, MN
Database Administrator (contract assignment)
Administered database backups, restores, and disaster recoveries.
Monitored database activity and made performance improvement recommendations.
Mar 05 – Aug 05 NCS Pearson Bloomington, MN
Database Analyst (contract assignment)
Designed, developed and integrated datawarehouse and subject-area datamarts in SQL Server 2000 for Business Objects reporting application.
Participated in business analysis meetings to discover metrics for data warehouse.
Dec 04 – Mar 05 Motivaction Minneapolis, MN
Database Analyst (contract assignment)
Led multiple database integration projects between SQL Server and AS400.
Designed and developed database structures for enrollment websites.
Converted Excel and online reports to SQL Server 2000 Reporting Services.
Apr 04 – Dec 04 Wells Fargo Minneapolis, MN
Database Consultant (contract assignment)
Integrated proprietary web-based CRM system (Athena) on SQL Server 2000.
Provided SQL Server database expertise in requirements-gathering processes.
Developed ad-hoc reports with SQL Server 2000 Reporting Services.
Mar 03 – Apr 04 UnitedHealth Group Plymouth, MN
SQL Server/Sybase DBA
Performed backups, restores, disaster recoveries, and database maintenance.
Automated infrastructure notifications using NetIQ, HP Openview, and SQL Server.
Designed SQL Server 2000 dimensional datamart for security operations group.
Jan 02 – Jan 03 Capital Professional Advisors Minneapolis, MN
Systems Analyst
Administered SQL 7.0 and Oracle 8i database systems.
Integrated Oracle 8i and SQL Server 7.0 databases for reporting system.
Assisted with modifications and maintenance of company’s ASP pages.
Jul 00 – Aug 01 Breakaway Solutions Minneapolis, MN
CRM/DBA Consultant
Administered SQL Server 7.0 databases for Onyx application.
Integrated database systems with DTS and T-SQL for Onyx application.
Wrote SQL stored procedures, ASP, and Visual Basic.
May 98 – Jul 00 American Express Financial Advisors Minneapolis, MN
Software Programmer
Developed stored procedures for Onyx CRM application on SQL Server 7.0.
Upgraded OLAP system for Y2K compliance.
Nov 96 – May 98 Buffets, Inc. Eden Prairie, MN
NT/RemoteWare Administrator
Administered restaurant SQL server, Exchange server, and NT domain servers.
Provided technical and application support to 350 restaurants nationwide.
INDEPENDENT
PROJECTS:
(part-time)
Jun 06 – Aug 06 TLC Trucking Brooklyn Park, MN
Database Consultant (contract assignment)
Brought in as database consultant to analyze database performance issues (website reports retrieved data too slowly)
Monitored overall system performance with SQL Profiler and Perfmon and provided summary and recommendations for performance enhancements.
Discovered main problem was related to the usage of user-defined functions (UDFs) for retrieving payroll information and used temporary tables instead of the UDFs to improve speed of stored procedures (in some cases from ten minutes to thirty seconds).
Jun 06 – Aug 06 Minute Clinic Minneapolis, MN
Database Consultant (contract assignment)
Provided high-level analysis and summary of existing SQL Server installation, and made recommendations for potential improvement.
EDUCATION:
Jul 94 Jamestown College Jamestown, ND
B.A. History
SKILLS: SQL Server (6.5 > 2022), Azure SQL, Integration Services, Reporting Services, SharePoint, Sybase, Oracle, HP OpenView, ASP, HTML, VBScript, Magic, Onyx, IIS, Windows, DOS, Unix, Idera SQLSafe, RedGate SQL Compare
Contact this candidate