Team Lead, SQL Database Administrator Resume Lakewood, NJ - Hire IT People

SUMMARY:

15+ years of experience with various Microsoft products and technologies.
Attended training for Database Administration and Performance Tuning. Microsoft Certified Professional, Database Administration for SQL Server 2005.

TECHNICAL SKILLS:

Microsoft SQL Server 2008/2012/2016
Database, Reporting, Integration, & Analysis Services
SQL Server Business Intelligence Studio
T - SQL
Functions, Stored Procedures, Triggers
Microsoft Dynamics SL 2015
Windows SharePoint Foundation 2013
Microsoft Windows Server 2008/2012
IIS 6.0/7.0
Active Directory
Powershell 5
C#

EMPLOYMENT HISTORY:

Confidential, Lakewood, NJ

Team Lead, SQL Database Administrator

Implementation, design, and maintenance of custom databases, web front end applications, SSRS hosted reports, SSIS packages, SSAS cubes.
Work with Senior Management, SQL Report Writers, and Business Analyst in developing queries and stored procedures for reports on company KPIs.
Creation and modification of database replication and SSIS packages to consolidate data from MS Dynamics and custom Project Tracking database into a data warehouse.
Work with IT Network group in setup of new SQL Servers, SQL Application installation, and providing resources for new software requiring a SQL backend.
Creation and monitoring of backups, SQL Database Replication, and other scheduled maintenance tasks.
Implemented Alerts on SQL Performance Conditions to automate notifications for unexpected growth with the tempDB and deadlocks.
Powershell scripting to execute queries on multiple servers for collecting metrics and settings to consolidated spreadsheets for review.
Identify and resolve performance issues to prevent application downtime using Performance Monitoring and SQL Profiler to collect performance metrics.
Provide guidance to Software Engineers, SQL Report Writers, and Business Analyst with SQL Server and T-SQL related questions to redesign queries or implement new indexes to improve performance.
Implemented User-Defined Table types to replace passing of comma delimited strings as stored procedure parameters.
Improved performance using Linked Servers by designing stored procedures that are remotely executed.
Support for SharePoint Services installation ensuring application availability and providing guidance to SharePoint power users with security configuration and feature availability.

Confidential, Wellington, NZ

Test Analyst

Reviewed Solution Design document to ensure application features met requirements specified by the client in the System Design document.
Developed test cases for acceptance and functional testing of application features.

Confidential, Wellington, NZ

C# Developer

Designed test scripts for automated acceptance testing of website functionality.
Developed class objects to work with existing C# Windows Form Application in outputting test scripts.

Confidential, Basking Ridge, NJ

SharePoint Application Developer/Analyst

Assisted IT Web Services organization by supporting Windows SharePoint Service application.
Worked closely with SQL DBAs and network administrators in maintaining components of SharePoint environment.
Conducted training sessions for new site administrators.

Confidential, Oceanport, NJ

System Test Engineer

Wrote and executed manual test cases for Acceptance, Functional, and Regression testing of suite of applications for Microsoft Windows Server, SharePoint, and Exchange products.
Wrote detailed defect reports to development teams for analysis and implementation.
Served as subject matter expert for MS SharePoint and CommVault’s SharePoint agents.
Developed C# applications for use on test SharePoint sites and to generate large data sets for back-up performance testing.

We provide IT Staff Augmentation Services!

Team Lead, Sql Database Administrator Resume

Lakewood, NJ

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship