SQL Developer

$75,000 - $85,000/Yr

City of Philadelphia - Philadelphia, PA

Part-time,Full-time - Mid 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 using the .NET framework, ensuring efficient and reliable solutions for the city's technology 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.
• 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

• Proficient in Microsoft SQL Server 2017 or later (Database administration and development).
• Experience with Microsoft SQL Server SSIS (Data Transformation Services).
• Strong knowledge of Standard Query Language (SQL) for query writing and optimization.
• Familiarity with PowerBI for data visualization.
• Experience with SQL Server Backup and Recovery procedures.
• Knowledge of PostgreSQL 12 and ODBC connectivity.
• Ability to write and maintain technical documentation.
• Experience in Extract, Transform, and Load (ETL) design and process management.
• Understanding of data access management using Active Directory.
• Knowledge of data governance to ensure data quality and compliance.
• Proficient in .NET Framework and C# for application development and maintenance.
• Experience with ASP.NET for web application development.
• Familiarity with Visual Studio as a development environment.

Nice-to-haves

• Experience with Microsoft SQL Server 2017 or later (Preferred).
• Knowledge of .NET application development with C# (Preferred).

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 for employees and their dependents.