Senior SQL Database Specialist -- Contract -- Onsite

Job Title: Senior SQL Database Specialist

Job Location: Washington, DC (Onsite)

Duration: 12+ months Contract

Position Description:

The candidate will provide all activities related to the administration of computerized databases, write SQL Server queries, and conduct backend development for the CATCH project and other TANF-related projects as needed. They will also manage system DBs as required.

Position Duties:

• Work with the Application Software Development (ASD) Division for database-related activities on the CATCH project.
• Write SQL Server queries and conduct backend development for the CATCH project and other TANF-related projects as needed.
• Develop procedures and scripts.
• Develop, implement, and optimize stored procedures and functions using SQL for CATCH Application.
• Designs, creates, and maintains databases in a client/server environment. Develop scripts for migration of CATCH data.
• Review and interpret ongoing business report requirements to develop high-quality database solutions.
• Expert knowledge of the Structured Query Language (SQL)environment with particular emphasis on planning, analysis, design, and implementation of reports and report interfaces intended for the end user.
• Develop procedures and scripts for data migration.
• Develop, implement, and optimize stored procedures and functions using SQL.
• Review and interpret ongoing business report requirements to develop high-quality database solutions.
• Research required data for analysis.
• Assists with activities related to the design and administration of databases.
• Designs, creates, and maintains databases in a client/server environment.
• Familiarity with the use of SSIS and linked servers.

Position Responsibilities:

• Provides all activities related to the administration of computerized databases.
• Projects long-range requirements for database administration and design in conjunction with other managers in the information systems function.
• Designs, creates, and maintains databases in a client/server environment.
• Conducts quality control and auditing of databases in a client/server environment to ensure accurate and appropriate use of data.
• Advises users on access to various client/server databases.
• Designs, implements, and maintains complex databases concerning Job Control Language (JCL), access methods, access time, device allocation, validation checks, organization, protection and security, documentation, and statistical methods.
• Applies knowledge and experience with database technologies, development methodologies, and front-end (., Cognos)/back-end programming languages (., Structured Query Language (SQL).
• Performs database programming and supports systems design.
• Additional duties include maintaining database dictionaries, overall monitoring of standards and procedures, file design and storage, and integrating systems through database design.