Database Administrator - Consultant

Client supports in the neighbourhood of 300 plus sql server databases and are in the Process of migrating those databases from sql server 2019 to sql server 2022. In Addition, dmv is implementing high availability solutions on a number of the systems Supported by these databases and increasing our use of reporting services and analysis Services implemented in a number of support systems such as sharepoint, ms system Center, team foundation server, and others. Scdmv is also facing increasing security Concerns around these assets. In addition, this position will supplement our current sql dba force with production Support activities such as os updates, security updates, etc. And will require beyond Normal business hours activities. This position will be required to support the oracle Dba team as needed, create reports in ssrs and power bi, and utilize erwin in managing Logical and physical data models, data dictionaries and model documentation. This is expected to be a long term, ongoing assignment. On-site presence is required Therefore regional candidates (sc, ga, nc) will be given preferred priority. Candidate will be working in a team environment consisting of 6 database engineers And administrators and working directly with application architect and developers, Business analysts and server support team. Excellent oral and written Communications skills are required. PRE-EMPLOYMENT CHECKS (drug, credit, criminal, motor vehicle)? Drug, Criminal, Credit, e-Verify, NDA DAILY DUTIES / RESPONSIBILITIES:

• SQL Server

o Setup and maintain data replication and mirroring o Configure maintenance automation o Backup and Recovery o Troubleshoot SQL Server performance issues as they occur, including after-hours and weekends o SQL Server monitoring o Install and configure new SQL Servers o Develop and support data warehouse and cubes through SQL Server Analysis Services o Migrate SQL Server databases to SQL Server 2022 o Develop Reports using SSRS o Support SSIS packages o Develop database design, development, and management standards o Consult with developers regarding database design. o Implement and support 3rd party databases for vendor supplied applications

• Oracle 19 familiarity: Desired

o Analyze, develop, and support stored procedures and SQL.

• Business Intelligence

o Design, develop, and manage dashboards and reports through a BI solution

• Data Modeling - as assigned

o Designing, developing, and maintaining logical and physical data models using Erwin Data Modeler o Ensuring database designs support scalability, integrity, and performance requirements. o Collaborating with data architects, developers, and business analysts to translate business requirements into data models. o Modeling activities are required in Oracle databases and may be required for MS SQL databases, Job Title: Database Administrator - Advanced (10356) Duration: 12 Months (Extension Possible) Location: Columbia, SC 29201 Interview Process: 1 Round - Virtual Work Location: F…

• 15 hours ago, Job Title: Database Administrator - Advanced (10330) Location: Columbia, SC (Hybrid - 2 days onsite/week) Duration: 12 Months (Extension Possible) Interview Process: 1 Round - O…
• 19 hours ago, Job Title: Database Administrator - Consultant (9363) Work Arrangement: Columbia, SC Hybrid (3 days onsite, 2 days remote) Contract Duration: 12 months Extension: Possible Inte…
• 21 hours ago +

• 5+ YEARS OF EXPERIENCE WITH SQL SERVER 2019 AND 2022
• 5+ YEARS OF EXPERIENCE WITH SQL SERVER

REPORTING SERVICES

• 5+ YEARS OF EXPERIENCE WITH SQL SERVER ANALYSIS SERVICES
• 5+ YEARS OF EXPERIENCE WITH SQL REPORTS DESIGNER
• 5+ YEARS OF EXPERIENCE WITH BI TOOLS AND DESIGN
• 5+ YEARS OF EXPERIENCE AS AN SQL DATABASE ADMINISTRATOR
• 2+ YEARS OF EXPERIENCE WORKING WITH STATE GOVERNMENT AGENCIES

REQUIRED EDUCATION: BA IN COMPUTER SCIENCE, DATA SCIENCE, OR CLOSELY RELATED FIELD. PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE):

• DATA DOMAIN BOOST (DD BOOST) TO SUPPORT BACKUP AND RESTORE OPERATIONS FOR SQL SERVERS
• EXPERIENCE WITH ORACLE 19 DATABASE OPERATIONS
• EXPERIENCE WITH ORACLE GRID CONTROL
• EXPERIENCE WITH ERWIN DATA MODELER

InterSources Inc, is a Small, Woman, and Minority-Owned Business Enterprise, ISO/IEC 27001, SOC 2 Type 2 certified company with massive 18+ years of diversified experience in providing IT Consulting Services, Artificial Intelligence, Data Analysis, Application Development, Cloud Services, Cybersecurity, Digital Marketing, ERP Management, Custom Software Development, Web Development, UI/ UX Design, System Integration, QA Support etc. We make reasonable accommodations for clients and employees, and we do not discriminate based on any protected attribute including race, religion, color, national origin, gender sexual orientation, gender identity, age, or marital status. We also are a Google Cloud and Oracle partner company.