Senior Database Engineer

DOB's Information Technology bureau is responsible for the data processing functions and operations of systems that provide operational, analytical and managerial support functions, as well as IT resource management for the agency. DOB IT develops and maintains application software for such systems. Working closely with owner/client bureaus within the agency, IT develops and implements both customized and packaged applications, and maintains the requisite technical infrastructure, using in-house project resources and hired consultants. We encourage innovation, creativity, and a think outside of the box attitude when solving complex problems and implementing new solutions.

The Department is in the process of the development, conversion and modernization of the agency's numerous old legacy systems. The Senior Database Engineer will serve as a Database Developer who will support DOB's architecture team with consolidating and optimizing new technology initiatives for the agency's mission critical systems.

Under general direction, with broad scope for the exercise of independent initiative and judgment, responsibilities include, but are not limited to:

• Supervising data engineering projects from beginning to end, including planning, designing, testing and implementation. Projects could include but not limited to the following:

o Extract, transform, and load (ETL) data warehouses, including the use of change data capture to load incremental changes from on premise data source to the cloud data warehouse.

o Optimize and tune complex SQL code for faster data retrieval and processing.

o Develop API that ingest data as well as share DOB agency data with external stakeholders

• Serving as a project leader for complex projects involving database systems and providing technical leadership and guidance to other development team members in the design, architecture, and best practices of data engineering solutions.
• Planning, designing, developing and implementing scalable database structures to support business requirements for anticipated data growth.
• Leading database design by working with development teams, coordinating with other developers, business team representatives, and others to accomplish the database design and documented specification.
• Developing SQL Server 2016 - 2022 T-SQL/Store Procedures/SQL Optimization and Tuning.
• Creating Complex Queries/Functions/Views/SQL jobs/Database Objects.
• Leveraging Python to call API to integrate data with our DOB data warehouse.
• Creating and maintaining end-to-end analytics solution in Azure Synapse, including creating Synapse pipelines to support Azure Data Lakes and Serverless and Dedicated Pools, which are used as data sources by our reporting systems, Power BI and Oracle Analytics.
• Deploying and troubleshooting SSIS Packages.
• Designing and implementing solutions for extraction and integration of data to and from a relational database or data warehouse for the purpose of reporting, decision support and analysis.
• Diagnosing and resolving database issues to maintain uninterrupted operations.
• Ensuring database optimization, data integrity, consistency, security and privacy is part of the application designs.
• Safeguarding data through robust security measures and regular audits.
• Implementing and managing backup and recovery protocols to prevent data loss.
• Monitoring database performance, implementing optimization strategies for increased efficiency.
• Collaborating with developers to implement database design in prototypes to help communicate database requirements to all interested parties and inform an iterative database design process with customer feedback.
• Reviewing developers' queries and stored procedures to check for correct implementation of database design.
• Performing scheduled activities; recommending solutions or alternate methods to meet requirements.
• Developing data dictionary, system specification, guidelines and documentation.
• Implementing, maintaining and supporting a variety of reports utilizing various reporting tools.
• Assisting in development of standard reports for ongoing business needs.

CIVIL SERVICE STATUS:

Only permanent Certified IT Administrators (Database), applicants who are reachable on the Certified IT Administrator (Database) open competitive list, and applicants as indicated below will be considered.

Candidates who are permanent in comparable civil service titles may be considered for title change under rule 6.1.9 of the Personnel Rules and Regulations of the City of New York.

REMOTE WORK:

This position may be eligible for remote work up to 2 days per week, pursuant to the Remote Work Pilot Program.

To Apply:

Visit Jobs NYC (cityjobs.nyc.gov) to view and apply for available positions. Search by agency (Department of Buildings), keywords, or for the specific Job ID #.

NOTE: ONLY THOSE CANDIDATES UNDER CONSIDERATION WILL BE CONTACTED.

REMOTE WORK

This position may be eligible for remote work up to 2 days per week, pursuant to the Remote Work Pilot Program.

CERT IT ADMINISTRATOR (DB) - 13644

Minimum Qualifications

Professional/Vendor Certification(s) in database administration that is required for the position to be filled. In addition, you must have one of the following:

1. A baccalaureate degree from an accredited college or university, and two years of satisfactory fulltime (not classroom based) experience in database administration. Experience must include database design, configuration, installation, troubleshooting, integration, performance monitoring, maintenance, enhancement, and security management;

2. A four-year high school diploma or its educational equivalent and six years of satisfactory full-time (not classroom based) information technology experience (IT) of which at least two years must have been database administration experience as described in "1" above; OR

3. A satisfactory equivalent of education and/or experience equivalent to "1" or "2" above. Undergraduate education may be substituted for experience on the basis that 30 undergraduate semester credits from

an accredited college or university is equivalent to 6 months of information technology experience, but may not be substituted for the required database administration experience. A masters degree in computer science or a related field from an accredited college or university may substitute for one year of database administration experience. However, all candidates must have at least one year of satisfactory full-time (not classroom based) database administration experience as described in "1" above.

Preferred Skills

• Experience as an SSIS subject matter expert, including strength in designing and troubleshooting SSIS Packages.- Experience with Python, especially calling API to extract data from external systems and integrating it to a relational data warehouse.- Experience supporting database administration as needed: Database backup, restore, etc.- Data modeling skills in both relational database and dimensional database.- Experience with Oracle OAS and Power BI.- Experience in designing and architecting end-to-end Analytics solution in Azure Synapse, including administration, as well as designing and implementing data pipelines to load data efficiently in Azure Synapse serverless SQL Pool.- Experience with Erwin.- DBA Engineering- Microsoft SQL (875): At least five (5) years of satisfactory, full-time experience in Microsoft SQL database engineering, including but not limited to: building and configuring multiple Microsoft SQL databases developing, designing, configuring and documenting database architecture, including software, hardware and physical layout (Processor configurations, SAN LUNs, data file layouts).- DBA Operations- Microsoft SQL (46T): At least five (5) years of satisfactory, full-time experience in a Microsoft SQL database administrator role, including but not limited to: database performance testing, troubleshooting, fixing data corruption, performing backup and disaster recovery, reviewing logs, establishing and responding to automated monitoring, performance tuning configuring and maintaining different types of replications, and managing distributed databases. Preferred Vendor Certifications- MSCA SQL 2016 Database Development- MSCE Data Management and Analytics- Microsoft Certified Azure Data Engineer Associate

55a Program

This position is also open to qualified persons with a disability who are eligible for the 55-a Program. Please indicate at the top of your resume and cover letter that you would like to be considered for the position through the 55-a Program.

Public Service Loan Forgiveness

As a prospective employee of the City of New York, you may be eligible for federal loan forgiveness programs and state repayment assistance programs. For more information, please visit the U.S. Department of Education's website at https://studentaid.gov/pslf/.

Residency Requirement

New York City Residency is not required for this position

Additional Information

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.