Help us change lives

At Exact Sciences, we're helping change how the world prevents, detects and guides treatment for cancer. We give patients and clinicians the clarity needed to make confident decisions when they matter most. Join our team to find a purpose-driven career, an inclusive culture, and robust benefits to support your life while you're working to help others.

Position Overview

The Database Developer is responsible for managing and tuning high-availability PostgreSQL databases associated with Laboratory Information Systems (LIS) and participates in cross-functional project teams developing software involving these databases. This position will participate in monitoring systems and providing proactive preventative maintenance, as well as recommendations for improvements and optimizations for current and future designs. This role will assist in developing data migrations, upgrading databases, participate in data warehousing efforts and developing suitable test plans for these changes. This person will participate in SQL development and mentoring other engineers in optimizing and writing efficient queries.

• 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.
• Excellent interpersonal skills.
• Excellent communication skills, in both oral and written English.
• Ability to collaborate with cross-functional team members.
• Uphold company mission and values through accountability, innovation, integrity, quality, and teamwork.
• Support and comply with the company's Quality Management System policies and procedures.
• Regular and reliable attendance.
• Ability to work designated schedule.
• Ability to lift up to 10 pounds for approximately 5% of a typical working day.
• Ability to work seated for approximately 90% of a typical working day. Ability to work standing for approximately 10% of a typical working day.
• Ability to work on a mobile device, tablet, or in front of a computer screen and/or perform typing for approximately 85% of a typical working day.
• Ability to travel 15% of working time away from work location, may include overnight/weekend travel.

• 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.

• 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.