Previous Job
Database Administrator Senior High
Ref No.: 18-01216
Location: Albany, New York
Start Date: 10/17/2018
Agency: OTDA
Is this a Project or Program specific request (e.g., Connections, SFS)?
If yes, please list the Project or Program Name:
PRJ0250506 Automated Claiming System (Client) Upgrade
Please provide a short description of the project:
This project involves an upgrade of the current Client application and functionality. Looking for a technology solution to reduce template maintenance, simplify application distribution, improve access to Client data, enhance reporting and user security updates.
Please provide a full listing of the day to day tasks to be performed by the Consultant (be descriptive and specific):
The Database Administrator will work closely with the Client Project Manager and technical staff to evaluate and improve the current state of the Client database structure and performance.
The candidate of this position will be responsible for, but not limited to:
Evaluation of the current designs logical and physical database models, provide recommendations for improvement.
Optimizing and performance tuning of the Oracle database
Evaluate and recommend improvements to all Oracle development, including PL/SQL Packages and Triggers
Perform Extract, Transform, and Load (ETL) techniques where needed
Establishes, monitors and ensures that project goals/objectives are met; managing daily work/priorities.
Which Service Group is required?
What is the number of staff being requested?
(maximum of 5)
Which Job Title Category is required?
Database Administrator
Which Skill Level is required?
Which Skill Demand is required?
How many Candidate Response Forms are being requested per Contractor per position? (1 or 2)
When is the Target Start Date?
(30 Business Days minimum from date of request)
How long is the engagement? (in months)
24 Months
When is the estimated completion date?
Is this a Full or Part-Time Position (Full time is considered 40 Hours Per Week)?
Full time
If Part-Time, enter approximate number of hours per week:
What are the daily work hours? (note if negotiable or list preferred start and end time):
8:00 am to 5:00 pm negotiable
Where is the Home Base Region?
Region 1
Where is the work office located? Enter Building Name (if known) Full Street Address, City, and ZIP
40 North Pearl St.
Albany, NY 12043
What type of software is typically used by the Agency? (e.g., Agency is an "IBM shop.”)
.Net, Microsoft technologies and Oracle Database
What type of hardware is typically used by the Agency? (e.g., Agency is a "Client shop.”)
Microsoft Technologies
Position Mandatory Qualifications
Database Administrator - Responsible for data analysis and database management- Maintenance, enhancement, designing of data dictionaries, physical and logical database models, and performance tuning
Senior – 60 to 84 months experience - Candidate is able to work without assistance and can provide leadership for others; may have advanced education
Requested Qualifications
A bachelor's degree
60 + months experience in designing logical and physical database models
60+ months experience optimizing and performance tuning Oracle databases
60+ months experience in Oracle development, PL/SQL development including Triggers, Packages
24+ months performing Extract, Transform, and Load (ETL) techniques.
Additional Information Requests:
Are there additional security requirements for the Authorized User?
Will additional training possibly be required during the Engagement?
If Yes, provide description of anticipated training.
What type, or manner, of Knowledge Transfer is requested during the engagement?
Database mentoring for State staff as well as organized documentation as requested.
Is travel anticipated during the Engagement?
If Yes, please list anticipated frequency and locations for travel: