SQL Database Administrator / Developer

Job Summary:

The Database Administrator / Developer creates SQL logic and other objects of varying complexity in support highly customized reports, data migrations, applications stored procedures, and production data issues troubleshooting and resolution.

Duties and Responsibilities:

·       Designs, develops, builds, analyzes, evaluates and installs database management systems to include database modeling and design, relational database architecture, metadata and repository creation and configuration management.

·       Uses data mapping, data mining and data transformational analysis tools to design and develop databases.

·       Determines data storage and optimum storage requirements.

·       Prepares system requirements, source analysis and process analyses and design throughout the database implementation.

·       Performs other related duties as assigned by the Database team lead.

·       Assist in the planning, analysis, documentation, design and development, and production support for a major application and database.

·       Support the team in analysis, design, development and testing of all required functionality iteratively, while incrementally developing a complete solution.

·       Work independently and efficiently with minimum supervision, but also within a collaborative team environment.

·       Perform problem analysis.

·       Exhibit effective communications (verbal and written) are required to interface with customers and team members.

Requirements

Minimum Qualifications/Experience:

·       Minimum 7 years of experience as a database administrator or developer DBA.

·       Strong working experience with Microsoft SQL Server (versions 2008, 2012, 2016, and above) to include:

o   SQL/T-SQL, stored procedures, functions, cursors, and triggers

o   Query performance optimization and SQL exceptions analysis

o   SQL Server Reporting Services (SSRS)

o   SQL Server Integrated Servers (SSIS)

o   Data migrations/ETL

o   Data normalization

·       Familiarity with database design and implementation.

·       Demonstrated ability to develop SQL logic and reports to documented requirements and specifications of varying complexity.

·       Strong verbal and written communication skills.

·       Ability to work independently as well as collaboratively.

Desired Skills:

·       Crystal Reports

·       Experience with TOAD

·       Microsoft Power BI

·       Knowledge and Experience with Azure SQL

Minimum Education:

·       Bachelor’s Degree Required.

Other:

·       U.S. Citizenship required for clearance eligibility.