osition: Data Warehouse Analyst

Place of Performance : Onsite -Tallahassee, FL

Duration: 48 Months Aprox


Contractor Qualifications and Experience:

Contractor staff assigned to this agreement must possess the following minimum qualifications and experience:

" Six years of experience with Structured Query Language (PL/SQL) to query Oracle databases.

" Six years of experience with Oracle relational databases, On-Line Transaction Processing (OLTP) and Decision Support System (DSS), serving in high performance, service-oriented, multi-tiered environments.

" Six years of experience with Source Code Control System (SCCS) for the management of internal code changes to Oracle Forms and Reports, Oracle objects, and scripts.

" Microsoft Structured Query Language (MS SQL) Related Experience:

" Six years of experience with MS SQL products inclusive of MS SQL 2008.

" Six years of experience as an MS SQL administrator inclusive of data design and modeling, monitoring, and performance tuning.

" Six years of experience with Structured Query Language (SQL) programming inclusive of stored procedures, functions, triggers, DTS packages, scheduled jobs, and linked servers.

" Six years of experience with SQL relational databases, OLTP and DSS, serving in high performance, service-oriented, multi-tiered environments.

" Six years of experience with configuration management (SourceSafe administration) for SQL database objects.

" Six years of experience with database design tools including ERWin and ERStudio.


Reports Development Experience:

" Six years of experience with independently analyzing and interpreting table structures and relationships to develop complex queries and reports.

" Six years of experience with database navigational and analysis tools, and the ability to recommend the appropriate tool for the appropriate data infrastructure complexity;

" Six years of experience with developing queries and reporting against complex relational databases with preference given to experience with Crystal Reports and ASP to deliver such queries and reports.

" Six years of experience with data integrity evaluation, taking corrective action on identified data problems, and assisting with implementing data quality checks during data intake;

" Six or more years developing queries and reports against the Versa Regulation and Versa Online Commercial Off-the-Shelf (COTS) products.


Contractor Responsibilities

SERVICE TASKS: Contractor will perform the following tasks in the time and manner specified:

" As directed by the Department, develop ad-hoc queries on database schema daily.

" As directed by the Department, provide reporting and data integrity requirements of the licensure data warehouse to the Department's Office of Information Technology (Client) daily.

" As directed by the Department, modify MS SQL T-SQL language daily.

" As directed by the Department, modify MS SQL Database Storage structures tables daily.

" As directed by the Department, modify MS SQL tables view indexes daily.

" As directed by the Department, develop ad-hoc queries on MS SQL Databases daily.

" As directed by the Department, work directly with the Department's Client to manage production promotion for Crystal BO reports daily.

" As directed by the Department, provide analytical services for system incidents and enhancements daily.

" As directed by the Department, process defect tickets to correct system errors within two business days.

" As directed by the Department, process release tickets to manage user requirements within the specific ticket request timeframe. The response due date of tickets assigned will range from one hour to more than one week.

" As directed by the Department, provide analytical services on systems to implement user-defined report requirements monthly.

" As directed by the Department, provide analytical services on systems to identify data integrity issues daily.

" As directed by the Department, facilitate collection of report requirements with the business program staff daily.

" As directed by the Department, deliver code to perform reporting functions as defined in user requirements daily.

" As directed by the Department, document report requirements, business processes, and system processes daily.

" As directed by the Department, perform testing on system changes to meet user-defined requirements daily.

" As directed by the Department, facilitate user acceptance testing (UAT) with the business program staff daily.

" As directed by the Department, facilitate meetings with technical and program staff (scheduling meetings, document decisions, identify issues and action items) daily.

" As directed by the Department, produce work estimates to implement user-defined requirements and system changes daily.

" As directed by the Department, produce status reports on the implementation of user-defined requirements monthly.

" As directed by the Department, produce detailed accounting of hours worked by tasks monthly.

" As directed by the Department, provide analytical services on Department's Client processes to identify operational efficiencies daily.

" As directed by the Department, provide analytical research to satisfy queries requested by the Legislature and Department's management daily.

" As directed by the Department, follow the Department's Client processes and coordinate with other Department IT staff to ensure compliance with Department standards daily.

" Coordinate efforts with the Department's Program Manager to achieve cost savings under this agreement, where feasible and practicable, as directed by the Department. Those efforts include, but are not limited to, identifying common system errors in systems that can be resolved in a manner that achieves cost savings in the State of Florida.