Database Administrator
3 weeks ago
Job Summary:
The requirements listed below are from the "**State of New York,**" and requires applicants to start on-site on **Day 1**
**Database Administrator - Expert - **HBITS-05-13387
**Agency Name: Information Technology Services (ITS)**
**Location : 99 Washington Ave, Albany, NY, 12207**
**Duration : 24. 0 Months**
**Project/Program Name**: Grants & Scholarships
**Short description of the Position**: Based on Governor’s Office priorities, there are crucial initiatives that benefit New York State Higher Education Services (HESC) and are part of the ITS/HESC project portfolio. This position will supplement the GLP DB staff for governor initiatives resulting from the 2024 NYS Budget and that effect HESC’s Grants and Scholarship programs.
**Duties**:
- Build and maintain a data architecture based on the requirements.
- Design and develop Logical and Physical Data Model using ER Studio Data Architect. Create DDL scripts to establish and maintain necessary databases.
- Write complex SQL queries against SQL Server and DB2 databases. Create DML scripts to manipulate data.
- Performance tuning SQL to improve efficiency.
- Working with NYS Agency representatives to develop gap analysis specifications and understand Agency business rules.
- Provide guidance and hands-on development for developing and maintaining queries in QMF for Workstation.
**Skills**:
- 84 months of Experience designing and developing logical and physical data models, and creating DDL scripts for tables, views, indexes, triggers, stored procedures.
- 84 months of Experience designing and developing Data Conversion Strategy Plan, Data Mapping Documents, Gap Analysis.
- 84 months of Experience writing complex DML SQL against enterprise SQL Server and DB2 databases.
- 84 months of Experience working with the tools like SQL Server Management Studio, SSMS Job Scheduler, SSIS, SSRS, Export/Import, ER Studio Data Architect, QMF for Workstation, Redgate SQL Compare, TSO.
- 84 months of experience using programming languages such as SQL, PL/SQL.
- 60 Months of experience performance tuning complex SQL against enterprise SQL Server and DB2 databases.
- Résumé
- Please submit a copy of resume which details relevant experience AND identifies a BS or MS Computer Science Degree and the School / Graduation Date obtained from.
**Job Types**: Full-time, Contract
Pay: $52.60 - $58.60 per hour
Schedule:
- 8 hour shift
- Monday to Friday
Ability to Relocate:
- Albany, NY: Relocate before starting work (required)
Work Location: In person
-
Database Administrator
1 week ago
Albany, United States Symplr Software LLC Full timeOverview The Database Administrator implements, maintains and continuously improves RDBMS systems to ensure availability, scalability, and advancement of our enterprise applications, showcasing solid technical and interpersonal skills to assist in debugging protocols/process for stack callbacks, implementing corrective action within SQL scope, and analyzing...
-
Database Administrator
2 days ago
Albany, United States Symplr Software LLC Full timeOverview The Database Administrator implements, maintains and continuously improves RDBMS systems to ensure availability, scalability, and advancement of our enterprise applications, showcasing solid technical and interpersonal skills to assist in debugging protocols/process for stack callbacks, implementing corrective action within SQL scope, and analyzing...
-
Expert Database Administrator
6 days ago
Albany, United States Castletop Logistics LLC Full timeJob Overview: We are seeking a skilled Expert Database Administrator HBITS-05-13403. Install, configure, and maintain SQL Server database instances. Troubleshoot problems and provide technical explanations. Host\lead meetings in a group environment. Required to work on site from day 1 **DURATION**:30 Months **LOCATION**: Albany, NY - _Onsite_ Install,...
-
SQL database Administration
1 week ago
Albany, United States Mindlance Full timeRole: SQL database Administration Location: Albany, NY Duration: 30+ Months Job description: • 84 Months Experience in MS SQL server and database Administration • 84 Months Experience in MS SQL Application Database Administration • 84 Months Experience in MS SQL Performance Tuning and Improvement • 84 Months Experience in MS SQL Extract Transform and...
-
SQL database Administration
2 days ago
Albany, United States Mindlance Full timeRole: SQL database Administration Location: Albany, NY Duration: 30+ Months Job description: • 84 Months Experience in MS SQL server and database Administration • 84 Months Experience in MS SQL Application Database Administration • 84 Months Experience in MS SQL Performance Tuning and Improvement • 84 Months Experience in MS SQL Extract Transform and...
-
Database Administrator- Expert
1 week ago
Albany, United States Mindlance Full timeProvide a short description of the Position: The APD project is designed to deliver an integrated health care data warehouse and analytic platform to provide policymakers, researchers, and consumers with a comprehensive repository of health care information. The NY APD will be used for quality measurement, population health monitoring, value-based...
-
Database Administrator- Expert
2 days ago
Albany, United States Mindlance Full timeProvide a short description of the Position: The APD project is designed to deliver an integrated health care data warehouse and analytic platform to provide policymakers, researchers, and consumers with a comprehensive repository of health care information. The NY APD will be used for quality measurement, population health monitoring, value-based...
-
Database Administrator
4 weeks ago
Albany, United States Wipro Limited Full timePreferred Qualifications Knowledge of HIV/AIDS experience with public health surveillance disease registries or public health laboratory data and working with confidential data. Experience with Microsoft Access Excel and SAS or other data analysis packages. Responsibilities Build database systems of high availability and quality depending on each end...
-
Database Administrator
4 weeks ago
Albany, New York, United States Wipro Limited Full timePreferred Qualifications Knowledge of HIV/AIDS experience with public health surveillance disease registries or public health laboratory data and working with confidential data. Experience with Microsoft Access Excel and SAS or other data analysis packages. Responsibilities Build database systems of high availability and quality depending on each end user's...
-
Administrative Assistant 1
7 days ago
Albany, United States State Police, Division of Full time**Minimum Qualifications** One (1) year permanent service as a New York State employee in a title allocated Salary Grade 6 or higher, OR Please Note: A typing performance test will be required for those interested employees outside of the Office Assistant 1 (Keyboarding) title series. **Duties Description** Responsible for timely preparation of Service...
-
Albany, United States NYS Office of Mental Health Full timeWe've been looking for you! We know you value job security, work life balance, and opportunity for growth. Join us at the New York State Office of Mental Health as an Administrative Assistant 1/Administrative Assistant Trainee to begin a rewarding, life-long career in public service and receive all of that and more! The State of New York offers unmatched...
-
Administrative Assistant
7 hours ago
Albany, United States Rose International Full timeDate Posted: 05/15/2024 Hiring Organization: Rose International Position Number: 464113 Job Title: Administrative Assistant Job Location: Albany, NY, USA, 12206 Work Model: Onsite Shift: Monday - Friday 8:45 am - 4:45 pm Employment Type: Temporary Estimated Duration (In months): 6 Min Hourly Rate ($): 20.00 Max Hourly Rate ($): 25.00 ...
-
Legal Administrative Assistant
1 day ago
Albany, United States MoxieIT Full time*Responsibilities:*- Assist with legal administrative tasks such as filing, document preparation, and maintaining case files.- Conduct legal research and compile data for attorneys.- Manage document management systems and databases.- Transcribe legal documents, correspondence, and pleadings.- Coordinate client interviews and meetings.- Support attorneys in...
-
Administrative Assistant
4 weeks ago
Albany, United States New York State Sheriffs’ Association Full timeThe NYS Sheriffs’ Association is seeking an experienced part-time Administrative Assistant to assist with multiple priorities simultaneously, supporting staff in an administrative capacity. Primary Responsibilities: - Assist in event and meeting planning, by working with the assigned staff to coordinate meeting locations, attendees, registration, meeting...
-
Albany, United States DASNY - Dormitory Authority of the State of New York Full time**Minimum Qualifications** Minimum Qualifications Bachelor’s degree or Associate’s degree plus three years relevant experience or High School diploma or equivalent plus four years of DASNY relevant experience or High School Diploma plus five years of relevant experience. Preferred Qualifications Bachelor’s degree in Business or Public Administration...
-
Administrative Assistant 1/trainee
2 days ago
Albany, United States Teachers' Retirement System Full time**Minimum Qualifications** Minimum Qualifications EITHER: 1) Reachable on the Civil Service eligible list; OR 2) Eligible for reassignment by virtue of having permanent competitive service as an Administrative Assistant 1 (11); OR 3) Eligible for transfer under the provisions of the Civil Service Law by virtue of having one year of permanent competitive...
-
HVAC Service Dispatcher
6 days ago
Albany, United States Pace Heating & Air Full timePace Heating & Air, Albany OR. Proudly service Corvallis, Albany, and the surrounding area since 1996. We provide service, maintenance and installation for residential homeowners and commercial properties with their heating, cooling, and indoor air quality needs. We are Hiring an HVAC Service Dispatcher / Administrative Assistant! Looking for someone with...
-
Administrative Assistant 1/trainee
7 days ago
Albany, United States Criminal Justice Services, Division of Full time**Minimum Qualifications** NON-COMPETITIVE MINIMUM QUALIFICATIONS: Administrative Assistant Trainee 1, NS (Equated to SG-8): NY HELPS: This title is part of the New York Hiring for Emergency Limited Placement Statewide Program (NY HELPS). At a future date (within one year of permanent appointment), itis expected employees hired under NY HELPS will have...
-
Administrative Assistant 1
7 days ago
Albany, United States General Services, Office of Full time**Minimum Qualifications** This title is part of the New York Hiring for Emergency Limited Placement Statewide Program (NY HELPS)* and applicants must meet the following minimum qualifications to be considered for this position: This title includes a traineeship opportunity and applicants will be appointed to the appropriate level** based on their...
-
Stocktaker - Administrative
3 days ago
Albany, United States Restaurant Depot Full timePosition Title: Stocktaker Department: Inventory Control Supervisor: Inventory Controller FLSA: Non-exempt Position Summary: The Stocktaker is responsible for ensuring all products in the warehouse are properly accounted for. They must count merchandise on the warehouse floor and compare it to information maintained in a database to ensure the amounts on the...