BI Database Administrator - Permanent - on site


Premium Job From Nigel Frank International

Recruiter

Nigel Frank International

Listed on

20th July 2022

Location

Troy

Salary/Rate

£57412 - £77916

Type

Permanent

This job has now expired please search on the home page to find live IT Jobs.

BI Database Administrator

Location: Troy, OH U.S. Citizen or Green Card Only

The BI Database Administrator is responsible for supporting and maintaining SQL Server databases including data warehouse databases. They will design, develop, and deliver database solutions including ETL. Position requires ability to administer all functions of a Microsoft SQL Server including index analysis for performance optimization, backup / restore strategies, security, troubleshooting job failures and alerts, and optimizing ETL processes. This position will interact and work extensively within the Microsoft Business Intelligence stack including the SQL Server Engine, SSIS, SSAS, SSRS & PowerBI.BI Database Administrator will provide enterprise-wide data warehouse expertise with emphasis on data design, access, usage, security, and quality of information. Responsible for developing, testing, improving, and maintaining new and existing databases to help users retrieve data effectivelyMonitor SQL Server for performance bottlenecks and recommend solutionsDiagnose and resolve data warehouse performance issues.Set and maintain database standards.Manage database access and develop processes for optimizing database security.Assist other developers, analysts, and designers in implementation of database solutions.Work with Business Intelligence Developer to create models within the data warehouse and/or changes to existing data stores.Ability to understand and implement Microsoft Database Solutions from within Azure DevOps source control.Identify data discrepancies and data quality issues, and work to ensure data consistency and integrity.The candidate will also regularly interact with the users ranging from the end user to management team to understand, document and communicate their needs, perform requirements analysis, develop, and deliver Data Models, reports, Business Intelligence, and data transformation solutions.This position requires analytical and problem-solving aptitude along with a wide range of technical development, design and multitasking skills.

Qualifications

5+ years of Database Administrator experience including 2+ years in business intelligence and data warehousing environments3 + years of experience using Microsoft SQL Server & Microsoft BI Suite like SSISStrong TSQL scripting abilitiesExperience with cloud servicesExperience in evaluating execution plans and index analysisExperience in SQL Server security.Understanding of relational and dimensional data modelingExceptional organizational skills to prioritize work and ability to balance maintenance and project workExcellent communication and interpersonal skillsAbility to work independently or as a team member.Green Card or US citizenship Desired Education/ExperiencePowerShell and Unix shell scripting skillsExperience in SSAS, SSRS & PowerBIUnderstanding and knowledge in data analytics and reporting If this role is of interest, please contact Mikala today at [email protected].

You are currently using an outdated browser.

Please consider using a modern browser such as one listed below: