Tier II DBA/BI Administrator

Maitland, Florida

Post Date: 08/28/2017 Job ID: 24825 Industry: Other Area(s)

Kavaliro is seeking a Tier II SQL Support/BI Administrator for their leading Orlando client. 

Position Description

Writes t-sql queries. Create reports in SSRS, Create and update packages in SSIS, Monitors Help desk and completes tickets.    Creates Excel Reports, Participates in the Month End Closing Process.

Summary of Responsibilities
  1. Monitor Help Desk and resolve data issues.  This is the primary responsibility of this position.
  2. Administer CSR application.
  3. Write queries.
  4. Create and update reports in Sequel Server Reporting Services.
  5. Create and update packages in Sequel Server Integrations Services.
  6. Creates and prepares Reports in Excel
  7. Participate in Month End Process.
  8. Project Quality Image.

Responsibilities
  1. Monitor Help Desk

Monitor help Desk and assigns tickets to the appropriate group. Responds to tickets in appropriate manner.
  1. Administer CSR application.  

Performs administrative task in the CRM and escalates problems to the appropriate dept.Provides CRM assistance and instruction to the field.
  1. Write queries

Write T-SQL queries to provide ad-hoc data request, reports. Knowledge of how indexes, index management, integrity checks, and statistics, are used in RDMS.
  1.   Create and update reports in Sequel Server Reporting Services

Communicates with report requestors to gather requirements and parameters for reports.Writes new reports, maintains existing reports to specifications, and researches discrepancies between reports, in SSRS. Maintains report subscriptions and data formats.
  1. Create and update packages in Sequel Server Integration Services

Writes ETL processes for packages deployed in SSIS to the production server.Perform direct ETL processes. Create export files such as Statements, Renewals, PIA letters, It’ s Time Postcards, and Village Mailers
  1. Creates and prepares Reports in Excel

Creates, updates and distributes Excel based reports
  1. Participate in Month End Process

Print, group and deliver month end reports. Exports files.  Transfers files via FTP. Download PDFs

Minimum Qualifications

Education/Experience

High School degree required, appropriate bachelor’ s degree preferred, advanced degree a plus.

Professional Certifications

None required. Desired MTA, MCSA, MCSE or MCSM 

Skills
  1. Knowledge about the RDBMS
  2. Database Tuning
  3. Sequel Server Reporting Services
  4. Sequel Server Integration Services
  5. T-SQL

 

Personal Attributes/Physical Demands
  1. Strong Time management.
  2. Demonstrate a high energy level, comfortable performing multifaceted projects in conjunction with day-to-day activities.
  3. Superior interpersonal abilities, demonstrates the ability to get along with diverse personalities and    is tactful, mature, and flexible.
  4. Shows sound judgment and good reasoning abilities. 
  5. Demonstrate strong communication and documentation skills.
  6. Resourceful, self-initiating, and well organized.
  7. Has a participative management style and advocate of team concept.
  8. Has the ability to establish credibility and be decisive but be able to recognize and support the organization’ s preferences and priorities.
  9. Results and people oriented, but have sound judgment-ability to balance other business considerations.  Service oriented, but assertive/persuasive.
  10. Ability to travel and work schedule flexibility to include availability on weekends. 
  11. Limited physical demands required.
Apply Online

Not ready to apply?

Send an email reminder to:

Share This Job:

Related Jobs: