Application DBA-1781


Apply Now
General Information

Job Description Summary

 

The Application DBA is involved in requirements definition, design, development, deployment, maintenance and enhancement of applications working as part of data warehouse development team, with specific focus on data warehouse databases. Must be able to coordinate with Information Systems Application Groups and Vendors for SQL Server upgrades. Will be required to work with data warehouse system architects to create database designs that meet the company's business goals. Other job functions include:

 

  • Design, develop and implement database schema, Microsoft SQL Server objects ( tables, views, functions, stored procedures, etc.)

  • Follow Agile practice

  • Design, develop and deploy ETL software, primarily in SQL Server Integration Services

  • Ongoing support and maintenance of databases for data warehouse applications

  • Write and debug complex SQL and understand the best ways to incorporate database requests into application programs

  • Perform database change management, performance tuning for data warehouse

  • Write the documentation of design specifications and implementation details

  • Collaborate with other team members to develop system designs, interfaces and protocols etc.

  • Collaborate with system DBAs

  • Coordinate with Information Systems Application groups and Vendors for SQL Server upgrades

  • Manages workload to deliver quality deliverables that meet requirements and timelines

  • Assists Manager in tracking progress, prioritizing work, developing time estimates and work plans and assisting less experienced team members

  • Provide backup support for Systems DBA

     

    Qualifications

  • 4 + years of SQL Server database development experience; knowledge of software systems, infrastructures and Data Warehouse concepts and ETL development

  • Strong analysis and troubleshooting skills

  • Strong organizational skills with attention to detail a must as well as good interpersonal and time management skills required

  • Working knowledge of computer operating systems (mainly Microsoft Windows Servers )

  • Bachelor's degree in Computer Science, Information Systems and/or related fields

     

    Special Knowledge and Skills

  • Working knowledge of SQL Server Databases and T-SQL programming (at least 4 years of proven experience)

  • Strong understanding of SQL Server database security

  • Experience with SQL Server from 2000 - current preferred

  • Experience in ETL package development using Microsoft SQL Server Integration Services (SSIS)

  • Basic knowledge of Web Services

  • Basic Windows server administration experience

  • Basic Networking experience

  • Excellent written and oral communication skills

  • Knowledge of ITIL best practices is a plus

     

Apply Now