SQL Developer

The SQL Developer assists in the process automation, the daily updating of the data using SSIS from an Oracle RDB database to a SQL Server 2014 or later database, and SQL Server 2014 or later database administration.  The position is involved in the operation, maintenance, and on-going development of the jail management application. The successful candidate will need to be able to write extensive SQL Query statements.  This position is responsible for the monitoring and performance of reports. The SQL Developer position is also responsible for the technical aspects of a data warehouse, primarily administering databases and resolving all issues to ensure data accuracy. The SQL Developer will perform data warehouse design and construction; perform extensive testing, as well as ETL and repository creation. This position will coordinate with other team members and managers to translate business needs into technical solutions. 

Essential Functions

    ETL (Extract, Transform, and Load): Monitor and safeguard the ETL process to extract the data from Lock and Track into a data warehouse Staging area using SSIS as well as to implement additional data sets from new data sources.

    Monitoring and safeguarding the ETL process to move the data from the Staging area into the data warehouse star schema using SSIS.  Maintain and enhance the business rules and transformations that will be utilized to cleanse and standardize the data

    Design and implementation of aggregate tables, views, and virtual tab

    SQL Server Database Administration: Perform aspects of database administration to support optimal performance of the data warehouse

    Handling of routine operational issues that come up with the data warehouse

    Responsible for working with the MIS staff for backup and recovery procedures

    Creating SSIS scripts including ETL packages

    Building SSRS reports with Visual Studio

    Data modeling

    Supporting Windows 2012-2019 Server Operating Environments

    Supporting Microsoft SQL Server 2014 or later

    Supports IJMS (Lock & Track) Operating Environment

    Training MIS Support Staff

    Provides feedback on software licensing needed for the position

    Works with Central OIT staff and contracted staff on operations and project work

    Provides end-users training

    Knowledge of SSRS environment support

    Maintains Reporting Intranet site

Competencies, Knowledge, Skills and Abilities

    Microsoft SQL Server 2014 or later database

    Microsoft SQL Server 2014 or later SSIS (Data Transformation Services)

    Standard Query Language (SQL)

    Oracle RDB 7.3 (Backup and Recovery)

    SQL (Backup and Recovery)

    PostgreSQL 12

    ODBC connectivity

    Technical Documentation

    SQL for Oracle RDB 7.3

    OpenVMS 8.4 or later

    Extract Transformation and Load (ETL)

    Data access management using Active Directory and securing reports

    Query writing to business level requirements

    Data governance