Computer Science Jobs in Schenectady, NY (NOW HIRING)

Duties Description Under the general direction of the Manager of Information Technology Services 1 DB, within the Dedicated Support Division, Sector C, the Technology Analyst 2 Rapid Application Development (RAD) will be the Application Database Administrator for the Data Management team. The incumbent will also serve as back-up database administration support for other Oracle databases for other statewide applications such as New York State Electronic Personnel System (NYSTEP), New York Benefits Eligibility and Accounting System (NYBEAS) and various Merit Examinations Systems. The incumbent will assist in supervision of data management staff as well as other technical staff.
Specific duties shall include but are not limited to:
-Coordinating the database administration tasks among all applications, including prioritization of outstanding tasks, assigning tasks to subordinates and establishing time frames for their completion
-Developing work plans and carrying out complex technical duties associated with database updates
-Translating business process requirements into efficient database designs and processes
-Designing, developing, and implementing database structures to support new applications and systems
-Identifying and resolving technical problems such as SQL tuning and performance issues associated with projects and applications
-Performing Unix scripting and scheduling on Sun Solaris servers
-Performing Oracle and SQL Server database administration tasks
-Developing reports in OBIEE/OAS
-Creating ETL Jobs via Oracle Data Integrator.
-Developing and maintaining SQL stored procedures and views as necessary
-Developing, implementing, and maintaining security standards for databases
-Ensuring timely and reliable backup and recovery of all databases
-Monitoring and tuning database performance for all databases
-Working with outside resources (e.g. vendor technical support, technical bulletins, manuals, and consultants) to find technological solutions to complex problems
-Participating in project development teams as a representative of the Data Management Unit
-Providing expertise, as needed, to ITS staff outside of the Data Management Unit
-Performing a full range of supervisory activities
Minimum Qualifications Six (6) years of information technology experience, two (2) years of which must be within the discipline of rapid application development.
SUBSTITUTIONS:
• Associate's degree with 15 semester credit hours in computer science or a related field substitutes for one year of general information echnology experience.
• Candidates in a bachelor's degree program with at least 15 semester credit hours in computer science or a related field can substitute for one year of general information technology
experience.
• Bachelor's degree in any field including or supplemented by fifteen (15) semester credit hours in computer science or a related field substitutes for three years substitutes for three (3) years of general information technology experience.
• Bachelor's degree in any field substitutes for two (2) years of general information technology experience.
• Master's degree or higher in computer science or related field substitutes for one year of general information technology experience.
Preferred Qualifications:
• Ability to diagnose application issues and decide what can be done with low-code instead of traditional coding.
• Intuitive understanding of turning ideas into working applications using drag-and-drop visual environment.
• Familiarity with pre-built templates, drag-and-drop visual interface, and entity builder.
• Basic knowledge of SQL, HTML, CSS, JavaScript, and general Web 2.0 techniques.
• Proven experience as a Software Analyst or similar role in software development, familiar with Agile or Scrum methodologies.
• Strong analytical, problem-solving, and troubleshooting abilities with attention to detail.
• Proven experience with low-code platforms such as OutSystems, Mendix, or Microsoft Power Apps.
• Strong understanding of software development life cycle (SDLC).
• Proficiency in designing and optimizing business process workflows.
• Experience with database management and integrations with external systems.
• Proficient in debugging and testing to ensure application quality.
• Knowledge of best practices and coding standards in software development.
• Excellent documentation skills, including technical specifications and user guides.
• Ability to work collaboratively in a team environment.
• Familiarity with Agile methodologies.
• Excellent communication skills for gathering requirements and
training end-users.
• Understanding of data protection and security policies.
• Ability to adapt to new features and updates on low-code platforms.
• Experience with performance monitoring and optimization of applications.
• Ability to manage regular maintenance and updates to applications.
• Strong coordination skills to work with IT and security
professionals, as well as other developers and departments.
Please note:
• Appointment to this position and continued employment with the agency is contingent upon obtaining and/or maintaining New York State residency within six (6) months of hiring.
• Appointment to this position is not final until all agency approvals have been granted.
• Some positions may require additional credentials, fingerprinting or a background check to verify your identity.
• Some positions may require up to 25% travel and/or lifting up to 50 lbs.
Additional Comments ITS will not offer permanent employment to any candidate unless the candidate provides documentation that they are authorized to accept work in the United States on a permanent basis. It is the policy of ITS not to hire F1 or H1 visa holders for permanent employment or to sponsor non-immigrant aliens for temporary work authorization visas or for permanent residence.
These positions are currently pending Civil Service approval and therefore will be temporary, and probation will not start until Civil Service approval is granted. Once they are approved, the official probationary period will begin. Details of the position(s) will be described further if you are selected for an interview.
If eligible, positions located in New York City will receive an additional $3,400 downstate adjustment location pay with regular annual salary. Positions located in the Mid-Hudson will receive an additional $1,650 adjustment location pay.
Benefits of Working for NYS Generous benefits package, worth 65% of salary, including:
Holiday & Paid Time Off
• Thirteen (13) paid holidays annually
• Up to Thirteen (13) days of paid vacation leave annually
• Up to Five (5) days of paid personal leave annually
• Up to Thirteen (13) days of paid sick leave annually for PEF.
• Up to three (3) days of professional leave annually to participate in professional development
Health Care Benefits
• Eligible employees and dependents can pick from a variety of affordable health insurance programs
• Family dental and vision benefits at no additional cost
Additional Benefits
• New York State Employees' Retirement System (ERS) Membership
• NYS Deferred Compensation
• Access to NY 529 and NY ABLE College Savings Programs, as well as U.S. Savings Bonds
• Public Service Loan Forgiveness (PSLF)
• And many more.
The Office of Information Technology Services is an equal opportunity employer, and we recognize that diversity in our workforce is critical to fulfilling our mission. We encourage all individuals with disabilities to apply.
Some positions may require additional credentials or a background check to verify your identity.
Name NYS ITS Human Resources
Telephone 518-473-0398
Fax 518-402-4924
Email Address PostingResponses@its.ny.gov
Address
Street 164 Columbia Turnpike
City Rensselaer
State NY
Zip Code 12144
Notes on Applying To apply for this position, please submit a cover letter and resume clearly indicating how you qualify. Ensure that you include the vacancy ID in the subject of your email for prompt routing. Your Social Security number may be required to confirm eligibility