22nd Century Technologies, Inc.
Location
Tallahassee, FL | United States
Job description
Duration: 6 Months
Contractor Qualifications and Experience:
- Five years of MS SQL Server Administration experience.
- Five years of MS SQL Server Integration Services experience.
- Five years of MS SQL Stored procedures, triggers, scheduling, and performance tuning.
- Five years of experience with MS SQL Server 2008 or a later version.
- Five years of experience with Business Intelligence Development Studio or Visual Studio for package(s) development.
- Five years of experience with SQL programming inclusive of stored procedures, functions, triggers, Data Transformation Services (DTS) packages, scheduled jobs, and linked servers.
- Five years of experience with SQL relational databases, Online Transactional Processing (OLTP) and Decision Support System (DSS).
- Five years of experience importing data into a large-scale data warehouse environment utilizing SQL Server Integration Services or Data Import functionality.
- Five years of experience with Source Control systems such as Visual Studio Team Services or Team Foundation Server.
- Five years of experience with software build and release management methodologies.
- DevOps certified with five years of experience in HIV Surveillance, Budget, and Case Management systems.
Contractor Responsibilities: - Assist with data management tasks for STD testing or other communicable diseases data on a weekly basis as directed by the Department.
- Produce and submit data reports related to quality improvement or technical assistance visits on a weekly basis as directed by the Department.
- Maintain current SQL Server integration packages deployed in production daily.
- Maintain and support the Department's STD or other communicable diseases Data warehouse and other SQL Server Databases daily as directed by the Department.
- Develop new SQL server integration packages as needed for Extract, Transform an Load (ETL) daily as directed by the Department.
- Collaborate with the Department's Division of Disease Control and Health Protection (DCHP) information technology teams; design, develop, and code based on business requirements for the DCHP Master Person Index (MPUI) project as part of the overall strategic effort for integration and interoperability of its systems and software daily as directed by the Department.
- Work with DCHP resources to standardize collection and storage of DCHP shared data daily as directed by the Department.
- Implement and submit DCHP SQL Server database standards on the Department's STD databases as directed by the Department.
- Monitor and optimize the existing Data Exchange Interfaces, including SQL Server Integration
- Services (SSIS), or any other Department STD or other communicable diseases systems daily as directed by the Department.
- Perform database administration tasks for the Department's STD or other communicable diseases databases as per Department policies and procedures daily as directed by the Department.
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. Report this job
- Dice Id: 10216532
- Position Id: 24-03628
Job tags
Salary
