Developer DBA (Southwest - Denver, CO)

Developer DBA - Denver, COMortgage Cadence, a wholly-owned subsidiary of Client, has been partnering with mortgage lenders since 1999, offering the industry's only true one-stop shop mortgage technology solutions designed for point-of-sale through post-closing. In a time when efficiency, speed and the customer experience are paramount to the success of lenders, Mortgage Cadence offers the most reliable software and dedicated people, supporting lenders every step of the way. Each of our products has revolutionized the mortgage lending process in some way, changing the way lenders lend and borrowers finance. As a software company, we think like a start-up, with every employee empowered and encouraged to be visionary. Teamwork and innovation define what we do as we take our customers into the future by providing the last lending solution they will ever need.The Data Architect would have operational experience in addition to experience owning the development and improvements to the data model for our core loan origination software. Duties would include assisting with the evolution of the data model, implementing a modern process for managing and validating requested schema changes and employing best practices for both process and schema. This role team will sit between the Development team and the Operational DBA team to solidify the relationship between the two teams and drive accountability for process, best practices, and stability. Additionally this role will need to look at tuning and performance improvements to their production systems from a development perspective.Qualifications:Minimum of 4 years of experience of database code schema management including best practicesMinimum 4 years of experience with management tools i.e. Visual Studio Database Projects, Red Gate SQL Toolbelt, etc.TSQL AnalysisMinimum 2 years rewriting poorly written queries to follow the database architecture designMinimum 2 years of database tuning Indexes, fragmentation, DMVs long running queries and execution plan analysis DMVs Analysis for performance and platform improvementsBachelor's Degree or equivalent work experience (12 years) or an Associate's Degree with 6 years of experience. Exceptions will be considered.Additional Preferred Skill Requirements:Developer Tools Visual Studio, API Management, etc.Database log analysisMonitoring ToolsDatabase Infrastructure TopologyDB Synchronization Replication, AlwaysOn, etc.Works well in complex environments