Database Administrator

3 weeks ago


Albany, United States Castletop Logistics LLC Full time

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



  • Albany, United States Symplr Software LLC Full time

    Overview 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...


  • Albany, United States Symplr Software LLC Full time

    Overview 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...


  • Albany, United States Castletop Logistics LLC Full time

    Job 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,...


  • Albany, United States Mindlance Full time

    Role: 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...


  • Albany, United States Mindlance Full time

    Role: 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...


  • Albany, United States Mindlance Full time

    Provide 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...


  • Albany, United States Mindlance Full time

    Provide 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...


  • Albany, United States Wipro Limited Full time

    Preferred 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...


  • Albany, New York, United States Wipro Limited Full time

    Preferred 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...


  • 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 time

    We'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...


  • Albany, United States Rose International Full time

    Date 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 ...


  • 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...


  • Albany, United States New York State Sheriffs’ Association Full time

    The 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...


  • 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...


  • Albany, United States Pace Heating & Air Full time

    Pace 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...


  • 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...


  • 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...


  • Albany, United States Restaurant Depot Full time

    Position 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...