Database Architect

Job Location:Corporate Indianapolis

PRIMARY PURPOSE:

The Database Developer is responsible for the overall design and development of databases that underly the business applications. The primary focus will be on business intelligence applications; but will also include other business-critical applications. Working with our DBA team, application developers, business analysts, and end users to understand their needs; you will build be responsible for database design and implementation. The Database Developer will also assist in performance tuning and troubleshooting issues related to the databases.

PRINCIPAL RESPONSIBILITIES:

The successful candidate’s responsibilities will include but not be limited to:

Works with the DBA team, application developers, business analysts and end users to understand needs and recommend appropriate solutions.

Designs and implements databases including tables, views, stored procedures and other database objects.

Troubleshoots issues with data and/or performance and recommends solutions.

Serves as liaison between the application team and the DBA support team.

Complies with corporate change management processes.

Assists with data integration work.

At times, assists with ETL and/or report development.

MINIMUM QUALIFICATIONS:

7-10 years demonstrated relational database development experience (ie. Tables, views, stored procedures, queries, etc.).

5-7 years demonstrated experience designing/modeling relational and analytical databases.

5-7 years demonstrated experience designing and developing databases in a Business Intelligence/Data Warehouse environment

5-7 years designing and developing MS SQL Server databases.

Effective written, oral, and interpersonal communications.

Working knowledge of Software Development Lifecycles (waterfall, iterative, agile, etc.).

Experience with Erwin Data Modeling software

Experience with Modern Database/storage technologies (Azure, Data Lake, NoSQL, etc.) is a plus.

Experience modeling and/or writing reports in PowerBI is a plus.

Experience with ETL technologies is a plus.

Experience with IBM DB2 is a plus.

R10685