The New York City Department of Transportation’s (NYC DOT) provides safe, efficient, and environmentally responsible movement of pedestrians, goods, and vehicular traffic on the streets, highways, bridges, and waterways of the City's transportation network. NYC DOT rehabilitates and maintains the City's infrastructure, including bridges, tunnels, streets, sidewalks, and highways. The NYC DOT IT & Telecom division is an award-winning team leading business transformation through technology innovation to enhance the agency’s ability to fulfill its’ mission. IT & Telecom acts as a strategic partner with all business units to promote technology initiatives by delivering quality service, and secure solutions that provide new and improved capabilities for the Agency. We work hard to embrace diversity and inclusion and encourage everyone in the division to bring their authentic selves to work every day. We offer our full-time employee’s competitive salaries, excellent benefit options and perks that include:

- Pension and Retirement Plans- Upon retirement, qualified members of the City’s generous pension program receive a guaranteed salary and health benefits for the rest of their lives. There are also 401K and 457 plans available to supplement your retirement needs.
- Health Care Coverage- We offer a multitude of health care plans that are sure to meet the needs of you and your family.
- Dental and Vision Coverage- We offer a wide variety of excellent civil service title-based union dental and vision coverage for individuals and families.
- Paid Time Off- We offer paid vacation and sick time off which accrues over time based on your years of service.
- Professional Development - We offer numerous training programs, leadership development opportunities, and career coaching services, while encouraging employees to attend approved off and on-site trainings and seminars.
- Additional Perks - Our employees are eligible for discounts on top theme parks, hotels, shows, events, movies and more.

Under general supervision and managerial direction, with latitude for independent initiative or judgement, the candidate is expected to perform data modeling, SQL development and ETL automations/integrations using MS-SQL Server Integration Services (SSIS); create reporting solutions using MS-SQL Server Reporting Services (SSRS); perform data analysis to drive key business objectives; support daily data warehouse load processes; develop applications and integrations using MS-SQL Server; perform database design for application development and product implementation initiatives under the guidance of Database Administrator and Architect; participate in requirements analysis and design; work closely with business analysts, subject matter experts and development teams on application projects; facilitate creation, migration and maintenance of database objects across development/QA/production environments; perform data model management and version control; follow best practices in data modeling including use of standard naming conventions, processes and templates to ensure consistency of data models; monitor and optimize database performance and capacity utilization to provide high availability and redundancy; take ownership of database performance, scalability and security; reverse engineer and document database architecture for business-critical legacy databases; define and implement data testing strategies with business stakeholders, application development teams and QA groups; participate in the software testing process, including identification and resolution of defects; contribute to and support roll-out strategies; participate in and contribute to formal/informal technical reviews and presentations; understand other database platforms like Oracle, MySQL and IBM DB2; understand high level application architecture/design, network design, performance constraints and security frameworks; apply technical knowledge to determine solutions and solve complex problems; research, present and/or make recommendations on technical issues; take inputs from reporting manager(s) and appropriately apply comments/feedback; estimates time required to complete development tasks; demonstrate the ability to cooperate with a variety of people and achieve results; proactively initiate, develop, and maintain effective working relationships with team members.

1. A baccalaureate degree in computer science, engineering or a related field from an accredited college and four years of satisfactory full-time experience related to IT automation engineering, monitoring engineering, management of infrastructure; or

2. Eight years of satisfactory full-time experience related to IT automation engineering, monitoring engineering, management of infrastructure;

3. Education and/or experience which is equivalent to "1" or "2" above.

- 4 years of experience in application data modeling and MS-SQL Server administration/utilities/tools - Microsoft Database Developer Certification - Proficiency in supporting MS-SQL Server 2017/2019 databases in high availability environments with intimate knowledge of SQL/T-SQL - Demonstrated knowledge of designing/ developing/ integrating databases, data warehouses and multidimensional databases in MS-SQL Server - Ability to write and optimize complex SQL queries, procedures and functions - Familiarity with SSRS, SSAS, SSIS and data warehousing concepts - Experience with database replication techniques

New York City Residency is not required for this position

The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.