Database Developer

Help us change lives

At Exact Sciences, we're helpingchange 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.

This is a hybrid position based out of our Madison, WI office location.

Essential Duties

Include but are not limited to the following:

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

Minimum Qualifications

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

Preferred Qualifications

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

Salary Range:

Exact Sciences is proud to offer an employee experience that includes paid time off (including days for vacation, holidays, volunteering, and personal time), paid leave for parents and caregivers, a retirement savings plan, wellness support, and health benefits including medical, prescription drug, dental, and vision coverage. Learn more about our benefits.

Our success relies on the experiences and perspectives of a diverse team, and Exact Sciences fosters a culture where all employees can develop personally and professionally with a sense of respect and belonging. If you require an accommodation, please contact us here.

Not ready to apply? Join our talent community and stay up to date on what's new at Exact Sciences.

We are an equal employment opportunity employer. All qualified applicants will receive consideration for employment without regard to age, color, creed, disability, gender identity, national origin, protected veteran status, race, religion, sex, sexual orientation, and any other status protected by applicable local, state, or federal law. Any applicant or employee may request to view applicable portions of the company's affirmative action program.

To view the Right to Work, E-Verify Employer, and Pay Transparency notices and Federal, Federal Contractor, and State employment law posters, visit our compliance hub. The documents summarize important details of the law and provide key points that you have a right to know.