SQL Developer

$75,000 - $85,000/Yr

City of Philadelphia - Philadelphia, PA

Part-time,Full-time - Entry Level

Philadelphia, PA

10,001+ employees

Executive, Legislative, and Other General Government Support

About the position

The SQL Developer/.NET Developer position at the City of Philadelphia is essential for automating processes and maintaining data systems using SQL Server 2019 and up. This role involves supporting the development of a jail management application and requires expertise in SQL Server database administration, ETL processes, and .NET development. The successful candidate will be responsible for writing complex SQL queries and developing applications to create efficient and reliable solutions for the city's IT needs.

Responsibilities

• Monitor, safeguard, and optimize the ETL process to extract data from various sources into a data warehouse staging area using SSIS/.NET.
• Implement additional data sets from new sources and move data from the staging area into the data warehouse star schema.
• Maintain and enhance business rules and transformations to cleanse and standardize data for reporting and analysis.
• Design and implement aggregate tables, views, and virtual tables to optimize query performance.
• Perform ongoing data modeling and maintenance of the data warehouse, ensuring alignment with business needs.
• Perform database administration tasks to support optimal performance of SQL Server 2019 or later databases.
• Handle routine operational issues related to the data warehouse.
• Work with MIS staff to implement backup and recovery procedures.
• Design and develop SSIS packages to manage ETL processes, including complex data transformations and load procedures.
• Build and enhance SSRS reports using Visual Studio, ensuring they meet business reporting requirements.
• Develop and maintain applications using the .NET framework, integrating with SQL Server databases to deliver scalable business solutions.
• Provide support for Windows Server 2019-2022 operating environments and maintain compatibility with the IJMS (ATIMS) system.
• Ensure optimal performance of Microsoft SQL Server 2019 or later.
• Collaborate with team members and stakeholders to translate business needs into technical solutions.
• Provide training and technical guidance to MIS support staff.
• Monitor the performance of reports and data processing, resolving issues to ensure accurate and timely delivery of data.

Requirements

• College degree in a related field.
• Expertise in Microsoft SQL Server 2017 or later (Database administration and development).
• Proficiency in Microsoft SQL Server SSIS (Data Transformation Services).
• Strong skills in Standard Query Language (SQL) for query writing and optimization.
• Experience with PowerBI for data visualization.
• Knowledge of SQL Server Backup and Recovery processes.
• Familiarity with PostgreSQL 12 and ODBC connectivity.
• Ability to write and maintain technical documentation.
• Experience in Extract, Transform, and Load (ETL) processes.
• Understanding of data access management using Active Directory.
• Knowledge of data governance principles.

Nice-to-haves

• Experience with .NET Framework and C# for application development and maintenance.
• Familiarity with ASP.NET for web application development.
• Experience with Visual Studio as a development environment.

Benefits

• Comprehensive health coverage for employees and their eligible dependents.
• Wellness program offering eligibility into the discounted medical plan.
• Paid vacation, sick leave, and holidays.
• Generous retirement savings options.
• Eligibility for the Public Service Loan Forgiveness program.
• Free commute on SEPTA public transportation for eligible employees.
• Tuition discounts and scholarships with partnerships from local colleges and universities.