Description

This position provides data support to the APD Info Systems team which is responsible for high level analytics, information technology integration, data 
systems development and maintenance and development and oversight of our Business Intelligence system using MicroStrategy. This role also works directly with customers outside of the team.

This position will also be writing Extraction, Transform and Load (ETL) or SSIS tasks for the ETL process.

Skills and responsibilities

1. Design, analyze, troubleshoot and resolve advanced operational and performance related database issues, coordinate changes, and maintain database structures, and assist in developing policies and procedures designed to ensure the integrity of the database environment

2. Design, coordinate, implement, and determine procedures necessary to save and recover production databases, and to recover databases from hardware and software failure

3. Perform database performance monitoring and auditing, implement efficiency improvements, and modify existing databases and database management systems

4. Design, configure and implement database network connectivity working with required technical teams.

5. Monitor capacity versus utilization and recommends appropriate action on a timely basis to avoid performance degradation

6. Create databases and database objects, such as tables, indexes, views, triggers, and stored procedures

7. Track database assets and critical information about those assets

8. Assist in development of data security standards to ensure data integrity data security 

9. Maintain data standards, prepare and develop database documentation, procedures, and definitions for data dictionaries

10. Create test database environment for applications section, including the creation of necessary libraries and procedures

11. Install new software releases and/or upgrades including researching, testing and implementing new technology

Details

  • Location:
    Austin
    ,
    TX
    This position requires a criminal background investigation.
  • Salary:
    $75,000.00
    -
    $99,200.00
    yearly
  • Deadline:
    2018-08-15

Qualifications

Minimum qualifications

Graduation with a Bachelor’s degree from an accredited college or university with major course work in a field related to the job, plus four (4)  years of experience in a related field.

Experience may substitute for education for up to four (4) years.

Preferred qualifications

• Oracle DBA Experience; SQL DBA Experience.
• Business Intelligence Applications experience using MicroStrategy.
• Experience in Data Analysis, Data Modeling, Data Integration and Data Warehousing.
• Experience with ETL (Extraction, Transform and Load) operations and fact tables.