Randstad Database Architect in Chicago, Illinois

Database Architect

easy apply

job details:

  • location:Chicago, IL

  • salary:$50 - $65 per hour

  • date posted:Tuesday, September 12, 2017

  • job type:Temp to Perm

  • reference:575907

easy apply

description

The Database Architect is a key leader in the design and management of transactional databases and data warehouses and the processes required to maintain and update those databases. This candidate will work closely in several different areas including Product Management, Engineering, Architecture and Operations.

  • Design database

  • Work closely with Application Architects to design database structures that properly model related business entities and relationships, providing operational flexibility and efficient query handling.

  • Design tables, determining the proper amount of referential integrity and normalization.

  • SQL support

  • Write optimized SQL code to support development.

  • Conduct SQL Server coding sessions for application developers.

  • Rewrite and tune poorly performing SQL code to improve system performance by studying execution plans and optimizing the capabilities of the DBMS.

  • Ensure that all new database code meets company standards for readability, reliability and performance

  • Develop database solutions by designing proposed system; defining database strategy, architecture, physical structure and functional capabilities

  • Maintain database documentation and relationship diagrams.

  • When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes and or index/query changes.

  • Contribute to the overall system design and operational design

  • Work with the architecture team and application developers to design and implement database strategies

  • Provide support and lead the business and technology teams in identifying the data flow associated with the business flow and guides data provisioning and data capture process optimization.

  • This Job has decision-making responsibilities up to the amount of a Database Architect level, as defined by the company.