Talent.com
No longer accepting applications
Database Designer

Database Designer

Simon Property GroupIndianapolis, IN, United States
19 days ago
Job description

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.