Sr. Database Developer
Current. Great West Financial - Sr Database Software Engineer 1/15 – 10/16• Core development for Autosuite Rule deferral logic includingo Participant Deferral Validationo Tier rule and Combined limit monitoringo Payroll Calendar extrapolation routineo Plan to Plan Transfero Employer Match Exchange (PERL)• Production and UAT support maintenance TGB Enterprises – Web Development 7/13 – 1/14• Responsible for maintenance and design of multiple custom websites• Coordinate Reseller web services• PHP/MySQL platform• CS4 Technologies including Dreamweaver, Flash and Fireworks Promontory Financial Group – Database Developer 11/12 – 01/13• Contract position through Robert Half Technologies• Developed MSSQL 2008 R2 T-SQL stored procedures (~500) to verify Bank Foreclosure Exceptions for over 9000 government regulations.• Query Analysis to index Database creating clustered, non-clustered and compound indexes on 75+ tables for stored procedures.• T-SQL Code inspection and analysis.• Worked in a team of five in an agile atmosphere.• Created Feature Test Plan SpectraLogic Inc. - Database Developer/Administrator 09/10 – 08/12• Install MSSQL 2008 R2 Server. Configure users, SQL Agent, Backup strategy, DB BU and recovery in support of ~15 database instances on multiple MS server and VM.• ERPLN/BAAN IV – Administration of users, jobs, roles, upload data exchange schemes, MSSQL CSV uploads. Migration from Baan IV to ERPLN.• Developed Accounting Support Services Software.• Developed and maintained large number of Stored Procedures, views, functions and all DBMS functionality