Register
Recruit Create CV
Unfortunately, this job posting is expired.
Don't worry, we can still help! Below, please find related information to help you with your job search.
Related keywords
Some similar recruitments
Sql Database Administrator Jobs
Recruited by Progilisys Solutions 9 months ago Address Phoenix, AZ, United States
Database Developer - Sql
Recruited by Humana 11 months ago Address , Phoenix, 85050, Az

Database Technician (Sql) Jobs

Company

Subscribe
Address Arizona, United States
Employment type FULL_TIME
Salary
Category Telecommunications
Expires 2023-08-18
Posted at 9 months ago
Job Description

The Database Technician is responsible to for the ongoing support of existing Microsoft SQL Server Integration Services (SSIS) projects and the creation of new SSIS import routines, as well as Microsoft SQL Server Reporting Services (SSRS) reports.

Essential Duties and Responsibilities:

  1. Ensure that scheduled/automated SSIS projects are running successfully per defined schedules.
  2. Manually process and import data files on both a regular and ad-hoc basis. This may require modification (clean up) of source files provided in Excel or CSV formats that fail pre-import validation.
  3. Troubleshoot SSIS failures when they occur, making changes to project definitions and/or source data to address the immediate business need, as well as any other changes necessary to restore the automated solution.
  4. Create new SSIS import routines based on defined scope of work. In most cases, new routines are variations on existing routines, with modifications based on source data or other requirements.
  5. Modify existing (and create new) SSRS reports to support business unit managers as well as customers. Create new and modify existing SSRS report subscriptions, as requested.
  6. Troubleshoot SSRS failures when they occur, making changes to report definitions and/or source data to address the immediate business need as well as any other changes necessary.
  7. Perform ad-hoc database queries to locate requested data and/or generate one-time reports, on as needed basis.

Required Skills:

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed are representative of the knowledge, skill, and/or ability required:


  • Functional knowledge of Microsoft SQL Server (2008/2012/2014), including SQL data types, table definitions, stored procedures, TSQL queries, SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
  • Associates or bachelor’s degree in Computer Science, MIS or related field, or an equivalent combination of education and/or a minimum one year of professional experience.
  • Ability to blend creativity, problem solving, and technical skills to support business needs.
  • A desire and capability to learn, maintaining a positive and constructive attitude.