SQL Server DBA/Developer Resume Libertyville, IL - Hire IT People

TECHNICAL SKILLS

Development Environments: Visual Studio.NET - C#, Delphi, PowerShell, VMWare Player

Databases: SQL Server, Oracle (PL/SQL), TOAD, MongoDB

Version Control: Microsoft Team Foundation Server, GitHub

PROFESSIONAL EXPERIENCE

Confidential, Libertyville, IL

SQL Server DBA/Developer

Responsibilities:

I configured and maintained SQL Server 2014 Transactional Replication initialized from snapshots and from database backups.
I resolved database performance issues by creating the appropriate indexes based on joins, where clauses, and fields in select statements.
I used DMVs such as sys.dm db missing index details to assist with the optimization of poorly performing views and stored procedures.
I updated the default settings for memory, parallelism, and the tempdb on newly installed SQL Servers.
I upgraded servers from SQL Server 2005 to SQL Server 2012 and moved databases and server objects by scripting detach and attach statements, users, permissions, jobs, database mail, and configuration settings.
I have written many complex SQL Server stored procedures using CTEs, the ROW NUMBER function, and dynamic SQL when necessary.
I created ETL routines to move data from local servers to Microsoft Azure using SSIS, stored procedures, BCP, and Partitioned tables.
I created ETL stored procedures that restore backup files, extract specific data, and write the records to target databases.
I developed a web application using Visual Studio 2012 (MVC 4) with a MongoDB backend database.

Confidential, Rolling Meadows, IL

SQL Server DBA

Responsibilities:

I set up and maintained SQL Server 2008 R2 Transactional Replication.
I configured SQL Server Column Level Encryption with Symmetric Keys, and I am familiar with TDE as well.
I used CommVault to manage SQL Server backup and restore requests.
I managed permissions for SQL Server logins, users, and roles.

Confidential, Libertyville, IL

SQL Server DBA/C# Developer

Responsibilities:

I automated the reporting of disk drive space, database failures, blocking SPIDs, and server failures by creating a stored procedure that called PowerShell scripts and queried system tables across multiple servers.
I designed a generic routine to move very large datasets (600 million records) across servers in 50000 record increments
I wrote stored procedures to import text and XML files..
I created a C#.NET console application to import Excel files into SQL Server.
I worked with the HTML5 Canvas object to create custom graphs.

Confidential, Lake Forest, IL

Sr. BI Developer

Responsibilities:

I wrote SQL Server 2008 SSIS packages to move data across servers.
I used SQL Server 2005/2008 Reporting Services (SSRS) to write RDL objects.
I re - wrote a very complex stored procedure by replacing cursors with recursive CTEs, which drastically increased performance.
I would most likely use the LEAD and LAG functions to accomplish the same results in the newer versions of SQL Server.

Confidential, Evanston, IL

Sr. Database Administrator

Responsibilities:

I configured SQL Server 2008 Database Mail, which allowed query results to be scheduled and emailed to specific users.
I synchronized development, test, and production databases.

Confidential, Reno, NV

DBA - Sr. Software Engineer

Responsibilities:

I created stored procedures to calculate slopes and process mathematical algorithms.
I wrote C#.NET desktop applications using LINQ and the Entity Framework.

Confidential, Reno, NV

Sr. Database Architect and Administrator

Responsibilities:

I created SQL Server 2005 TSQL database conversion and migration scripts.
I configured SQL Server 2005 replication through custom scripts in order to replicate inserts and updates, but not deletes.
I created SQL Server 2005 SSIS packages.
I wrote a C#.NET console application using SMO to automate the scripting of database objects and selected data.

Confidential, Reno, NV

DBA/Sr. Software Engineer

Responsibilities:

SQL Server 2000 DBA and .NET Developer
I administered four 500 GB databases.
I set up and managed SQL Server 2000 replication.
I wrote SQL Server 2000 DTS packages for ETL purposes.
I was in charge of all database backups and performed restores when needed.
I wrote C#.NET Web Services.
EDI (Electronic Data Interchange) Project Manager
I supervised 6 employees.
I worked with Sterling Commerce Gentran Server for Windows and used this application to configure and test B2B transactions with major retailers.
I mapped EDI 810, 812, 816, 820, 850, 856, and 864 documents.