Job role: SQL DBA
Duration: 6 month CTH
Location: Martinez, CA - Hybrid, 3x a week onsite (Tues, Wed, Thurs)
Must Haves: SQL server - 2017 and current (2022) Azure Python scripting / Powershell Strong SQL skills 4+ years working experience - SQL DBA TFS / Visual Studio Support SSIS Knowledge, Skills, and Abilities Knowledge of: Principles and practices of database administration Methods and techniques of database design Operational characteristics of information systems environments Methods and techniques of applications development Principles and practices of software installation Principles and practices of system installation and administration SQL database language ETL development software Ability to: Develop and modify database models based on County needs Participate in systems analysis, design, and implementation Perform various database administration functions Develop standards and methodologies for use of the County's database management system Monitor and troubleshoot database performance Communicate clearly and concisely, both orally and in writing Establish and maintain effective working relationship with those contacted in the course of work Program and maintain business logic Assess existing technologies and/or systems and establish plan for improvements, changes and/or replacements. Typical Tasks: Develops, modifies, and maintains database models based on logical models, designs, and requirements Documents and communicates changes in database models Reviews data models developed by other information systems professionals and recommends modifications Assures logical and physical data models meet County standards for naming, metadata, and other common data structures Participates in systems analysis, design, implementation and maintenance Provides, advises and consults with application programmers during systems analysis Develops standards and preferred methodologies for use of the County's database management system environment and associate application developments Installs, upgrades, and maintains software and/or patches for standard database management systems Establishes and implements procedures for database security, backup method/policy and disaster recovery solutions Monitors and optimizes database performance, and responds to system problems that may affect the database Consults and assists with the software implementation Programs and maintains business logic for application integration, data extraction, data transformation, and data load Ensures database accessibility and scales for system availability needs Establish plans for system capacity, technology succession planning, technology modernization, system upgrade and migration