We provide IT Staff Augmentation Services!

Mssql Server Administrator Resume

Moline, IL

SUMMARY:

  • 5+ years combined experience as a MSSQL Developer With ETL
  • 2+ years of programming experience with .NET Framework 3.0 - 4.6, C#3 - 6
  • Strong experience writing complex queries, stored procedures, triggers, scalar functions and performing DBA duties in SQL 2008R2-2016
  • 3 years combined experience developing with Dynamics CRM and Dynamics GP
  • 2+ years experience developing ETL SSIS projects with MSSQL & Kingswaysoft
  • SSIS, SSRS and SSAS Tabular with DAX and Oracle 12c
  • Development experience with Crystal Reports with MSSQL Backend Queries
  • Experience with TFS and Azure Devops Agile Tools and Scrum methodology

PROFESSIONAL EXPERIENCE:

Confidential, Moline, IL

MSSQL Server Administrator

Responsibilities:

  • Primary role to work with John Deer staff in a standard MSSQL Audit Compliance Project
  • Operated to detect and fix login credentials for users, service accounts and SA accounts
  • Updated recovery models and backup locations for Disaster Recovery
  • Identified and fixed outstanding updates, patches and decommissions
  • Provide Tier III dealer hosting support that includes cyber security and dealer application support
  • Audit query performance and overall server performance and query maintenance to reduce usage cost

Confidential, Moline, IL

MSSQL Developer

Responsibilities:

  • ETL Project Development using KingswaySoft and SSIS within Visual Studio 2015
  • Development with C#, SQL SP and JavaScript to customize forms, entities, workflows and dashboards
  • Azure SQL Dynamics interregional development
  • Mid Level Dev of C# 6 Projects with .NET 4.0-4.7 Framework to customize Dynamics 365
  • Maintenance of IMM Workflows and Dynamics CRM Business Logic Workflows
  • Source Control Best Practices with TFS and extensive Documentation
  • Build FetchXml Queries within Dynamics 365
  • SSIS Package Development for ETL, ODS and Staging for data migration and management
  • SSRS with SSAS Report Development including MSSQLTabular Data Development
  • SQL Queries, Views, Stored Procedure Development with DBA duties
  • Development and Maintenance of REST APIs

Confidential, East Moline, IL

Legacy VB6 and SQL Developer

Responsibilities:

  • Work with legacy Batch jobs, transaction files and master files in order to update data flow.
  • Develop and update VB6 Case/Switch statements to work in SQL2014 SP, Jobs and Triggers.
  • Study and understand VB6 software in order to rewrite to C#6 and SQL 2012.
  • Understand and map out MS Access VB Macros and Modules in order to rewrite to C#6 and MSSQL 2012/2014 Stored Procedure, SSIS Jobs, Triggers and (scalar) Functions.
  • Create and maintain SharePoint Online and 2013 Sites
  • Work closely with upper management to follow strict and complex project direction.
  • Document all work including software logic and data flow

Confidential, Peoria, IL

MSSQL Developer

Responsibilities:

  • Programmed SQL imports, SQL Report with email jobs for automated report emails
  • XAML GUI development including mocks, packaged styling with Bootstrap, Angular, LESS and SASS
  • ASP.Net MVC 4, ASP.Net MVC 5 with C#6 and Entity Framework as desktop application development
  • Use of C# classes, methods and statements to control the back-end of MVC projects
  • SQL 2014 data management including table creations, index, queries, jobs and stored procedures
  • Productivity Tracking software developing from concept to publication on multiple platforms
  • Legacy program migration from Angular Web Apps to MVC Apps
  • User manual research and creation including project and application documentation
  • Power BI Reporting Set up and Staff that included setting up SQL Tabular Analysis Service
  • Worked to move office staff from excel to Power Bi for improved reporting
  • Trained staff on how to use Power Bi with Tabular Data Models to increase overall reporting
  • Developed numerous Power Bi Templates to standardize meta-data, dashboards, corporate image, ease of use and performance when passing DAX, SQL, Power Query and MDX.
  • Created inventory forecast reports to work in combination with inhouse MVC floor application (beta).

Confidential, North Dakota

MSSQL Developer and DBA

Responsibilities:

  • Successfully consulted in the restructuring and rebuilding of the IT Software Department
  • Developed and maintained over 50 production C#3-6 WinForms desktop applications
  • Developed with .Net Framework 4.0 - 4.6, Visual Basic 6.0, C#3 and Access Databases
  • Extensive experience writing stored procedures, triggers, complex views and queries, agent jobs in SQL 2008R2/2014
  • ETL data warehousing with SSIS projects, complex date ranges and BOM inventory
  • Microsoft Dynamics GP 2013/2015 backend development
  • Introduce Project Panorama 1.2 to track software and bug development
  • Proven track record of delivering complex, high-quality user-friendly applications
  • User manuals and software documentation
  • Developed Crystal Reports 11.5, 2008R2/2014 SQL Reports, SharePoint Server 2013 Web Report Portals, SSRS Pivot Reports
  • DBA duties including deadlock investigation and repair, job maintenance, report building, stored procedure maintenance and development of production and development servers
  • Table indexes management with third party tool Idera

Confidential, Los Angeles, CA

ASP.Net Developer

Responsibilities:

  • Developed complete ASP.Net 4.0 websites and customer portals
  • Work with Visual Studio 2010, C#4 with SQL 2008R2 back-end environment
  • Frontend web developed with CSS3, HTML4, XML and JavaScript 1.8.5, XAML 2.0
  • ADO.Net Web API dev with GET POST PUT DELETE SQL2008R2 data administration
  • Coordinated large projects with outside programming teams
  • Managed complete product development including marketing, distributing and outside-sales shopping cart programming

Hire Now