Sr. SQL DBA

Levi, Ray & Shoup - Kansas City, MO

Full-time - Mid Level

Kansas City, MO

Professional, Scientific, and Technical Services

About the position

The Sr. SQL DBA position at LRS Consulting Services involves managing and optimizing SQL Server environments to ensure the availability and performance of corporate applications. This role combines technical expertise with strong communication skills, requiring the DBA to collaborate with application development and infrastructure teams to meet business objectives while maintaining high reliability and performance of production databases.

Responsibilities

• Installs, administers, and maintains SQL Server environments.
• Monitors performance, tunes and optimizes current SQL Server environments to ensure availability, integrity, security, and reliability of data.
• Reviews and recommends improvements to existing data server architecture.
• Monitors and manages users and applications data access across multiple environments.
• Develops, maintains, and tests SQL Server backups and disaster recovery procedures.
• Implements and maintains capacity planning procedures for SQL Server environments.
• Able to deploy packages and troubleshoot issues with SSIS packages.
• Able to deploy RDLs and troubleshoot issues with SSRS.
• Maintains SQL Database compliance with versioning and security patches.
• Robust knowledge of SQL Server backups, recovery, and user security.
• Knowledge of TDE Encryption implementation and maintenance.
• Researches and evaluates hardware and/or software.
• Optimizes current SQL processes.
• Provides day-to-day support for SQL Server environments.
• Provides Change Management support, including reviewing/approving and implementing changes that affect databases.
• Maintains database instances across multiple operating environments.
• Develops and tests database migration procedures.
• Establishes database procedures and standards; assists in database and data related process design.
• Documents data related processes and data server's technical configurations.
• Performs other related duties as assigned and required.

Requirements

• Bachelor's Degree (experience can be in lieu of degree)
• 7 or more years of experience in database administration

Nice-to-haves

• Azure
• Any DBA/ SQL Certifications

Benefits

• Flexible work schedule with remote options
• Collaborative in-office environment