What are the responsibilities and job description for the Database Designer position at SPG Administrative Svcs. Ptr.?
Job Location:
Corporate IndianapolisPRIMARY 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.
