Remote Database Designer

JobgetherPrior Lake, MN
3dRemote

About The Position

This position is posted by Jobgether on behalf of a partner company. We are currently looking for a Remote Database Designer. In this role, you will be pivotal in enhancing our SaaS platform's database infrastructure, ensuring it is scalable and efficient. You'll work closely with developers to create cohesive data models while addressing existing design flaws. Your contributions will help streamline our data processes and improve the overall performance and maintainability of our systems. This is a unique opportunity to impact database design and implementation in a role that encourages collaboration and innovation.

Requirements

  • 5+ years of experience in database design, data modeling, or equivalent role.
  • Strong proficiency in SQL Server (schema design, indexing strategies, constraints, T-SQL queries).
  • Proven experience normalizing databases and consolidating schemas in production environments.
  • Familiarity with data modeling tools (ER/Studio, ERwin, SQL Server Data Tools, etc.).
  • Strong understanding of relational database theory and best practices for OLTP environments.
  • Ability to collaborate with developers to translate business requirements into efficient data structures.

Responsibilities

  • Analyze current database structures to identify and resolve design flaws, redundancies, and normalization issues.
  • Redesign and refactor schemas to align with best practices for scalability, maintainability, and performance.
  • Consolidate multiple databases into logical schemas where appropriate.
  • Collaborate closely with developers to ensure application features align with the data model.
  • Define and enforce database design standards, naming conventions, and documentation practices.
  • Work with the DBA to ensure designs are operationally sound, secure, and maintainable.
  • Assist in ETL process design, reporting architecture, and data warehouse modeling.
  • Provide coverage for the DBA during planned absences, including monitoring, maintenance, and basic administrative tasks.
  • Document all schemas, relationships, and design decisions in a maintainable format.

Benefits

  • Fair and Competitive Salary
  • Flexible schedule in a hybrid or remote-work environment
  • Flexible Paid Time Off
  • Paid Parental Leave
  • Tuition Reimbursement
  • Identity Theft Protection
  • Medical, Dental, and Vision Insurance
  • 100% Company-paid Short-Term and Long-Term Disability
  • 100% Company-paid Life Insurance with additional voluntary enrollment options
  • Employee Assistance Programs including counseling with up to 6 complimentary sessions
  • Monthly Wellness (Gym Membership) Stipend
  • Health Spending Account (HSA) and Flexible Spending Account (FSA) Programs
  • 401(k) Plan with a 100% vested company match
  • Career development and growth opportunities
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service