Job Id : 4694
Jobtitle : DBA
Location : Charlotte, NC
Company Name : CRG
Industry : Information Technology
Salary : $40,000 - $100,000 YEAR
Job type : Fulltime
Posted on: 2019-09-06
Required Skills : XMLA Protocol, T-SQL Coding
Benefits : No benefits are available
Job Description :
This candidate must be experienced in the deployment, administration, and configuration of SQL Server databases as well as a working knowledge of NoSQL databases.
This role will plan, coordinate, and develop databases to include database definition, structure, documentation, and requirements.
As a BI DBA, this person will formulate and monitor standards relating to database management, administration of the database servers, as well as identifying and resolving performance issues, specifically in the area of Business Intelligence.
You will need strong Dimensional Modeling experience with a solid understanding of BI-centric architecture, specifically concepts of Analytical Processing, Data Marts, and Data Cubes.
Create and maintain databases and database structures Create and document dimensional models and ERDs Design, Code, and Optimize databases with focus on high-performance data-delivery Monitor and maintain system health and security Design backup processes for server and associated data Create accounts and assign security levels Establish a disaster recovery plan Provide end-to-end technical support and problem resolutions Schedule and perform regular server and database maintenance Create database management processes and procedures Performance monitoring and troubleshooting production issues
Minimum of 5 years of experience in data specific roles to include but not limited to database administration, T-SQL coding, manipulating data sets, and data architecture
Experience with SSMS, SSRS, SSIS, and SSAS administration Experience working with and creating data architectures
Fundamental understanding of differences between transactional and dimensional database models and why they exist Strong expertise in T-SQL code development
Experience and thorough understanding of SQL execution plans and how to optimize queries for high-performance
Attention to detail with strong problem-solving skills
Working knowledge of XMLA protocol and cube technology Knowledge of cloud architecture to include AWS and Azure Excellent written and verbal communication skills for coordinating across teams
Drive to learn and master new technologies and techniques
Jobrino Los Angeles
We're searching for a seasoned, pro-level MongoDB repository administrator/architect. With
V-Soft Consulting Group Chesterbrook, PA
Core Responsibilities: Maintains hardware platforms to perform at optimum response; maintains ...
Vensoft Inc Maryland Heights, MO
Job Description: Bachelors' degree in Business, Mathematics, Computer Information Systems,...
Pioneer Consulting Services LLC Baltimore, MD
Job Description: Provide technical expertise and support in the use of DBMS. Evaluate and ...
i3 INFOTEK Long Beach, CA
Job Description: Key Qualifications: 8 + years of experience in Microsoft SQL Server ...