SQL/DBA Data Architect in Winston-Salem, NC at MDI Group

Date Posted: 5/28/2018

Job Snapshot

Job Description


SQL/DBA Data Architect
Direct Hire
Winston-Salem, NC

The SQL DBA/Data Architect will serve as the lead database administrator and also play an integral role in BI initiatives and general SQL Server/.Net development. This individual will work closely with our development team to ensure appropriate practices are adhered to in regards to creating database schemas, indexes, and stored procedures, as well as BI and .Net development. 
 
What you will be doing: 

Interface between developers, end users, and help desk resources to bring application issues related to database infrastructure to resolution
Perform day to day database functions to support developers such as managing incident management tickets, security administration and execution of backup and restores procedures.
Work as principal database administrator to help resolve and troubleshoot issues, support security and end user access requirements.
Perform tasks such as build out of MS SQL server test environments, consolidate/cluster and upgrade to MS SQL server, and implement monitoring improvements
Infrastructure/Application/Developer Support
Support developer team efforts in a web development environment - provide support for code promotions, troubleshoot development issues, and drive resolution
Support administrators in an IT operations group - participate in standard maintenance and patching activities, troubleshoot with cross functional IT personnel to resolve application/infrastructure issues
Follow established policies and procedures related to ITSM including incident, change, and problem management
MS SQL Server stored procedures, ER diagrams, tables, views, triggers, UDFs etc.
SQL Administrative Performance Tuning, analysis of execution plans, SQL Profiler
Data Warehouse/ BI Solution Design
Dimensional Modeling, Dashboards and scorecards, Dimensional/ Star Schema design, ETL frameworks
BI tool end user support and maintenance
BI SharePoint integration, publishing
MS SQL Reporting Services - Drilldown & Drill through SSRS report and sub report Creation, subscription creation
MS SQL Integration Services Complex SSIS package creation, configuration and deployment
 
Required:
Minimum 5 years or more of in-depth database experience with MS SQL server 2005, 2008, & 2012
Hands on solutions architecture with MS BI solutions.
Experience in performance tuning and monitoring using native Microsoft performance and monitoring tools
MS SQL management studio and SQL Profiler
Perform code reviews and assisting developers with tuning for queries, stored procedures, functions, etc.
Develop and troubleshoot advanced stored procedures
Experience supporting and developing .Net applications
Create scheduled tasks and database jobs for application, archiving, and maintenance purposes
Perform database capacity planning and providing architecture recommendations for the underlying storage and virtualized infrastructure
Backups, restores, recovery models and using backup tools
Experience with the various high availability and disaster recovery options for Microsoft SQL
Experience with ticketing and change management processes
Work in a team environment with the various tiers of IT roles like help desk, developers, system administrator and management.


CHECK OUT OUR SIMILAR JOBS

  1. Developer Jobs
  2. DBA Jobs

A GREAT PLACE FOR GREAT PEOPLE TO WORK

Search IT Jobs