Responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of our corporate applications. This is a “hands-on” position requiring solid technical skills, as well as excellent interpersonal and communication skills.
The successful candidate will be responsible for the development and sustainment of the SQL Server Warehouse, ensuring its operational readiness (security, health and performance), while maintaining the existing systems and databases related to ERP, Project Management, and financial. The data warehouse supports an enterprise application suite of program management tools. Must be capable of working independently and collaboratively. The daily work is varied and challenging with a fantastic opportunity to engage in a positive and creative work environment.
Essential Functions (Key Responsibilities):
1.Perform application administration for the Deltek Vision application, including updates from the developers and contractors, as well as creating and maintaining custom programs and customizations for the application.
2.Perform system administration for the Deltek Vision application, including database servers.
3.Developing and maintaining similar systems for other business processes, including the corporate Intranet, Internet, or Site360 applications.
5.Maintain and improve the performance of existing software by ensuring availability, functionality, and optimization.
6.Design and update software databases to meet the growing needs of our organization.
7.Create and maintain reports for use by the business units, typically in SSRS using RDL.
8.Maintain the Data Warehouse and other analytics as required, typically in SSIS, and create and maintain data transformations that the business requires.
9.Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
10.Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.