SQL DBA
SQL DBA
Posted on :
13-10-2024
Employer Active
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
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 Countys 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 Countys 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
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
