Job Description :
Database Developer

The ideal candidate brings proven problem-solving and leadership experience and the ability to thrive in a highly collaborative and fast-paced work environment. Our client needs an individual who is passionate about software and is constantly pushing themselves to learn new technologies to develop better, faster and more efficient applications.

This is a hands-on technical role, requiring strong SQL Server DBA skills and proven experience in ETL development and support.

The role is responsible for:

Enterprise-wide data security, integrity, performance and availability
Support database project efforts
Create, maintain and apply SQL Server database administration standards
Manage SQL Server databases through multiple product life-cycle environments, from development to mission-critical production systems.
Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations
Refine and automate DBA processes, track issues, and document changes
Assist developers with complex query tuning and schema refinement.
Essential Duties and Responsibilities include the following. Other duties may be assigned. All work is performed with deadlines based on agency priorities.

Solution Analysis and Design

Performs analysis and design for medium-sized to large/complex development/maintenance projects
Develops and documents application designs and analyzes impact to existing systems and alternatives
Determines the impact and potential costs of proposed changes
Conducts and participates in peer design reviews

Software Development

Possesses and applies advanced knowledge of technology principles, best practices and procedures to the completion of complex software development assignments
Develops complex code and configuration data using secure coding practices
Ensures that all code, configuration data, and system documentation is accurate, complete, understandable, and adheres to our client''s standards
Addresses security vulnerabilities Use tools to assure security; analyze outputs; recommend corrective actions
Conducts and participates in code reviews

Software Testing

Develops and executes unit test scenarios and scripts to ensure comprehensive testing of business software using non-sensitive data
Gathers or creates test data necessary to execute test scripts in compliance with high standards.
Executes tests and documents results.
Works with QA on test results, defect remediation and script re-use.
Supervisory Responsibilities

This job has no supervisory responsibilities.

Skills and Abilities

Demonstrated ability to:

Ascertain and meet customer expectations
Work effectively and independently in a fast paced team environment where priorities can rapidly change
Prioritize own work activities with minimal guidance and coaching
Solve complex problems through discovery and analysis with minimal guidance
Complete complex projects independently with minimal oversight and direction
Manage competing priorities to meet goals
Learn new technologies and mentor others in learning new technologies
Communicate effectively orally and in writing
Develop and manage detailed and accurate work plans and appropriately communicate work plan risks and impacts to management
Provide, maintain and follow technical documentation
Demonstrated comprehensive knowledge of the following tools/technologies:

SQL Server 2012, 2014 and 2016 database administration experience
Database Performance Monitoring, Tuning and Optimization
SQL Server Integration Services development and support experience
Development of TSQL, stored procedures and SSRS
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
Experience of working with Windows server 2012 and 2016, and Active Directory
Knowledge of SAN Storage
Ability to organize and plan work independently
Ability to multi-task and context-switch effectively between different activities and teams
Other Skills and qualifications:

Data Warehouse design, development and support
Data Modelling
Power BI
MCTS, MCITP, and/or MVP certifications a plus
Education and/or Experience

Candidates must have a Bachelor’s degree from a four-year college or university in computer science or closely related field and 7 or more years of experience.