DCPS – Database and ETL Administrator (609020)

Contract with Government of the District of Columbia
DCPS – 1200 First Street NE, 9th Floor Washington, DC 20002
Position closes 10/28/2019

US Citizens or Green Card Holders Only

Short Description:

The DCPS IT Enterprise Application & Data Systems (EADS) Group requires the services of an experienced database administrator to support our Application Development and Systems Operation activities.

Skills/Required Years of Experience:

Experience with MS SQL Server (Required 8 years)
Experience with database backend and disaster recovery. (Required 5 years)
Progressive experience in database maintenance and ETL development (Required 5 years)
Progressive experience in a Virtual Server environment (Required 3 years)
Experience with SQL Server High Availability Solutions (Required 3 years)
Experience with ETL tools (SSIS preferred, but other ETL tools acceptable) (Required 5 years)
Experience with standard scripting languages (Shell, Perl, Python, etc.) (Required 5 years)
Experience of standard database concepts (query optimization, database tuning, data modeling, etc.) (Required 5 years)
Experience with data warehousing (Nice to have 2 years)
Experience with NoSQL (Nice to have 2 years)
Experience tuning SQL queries to optimize performance relative to application needs (Nice to have 2 years)
Experience with application development languages and tools a plus (Java, JSP, etc.) (Nice to have 2 years)
Experience with supporting tools and technologies including basic operating system tools (mainly Linux) and configuration options (Nice to have 2 years)
Designing, creating and maintaining databases in a client/server environment (Nice to have 2 years)
6-10 yrs planning, coordinating, and monitoring project activities (Required 6 years)
6-10 yrs leading projects, ensuring they are in compliance with established standards/procedures (Required 6 years)
Bachelor’s degree in IT or related field or equivalent experience (Required 10 years)

Complete Description:

  1. Background
    1.1 The District of Columbia Public Schools (DCPS) educates approximately 49,000 students in 111 schools and educational centers. It employs about 8000 teachers, principals, classroom aides, social workers, counselors, custodians and other support staff classified, to carry out the public education mission in DC. The District also counts amongst its facilities another four administrative locations and mission-oriented offices, such as the Central office location and support sites, warehouse and logistics facilities. Information Technology in the Office of Data Systems and Strategy (ODSS) creates policy and processes to assist schools, administrative offices, and staff integrate technology seamlessly to provide the very best educational experience for DC students.
    1.2 In the past, IT has utilized Tandem contractors to provide this service. On September 30, 2017, the contract ended and was not extended as the scope had changed.
  2. Purpose
    2.1 The Office of Data Systems and Strategy (ODSS) Information Technology Team is seeking bids for an Enterprise Application and Data Systems (EDS) Database Administrator to deliver operational support to the DCPS Data Systems for upkeep, and supplementary alterations to the Student Information System (SIS) and additional associated student data. These systems are the power behind the entire school District’s data. Work may vary between system and database management, client-based code improvement, application configuration, project requirements assembly, and necessary technical project management.
    2.2 The contractor will operate under the direction of the Director of Applications, who will directly manage the contractor team.
  3. Scope

Position Description:
3.1 The incumbent will have the primary responsibility of developing and maintaining internal databases and ETL scripts. Other duties may involve writing complex queries for reporting using raw SQL queries and scripting languages such as Perl, Python, etc. In addition to designing to fill a particular set of requirements, they will also balance immediate needs with future direction and ensure that work for one project can be leveraged for other purposes as much as possible.
3.2 Additional areas of focus include initiatives to increase report automation, making data more easily available to allow for self-service end user data pulls, and the creation of infrastructure to consolidate data transfer between the main Student Information System and other systems of record. In addition to technical skill, they must have a strong sense of curiosity as a critical part of the role will be to help come up with the future long-term vision for data systems in DCPS and plan out what should be built to implement that vision.

  1. Objectives
    4.1 The objective of solicitation is to obtain staff to develop and maintain internal databases and ETL scripts.
    4.2 It is an objective of this program that the contract define, as a minimum:
    4.3 Design, Analysis, and Test: The design of databases and ETL scripts to satisfy the DCPS Data Systems performance requirements. Performance of analysis and tests, as needed to aid the design process and to document the end item satisfies the DCPS performance requirements.
    4.4 Configuration Management: Establishment of a product baseline to define the configuration of the internal databases and ETL scripts with a demonstrated capability to satisfy the user’s performance requirements. Establishment and maintenance of a configuration management process to thereafter control the internal databases and ETL scripts configuration for the life of the contract. Documentation of the design of the product baseline through the use of engineering data. Establishment and maintenance of an Integrated Product Team, to include District personnel, for insight into the design’s progress.
    4.5 Quality Control: Development and maintenance of a quality program to ensure the internal databases and ETL scripts are produced in accordance with the engineering data. Development and implementation of procedures to properly maintain measuring and test equipment. Development and implementation of procedures to ensure appropriate corrective action of nonconforming material.
    4.6 Logistics: Development and delivery of all data necessary to support the internal databases and ETL scripts (including provisioning, installation, operational and repair manuals, and engineering data) consistent with the maintenance concept. Compatibility (form and format) of the data with existing government systems is fundamental.
    4.7 Management Objective: The management objective is to allow the District the maximum flexibility to innovatively manage the program schedule, performance, risks, warranties, subcontracts, and data to produce internal databases and ETL scripts that satisfies the DCPS’ performance requirements. Another objective is to maintain clear District visibility into the program schedule, performance, and risk.
  2. Tasks & Requirements
    5.1.1 The contractor shall meet in person with the Director of Data, within one (1) working day after issuance of the purchase order to begin professional services in support of DCPS operation.
    5.1.2 The contractors will be required to establish suitable processes and systems to guarantee the most regimented organization of resources involved in the support of the SIS including project tracking, knowledge management, and software development. Complete documentation of processes and work is required every Friday by 3pm for all changes to the system or processes. Specific day-to-day duties include the following:
    5.1.3 Perform the following duties
    5.1.3.1 store and organize data
    5.1.3.2 database capacity planning
    5.1.3.3 database installation
    5.1.3.4 database configuration
    5.1.3.5 database design, development and implementation
    5.1.3.6 database migration
    5.1.3.7 database performance tuning and monitoring
    5.1.3.8 database security and troubleshooting
    5.1.3.9 database backup and data recovery
    5.1.4 Collaborate with project and operation teams by conducting the database administration task such as installation, configuration, upgrade, migration, and others as assigned by manager.
    5.1.5 Conduct backup and recovery, database security, storage and capacity planning, performance monitoring and tuning tasks as assigned by manager
    5.1.6 Conduct trouble shooting and data restores as needed and as assigned by manager
    5.1.7 Conduct Extract, translate, and Load tasks as assigned by manager
    5.1.8 Collaborate with other DBAs to establish and enhance best practices in the area of back-up, data-recovery, database security, ETL, and storage.
    5.1.9 Conduct the following tasks as assigned:
    5.1.10 Write SQL code to implement complex queries for reporting
    5.1.11 Investigate new technologies and suggests new solutions to business problems
    5.1.12 Performs other related duties as assigned.
    5.2 Requirements
    5.2.1 Vendor Qualifications
    5.2.2 The contractor must possess the following skills and knowledge areas for this position. Submit a complete the Vendor Qualifications Chart to address experience and ensure experience is addressed in the resume submission.

Required Skills and Experience
Required: 8+ Experience with MS SQL Server.
Required: 5+ Experience with database backend and disaster recovery.
Required: 5+ years progressive in database maintenance and ETL development
Required: 3+ years progressive experience in a Virtual Server environment
Required: 3+ Experience with SQL Server High Availability Solutions
Required: 5+ Experience with ETL tools such as SSIS
Required: 5+ Experience with standard scripting languages (Shell, Perl, Python, etc.)
Required: 5+ Experience of standard database concepts (query optimization, database tuning, data modeling, etc.)
Required: Strong self-starter and ability to work independently
Required: Strong attention to detail and the ability to translate high level technical and business initiatives and goals into discrete tasks and specific timelines
Required: Excellent communication skills, especially the ability to actively listen and draw out the true needs rather than the stated wants of any given stakeholder
Required: Superb problem-solving skills and troubleshooting abilities
Required: Ability to work independently as well as collaboratively in a multidisciplinary team
Required: Strong focus on teamwork and developing the skills of DCPS colleagues both technical and non-technical as well as ability to learn additional skill.
Nice to have: Experience with data warehousing
Nice to have: Experience with NoSQL
Nice to have: Exceptional facility with tuning SQL queries to optimize performance relative to application needs
Nice to have: Experience with application development languages and tools a plus (Java, JSP, etc.)
Nice to have: Experience with supporting tools and technologies including basic operating system tools (mainly Linux) and configuration options

  1. Delivery
    6.1 All written deliverable products shall be submitted in electronic draft format for the Director of Data’s review and comment. Final copies shall be delivered to the Director of Data five (5) working days after receipt of the District’s comments. Deliverables shall be submitted with an enclosed letter describing the deliverable product and

Responsibilities:

  1. Coordinates IT project management, engineering, maintenance, QA, and risk management.
  2. Plans, coordinates, and monitors project activities.
  3. Develops technical applications to support users.
  4. Develops, implements, maintains and enforces documented standards and procedures for the design, develop

Background check is required, if selected for the position.
There are no reimbursable expenses allocated to this position.

This entry was posted in Closed Positions. Bookmark the permalink.