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
--