Project Assistant, Ref#7057
Job Posting for Project Assistant, Ref#7057 at Information Technology Services, Office of
Minimum Qualifications
Seven years of experience with MS SQL, including three years working with DMV MS SQL systems, as well as two years converting inline SQL to PL\SQL stored procs, two years SSIS experience, two years of experience migrating from MS SQL 2k3 to newer supported MS SQL versions, and at least eighteen months experience writing ETL, automating migrations, facilitating migration schedules, and developing infrastructure.
The following degrees may substitute for the general experience as indicated:
The following degrees may substitute for the general experience as indicated:
- Associate’s degree and six years of experience
- Associate’s degree including 15 semester credit hours in computer science and five years of experience
- Bachelor’s degree and five years of experience
- Bachelor’s degree including 15 semester credit hours in computer science and four years of experience
- Master’s degree in computer science or related field substitutes for an additional year of experience
- Doctorate in computer science or related field substitutes for an additional 2 years of experience
Duties Description
Under the direction of a Project Coordinator, SGE-29, within Chief Technology Office, Shared Platform Services, Data Management Services, the Project Assistant, NS, will play a critical role in supporting the migration of legacy Department of Motor Vehicle (DMV) servers and software to supported platforms, while ensuring minimal disruption to DMV services.
Duties include, but are not limited to:
Duties include, but are not limited to:
- Upgrade Legacy SQL Batch Processing, refactor, rewrite, or convert all legacy Data Transformation Services (DTS) packages, SQL Server Integration Services (SSIS) packages, and SQL Agent tasks to adhere to the new Enterprise Standards.
- Authentication Enhancement modify all existing SSIS packages to utilize domain authentication instead of SQL authentication.
- SSIS Upgrade and Cloud Migration, upgrade SSIS instances to either SQL Server 2022 or an appropriate Cloud solution.
- Code Consolidation for ETL Processes, aggregate all Data Management Views (DMV) Extract, Transform, Load (ETL) source code into a unified solution within a Development Operations (DevOps) framework.
- Staging (STG) Packages Consolidation, consolidate all staging packages to a Development/Test (DEV/TST) instance to minimize licensing costs.
- Database Migration, transition all databases running on unsupported versions to SQL Server 2022, especially those critical for Priority 1 (P1) applications, affecting over 140 databases.
- Infrastructure Consolidation, combine underutilized DMV instances into a new SQL Server 2022 infrastructure to further reduce licensing expenses, addressing inefficiencies stemming from the 2003 mitigation project.
- Access and Compliance, ensure continued access for the SQL Enterprise team, including but not limited to CommVault backups and restores, SysAdmin access to relevant instances, and local administrator access to all Virtual Machines (VMs) involved in the project. Attend all SQL Enterprise team meetings to maintain compliance with platform standards and justify the required access levels.
- Perform the full range of supervisor responsibilities.
Additional Comments
NYS is an equal opportunity employer.
We are also recruiting for this role in NYC.
Some positions may require fingerprinting and background checks.
Benefits of Working for NYS
Generous benefits package, worth 65% of salary, including:
Holiday & Paid Time Off
Health Care Benefits
Additional Benefits
We are also recruiting for this role in NYC.
Some positions may require fingerprinting and background checks.
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
- Up to 50% telecommuting
- 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.
Some positions may require additional credentials or a background check to verify your identity.
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution.
Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right.
Surveys & Data Sets
Sign up to receive alerts about other jobs that are on the Project Assistant, Ref#7057 career path.
Click the checkbox next to the jobs that you are interested in.
Sign up to receive alerts about other jobs with skills like those required for the Project Assistant, Ref#7057.
Click the checkbox next to the jobs that you are interested in.
-
Backup/Recovery Skill
-
Income Estimation: $113,206 - $147,669
-
Income Estimation: $112,653 - $142,940
-
-
Change Data Capture Skill
-
Income Estimation: $111,866 - $145,464
-
Income Estimation: $117,453 - $144,802
-
View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles
Skills Library
Job openings at Information Technology Services, Office of
Information Technology Services, Office of
Albany, NY
Full Time
Information Technology Services, Office of
Albany, NY
Full Time
Information Technology Services, Office of
Albany, NY
Full Time
Information Technology Services, Office of
Hampton, NY
Full Time
Not the job you're looking for? Here are some other Project Assistant, Ref#7057 jobs in the Albany, NY area that may be a better fit.
We don't have any other Project Assistant, Ref#7057 jobs in the Albany, NY area right now.
Transportation, Department of, Albany, NY
US Assistant Secretary for Housing-Federal Housing..., Albany, NY