The Office of the Queens County District Attorney (QDA) is seeking an experienced Senior Database Administrator to design, implement, optimize, and support relation database management systems to support in-house created and off-the-shelf commercial applications to aid in case tracking and processing. The Senior Database Administrator will be part of QDA’s Information Services Bureau that includes a staff of 12 and serves an office of over 800 staff.

The Senior Database Administrator’s responsibilities will include, but are not limited to:

• Design redundant, highly available database clusters for several in-house and off-the-shelf enterprise applications
• Implement and maintain zero loss database mirroring across multiple nodes in multiple clusters
• Perform index tuning and optimization tasks using SolarWinds DPA
• Develop and maintain entity relationship diagrams of data stores
• Integrate with our current production object-oriented, Iris, databases
• Design disaster recovery plan, schedule and implement the plan on a regular basis
• Create and document various data views for use in data visualization tools, such as Power BI
• Maintain object relationship consistency across all related data stores, enforcing foreign key constraints on dependent tables
• Implement role-based security access, leveraging SSO and MFA where required

Preferred Education and Qualification Requirements:

1. A baccalaureate degree from an accredited college, and two years of satisfactory full‐time (not classroom-based) experience in database administration planning, design, configuration, installation, troubleshooting, integration, performance monitoring, maintenance, enhancement, and security management; or
2. A four‐year high school diploma or its educational equivalent and six years of satisfactory full‐time (not classroom-based) information technology experience of which at least 2 years must have been as described in ʺ1ʺ above; or
3. A master’s degree in computer science or a related field from an accredited college may substitute for one year of experience. However, all candidates must have at least one year of satisfactory full‐time (not classroom-based) information technology experience as described in ʺ1ʺ above.

Must have excellent communication skills and experience in handling confidential information.

Strong preference will be given to candidates with skills or expertise in MongoDB.

Qualified candidates must have a permanent New York City computer-related civil service title in order to be considered for this position.

In addition, the following skills are required:

• SQL Server
• MariaDB
• SolarWinds DPA
• Index Tuning
• E-R Diagramming
• Data Normalization
• Backup and Restore
• Database Mirroring

Application Information:
Salary Range: $90,000 - $125,000

Comprehensive benefits package including health insurance, 401K and more. Salary commensurate with experience.

*As of August 2, 2021, all new hires must be vaccinated against the COVID-19 virus, unless they have been granted a reasonable accommodation for religion or disability.  If you are offered city employment, this requirement must be met by your date of hire, unless a reasonable accommodation for exemption is received and approved by this office.

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.

To apply, please submit a resume and cover letter, by clicking on the link below: