Get your dream job within 2 days (HURRY UP)ENROLL NOW
+


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.

 

Responsibilities:

 

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

 

Required Skills:

 

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 

Recommended jobs for you

  • SQL / DBA architect - Hiring OPT CPT H1B Candidate

    Jobrino Los Angeles

    We're searching for a seasoned, pro-level MongoDB repository administrator/architect. With

    View Job
  • SQL Server DBA

    V-Soft Consulting Group Chesterbrook, PA

    Core Responsibilities: Maintains hardware platforms to perform at optimum response; maintains ...

    View Job
  • Sr. DBA - Mainframe

    Vensoft Inc Maryland Heights, MO

    Job Description: Bachelors' degree in Business, Mathematics, Computer Information Systems,...

    View Job
  • Application DBA

    Pioneer Consulting Services LLC Baltimore, MD

    Job Description: Provide technical expertise and support in the use of DBMS. Evaluate and ...

    View Job
  • SQL DBA

    i3 INFOTEK Long Beach, CA

    Job Description: Key Qualifications: 8 + years of experience in Microsoft SQL Server ...

    View Job

Thanks For Your Feedback

Attach A Resume First