SQL DBA (SQL server 2017 and current (2022))

Apply by Email/Direct Application at

Location: Martinez - Hybrid, 3x a week onsite (Tues, Wed, Thurs)

Duration: 6 month CTH

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

From Client:

• Python and Powershell knowledge - Skilled or Advance
• DevOps and Visual Studio Administration - Skilled or Advance
• SSIS Developer - Advance or Expert
• Azure SQL Integration - Skilled or Advance
• SQL Server Administration - Advance or Expert

Minimum Qualifications

Education: Possession of a Bachelor s degree from an accredited college or university with major course work in information systems, computer science or a closely related field.

Experience: Four years full-time or its equivalent experience performing database administration and/or computer programming analyst duties. Two years of the required experience must have included database administration duties.

Substitution: Additional qualifying experience may be substituted for the required education on a year-for-year basis up to a maximum of two years.

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

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.