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