> Markdown version of [/jobs/ext/2156488-information-technology-specialist-2-programming](https://www.wearedevelopers.com/jobs/ext/2156488-information-technology-specialist-2-programming). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Information Technology Specialist 2 (Programming) - **Company:** NYS Governor's Office of Employee Relations - **Location:** Albany, NY, United States (Remote available) - **Salary:** $71,427.0 - $98,409.0 - **Contract:** Permanent contract - **Skills:** Computer Programming, Databases, Data Dictionary, Data Security, Disaster Recovery, Logical Data Models, Enterprise Software Applications, Information Technology - **Published:** August 20, 2026 - **Apply:** https://statejobsny.com/public/vacancyDetailsView.cfm?id=222111 ## About the Role Current New York State employee with one year or more of qualifying permanent service allocated to a Grade 16 or above and eligible for transfer under Section 52.6 of the NYS Civil Service Law., A bachelor's or higher-level degree including or supplemented by 15 semester credit hours in computer science; OR a bachelor's or higher-level degree in any field AND one year of experience in information technology; OR 60 semester credit hours including or supplemented by 15 semester credit hours in computer science AND one year of professional experience in information technology; OR two years of professional experience in information technology. ## Description Duties Description Under the direction of the Manager of Enterprise Applications, the Information Technology Specialist 2 (Programming) is responsible for all activities associated with the design, development, installation, and performance of agency databases. Duties include, but are not limited to: - Design or assist in the design and maintenance of databases. - Assist in the development of logical data models. Defines data entities, data attributes, and logical data groups and relationships. - Assist in the development of physical database design. Address performance criteria and standards. - Coordinate database change controls to interact with application change management. - Assist in the training of application programmer analysts and operations personnel in the efficient use of database software. - Participate in the development of disaster recovery planning for databases. - Maintain specialized data access modules and other programs required to make data available to program and end-users. - Install and maintain database software products and specialized data access programs. - Install, customize, and maintain complex database software components. - Test and implement new and updated versions of databases, data dictionary, and other files handling software from vendors. - Act as vendor liaison for the diagnosis and resolution of database-related software problems. - Participate in the development of database standards such as naming conventions, update protocols, performance standards, and internal controls. - Convert existing databases to new or updated software releases from vendors. - Monitor the operation and performance of the database software, taking whatever corrective action necessary to obtain the most effective use of it. - Monitor and tune such variables as space, buffers, logs, and journals. - Identify and resolve malfunctions and complex problems related to database use, maintenance, and management. - Maintain a log of database problems and resolutions for future reference. ## Related Videos - [Crypto-secure Data Management with In-Database Blockchain](https://www.wearedevelopers.com/videos/632-crypto-secure-data-management-with-in-database-blockchain) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Parquet, Delta, Iceberg & Ducklake - An introduction for developers](https://www.wearedevelopers.com/videos/100075-parquet-delta-iceberg-ducklake-an-introduction-for-developers) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [Blazing Fast Page Navigation with Speculation Rules](https://www.wearedevelopers.com/videos/1570-blazing-fast-page-navigation-with-speculation-rules) - [Web-based Information Visualization](https://www.wearedevelopers.com/videos/84-web-based-information-visualization) ## Related Articles - [Best Paying Jobs in Technology](https://www.wearedevelopers.com/magazine/256-best-paying-jobs-in-technology) - [How Many Jobs Are Available in Technology?](https://www.wearedevelopers.com/magazine/450-how-many-jobs-are-available-in-technology) - [System change: restart as developer?](https://www.wearedevelopers.com/magazine/39-system-change-restart-as-developer) - [What’s the Difference between a Junior, Mid, and Senior Developer?](https://www.wearedevelopers.com/magazine/238-what-s-the-difference-between-a-junior-mid-and-senior-developer) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)