Job Description :

Engagement Type:

Contract

Short Description:

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

Complete Description:

Overview 8+ years of experience. The DCPS IT Enterprise Application & Data Systems (EADS) Group requires the services of an experienced database and ETL administrator to support our Application Development and Systems Operation activities. 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. 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 EADS is part of the DCPS Information Technology division within the Office of Data and Technology. The incumbent will report to the Director of Enterprise Applications & Data Systems and will gather and document reporting requirements, systems specifications, data models and manage Data Systems projects to include data compliance, self-service reporting, data warehouse, machine learning, analytics, and other as assigned by the Director. Qualifications 1. Basic Oracle DBA skills (startup/shutdown oracle database, backup/recover database, log review). 2. Basic PERL programming/debugging. 3. Microsoft SSIS development/troubleshooting. 4.Microsoft T-SQL query (Stored procedure, function, join query). • Should be a Microsoft SQL Server SSIS developer to create, deploy and troubleshoot packages as required. • Should have strong T-SQL skills to identify data issues from applications and should be able to fix and modify Functions and Stored procedures on production environment. This IS MANDATORY Requirement. • Should be able to work with multiple sources of data Such as Microsoft SQL Server, Oracle. • Should have good understanding on transformations between multiple sources. • Should have basic hands-on on Linux to access Oracle sources and to Schedule jobs. • Should have knowledge on windows to schedule jobs and to verify SQL Logs. 4. Basic MS SQL administration: backup/restore, HA SQL deployment. 5. Bachelor’s degree in Information Technology or related field or equivalent experience Key Duties and Responsibilities • Collaborate with project and operation teams by conducting the database administration task such as installation, configuration, upgrade, migration, and others as assigned by manager. • Conduct backup and recovery, database security, storage and capacity planning, performance monitoring and tuning tasks as assigned by manager • Conduct trouble shooting and data restores as needed and as assigned by manager • Conduct Extract, translate, and Load tasks as assigned by manager • Collaborate with other DBAs to establish and enhance best practices in the area of backup, data-recovery, database security, ETL, and storage. • Write SQL code to implement complex queries for reporting • Investigate new technologies and suggests new solutions to business problems • Performs other related duties as assigned. • 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 with respect to 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. • Includes maintenance of database dictionaries, overall monitoring of standards and procedures, file design and storage, and integration of systems through database design Knowledge, Skills, and Abilities • Required: 8+ Experience with MS SQL Server. • Required: 8+ Experience with database backend and disaster recovery. • Required: 8+ 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. • Experience with data warehousing • Experience with NoSQL • Exceptional facility with tuning SQL queries to optimize performance relative to application needs • Experience with application development languages and tools a plus (Java, JSP, etc.) • Experience with supporting tools and technologies including basic operating system tools (mainly Linux) and configuration options

Client Information

Work Location:

DCPS - 1200 First Street NE, 9th Floor Washington, DC 20002

Cost Center:

DCPS - District of Columbia Public Schools

Project:

 

Required/Desired Skills

Required /Desired

 

Skill

Required /Desired

Amount

of Experience

8+ Experience with MS SQL Server.

Required

8

Years

 
                 

 

8+ Experience with database backend and disaster recovery.

Required

8

Years

8+ years progressive in database maintenance and ETL development

Required

8

Years

 

3+ years progressive experience in a Virtual Server environment

Required

3

Years

3+ Experience with SQL Server High Availability Solutions

Required

3

Years

 

5+ Experience with ETL tools such as SSIS

Required

5

Years

5+ Experience with standard scripting languages (Shell, Perl, Python, etc.)

Required

5

Years

 

5+ Experience of standard database concepts (query optimization, database tuning, data modeling, etc.)

Required

5

Years

Strong self-starter and ability to work independently

Required

8

Years

 

Strong attention to detail and the ability to translate high level technical and business initiatives and goals into discrete tasks and timelines

Required

8

Years

Excellent communication skills, especially the ability to listen and draw out the true needs rather than the stated wants of any given stakeholders

Required

8

Years

 

Superb problem-solving skills and troubleshooting abilities

Required

8

Years

Ability to work independently as well as collaboratively in a multidisciplinary team

Required

8

Years

 

Strong focus on teamwork and developing the skills of DCPS colleagues both technical and non-technical as well as ability to learn additional skill.

Required

8

Years

Experience with data warehousing

Required

1

Years

 

Experience with NoSQL

Required

1

Years

Exceptional facility with tuning SQL queries to optimize performance relative to application needs

Required

1

Years

 

Experience with application development languages and tools a plus (Java, JSP, etc.)

Highly desired

1

Years

Experience with supporting tools and technologies including basic operating system tools (mainly Linux) and configuration options

Required

1

Years

             

Similar Jobs you may be interested in ..