Database Developer

$85,000 - $135,000/Yr

Exact Sciences - Madison, WI

Full-time - Mid Level

Hybrid - Madison, WI

Ambulatory Health Care Services

About the position

The Database Developer at Exact Sciences is responsible for managing and optimizing high-availability PostgreSQL databases associated with Laboratory Information Systems (LIS). This role involves participating in cross-functional project teams, monitoring systems, providing preventative maintenance, and recommending improvements for database performance. The position also includes developing data migrations, upgrading databases, and mentoring other engineers in SQL development. This is a hybrid role based in Madison, WI, aimed at supporting the company's mission to improve cancer prevention and treatment through data management.

Responsibilities

• Develop and proactively review performance monitoring of production PostgreSQL databases.
• Evaluate database parameters and system settings for performance and recommend improvements as databases scale.
• Participate in system capacity planning.
• Participate in database design and data modeling and provide recommendations for improvement or optimizations.
• Provide query and index optimizations.
• Participate in an agile software development life-cycle; including providing testing guidelines for database related changes.
• Provide SQL development support, evaluate query plans, and participate in query tuning.
• Mentor other engineers in developing efficient SQL queries.
• Assist in developing reports.

Requirements

• Bachelor's degree in IT or related field; or High School Degree/General Education Diploma and 4 years of relevant experience in lieu of Bachelor's degree.
• 3+ years of experience managing a production RDBMS including experience with PostgreSQL.
• 1+ years of experience with optimizing database performance through pro-active testing and ongoing real-time monitoring.
• Basic computer skills to include Internet navigation, Email usage, and word processing.
• Proficient in Microsoft Office to include Excel macros and pivot tables.
• Coursework or professional working knowledge of SQL development and database design, PostgreSQL (tuning, optimization parameters, replication techniques, and data warehouse design), DML, and DDL.
• Coursework or professional working knowledge of query planning.
• Demonstrated ability to perform the Essential Duties of the position with or without accommodation.
• Authorization to work in the United States without sponsorship.

Nice-to-haves

• Coursework or professional working knowledge with Java development stack, Hibernate and SDLC.
• Coursework or professional working knowledge with AWS cloud base database administration and Amazon RDS support.

Benefits

• Paid parental leave
• Health insurance
• Dental insurance
• Paid time off
• Vision insurance
• Retirement plan