Senior SQL Database Specialist - Washington, United States - Lorven Technologies

    Lorven Technologies
    Lorven Technologies Washington, United States

    4 weeks ago

    Default job background
    Description

    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 (e.g., Cognos)/back-end programming languages (e.g., 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.