Senior SQL Server DBA and Developer Resume

SUMMARY

Over 30 years of Information Technology experience, and over 18 years as a SQL Server DBA and Developer.
Managed large databases within production, COOP, UAT, QA, stage and development environments.
Experienced with Microsoft SQL Server 2000, 2005, 2008, 2008 R2, 2012, 2014, 2016 and 2017 performing: data acquisition, analysis and design, DBMS optimization, recovery strategy and load strategy design, and implementation.
Performed standard DBA tasks with SQL Server including: installation and configuration, security management, space management, performance monitoring and tuning, backup and restore, maintaining indexes, design and development of databases, policy based management, EPM, MDW, and UCP.
Created multiple logical and physical database designs using rules of normalization and sound design practices.
Used Query Analyzer, SQL Server Management Studio and Visual Studio to create/edit Transact SQL to create stored procedures, triggers, optimize code, and create maintenance scripts, including batch (.cmd files) and PowerShell scripts.
Transferred data using multiple ETL tools, including DTS, SSIS, BCP, and bulk load procedures from multiple environments (SQL Server, XML and flat data files).
Experienced in developing scripts to manage and report on server availability, space utilization, database consistency, update statistics, security audits, scan server logs and SQL Server logs.
Experienced with performance measuring and tuning methods using Windows performance monitor (PerfMon), SQL Activity Monitor, SQL Profiler and Extended Events.
Supported/used Crystal Reports, reporting services (SSRS), replication and clustering (WSFC).
Delivered large - scale systems with high quality and within prescribed timelines.
Performed standard network management tasks on Windows 7 and 10 and Windows Server 2008, and 2012.
Answered questions in Microsoft.public.sqlserver.* Usenet groups and SQLServerCentral.com.
Active user, developer and administrator of DB2, Hadoop, MongoDB, MySQL, Oracle, PostgreSQL, SQL Server, Sybase and Teradata databases.
Fast learner.
Extensive Unisys mainframe experience. Support all levels from customer to engineering.

PROFESSIONAL EXPERIENCE

Confidential

Senior SQL Server DBA and Developer

Responsibilities:

Started on site. Had to move for family reasons, I was invited to work remotely.
NCI (National Cancer Institute) database development and administration as required.
NIDDK (National Institute of Diabetes and Digestive and Kidney Diseases) database development and administration as required.
Reviewed database backup schedules and procedures and implemented changes.
Developed PowerShell scripts for routine monitoring and ETL.
Scripted verification that full/differential/log backups were taken correctly and emailed violations.
For HIPAA, wrote logout monitoring together with login to give date-time per session.
Used SSMA and migrated several servers to SQL Server 2014.
Wrote Full/Differential/Log shipper.
Simplified password change procedures.
Added logging to SSIS jobs/packages.
Added check datasource connections to SSIS packages. email on failure.
Parameterized SSIS packages and jobs.
Simplified SSIS package modifications.
Decoded SSIS packages by writing an XML shredder.
Used for understanding/documenting packages
Proposed and implemented Enterprise Policy Management (EPM) Policy Based Management (PBM) of SQL Servers.
Full SQL Server support including SSAS, SSIS and SSRS, including report creation.
Support of SQL Server 2000, 2005, 2008, 2008 R2, 2012, 2014, 2016 and 2017.
Used Docker on home iMac to run Linux SQL Server 2017.
Attended weekly one hour session on Big Data and Analysis.

Confidential

Senior SQL Server DBA and Developer

Responsibilities:

Developed inventory system and database using T-SQL.
Reviewed databases backup schedules and recommended changes.
Pointed out backup to be taken to another server should be copy only.
Recommended changes in security environment.
Proposed and implemented Enterprise Policy Management (EPM) Policy Based Management (PBM) of SQL Servers.
Full SQL Server support including SSAS, SSIS and SSRS.
Created reports.
Support of SQL Server 2005, 2008, 2008 R2 and 2012.
Used SQL Server 2014 for development.

Confidential

Director of Data Engineering and Analysis

Responsibilities:

Audited the database to show problems/bottlenecks/mislaid items:
Used SQL Server 2008 R2, Access and Excel to present/analyze data.
Wrote Excel VBA to neatly present Show Details from pivot tables.
Wrote Access VBA to check backups/restores on SQL Server.
Wrote Access VBA to drive SQL Server, Excel, PowerPoint, Word and Outlook for weekly reports for management.
Wrote Access VBA to generate VBA code in Excel workbooks using the VBE object model.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship