MS-SQL Data Base Administrator

Skills Required: 
Candidate must have experience performing standalone installation, adding features to an existing installation and the upgrading of an existing instance of SQL Server to different edition. Working knowledge of the SQL Server Installation Center for maintenance. Ability to comprehend and author complex and extensive SQL script is a must, with the expectations of maintaining and rewriting legacy processes to accommodate versioning and infrastructure changes. SQL programming skills should be denoted via efficient and effective syntax, acceptable peer code reviews, demonstrable product results, and documentation principles. Candidate should be extremely proficient with Data Manipulation Language (DML), Data Query Language (DQL), Data Definition Language (DDL), Data Control Language (DCL) and SQL Server Integration Services (SSIS) Packages as well as data management concepts such as normalization, aggregation, concurrency, and data modeling, to include data interchange formats such as JavaScript Object Notation (JSON). Security driven concepts are top priority in all development and applied against standards set by the National Institute of Standards and Technology (NIST), Microsoft Trust Center (Azure Compliance) and any internal Departmental policies. Strong expertise in Data Modeling - Logical Modeling, Physical Modeling, Relational Modeling, ER Diagrams, Entities, Attributes, Cardinality, Functions, Views, and Triggers. Azure Cloud Services, BLOB Storage, SQL Data Tools, SQL Reporting Services and Amazon Web Services (AWS) are additional resources that the candidate should have work related experience with. Candidate must possess superior communication and documentation skills, strong decision making and organizational attributes along with exceptional analytical and problem-solving skills. Candidate will work closely with Project Management, Application Designers, Peer Data Administrators and Project Owners in workflow and business rule discovery, application design assistance, data modeling, and any applicable project related implementation of process controls.
Skills Preferred:

Experience Required: Candidate should have 5 to 10 years of experience working with various database management systems in the areas of database design, testing, implementation, maintenance and administration in a multiple platform environment and a required minimum of 5 years of experience in the role of a lead Microsoft SQL Server database administrator. Experience Required shall relate to the Skills Required section outlined in the Position Details within this requisition request.