SQL Database Administrator

We are seeking a skilled SQL Database Administrator (DBA) with a strong background in programming to manage and optimize our database systems, ensure data integrity, and contribute to application development. The ideal candidate will have experience designing, implementing, and maintaining databases while supporting development teams with SQL and programming

expertise.

Responsibilities include but are not limited to:

• Database Administration:

• Manage, monitor, and maintain SQL databases to ensure high availability and

• performance.

• Implement and oversee backup, recovery, and disaster recovery plans.

• Optimize database performance, troubleshoot bottlenecks, and resolve issues.

• Design and implement database schemas, tables, and indexing strategies.

• Programming and Development Support:

• Write efficient and optimized SQL queries, stored procedures, triggers, and

• functions.

• Collaborate with development teams to design and integrate databases into

• applications.

• Automate database-related tasks using programming languages (e.g., PowerShell,

• or C#).

• Security and Compliance:

• Implement database security measures, including role-based access control and

• encryption.

• Ensure compliance with industry standards and regulations.

• Collaboration and Documentation:

• Work closely with cross-functional teams, including developers, system

• administrators, and analysts.

• Create and maintain documentation for database systems, configurations, and processes.

In addition to the Minimum Qualification Requirements, candidates must possess the following:

• Bachelor's degree from an accredited college; and

• Minimum two (2) to four (4) years of experience in the SQL DBA or in a related role.

• Expertise in Microsoft SQL Server.

Preferred Requirements/Skills:

• Familiarity with Ubuntu or its variant.

• Proficiency with C# programming language., 1. A baccalaureate degree from an accredited college and two years of experience in community work or community centered activities in an area related to the duties described above; or

2. High school graduation or equivalent and six years of experience in community work or community centered activities in an area related to the duties as described above; or

3. Education and/or experience which is equivalent to "1" or "2" above. However, all candidates must have at least one year of experience as described in "1" above.

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.

Salary Min: $ 72,779.00

Salary Max: $ 95,735.00