Database Administrator Job at Advantage Tech, Kansas City, MO

bVpCTVRYZ2FJb1ZVZmgycThmeVNiWVA3SWc9PQ==
  • Advantage Tech
  • Kansas City, MO

Job Description

Advantage Tech is searching for an Database Administrator to join their client's team in Kansas City, MO.

Job Summary:

We are seeking an experienced Microsoft Database Administrator (DBA) to join our team. The ideal candidate will have over 7 years of experience in managing, optimizing, and securing Microsoft SQL Server databases. This role requires a deep understanding of database architecture, performance tuning, disaster recovery, and automation. The DBA will collaborate with developers, system administrators, and business analysts to ensure the availability, reliability, and security of enterprise database systems.

Key Responsibilities:

  • Install, configure, and maintain Microsoft SQL Server (2016, 2019, and later versions) in on-premise and cloud environments.
  • Monitor and optimize database performance, tuning queries, indexes, and execution plans.
  • Implement backup, recovery, and disaster recovery strategies to ensure business continuity.
  • Manage and optimize database security, user access, and role-based permissions.
  • Design and implement high-availability solutions such as clustering, mirroring, and replication.
  • Develop and maintain T-SQL scripts, stored procedures, functions, and triggers to support application requirements.
  • Automate administrative tasks using PowerShell, SQL Server Agent, or other scripting tools.
  • Conduct database patching, updates, and migrations to ensure compliance with security and industry standards.
  • Troubleshoot and resolve database performance issues, locks, deadlocks, and connectivity problems.
  • Work closely with developers and system engineers to optimize database-driven applications.
  • Implement and maintain data integrity, indexing strategies, and normalization techniques.
  • Stay up-to-date with industry best practices and emerging technologies in SQL Server administration and cloud database solutions.

Required Qualifications:

  • 7+ years of hands-on experience with Microsoft SQL Server (2016, 2019, and newer).
  • Strong expertise in database performance tuning, indexing, and query optimization.
  • Experience with backup and disaster recovery strategies, including Always On Availability Groups.
  • Knowledge of cloud-based SQL solutions (Azure SQL Database, AWS RDS for SQL Server, etc.).
  • Proficiency in T-SQL development including writing and debugging stored procedures, views, and triggers.
  • Hands-on experience with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
  • Experience with PowerShell scripting and SQL Server automation.
  • Familiarity with data security best practices, encryption, and compliance standards (GDPR, HIPAA, SOX, etc.).
  • Understanding of NoSQL, Big Data, or other emerging database technologies is a plus.
  • Strong problem-solving and analytical skills with the ability to troubleshoot complex database issues.
  • Excellent communication and collaboration skills.

Preferred Qualifications:

  • Microsoft certifications such as MCSA: SQL Server, MCSE: Data Management and Analytics, or Azure Database Administrator Associate.
  • Experience working with DevOps methodologies and CI/CD pipelines for database deployments.
  • Knowledge of other database systems such as Oracle, MySQL, or PostgreSQL is a plus.
  • Experience with AI-driven database optimization and monitoring tools.

Job Tags

Similar Jobs

Konviere Corporation

Live Chat Operator Job at Konviere Corporation

A Chat Operator will play a crucial role in providing exceptional customer support and assistance through chat-based interactions. Your excellent...  ...the ability to think quickly and rationally. Ability to work independently and as part of a team in a fast-paced... 

Pacific Rail Services

Train Conductor Job at Pacific Rail Services

 ...PRS Auto is hiring immediately for a Railroad Conductor & Engineer to join our team at the Union Pacific Houston, TX Auto Terminal!...  ...of rail cars that will facilitate the loading and unloading of trains in the rail yard. Various shifts available both day and night... 

TYR Sport

Product Assistant, Footwear Job at TYR Sport

Summary: The Product Assistants primary responsibility is to support the end-to-end development process to produce best-in-class footwear. This role is responsible for overseeing and assisting product management from initial design concept to final production while remaining...

Caring Senior Service

Immediate Hiring - Part Time Caregiver Job at Caring Senior Service

 ...Caring Senior Service of Kerrville is now hiring experienced Caregivers and CNAs with Weekend Availability! Join Caring Senior Service...  ...We value and celebrate your contributions. ~ Paid Holidays & Time Off: Enjoy work-life balance with paid time off. ~1:1... 

EXL

Redshift Database Administrator Job at EXL

 .... Job Description: Role Overview: Redshift Database Administrator responsible and working on various key data systems and services...  ...emphasis on Linux and Windows systems Experience with OS-level scripting environment such as KSH shell., PowerShell...