The SQL Server DBA will manage the administration, performance, and support of SQL Server databases, ensuring their availability and reliability across various environments.
SQL Database Developer
📜 Description
- Develop queries, procedures, and functions for databases interfacing with ERP and agency systems.
- Support redevelopment and integration of multiple database systems and applications.
- Establish the foundation for a data warehouse.
- Design, modify, and maintain stable, reliable databases according to requests and industry practices.
- Create and maintain database documentation and design diagrams.
- Ensure database programs meet agency and performance requirements; research and recommend design and feature improvements.
🛠️ Requirements
- Proven database development skills.
- Knowledge of software development.
- Hands-on experience with MSSQL.
- Experience developing documentation.
- Bachelor’s degree in computer science or relevant work experience.
- Preferred: understanding of data management, database design, integration, and data warehouse design.
- Preferred: knowledge of industry best practices and techniques, with problem-solving skills.
- Preferred certifications: Microsoft Certified Solutions Associate (MCSA) or Microsoft Certified Solutions Expert (MCSE).
Full job description
Company Description
Job Description
SQL Database Developer - State of South carolina-Department of transporatation-SCDOT
Only W2(Green Card/ US Citizen)
Hourly rate $60/hr W2
Job Description
SCOPE OF THE PROJECT:
RE-DEVELOPMENT AND INTEGRATION OF MULTIPLE DATABASE SYSTEMS SERVING INTERFACING BETWEEN THE AGENCY PERSONNEL INFORMATION SYSTEM, CLOUD HOSTED ENTERPRISE ASSET MANAGEMENT SYSTEM, AND VARIOUS INTERNAL SYSTEMS AND APPLICATIONS. PRIMARY FOCUS WILL BE TO DEVELOP QUERIES, PROCEDURES, AND FUNCTIONS WITHIN IN THE DATABASE INTERFACING WITH THE STATE ERP SYSTEM AND SCDOT SYSTEMS AND APPLICATIONS. SECONDARY FOCUS WILL BE ESTABLISHING THE FOUNDATION FOR A DATA WAREHOUSE. POSITION IS ONSITE.
DAILY DUTIES / RESPONSIBILITIES: DESIGN STABLE, RELIABLE AND EFFECTIVE DATABASES. MODIFY DATABASES ACCORDING TO REQUESTS, FOLLOW INDUSTRY STANDARDS, BEST PRACTICES AND USE COMMON PRACTICES AND TECHNIQUES. CREATE AND MAINTAIN ACCURATE DOCUMENTATION AND DESIGN DIAGRAMS, ENSURE DATABASE PROGRAMS MEET AGENCY AND PERFORMANCE REQUIREMENTS, RESEARCH AND PROVIDE RECOMMENDATIONS FOR DATABASE DESIGN AND FEATURE IMPLEMENTATION.
REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE):
PROVEN SKILLS AS A DATABASE DEVELOPER
KNOWLEDGE OF SOFTWARE DEVELOPMENT
HANDS ON EXPERIENCE WITH MSSQL
DOCUMENTATION DEVELOPMENT
PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE):
IN-DEPTH UNDERSTANDING OF DATA MANAGEMENT, DATABASE DESIGN, INTEGRATION, AND DATA WAREHOUSE DESIGN
KNOWLEDGE OF INDUSTRY BEST PRACTICE AND TECHNIQUES
ABILITY TO UNDERSTAND REQUIREMENTS AND A PROBLEM-SOLVING ATTITUDE
REQUIRED EDUCATION/CERTIFICATIONS:
BS DEGREE IN COMPUTER SCIENCE OR RELEVANT WORK EXPERIENCE IN FIELD
PREFERRED EDUCATION/CERTIFICATIONS:
MICROSOFT CERTIFIED SOLUTIONS ASSOCIATE (MCSA)
MICROSOFT CERTIFIED SOLUTIONS EXPERT (MCSE)
Share resume to sam@miraclezit(dot)com
Qualifications
Additional Information
All your information will be kept confidential according to EEO guidelines.
Similar jobs
Search more Database Administrator jobsADMINISTRADOR DE BANCO DE DADOS - TI
Administra e monitora bancos de dados, garantindo desempenho, disponibilidade, integridade e segurança, além de otimizar consultas, manter estruturas e apoiar a integração e disponibilização de dados.
PostgreSQL Database Administrator - CLEARED
The PostgreSQL Database Administrator will manage and modernize mission-critical database environments, ensuring secure access and optimal performance within a federal cloud infrastructure.
Provides technical expertise for pharmacovigilance systems, maintaining and configuring Argus Safety databases, supporting data migrations and integrations, and ensuring validated, compliant safety reporting.
IBM Database Administrator
As an IBM Database Administrator, you will install, maintain, and support IBM Db2 databases, ensuring their security, availability, and performance for critical applications.
