Sr SQL Database Administrator

Job Description: Sr. SQL Database Administrator

Hybrid - Lake Forest, IL but remote ok

What are the top 3 skills required for this role?

1. Azure SQL Database, Azure Cosmos Db

2. DB2 (Good to have)

3. Experience in audit activities

Job Description/ Responsibilities

As a Senior Database Administrator , you will work as part of our Database Operations team to support a complex data tier based on Microsoft SQL Server. The ideal candidate for this role will have a passion for building, designing, and supporting complex and mission-critical data solutions on VM's and the Microsoft Azure cloud environment.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

Responsibilities for a Senior Database Administrator may vary, but should include:

• Work independently and take a lead role on projects with minimal supervision.

• Serve as a go-to resource for questions related to database systems.

• Identify database performance and capacity requirements by analyzing current workloads and utilizing best practices.

• Serve in an architectural capacity for database high availability and disaster recovery design.

• Support team initiatives by developing tools and identifying opportunities for process automation.

• Support and build automated environment installation and setup processes.

• Interact positively with customers to support processes critical to business operations.

• Monitor and troubleshoot database instances, perform root-cause analysis, identify opportunities for improved system performance, and assist development teams with implementation.

• Work closely with System Administration team to support infrastructure enhancements and maintenance.

• Participate in production support on-call rotation to triage and resolve critical issues outside of business hours.

• Drive vulnerability remediation.

• Create and manage database standards.

REQUIRED SKILLS:

• Ability to develop and grow interpersonal relationship within and across teams

• Expert knowledge of common database administration tasks such as backup & restore, recovery models, integrity checks, and replication methods.

• Experience automating SQL Server administration tasks and workflows at scale.

• Experience with SQL Server High Availability & Disaster Recovery features.

• Familiarity with modern SQL Server data protection and security features.

• Firm understanding of the most prominent Azure database technologies such as Azure SQL Database.

• Fundamental knowledge of T-SQL code is required, strong expertise in this area is a bonus.

• In-depth knowledge of deploying and supporting SQL transactional replication.

• Experience with Azure SQL Database and Azure SQL Managed Instance

Desired SKILLS

• Experience with Azure Cosmos Db

• Experience with common tools utilized in our environment such as SQL Backup, Git, ServiceNow, Foglight, and Spotlight.

• Good to have DB2 skills

Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.