Previous Job
Previous
Technical Architect Expert High
Ref No.: 18-00025
Start Date: 01/24/2018
Agency: Information Technology Services (ITS)

Is this a Project or Program specific request (e.g., Connections, SFS)? Yes
If yes, please list the Project or Program Name: System Support – Connections 

Please provide a short description of the project: System Support role involves architecting and maintaining Oracle enterprise-level databases in support of computerized application systems.
The CONNECTIONS project is an ongoing effort to provide the development, maintenance, and support activities on the New York State's Statewide Automated Child Welfare Information System (SACWIS) for OCFS, LDSS, and Voluntary Agencies. 

Please provide a full listing of the day to day tasks to be performed by the Consultant (be descriptive and specific):
Review project/application/infrastructure initiatives and requirements
Design and Develop Oracle RDBMS solutions, options, and configurations
Advise on future applicability & suitability of architected solutions
Research Industry database  trends for suitability to support systems.
Develop and enforce database & design standards 
Database instance monitoring and tuning
Schema design (data modeling), development and implementation
Design, Implement, and enforce database security
Hardware/Software Infrastructure support (Oracle rdbms, server o/s);  Interface with Server administrators and other technical support staff
Database Backup and Recovery procedures (Oracle RMAN, utilities, etc.)
Disk & Tablespace utilization, monitoring, and reorganization;  
Data Management support (data refresh processes, application data fixes, Data load and/or conversion support)
Troubleshooting and problem resolution;   Utilize Oracle Support as needed. Provide Oncall/after hour support as needed.
SQL (Application) monitoring, tuning and advice
SQL & PL/SQL expertise; create/ troubleshoot Oracle-based procedures.
Utilize Oracle  Enterprise Mgr product to facilitate db admin tasks.

Which Service Group is required?
Service Group 1. STANDARD TITLES
What is the number of staff being requested? 
(maximum of 5) 1
Which Job Title Category is required? 
Technical Architect
Which Skill Level is required? 
Expert
Which Skill Demand is required? 
High
How many Candidate Response Forms are being requested per Contractor per position?     (1 or 2) 1
When is the Target Start Date?
(30 Business Days minimum from date of request) 3/2/2018
How long is the engagement? (in months) 24
When is the estimated completion date? 3/1/2020
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): Negotiable 7am - 5pm
Where is the Home Base Region? 
Region 1 - Capital Area
Where is the work office located?  Enter Building Name (if known) Full Street Address, City, and ZIP Swan St. Bldg, Core 3 , Albany,  New York , 12228
What type of software is typically used by the Agency?  (e.g., Agency is an "IBM shop.”) Oracle RDBMS,  IBM Unix O/S, Microsoft .NET Framework
What type of hardware is typically used by the Agency? (e.g., Agency is a "Client shop.”) IBM

Position Mandatory Qualifications
 Technical Architect
- Technical expert centered around a technology, technologies or a portfolio of applications- Designing and implementing Information Technology solutions
Expert
84+ Months: Candidate is able to provide leadership of large teams and/or extensive industry experience and is considered at the top of his/her field

Requested Qualifications 
Bachelor's degree (or higher) with major or minor in Computer Science or related field. 
84 months experience architecting technical solutions utilizing Oracle relational database technologies.  Specific areas of experience are expected to include (but are not limited to): Database Instance & Multi-Schema configurations, Security,  High Availability/Disaster Recovery features (RAC, Data Guard), Backup/Recovery (RMAN, Flashback), Disk configurations (including ASM, partitioning), Oracle Enterprise Mgr/Grid Control, Oracle Network setup including Dedicated and Shared server configurations.
84 months experience participating in project system development life cycle activities to collect and organize data and database infrastructure requirements including data modeling (logical and physical), database design, hardware/software, high availability/disaster recovery, and post implementation monitoring and troubleshooting.   
84 months demonstrated experience as database administrator of Oracle Relational databases utilizing software releases 11 and 12. Experience must include but not limited to performance of the following:  software installation, database instance creation, schema design (data modeling) and creation (DDL), tablespace management, backup and recovery, data management utilities (data pump, sql loader, etc.), sql tuning skills, and SQL/Pl-SQL.
60 months demonstrated experience installing, configuring, and utilizing the Oracle Enterprise Manager product versions 11 and 12 to support the administration and monitoring of Oracle databases and overall Oracle infrastructure.
84 months experience working with UNIX. Experience should
include operating system principles, system/ server admin staff on database and application related issues,
and shell scripting to support automation of database tasks.
12 months demonstrated experience monitoring, supporting and helping to administer Informatica IIR/SSA search software. 
36 months demonstrated experience supporting Oracle interfaces for computer applications utilizing Microsoft .Net Framework 2.0 or higher.
36 months demonstrated data processing experience working in public/government sector IT applications dealing with the delivery of government assistance or entitlements.  

Additional Information Requests:
Are there additional security requirements for the Authorized User? Yes: ITS-NDA, Fingerprinting background check, DTF 202 Form, FTI Appendix, CJIS certification and HIPAA document.  
Will additional training possibly be required during the Engagement? No 
If Yes, provide description of anticipated training.
What type, or manner, of Knowledge Transfer is requested during the engagement? Knowledge transfer would include relaying specific technical information, status, and methods/procedures as needed within the projects assigned to this position.
Is travel anticipated during the Engagement? No