|Date Posted:||April 26 2018|
|Requirements:||Analyze developer’s needs for new objects and make recommendations as to the most efficient way to implement the requirements while ensuring optimization; |
Code stored procedures, triggers, and views using Ansii standard SQL and SQL Server Transact SQL;
Develop and maintain technical specifications, standards, procedures, and techniques for collecting, processing, storing, and distributing data;
Develop and maintain processes that optimize databases and queries to ensure response times are kept to a minimum;
Analyze, troubleshoot, and resolve SQL database issues to minimize impact on users;
Create SQL Server Integration Systems (SSIS) Packages that push data to SQL server databases from IBM mainframe SQL databases;
Write SQL Server Powershell scripts for use in monitoring SQL Server database activity;
Create Linked Servers to obtain data from multiple SQL databases;
Administer SQL Server security as needed to applications’ programmers;
Create SQL Server indexes as needed to improve the performance of FDC’s applications;
Refresh Development and Test SQL environments with production data as needed for testing out program changes;
Restore SQL databases when requested.
EDUCATION AND EXPERIENCE
A bacholer degree in IT or closely-related field; MBA or BS degree preferred.
4 - 7 years of overall IT experience.
|Job Location:||Tallahassee, FL|