SQL Server DBA

Job Title: SQL Server DBA

Location: Remote(NY/NJ)

We are looking for an experienced SQL Server DBA 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

Key Responsibilities:

• Use monitoring tools to diagnose performance opportunities and provide suggestions and feedback to developers
• Support the QA and dev teams with backups/restores of databases and instance snapshots
• Manage assigned tasks within the Jira ticket system
• Provision access to users
• Participate in weekly production code releases and hot fixes
• Manage replication jobs in data replication tool (Cloud Basic)
• Review Git pull requests that relate to data model, query, or schema changes
• Respond to ad hoc reporting requests
• Apply patches and updates
• Assist auditors in responding to internal and external audit requests
• Provide cross-functional communication and support to engineering and product teams

Requirements:

• 5 + 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.
• Experience working with government (Medicaid, Medicare) security and government policies such as ISPE, ARS, GRC.

Bonus Skills:

• MySQL, MongoDB, PBM or healthcare-based business experience preferred
• Jira, Confluence, Bitbucket, Data modelling, Replication (any),.NET, Python