Senior Database Administrator (6 month contract)

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.