Review Vacancy

Date Posted: 05/04/22
Applications Due: 05/25/22
Vacancy ID: 104168

Position Information

AgencyAttorney General, Office of the

TitleInformation Technology Specialist 2

Occupational CategoryI.T. Engineering, Sciences

Salary Grade18

Bargaining UnitPS&T - Professional, Scientific, and Technical (PEF)

Salary RangeFrom $60069 to $76387 Annually

Employment Type Full-Time

Appointment Type Permanent

Jurisdictional Class Competitive Class

Travel Percentage 10%


Workweek Mon-Fri

Hours Per Week 37.5


From 8:30 AM

To 5:30 PM

Flextime allowed? No

Mandatory overtime? No

Compressed workweek allowed? No

Telecommuting allowed? No


County Rensselaer

Street Address 200 Broadway

City Troy


Zip Code12180

Job Specifics

Minimum Qualifications One year of permanent competitive service as an Information Technology Specialist 1 and reachable on the Information Technology Specialist 2 list OR in a position at G-16 or higher deemed administrative under Section 52.6 of Civil Service Law OR in a position approved for transfer under Section 70.1 of Civil Service Law. The transfer cannot be a second consecutive transfer resulting in advancement of more than two salary grades. Candidates reachable on the appropriate eligible list for this title will be considered through a canvass and do not need to apply to this vacancy posting.

Duties Description The Office of the Attorney General (OAG) is seeking an Information Technology Specialist 2 to work in the Business Services Group. The incumbent will be responsible for the maintenance and support of SQL Server databases and windows servers.

• Perform database management responsibilities for production and non-production workloads.
• Install, configure, and maintain SQL Server databases.
• Upgrade/migrate SQL Server instances/databases to newer versions of SQL Server.
• Ensure databases are being backed up and can be recovered in a timely manner.
• Monitor server activity, error logs, space usage, and resolve problems as needed.
• Apply Service Pack/Hot Fixes on SQL Server Instances to address security and upgrade related issues.
• Create jobs, maintenance plans, scheduled tasks, index rebuilds, alerts, and notifications.
• Use T-SQL & SQL to create stored procedures, tables, views, triggers, and other database objects.
• Document the installation, configuration, and optimization procedures for SQL Server databases.
• Take proactive measures to monitor, trend, and tune SQL databases, such as running maintenance jobs.
• Configure SQL Server monitoring utilities to minimize false alarms, analyze trends, prevent incidents, and reduce recovery time.
• Troubleshoot performance issues and determine the most effective way to scale.
• Identify potential code defects and enhancements.
• Provide after-hours support for troubleshooting or corrective actions related to incidents impacting application availability within production environments.
• Other duties as assigned.

• Experience configuring, monitoring, and administering Windows Server.
• Experience working as a Microsoft SQL DBA leveraging versions 2012 or later.
• Experience automating SQL Server deployment and configuration through PowerShell.
• Experience with Microsoft Azure.
• Experience working in Microsoft Active Directory.
• Experience with VMWare and vCenter Server.
• Experience managing storage.

Additional Comments Candidates from diverse backgrounds are encouraged to apply. The Office is an equal opportunity employer and is committed to workplace diversity.

Per Office of the Attorney General policy, confirmation of vaccination status is a condition of employment for this position. If you are not fully vaccinated, you will be required to provide negative COVID-19 test results once weekly. The agency will consider religious and reasonable accommodations.

PLEASE NOTE: Unless otherwise specified in the “Notes on Applying” section, the “Application Due” date associated with this posting is not the last day applications can be submitted. Applications for this position will be accepted by the hiring bureau on a rolling basis until a candidate is selected; recruitment for this position can be closed or suspended at any time.

Some positions may require additional credentials or a background check to verify your identity.

Contact Information

Name Mary Seebald

Telephone 5187762500

Fax 518-915-7754

Email Address


Street Office of the Attorney General, Human Resources Managment Bureau

State Capitol

City Albany

State NY

Zip Code 12224


Notes on ApplyingPreferred method of applying is via e-mail to You must include vacancy ID # 104168 in the subject line. Please be sure your submitted cover letter and resume indicate your current Civil Service title.