Job Description

Job Title: Software Developer
Work Arrangement
Onsite
Hours: 7.25 hours/day (8:00 AM - 5:00 PM, excluding lunch)
Monday to Friday
Role Summary
The Software Developer is responsible for translating technical system specifications into working, tested applications. The role focuses on enterprise database development, reporting solutions, and end-to-end SDLC delivery, with strong emphasis on Microsoft SQL Server and Computer Aided Dispatch (CAD) systems in a public safety environment.
Key Responsibilities
Translate technical system specifications into working, tested applications
Develop detailed programming specifications
Write, generate, and maintain application code
Compile data-driven programs and conduct unit testing
Design, code, test, debug, and document applications
Troubleshoot and resolve data quality, performance, and system issues
Support application deployment, maintenance, and enhancements
Manage end-to-end SDLC activities, including Agile delivery
Develop and maintain data models, database designs, and documentation
Collaborate with technical teams and business stakeholders
Deliver solutions within defined project timelines
Required Skills & Experience
Design & Development Experience (35%)
10+ years experience with Microsoft SQL Server Reporting Services (SSRS)
10+ years experience in database development using Microsoft SQL Server
Experience with database architecture, data modeling, and design:
OLTP, OLAP, Data Warehousing
Logical and physical database design
Capacity planning
Experience with performance tuning:
SQL Profiler
Tracing
Execution plan analysis
Experience with data integration and migration:
ETL
SSIS
OS scripting
Experience writing Python and SQL scripts for Computer Aided Dispatch (CAD) systems
Experience with SOAP and REST web services for real-time data processing
Experience using collaboration tools such as Jira and Confluence
Ability to translate complex business requirements into technical solutions
Knowledge of UI design principles
Technical Skills (35%)
10+ years experience developing enterprise-level IT solutions using Microsoft SQL Server
Experience developing and maintaining complex:
SQL queries
Views
Stored procedures
End-to-end SDLC ownership for Computer Aided Dispatch (CAD) systems
Experience developing process models and evaluating system effectiveness
Experience delivering solutions for 9-1-1 public safety environments
Demonstrated ability to meet project delivery timelines
Communication & Collaboration (25%)
Strong verbal and written communication skills
Strong interpersonal and negotiation skills
Consulting experience engaging stakeholders and leading requirements discussions
Ability to work with minimal supervision in an Agile environment
Proven team player with a track record of meeting deadlines
Experience producing conceptual, logical, and physical data documentation
Experience supporting multi-year projects
Public Sector Experience (5%)
Experience working on multiple concurrent projects
Experience delivering enterprise reporting solutions for highly sensitive data
Experience with public-sector governance methodologies (e.g., UPM, architecture gating)
Must-Have Summary
Microsoft SQL Server (10+ years)
SQL Server Reporting Services (SSRS)
Enterprise Database Development
Complex SQL Queries & Stored Procedures
ETL / SSIS
Computer Aided Dispatch (CAD)
Public Safety / 9-1-1 Systems

Skills Required