Database Administrator
New
M
Medical Review Institute of America (MRIoA)Healthcare technology
Source API remote eligibility restrictions: United StatesFull-TimeSenior
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Experience
- 5+ years as a SQL Server DBA supporting business-critical production systems; 2+ years administering and designing databases in Microsoft Azure.
- Required Skills
- PythonMicrosoft AzureMicrosoft SQL ServerMongoDB
Requirements
- Bring 5+ years of experience as a SQL Server DBA supporting business-critical production systems.
- Bring 2+ years administering and designing databases in Microsoft Azure.
- Have led or played a key role in at least one database migration.
- Demonstrate expert SQL Server administration and T-SQL skills, including performance tuning, indexing, and query plan analysis.
- Have strong OLTP and analytical data modeling and database design skills.
- Have deep knowledge of Azure database services, including security, networking, high availability, and cost; familiarity with Google Cloud data services.
- Understand database security, encryption, and auditing, including PHI/HIPAA protection, Entra ID, Key Vault, and Defender for SQL.
- Have working knowledge of NoSQL and document databases, such as Cosmos DB or MongoDB, including data modeling, partitioning, and consistency.
- Use PowerShell and Python scripting and source control or CI/CD tools for database changes, such as Git, Azure DevOps, SSDT, or Flyway.
- Hold a bachelor's degree in computer science, information systems, or a related field, or have equivalent education and experience.
- Support development, QA, and BI teams in an Agile SDLC and formal change-management environment.
- Production experience with a NoSQL/document database, healthcare or regulated-environment experience, and Microsoft Fabric experience are preferred.
- Preferred certifications include DP-300, AZ-305, Google Professional Cloud Database Engineer, DP-700/DP-600 or Snowflake/Databricks equivalents, Security+, or ITIL Foundation.
- Participate in an on-call rotation and occasional after-hours or weekend work for maintenance, migrations, and incidents.
Responsibilities
- Administer, patch, secure, and support on-premises SQL Server, including SQL Agent, SSIS, and linked servers.
- Inventory databases, dependencies, and data flows to sequence migrations, then decommission servers after workloads move.
- Lead the design of Azure transactional database environments, including tiers, sizing, high availability, networking, and security.
- Oversee on-premises-to-Azure migrations from assessment through cutover, validation, and rollback, while managing consumption and cost.
- Support database workloads across cloud platforms, including Cloud SQL, BigQuery, and PostgreSQL, and advise on migration to Microsoft Fabric.
- Administer NoSQL and document databases such as Azure Cosmos DB and MongoDB, including partitioning, indexing, consistency, throughput, cost, and recovery.
- Maintain monitoring, alerting, health checks, and performance baselines; tune queries and indexes and lead root cause analysis.
- Configure auditing for Information Security's SIEM and design and test backup, high availability, and disaster recovery to RPO/RTO targets.
- Partner with development, QA, and BI teams on data modeling, schema design, query patterns, database code reviews, and testing standards.
- Manage database change control and deployments across environments; establish standards, runbooks, and documentation, and automate routine tasks.
View Full Description & ApplyYou'll be redirected to the employer's site