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

Mastech Digital

Incident Problem Manager Job at Mastech Digital

 ...Role: Problem Manager Location: 3 days on site in Reston VA or Plano TX Duration: multiyear capped at 2-year tenure limit...  ...Facilitate root cause analysis investigation of technology incidents, develop roadmap / strategy to permanently fixes to those causes... 

Ashland Hills Hotel

Join the Ashland Hills Team as a Banquet Server! Job at Ashland Hills Hotel

 ...About the Role: Seasonal Banquet Server The Banquet Server plays a crucial role in ensuring that events hosted at Ashland Hills F&B are executed flawlessly, providing an exceptional dining experience for guests. This position involves setting up banquet rooms, serving... 

2.7 August Apparel, Inc.

Fashion Design Assistant Job at 2.7 August Apparel, Inc.

 ...Job Description The Fashion Design Assistant is vital in supporting the design team in creating...  ..., preparing design documents, data entry, and managing design achieves. Assist...  ...desire to learn and grown in a fast-paced environment. High level of creativity... 

Alchemy Global Talent Solutions

CDL A Truck Driver (OTR) Job at Alchemy Global Talent Solutions

 ...Shipping and Storage company who are looking for a CDL Shuttle Driver to join their dynamic team in Dallas. A clean driving record...  ...packing art for various transport and manage inventory. Vehicle Operation, drive the company vehicles with CDL, comply with regulations.... 

China Global Connections

Psychology Teacher 心理老师 Job at China Global Connections

 ..., 15-20k Job responsibilitiesTeach the subject of Psychology to high school students and ensuring an engaging and enriching learning experiencePreparing lessons and lectures, tutoring techniques...