Position is HybridDescription:The client is looking for a Database Administrator - ConsultantScope of the 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 2019 to SQL Server 2022. In addition, the 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 SharePoint, MS System Center, Team Foundation Server, and others. The 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 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.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.DAILY DUTIES / RESPONSIBILITIES:SQL ServerSetup and maintain data replication and mirroringConfigure maintenance automationBackup and RecoveryTroubleshoot SQL Server performance issues as they occur, including after-hours and weekendsSQL Server monitoringInstall and configure new SQL ServersDevelop and support data warehouse and cubes through SQL Server Analysis ServicesMigrate SQL Server databases to SQL Server 2022Develop Reports using SSRSSupport SSIS packagesDevelop database design, development, and management standardsConsult with developers regarding database design.Implement and support 3rd party databases for vendor supplied applicationsOracle 19 familiarity: DesiredAnalyze, develop, and support stored procedures and SQL.Business IntelligenceDesign, develop, and manage dashboards and reports through a BI solutionData Modeling – as assignedDesigning, developing, and maintaining logical and physical data models using ERwin Data ModelerEnsuring database designs support scalability, integrity, and performance requirements.Collaborating with data architects, developers, and business analysts to translate business requirements into data models.Modeling activities are required in Oracle databases and may be required for MS SQL databasesRequired Skills (Rank in Order of Importance):5+ years of experience with SQL Server 2019 and 20225+ years of experience with SQL Server Reporting Services5+ years of experience with SQL Server Analysis Services5+ years of experience with SQL Reports Designer5+ years of experience with BI tools and design5+ years of experience as an SQL Database Administrator2+ years of experience working with State Government AgenciesPreferred Skills (Rank in Order of Importance):Data Domain Boost (DD Boost) to support backup and restore operations for SQL ServersExperience with Oracle 19 Database OperationsExperience with Oracle Grid ControlExperience with ERwin Data ModelerRequired Education:BA in Computer Science, Data Science, or closely related field.Notes:Position is Hybrid, however remote capability is very limited and the candidate should expect to be onsite five days a week. Remote days are based off of project needs and client discretion.Work Schedule: Weekend Hours and On Call Rotation is to be expected for project needs per the discretion of the client . VIVA is an equal opportunity employer. All qualified applicants have an equal opportunity for placement, and all employees have an equal opportunity to develop on the job. This means that VIVA will not discriminate against any employee or qualified applicant on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status
Description:
The client is looking for a Database Administrator - Consultant
Scope of the 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 2019 to SQL Server 2022. In addition, the 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 SharePoint, MS System Center, Team Foundation Server, and others. The 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 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.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.DAILY DUTIES / RESPONSIBILITIES:SQL ServerSetup and maintain data replication and mirroringConfigure maintenance automationBackup and RecoveryTroubleshoot SQL Server performance issues as they occur, including after-hours and weekendsSQL Server monitoringInstall and configure new SQL ServersDevelop and support data warehouse and cubes through SQL Server Analysis ServicesMigrate SQL Server databases to SQL Server 2022Develop Reports using SSRSSupport SSIS packagesDevelop database design, development, and management standardsConsult with developers regarding database design.Implement and support 3rd party databases for vendor supplied applicationsOracle 19 familiarity: DesiredAnalyze, develop, and support stored procedures and SQL.Business IntelligenceDesign, develop, and manage dashboards and reports through a BI solutionData Modeling – as assignedDesigning, developing, and maintaining logical and physical data models using ERwin Data ModelerEnsuring database designs support scalability, integrity, and performance requirements.Collaborating with data architects, developers, and business analysts to translate business requirements into data models.Modeling activities are required in Oracle databases and may be required for MS SQL databasesRequired Skills (Rank in Order of Importance):5+ years of experience with SQL Server 2019 and 20225+ years of experience with SQL Server Reporting Services5+ years of experience with SQL Server Analysis Services5+ years of experience with SQL Reports Designer5+ years of experience with BI tools and design5+ years of experience as an SQL Database Administrator2+ years of experience working with State Government AgenciesPreferred Skills (Rank in Order of Importance):Data Domain Boost (DD Boost) to support backup and restore operations for SQL ServersExperience with Oracle 19 Database OperationsExperience with Oracle Grid ControlExperience with ERwin Data ModelerRequired Education:BA in Computer Science, Data Science, or closely related field.Notes:Position is Hybrid, however remote capability is very limited and the candidate should expect to be onsite five days a week. Remote days are based off of project needs and client discretion.Work Schedule: Weekend Hours and On Call Rotation is to be expected for project needs per the discretion of the client .
(Please ensure email matches your resume email)
(document types allowed: doc/docx/rtf/pdf/txt) (max 2MB)
By submitting this form, you are consenting to the VIVA team contacting you via Phone/Email