MS SQL Data Engineer/Administrator Resume

SUMMARY

MS SQL Server Database Administrator with 18+ years’ experience.
Strong work ethic, excellent communication skills, and highly knowledgeable in Microsoft SQL Server 2000 - 2019.
Highly skilled at MS SQL Server Technologies including: Always On Availability Groups, Replication (transactional, merge and snapshot), Mirroring, High Availability, Disaster Recovery, SQL Profiler, Performance Monitor, DBCC, BCP, Backup and Recovery, SSIS, SSRS (MS Reports).
Proficient in writing code (SQL or Python scripting) to extract transform and load (ETL) from any data source to any data source.
Proficient in Microsoft C# coding to build data driven API’s and web-based applications.
Ability to work with PaaS and IaaS vendors to implement cloud and/or hybrid data solutions.

PROFESSIONAL EXPERIENCE

Confidential

MS SQL Data Engineer/Administrator

Responsibilities:

MS SQL Server 2008-2019 DBA and developer
Reviewed and performed MS SQL Server best practices.
Working knowledge in an Agile (Scrum and Kanban) environment.
Installed and upgraded MS SQL Server 2008 to SQL Server 2017 HA Always On Availability Group Cluster on premise.
Implemented and administrated MS Azure SQL Server 2017 HA Always On Availability Group Cluster for multi-terabyte data warehouse.
Analyzed and mapped data for conversion of an MRP system to a new SAP S/4Hana ERP system (Paas).
Implemented multiple Power BI dashboards and reports for single source high level data aggregation used by upper management for displaying KPI information.
Implemented restful api to transfer data between systems.
Implemented C# web portal for shipping reports including commercial invoice and bar-coded shipping labels.
Documented business systems and data flow using Visio, LucidChart, Jira and Confluence.
Communicated best practices and ROI with upper level management.

Confidential

MS SQL Database Administrator

Responsibilities:

Microsoft SQL Server DBA Installed and administered Always on availability groups, replication, mirroring and clustering for high availability. Including SQL Server 2017 running on Linux (2 nodes/1 witness and 3 node cluster) with Pacemaker as a WSFC alternative.
Amazon Web Services Installed and administered AWS Data Migration Services for replicating SQL Server 2016 (Source) to a MariaDB 10.3 (Target) used for replication to 5 read replicas in multi-regional data centers around the globe. This project saved Confidential over $100K in SQL Server licensing fees.
Google Cloud Platform Installed and administered Attunity Replicate for replicating SQL Server 2016 (Source) to a multi master (7 nodes) MariaDB 10.3 (Targets) located in multi-regional data centers around the globe.
Nagios Server Installed and administered for monitoring SQL Server and MariaDB running on-prem and in AWS and GCP data centers.

Confidential

MS SQL Database Administrator

Responsibilities:

Implemented and administrated Microsoft SQL Server 2017 HA Always On Availability Group Cluster on premise.
Implemented and administrated Microsoft Azure SQL Server 2017 HA Always On Availability Group Cluster.
Automated backup and recovery (to a development server) through jobs calling stored procedures.
Automated database checks and index rebuilds for all production databases generically so when a new database is added to the server all backups, checks and rebuilds are automated.
Performance tuned multi-terabyte databases.
Implemented a company wide data warehouse to analyze data from different data sources (SQL Server, Access, Excel, MySQL, Oracle, Postgres and SQLite) into a single source of truth data warehouse.
Implemented a SQL Server Reporting Services front end for all data warehouse analytical reports.
Implemented shell scripts and CRON jobs to run backup and maintenance scripts for Oracle 11g databases.