Epsilon - Naperville, IL

posted 5 months ago

Full-time - Senior
Naperville, IL
5,001-10,000 employees
Professional, Scientific, and Technical Services

About the position

The Lead Database Developer position at Epsilon is a critical role responsible for the architecture, development, implementation, and maintenance of SQL Server-based applications and components specifically tailored for the automotive marketing platform. The ideal candidate will possess a robust background in database architecture and a proven track record in SQL programming and database development. This includes comprehensive experience in analysis, design, development, implementation, testing, maintenance, and quality assurance of database systems. In this role, you will be tasked with collaborating closely with developers, project managers, business analysts, and business users to conceptualize, estimate, and develop new software applications and enhancements. You will assist in defining, developing, and documenting the software's objectives, business requirements, deliverables, and specifications in collaboration with internal users and departments. Additionally, you will be responsible for developing technical documentation that outlines the system components, development environment, and implementation strategies. Your responsibilities will also include preparing and dispensing user stories, providing guidance, and reviewing the work of other team members. You will work alongside the QA team to define test cases, metrics, and resolve any questions regarding test results. Furthermore, you will recommend improvements to business process flows and communicate problem resolution processes to project management effectively. As a Lead Database Developer, you will develop and implement solutions in accordance with established policies and procedures, facilitate the design and implementation process for new products/projects, and keep senior executives informed of alternatives. You will analyze user requests and assist with design activities while providing in-depth technical knowledge to the team. Your role will also involve working closely with the QA team to identify and implement appropriate manual and automated functional tests, advising and mentoring team members, and fulfilling administrative duties as defined by the support process. In addition, you will collaborate with cross-functional teams during crises to address and resolve complex incidents and problems, assess, analyze, and resolve cross-functional issues, and identify potential areas for improvement in existing policies and procedures. Finally, you will develop metrics to assess and improve the quality and effectiveness of the development team.

Responsibilities

  • Responsible for the architecture, design, development and maintenance of SQL Server based applications and components for a large-scale enterprise application.
  • Collaborate with developers, project managers, business analysts and business users in conceptualizing, estimating and developing new software applications and enhancements.
  • Assist in the definition, development, and documentation of the software's objectives, business requirements, deliverables, and specifications in collaboration with internal users and departments.
  • Develop technical documentation to define the system components, development environment and implementation planning/strategies.
  • Prepare and dispense user stories, provide guidance, and review the work of other team members.
  • Collaborate with the QA team to define test cases, metrics, and resolve questions about test results.
  • Recommend business process flow improvements and clearly communicate problem/resolution process to project management.
  • Develop and implement solutions in accordance with policies and procedures.
  • Facilitate the design and implementation process for new products/projects, informing senior executives of alternatives.
  • Analyze user requests and assist with design activities.
  • Provide in-depth and strong technical specialty and knowledge to the team.
  • Work closely with the QA team to identify and implement appropriate manual and automated functional tests.
  • Advise and mentor team members in specialized technical areas as well as fulfill administrative duties as defined by the support process.
  • Work with cross-functional teams during crisis to address and resolve complex incidents and problems in addition to assessment, analysis, and resolution of cross-functional issues.
  • Recognizes and identifies potential areas where existing policies and procedures associated with support requires improvement and helps in the process improvement activity.
  • Develop Metrics to Assess & Improve quality and effectiveness of the development team.

Requirements

  • Bachelor's degree in Computer Science or equivalent engineering.
  • 8+ years enterprise level relational database experience with SQL Server in large scale enterprise application environment.
  • At least 3 years of hands-on SQL Server performance tuning, indexing and optimization.
  • Deep hands-on experience in SQL Server database architecture, design, and development, including ER Diagrams, data warehousing and schema design.
  • Expertise, strong specialization or substantial project work in SQL, API / Stored Procedure design, Relational Database design, Linux and Windows Shell scripting.
  • Proficient understanding of distributed computing and scalability principles.
  • Expertise in data structures, algorithms, and techniques to tune software for maximum performance.
  • Experienced with ETL tools including Informatica, Pentaho PDI along with some exposure to Change Data Capture tools such as HVR or Oracle Golden Gate.
  • Data integration using SQL Server Integration Services or equivalent.
  • Experience with data security, PII rules and legislation including GDRP and CCPA.
  • Experience with Oracle, PostgreSQL, or MySQL experience highly desirable.
  • Experience with database scaling including logical and physical partitioning, database sharing and high availability.
  • Experience in using design patterns, distributed paradigms, modeling techniques such as UML.
  • Experience leading development teams and providing technical direction and leadership.
  • Experience with Agile/Scrum.
  • Outstanding communication skills and the ability to work well within agile scrum environment and within tight deadlines.

Nice-to-haves

  • Preferred experience in cloud data management and automation technologies using AWS, Google or Azure.

Benefits

  • Competitive pay
  • Comprehensive health coverage
  • Endless opportunities to advance your career
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service