This job offer is no longer available
About
This position is assigned responsibilities involving the administration of SQL Server databases. This includes the design, development, maintenance, security administration, capacity planning, performance monitoring and tuning, upgrade, backup and recovery of SQL Server databases to ensure the availability, integrity, confidentiality and security of information. A resource will work on projects for a state agency working on complex applications- mainly performing maintenance but could perform production duties as well. Position Responsibilities Ensure maximum database availability, performance and security by utilizing best industry practices, and provide database-related assistance to end users and application developers Design and implement online databases, security access systems, data sets and jobs; define parameters for file or space utilization; establish direct access files or other file configurations as required; monitor space utilization and makes modifications as needed Document and demonstrate solutions by developing documentation, flowcharts, layouts, diagrams, charts, and code comments Install and modify vendor software products; conduct appropriate tests to ensure compatibility of new or modified programs with operating system requirements; use database performance and tuning tools in order to monitor and enhance response times and system performance Respond to database operational emergencies as required, including database recoveries involving the use of database log files, which provide for the recovery of databases with no loss of data and do not require the user to re-enter data into the database Create queries, stored procedures, functions and other database objects Perform other data management processes utilizing database protocols Provide applications development and other unit personnel with database and data security information required to support application development and other activities Support repository/database dictionary requirements and activities; develop, implement and monitor control blocks and data definitions to support databases Confer with computer operations, technical support, user and vendor representatives concerning database requirements, system performance, software maintenance, capacity planning, and data security requirements Review systems specifications for compliance with departmental, division and database administration standards Provide assistance to the data engineering team to make data in agency systems available to the State Data Platform. Preference will be given to candidates who possess experience in building and maintaining multi-node High Availability SQL Clusters, Azure including but not limited to building and maintaining Azure SQL databases, Azure Managed Instances, Azure replication and etc., Azure equivalent cloud technology, like Google Cloud and etc., Power BI Report Server configuration and maintenance, Postgres, MySQL and SharePoint Database maintenance, and strong communication and client-facing skills with the ability to work in a centralized technology environment.
Languages
- English
Notice for Users
This job was posted by one of our partners. You can view the original job source here.