Senior Database Administrator (6 month contract)

Job Description

We are seeking an experienced Senior Database Administrator (DBA) to oversee the administration, integrity, performance, and evolution of the databases that power our clients' Dental Practice Management Systems (DPMS) across the entire product portfolio.

This is a platform-spanning role responsible for both relational and non-relational databases, including Microsoft SQL Server, PostgreSQL, MongoDB, Azure Cosmos DB, and other modern data platforms. The ideal candidate will own database architecture, schema design, migration strategies, data governance, and performance optimization across cloud and on-premise environments.

You will work closely with Application Architects, Engineering, Infrastructure, and Cloud teams to ensure our data platforms remain scalable, secure, reliable, and aligned with business and clinical requirements. This role is particularly well-suited for someone who enjoys solving complex data challenges, modernizing legacy systems, and designing data structures that support large-scale enterprise applications.

esponsibilities

Database Architecture & Data Modeling

• Design, implement, and evolve database schemas and data structures across SQL and NoSQL platforms.
• Own data modeling strategies across relational and non-relational databases, selecting the most appropriate structures for each application and workload.
• Oversee schema design and governance for both legacy and modern systems.
• Create and maintain normalized relational models as well as denormalized and document-based data structures.
• Partner with engineering teams to translate business and clinical requirements into scalable database solutions.

Database Administration & Performance

• Administer and maintain Microsoft SQL Server, PostgreSQL, MongoDB, Azure Cosmos DB, and related database platforms.
• Monitor database health, performance, availability, backups, and disaster recovery processes.
• Perform query optimization, index maintenance, partitioning strategies, and capacity planning.
• Troubleshoot complex database issues and implement long-term solutions.
• Ensure high availability and reliability across production environments.

Data Migration & Synchronization

• Design, review, and manage schema changes, upgrades, and database migrations across multiple environments.
• Lead modernization initiatives involving long-standing legacy systems and database transformations.
• Support data synchronization and movement across heterogeneous platforms.
• Work with ETL, ELT, data gateway, and change-data-capture (CDC) processes to ensure data consistency.
• Maintain data integrity across cloud and on-premise systems.

Cloud & Security

• Collaborate with Infrastructure and Cloud teams to provision, configure, and secure database environments.
• Support cloud-hosted database services within Microsoft Azure.
• Implement database security controls, access governance, and compliance standards.
• Manage user permissions, data access controls, and audit requirements.
• Ensure proper backup, recovery, and disaster recovery procedures are maintained.

Documentation & Governance

• Create and maintain data dictionaries, schema documentation, entity relationship diagrams, and database architecture documentation.
• Establish database governance standards and best practices.
• Ensure schema changes are properly versioned, documented, and safely deployed.
• Provide technical guidance and recommendations on database strategy and architecture.

Requirements

• 5+ years of experience as a Database Administrator, Database Engineer, or Data Platform Engineer.
• Strong experience administering Microsoft SQL Server environments.
• Experience with PostgreSQL or other enterprise relational databases.
• Hands-on experience with NoSQL databases such as MongoDB, Azure Cosmos DB, or similar document/key-value stores.
• Strong expertise in relational and non-relational data modeling.
• Experience designing and governing schema changes and database migrations.
• Experience supporting legacy system modernization and database transformation projects.
• Strong SQL query optimization, indexing, and database performance tuning skills.
• Experience with ETL, ELT, data synchronization, or data movement pipelines.
• Understanding of Change Data Capture (CDC) and cross-platform data synchronization strategies.
• Experience with Microsoft Azure database services and cloud-hosted environments.
• Knowledge of backup, recovery, high availability, and disaster recovery processes.
• Strong troubleshooting and problem-solving skills.
• Excellent attention to detail and documentation skills.
• Strong written and verbal English communication skills.

Nice-to-Haves

• Experience with Azure Cosmos DB at scale.
• Experience with enterprise healthcare, healthcare technology, or regulated industries.
• Experience supporting SaaS products and cloud-native applications.
• Knowledge of data governance frameworks and compliance requirements.
• Experience with database automation and Infrastructure as Code (IaC).
• Familiarity with data warehousing and analytics platforms.
• Experience working with hybrid cloud and on-premise environments.
• Exposure to DevOps and CI/CD practices related to database deployments.

Benefits

• Work remotely Monday - Friday, 40 hours a week (no weekends)
• Health Care Reimbursement
• Active Lifestyle Reimbursement
• Quarterly Home Office Reimbursement
• Payroll Deduction Purchase Plans
• Continuous Learning Bonus
• Access to Training and Professional Development Platforms
• Did we mention it's REMOTE?!!

One of our core values at Zipdev is "Be authentic." that's why we encourage you to answer the application form in your own words; we are interested in getting to know you, not a digital assistant.

Wondering how our remote environment or our payment method work? We've put together some helpful answers in our FAQs at the bottom our our career site. Take a look and let us know if you have any other questions!