The Dufresne Group

Backend Engineer

• Plan, design, and implement complex data interfaces, transformations, and OLTP and OLAP databases
• Model, develop, and implement transactional, ETL staging, and analysis/reporting databases, data structures, and cubes to satisfy business and technical requirements
• Complete continuous improvement projects to further automate, fix issues, and increase efficiency across database, ETL, and business line processing
• Focus on SQL and PL/SQL application development using packages, store procedures, functions, triggers, and views
• Automate complex processes using SQL agent jobs, SQL Server Integration Services, etc
• Manage SQL code in a source control system
• Implement database performance monitoring and tuning
• Establish and enforce SQL development coding standards and best practices
• Lead/participate in SQL code reviews
• Train other development teams on the implementation of the code
• Write clean, fast code that is free of bloat and unnecessary overhead
• Ensure accuracy and integrity of data through the development of constraints and validation rules

Senior Database Developer – Contract