Hybrid/Local SQL Server Admin/Oracle DBA (both must) with SSIS, UAT, TFS admin, OLTP, DSS and SSRS experience

Job ID: FL-PR474134-R76015 (911590425)

Hybrid/Local SQL Server Admin/Oracle DBA (both must) with SSIS, UAT, TFS admin, OLTP, DSS and SSRS experience

Location: Tallahassee, FL (FWC)
Duration: 12 months

Qualification Requirements for Contractor:
1. Oracle-related
a. Four or more years’ experience with Oracle Database Server.
b. Four or more years’ experience as Oracle database administrator inclusive of data design/modeling,
monitoring, and performance tuning.
2. MS SQL-related
a. Seven or more years’ experience with MS SQL products inclusive of MS SQL 2008.
b. Seven or more years’ experience as MS SQL database administrator inclusive of data
design/modeling, monitoring, and performance tuning.
c. Seven or more years’ experience with SQL programming inclusive of stored procedures, functions,
triggers, SSIS packages, scheduled jobs, and linked servers.
d. Seven or more years’ experience with SQL relational databases, OLTP and DSS, serving in high
performance, service-oriented, multi-tiered environments.
e. Three or more years’ experience with configuration management (TFS administration) for SQL
database objects.
f. Five or more years’ experience with database design tools.
g. Five or more years’ configuration management of SSRS reports and associated database objects.
3. Enterprise platform-related
a. Five or more years’ experience in change management best practices, serving in a code promotion
role in partnership with development team.
Additional relevant experience may substitute for the recommended educational level on a year-for-year basis and
additional relevant education may substitute for the recommended experience on a year-for-year basis.

Database Analyst (C. Advanced) Scope of Work:
The selected applicant will be expected to perform some combination of the following tasks:
1. Provide Oracle database administration inclusive of data design/modeling, monitoring, and performance
tuning.
2. Provide MS SQL database administration inclusive of data design/modeling, monitoring, and performance
tuning.
3. Provide SQL programming inclusive of stored procedures, functions, triggers, SSIS packages, scheduled jobs,
and linked servers.
4. Provide configuration management (TFS administration) for SQL database objects.
5. Provide change management in a code promotion role in partnership with development team.
6. Provide configuration management for SSRS reports and associated database objects.
7. Provide analytical services on systems to implement user-defined requirements.
8. Provide analytical services on systems to identify operational efficiencies.
9. Facilitate collecting system requirements with the business program staff.
10. Produce work estimates to implement user-defined requirements.
11. Perform testing on system changes to meet user-defined requirements.
12. Facilitate user acceptance testing (UAT) with the business program staff.
13. Produce status reports on the implementation of user-defined requirements.
14. Produce accounting of hours worked by tasks.
15. Provide analytical services on FWC IT processes to identify operational efficiencies.
16. Follow FWC IT processes and coordinate with other FWC IT staff to ensure compliance with FWC standards.
17. Technical consultant to FWC staff.
18. Provide emergency after hours and weekend support for database systems.
19. Provide maintenance and support by applying updates and/or upgrades to database infrastructure
environments.
20. Take an active role in the agency information technology monitoring and reporting activities.
21. Complies with and enforces all agency policies, procedures, and security policies.
22. Provide Technical Training (Knowledge Transfer), as required for Office of Information Technology Support
Staff as related to FWC database systems configuration and operation.
23. Remote work for this position is contemplated but must be available for initial on-site setup and regular
meetings at FWC offices in Tallahassee, Florida. Local/Regional candidates preferred.
The deliverables and performance standards associated with each task identified in this scope of work are further
defined in Standards and Specifications table below.

Appendix+C+-+Candidate+References.pdf

Exhibit+E+-+Resume+Self-Certification+Form.pdf

Leave a Reply

Search

Categories

Archives

Tags

There’s no content to show here yet.

Discover more from innoSoul:

Subscribe now to keep reading and get access to the full archive.

Continue reading