Database Administrator - Onsite

Company: Viva USA Inc.
Location: Blythewood
Posted on: April 1, 2025

Job Description:

Title: Database Administrator - Onsite

Candidates should take the time to read all the elements of this job advert carefully Please make your application promptly.

































Description:
















SCOPE OF PROJECT:

The client supports in the neighborhood of 300 plus SQL server databases and are in the process of migrating those databases from SQL server 2016 to SQL server 2022. In addition, client 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 Share point, MS system center, team foundation server, and others. client 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 hours activities.

This is expected to be a long term, ongoing assignment. On-site presence is required therefore regional candidates will be given preferred priority.

Candidate will be working in a team environment consisting of 5 database engineers and administrators and working directly with application developers and server support team. Excellent oral and written communications skills are required.


DAILY DUTIES / RESPONSIBILITIES:

SQL Server
Setup and maintain data replication and mirroring
Configure maintenance automation
Backup and Recovery
Troubleshoot SQL Server performance issues as they occur, including after-hours and weekends
SQL Server monitoring
Install and configure new SQL Servers
Develop and support data warehouse and cubes through SQL Server Analysis Services
Migrate SQL Server databases to SQL Server 2019
Develop Reports using SSRS
Support SSIS packages
Develop database design, development, and management standards
Consult with developers regarding database design.
Implement and support 3rd party databases for vendor supplied applications
Oracle 19: Desired
Analyze, develop, and support stored procedures and SQL.
Business Intelligence
Design, develop, and manage dashboards and reports through a BI solution
Develop and present end user training for BI solution
Develop and present developer training for BI solution

REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE):

Sql server 2012, 2014, 2016, 2019
Sql server reporting services
Sql server analysis services
Reports designer
Business intelligence tools and design.
8 - 10 years sql dba experience


PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE):

DD boost to support backup and restore operations for SQL server
Oracle 19
Business intelligence
Microsoft office
Microsoft Visio


Skills:

Category Name Required Importance Level Last Used Experience
Database Platforms backup/recovery Yes 1 Advanced Within 2 Years 6 + Years
Database Platforms failover clusters Yes 1 Advanced Within 2 Years 6 + Years
Database Platforms High-Availability Yes 1 Advanced Within 2 Years 6 + Years
Database Platforms MS SQL SERVER 2019 Yes 1 Advanced Within 2 Years 2 - 4 Years
Database Platforms Schema design including the appropriate implementation of database access security protocols into reporting program code. Yes 1 Advanced Within 2 Years 6 + Years
Database Platforms SQL Server Analysis Services ( SSAS) Yes 1 Advanced Within 2 Years 4 - 6 Years
Database Platforms SQL Server Integration Services (SSIS) Yes 1 Advanced Within 2 Years 4 - 6 Years
Database Platforms SQL Server Reporting Services (SSRS) Yes 1 Advanced Within 2 Years 4 - 6 Years
Database Platforms Strong background in database planning, scaling, and capacity planning activities Yes 1 Advanced Within 2 Years 4 - 6 Years
Database Platforms MS SQL No 1
Database Platforms Oracle19 No 1 Intermediate Within 2 Years 1 - 2 Years
Miscellaneous Business Intelligence (BI) Yes 1 Advanced Within 2 Years 6 + Years
Miscellaneous DESIGN OF COMPLEX WEB INTELLIGENCE REPORTS AND DASHBOARDS Yes 1 Advanced Within 2 Years 6 + Years

Additional Skills:

SharePoint 2010, 2013
MS System Center
DD Boost
Unstructured Data Management
Visio, MS Project














Mandatory skills:








SQL Server monitoring, SQL Server database, SQL Server 2019,
SQL Server 2012, 2014, 2016, 2019, SQL Server reporting services, SQL Server analysis services,
SSAS, SQL Server Analysis Services, SSIS, SQL Server Integration Services, SSRS, SQL Server Reporting Services,
ms system center, team foundation server, sharepoint,
data replication, data mirroring, data warehouse, data cubes,
BI, Business Intelligence, BI solution, BI tools, Web Intelligence Reports,
database design, database development, database platforms failover clusters, high availability,
Backup and Recovery, Dashboards, Reports, Stored Procedure, Reports Design, Backup and Restore,
Schema design, database access security protocols, database planning, scaling, capacity planning,
reporting services, analysis services, production support, application development, server support






VIVA USA is an equal opportunity employer and is committed to maintaining a professional working environment that is free from discrimination and unlawful harassment. The Management, contractors, and staff of VIVA USA shall respect others without regard to race, sex, religion, age, color, creed, national or ethnic origin, physical, mental or sensory disability, marital status, sexual orientation, or status as a Vietnam-era, recently separated veteran, Active war time or campaign badge veteran, Armed forces service medal veteran, or disabled veteran. Please contact us at hr@viva-it.com for any complaints, comments and suggestions.






Contact Details :

Account co-ordinator: Binodh M.T, Phone : (408) 709 3343, Email: staffing10@viva-it.com



VIVA USA INC.
3601 Algonquin Road, Suite 425
Rolling Meadows, IL 60008
staffing10@viva-it.com - http://www.viva-it.com

Keywords: Viva USA Inc., Columbia , Database Administrator - Onsite, IT / Software / Systems , Blythewood, South Carolina