SQL Developer/.NET Developer

The SQL Developer/.NET Developer plays a crucial role in automating processes, maintaining and updating data systems using SQL Server 2019 and up, and supporting ongoing development for a jail management application. This position requires expertise in SQL Server database administration, ETL processes, and .NET development to create efficient, reliable solutions. The successful candidate will be proficient in writing complex SQL queries and developing applications using the .NET framework.

Essential Functions
• 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.
• Database Design & Data Warehousing:
• 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.
• SQL Server Database Administration:
• 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.
• SSIS & SSRS Development:
• 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.
• .NET Application Development:
• Develop and maintain applications using the .NET framework, integrating with SQL Server databases to deliver scalable business solutions.
• System & Server Support:
• 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.
• Collaboration & Training:
• Collaborate with team members and stakeholders to translate business needs into technical solutions.
• Provide training and technical guidance to MIS support staff.
• Offer feedback on software licensing needs for database and development tools.
• Performance Monitoring & Optimization:
• Monitor the performance of reports and data processing, resolving issues to ensure accurate and timely delivery of data.

Competencies, Knowledge, Skills and Abilities
• Microsoft SQL Server 2017 or later (Database administration and development)
• Microsoft SQL Server SSIS (Data Transformation Services)
• Standard Query Language (SQL) (Query writing and optimization)
• PowerBI
• SQL Server Backup and Recovery
• PostgreSQL 12
• ODBC connectivity
• Technical Documentation (Writing and maintaining documentation)
• Extract, Transform, and Load (ETL) (Design and process management)
• Data access management using Active Directory (Securing data and reports)
• Query writing based on business requirements
• Data governance (Ensuring data quality and compliance)
• .NET Framework and C# (Application development and maintenance)
• ASP.NET (Web application development)
• Experience with Visual Studio (Development environment)

Requirements

• Establish and maintain effective working relationships with associates, departmental officials, and outside consultants.
• Analyze and present complex data structures.
• Learn the operations, functions, data, reporting needs, and business requirements.
• Learn the regulations, ordinances, policies, and procedures related to the work of the Prisons.
• Read, interpret, and understand technical information and apply cross-functional knowledge.
• Effectively present information and respond to questions from managers, co-workers, and system users.
• May assist with planning, organizing, and directing the work activities of outside consultants and/or systems analysts and programming personnel assigned to a team.
• Advise OIT and Prisons management with respect to systems development projects and/or enhancements.
• Job Scheduling (creation, modifying, and monitoring).
• Microsoft SQL Server 2017 or later (Preferred).
• .NET application development with knowledge of C# (Preferred).

Additional information

Salary Range: $75,000 - $85,000

Important: To apply, candidates must provide a cover letter and resume.

Work Setting: in-person (onsite)

Discover the Perks of Being a City of Philadelphia Employee:
• We offer Comprehensive health coverage for employees and their eligible dependents
• Our wellness program offers eligibility into the discounted medical plan
• Employees receive paid vacation, sick leave, and holidays
• Generous retirement savings options are available
• Pay off your student loans faster - As a qualifying employer, City of Philadelphia employees are eligible to participate in the Public Service Loan Forgiveness program. Join the ranks of hundreds of employees who have already benefited from this program and achieved student loan forgiveness.
• Enjoy a Free Commute on SEPTA - Starting September 1, 2023, eligible City employees will no longer have to worry about paying for SEPTA public transportation. Whether you're a full-time, part-time, or provisional employee, you can seize the opportunity to sign up for the SEPTA Key Advantage Program and receive free Key cards for free rides on SEPTA buses, trains, trolleys, and regional rails.
• Unlock Tuition Discounts and Scholarships - The City of Philadelphia has forged partnerships with over a dozen esteemed colleges and universities in the area, ensuring that our employees have access to a wide range of tuition discounts and scholarships. Experience savings of 10% to 40% on your educational expenses, extending not only to City employees but in some cases, spouse and dependents too!
Join the City of Philadelphia team today and seize these incredible benefits designed to enhance your financial well-being and personal growth!

*The successful candidate must be a city of Philadelphia resident within six months of hire

Effective May 22, 2023, vaccinations are no longer required for new employees that work in non-medical, non-emergency or patient facing positions with the City of Philadelphia. As a result, only employees in positions providing services that are patient-facing medical care (ex: Nurses, doctors, emergency medical personnel), must be fully vaccinated.

The City of Philadelphia is an Equal Opportunity employer and does not permit discrimination based on race, ethnicity, color, sex, sexual orientation, gender identity, religion, national origin, ancestry, age, disability, marital status, source of income, familial status, genetic information or domestic or sexual violence victim status. If you believe you were discriminated against, call the Philadelphia Commission on Human Relations at 215-686-4670 or send an email to [email protected].