Database Administrator Expert

2 weeks ago


Albany, United States Princeton IT Services Full time
Job DescriptionJob Description

Job Title: Database Administrator Expert

Location: Albany, NY

Role Type: Contract

Job Overview:

The Database Administrator Expert will play a pivotal role in supporting the priorities and initiatives. This position will be integral to the project portfolio, particularly in supplementing the staff for initiatives resulting from the Budget that impact Grants and Scholarship programs.

Key responsibilities:

  • Building and maintaining a robust data architecture tailored to meet specific requirements.
  • Designing and developing Logical and Physical Data Models using ER Studio Data Architect, and creating DDL scripts to establish and maintain databases.
  • Writing complex SQL queries against SQL Server and DB2 databases, and creating DML scripts for data manipulation.
  • Collaborating with project managers, solution architects, business analysts, application development teams, and QA to ensure the quality of DDL and DML scripts.
  • Conducting performance tuning of SQL queries to enhance efficiency.
  • Working closely with representatives to develop gap analysis specifications and understand business rules.
  • Providing guidance and hands-on development for queries in QMF for Workstation.
  • Creating comprehensive documentation on data models and describing data usage in application process flow.

Requested Qualifications:

  • 84 months of Experience designing and developing logical and physical data models, and creating DDL scripts for tables, views, indexes, triggers, and stored procedures.
  • 84 months of Experience designing and developing Data Conversion Strategy Plan, Data Mapping Documents, and Gap Analysis.
  • 84 months of Experience writing complex DML SQL against enterprise SQL Server and DB2 databases.
  • 84 months of Experience working with tools like SQL Server Management Studio, SSMS Job Scheduler, SSIS, SSRS, Export/Import, ER Studio Data Architect, QMF for Workstation, Redgate SQL Compare, and TSO.
  • 84 months of experience using programming languages such as SQL, PL/SQL.
  • 60 Months of experience in performance tuning complex SQL against enterprise SQL Server and DB2 databases.


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


  • Albany, United States PSI International Full time

    HBITS-05-13380 Database Architect Expert Agency Name: Information Technology Services (ITS) Is this a Project/Program specific Position? Yes If YES, list the Project/Program Name: Enterprise Data Warehouse and various Health Cluster projects within the agency. provide a short description of the Position: Data warehouse database and ETL(Extract, Transform,...


  • Albany, United States Absolute Staffing & Consulting Solutions Full time

    Job DescriptionJob DescriptionAbsolute Staffing is searching for a Database Administrator to work with our client. Location: Albany, NY (12207)Duration: 24 Months Job Description: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...


  • Albany, United States Absolute Staffing & Consulting Solutions Full time

    Job DescriptionJob DescriptionAbsolute Staffing is searching for a Database Administrator to work with our client. Location: Albany, NY (12207)Duration: 24 Months Job Description: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...

  • Database Administrator

    Found in: beBee S US - 3 weeks ago


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

  • Database Administrator

    Found in: beBee jobs US - 3 weeks ago


    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 CareerBuilder Full time

    Hello, We are urgently hiring for the below contractual role with our Direct client NYS: Job Title: Oracle Database Administrator (OBIEE / AIX) Client:State of New York Agency: NYS OPWDD Task ID:HBITS-05-13353 Location: 500 Balltown Road, Schenectady, NY 12304 Duration: 30 months This is a long term opportunity on the Hourly-Based IT Services (HBITS)...


  • Albany, United States Castletop Logistics LLC Full time

    Job Overview: We are seeking a talented Expert Software Architect HBITS-05-13394. Required to work on site starting day 1. **DURATION**:21 Months **LOCATION**: Albany, NY - _Onsite_ This position will be in support of the NYS Tax Modernization Program. This program will encompass multiple projects to modernize legacy systems within the NYS Department of...


  • Albany, United States DWebTech Full time

    Job DescriptionJob DescriptionRole: PeopleSoft Administrator Location: Albany, NY Description: 84 months of system administration experience in Oracle's PeopleSoft FSCM 9.1 or higher release. Where duties included installation, configuration, tuning, upgrade/patching, and perform code migrations in a Unix/AIX environment. 84 Months of system...

  • Expert Systems Developer

    Found in: beBee jobs US - 2 weeks ago


    Albany, New York, United States Quality Healthcare Staffing Full time

    Position: Expert Systems DeveloperDuration: 24 MonthsLocation: Albany, NY – OnsiteHourly Wage Range: $55 to $60 per hourQualifications:Systems Developer with expertise in developing and implementing backend applications and programs for businesses and organizations.Expertise Level: 84+ months, capable of guiding large teams or possessing extensive industry...

  • Software Architect Expert

    Found in: Careerbuilder One Red US C2 - 1 day ago


    Albany, NY, United States Godspeed Group Full time

    Job Title: Software Architect ExpertLocation: 40% Remote; In office Tues./Wed./Thurs.Duration: 30 MonthsHours: 40 hrs. per week / Mon-Fri, 8:30am to 5pm ET (negotiable)Position Skill Level: 84+ Months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.Requested...

  • Systems Architect Expert

    Found in: beBee jobs US - 2 weeks ago


    Albany, New York, United States Quality Healthcare Staffing Full time

    Job Title: Systems Architect ExpertLocation: Albany, New YorkPayrate: $53 - $58 per hourSchedule: 8:00 A.M. - 5 P.M, Monday to FridayDue Date: 04/15/2024Responsibilities:Architect technology solutions aligning with business requirements and standards.Troubleshoot OS configurations, storage, and networking of business applications.Collaborate with vendors for...

  • IT Specialist

    5 days ago


    Albany, United States Avenues International Full time

    Job DescriptionJob DescriptionPosition Name: PeopleSoft FSCM ConsultantJob ID: HBITS-05- 13361Duration: 18+ Months Location: Albany, NY, (Day 1 Onsite)Primary Skills:84 months of functional experience performing PeopleSoft FSCM (GL and KK) implementations including requirements gathering and producing functional specifications.84 months of experience in...


  • Albany, United States Equiliem Full time

    Summary of Duties: The successful candidate will assist with all aspects of NY's prescription program, paper and electronic; prescriber education, issuing controlled substance licenses to healthcare facilities, processing drug destruction requests from healthcare facilities, providing guidance to pharmacies with submission of dispensed prescription data, and...


  • Albany, United States Colonie Senior Services Centers Full time

    This position is responsible for overall efficient functioning of general administrative office operations. Job duties include but not limited to: - Typing and filing - Preparation of reports, composition of formal correspondence - Maintaining mailing lists, database information, and resident records - Processing accounts payable and logging accounts...


  • Albany, United States Pace Heating & Air Full time

    Job DescriptionJob DescriptionPace 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 Computer Systems Administrator

    Found in: beBee S US - 3 weeks ago


    Albany, United States Judicial Branch Full time

    Summary The ACSA position includes litigation support duties, assistance to the Computer Systems Administrator, and user support responsibilities. ...

  • Assistant Computer Systems Administrator

    Found in: beBee jobs US - 2 weeks ago


    Albany, New York, United States Judicial Branch Full time

    Summary The ACSA position includes litigation support duties, assistance to the Computer Systems Administrator, and user support responsibilities. Duties Litigation support job duties can include, but are not limited to, the following:Apply knowledge of court rules, local practices, and the Federal Criminal and Civil Rules of Procedure in analyzing...


  • Albany, United States SMR Group Full time

    Job Description Job Description Oncology Territory Manager Job Description Our long-time client is dedicated to the creation and supply of innovative pharmaceutical therapies to improve standards of care and address diversified, unmet medical needs of people globally by leveraging our world-class science and technology. With more than 100 years of scientific...

  • SharePoint Administrator

    Found in: Jooble US O C2 - 2 weeks ago


    Albany, NY, United States Isospin Technologies, LLC Full time

    Title: Sharepoint Developer Position Type: Contract Location: Albany, NY Description: Mandatory Qualifications: 1.Level II- Between four (4) and seven (7) years of experience as a Developer 2.​7 years Proven experience as a SharePoint Web Developer with a strong portfolio showcasing custom SharePoint solutions with hands-on experience in SharePoint...