Compensation Overview

Summary:

We are looking for an experienced Database Architect with management experience to support our production and non-production environments. The role provides day-to-day database support for .NET (LINQ/Entity Framework) applications using SQL Server running primarily on AWS RDS. SQL Server constitutes 95% of our database environment but we do support other platforms. We also support RDS instances and VMs running Postgres, MySQL, and MongoDB. We are a 24/7/365 organization, and this role requires participation in an on-call rotation. This role will be driving day to day work with a strategic view.

Essential Duties and Responsibilities:

• Responsible for Relational databases (SQL Server, MySQL, etc.) and No-SQL databases (MongoDB Atlas).
• Lead the design, implementation, and maintenance of database architectures including data migrations, data replication and data management.
• Develop and maintain intelligent and robust automation for routine database tasks.
• Manage teamwork via Jira ticket system.
• Ensure high availability of critical databases, including failover, redundancy mechanisms and data replication (CloudBasic used).
• Ensure databases meet organizational requirements, including performance, scalability, security, and availability.
• Analyze and optimize database performance, including query optimization, indexing, and storage management.
• Oversee the installation, configuration, upgrading, and patching of database servers.
• Ensure data integrity, backup, and recovery processes are in place and effective.
• Support the QA and dev teams with lower environment refreshes.
• Lead the resolution of database-related incidents and issues.
• Collaborate with application development teams, system administrators, and other stakeholders.
• Monitor and forecast database growth and capacity requirements.
• Responsible for optimal developer queries and good database design via support and code approvals.
• Assist auditors to respond to internal and external audit requests.
• Participate in bi-weekly production code releases and hot fixes.
• Participate in a weekly rotation for on-call support for critical business impacting issues outside of what the DBA NOC can triage.
• Implement and maintain database monitoring tools and dashboards.

Requirements:

• 10+ years of experience as a production support SQL Server DBA, preferably in an AWS or GCP environment, or in other cloud environments (or related data systems experience).
• Proficient with TSQL, DML, DDL, SSMS.
• Strong troubleshooting and debugging skills.
• Must understand how to interpret a query plan, have deep knowledge of indexes and statistics.
• Able to respond to calls within the SLA when on-call.
• Able to import/export data using common SQL Server tools such as BCP, SSIS or Powershell.
• Proficient with Powershell (particularly dbatools) and a working knowledge of Bash.
• Experience with source control systems such as Git, TFS, SVN
• Passion for embracing and learning new technologies.
• Experience with High Availability techniques to ensure maximum uptime when adding indexes, modifying large amounts of data, patching, and re-sizing instances.

Bonus Skills:

• MySQL
• MongoDB
• PBM or Healthcare based business experience preferred.
• Jira, Confluence, Bit Bucket
• Data modeling
• Replication (any)
• .NET
• Python

Salary: 150,000 - 180,000