Randstad Database Architect in Chicago, Illinois
salary:$50 - $65 per hour
date posted:Tuesday, September 12, 2017
job type:Temp to Perm
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.
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.
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.