WASHINGTON, DC, USA
4 days ago
Database Developer (Report Writer)
Job Seekers, Please send resumes to resumes@hireitpeople.com

Seeking an experienced (3 to 7 years) database developer to write and maintain complex SQL queries for reporting and ETL from a Microsoft SQL Server database.  Some use of standard scripting languages such as Perl may also be necessary.

 

Complete Description:

Seeking an experienced database developer to act as a report writer supporting our Student Information System and reporting in general.  They will have primary responsibility for creating reports from two different Microsoft SQL Server 2012 databases for reporting and ETL using raw SQL queries and scripting languages such as Perl, Ruby, etc.   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 (service oriented architecture, etc),  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. 

 

Position Responsibilities:

•          Works with other programs and offices within DCPS to understand overall DCPS needs so as to implement strategic rather than tactical solutions

•          Write SQL code to implement complex queries for reporting

•          Create scripts and queries to enable data integration between various student data systems

•          Creates user-friendly report formats and on-demand report interfaces for use by non-technical users

•          Investigates new technologies and suggests new solutions to business problems

•          Evaluate software to determine the level that it meets the needs of the business today and in the future (design, extendibility, flexibility, integration, utilizes generic business objects/components etc.).

•          Supports and carries out the Chancellor’s mission to transform DC Public Schools and close the achievement gap

•          Performs other related duties as assigned.

 

Professional/Educational Qualifications

•          Bachelor’s degree required

•          3 to 7 years experience in database development or database administration

•          Strong Experience with writing complex SQL queries

•          Good Experience MS SQL Server, especially MS-SQL 2012

•          Experience with ETL approaches, concepts, and tools

•          Experience with standard scripting languages (Shell, Perl, Ruby, etc)

 

Strong Candidate will have

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

•          Exceptional knowledge of standard database concepts (query optimization, database tuning, data modeling, etc)

•          Keen sense of maximizing return on investment, focusing on the 80% solutions rather than a fruitless quest for perfection

•          Strong self-starter and ability to work independently

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

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

•          Superb problem solving skills and troubleshooting abilities

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

•          Strong focus on teamwork and developing the skills of DCPS colleagues both technical and non-technical

 

Skills:

Skill

Required / Desired

Amount

of Experience

Expertise Rating

 

Strong experience in database development or database administration

Required

5

Years

2 - Proficient

Good experience with MS SQL Server

Highly desired

3

Years

2 - Proficient

Strong experience with writing complex SQL queries

Required

5

Years

3 - Expert

Strong experience with standard scripting languages (Shell, Perl, Ruby, etc)

Desired

1

Years

1 - Basic

Strong experience tuning SQL queries to optimize performance relative to application needs

Required

5

Years

3 - Expert

Bachelor's Degree

Required

 

 

 

 

 

 Candidate must bring his own laptop. Client or vendor will not be providing it

 

 

-- 
Confirm your E-mail: Send Email