Senior SQL DBA Data Engineer

Kforce has a client in Lenexa, KS that is looking for a Senior SQL Database Administrator (DBA)/Data Engineer.

Overview: In this dual role, the right candidate will administer, secure, and optimize the client's SQL Server database environment while designing, implementing, and managing the data architecture that supports the organization's data strategy. You will collaborate with various departments to ensure database performance, availability, and data integrity, optimize data pipelines, and drive efficient data solutions using SQL Server, Azure, and other technologies. As the industry adapts to AI, the engineer will help capitalize on the native AI capabilities in SQL Server 2025-including the vector data type, semantic (vector) search, in-database embedding generation, and external AI model integration-to build modern, AI-ready data solutions.

Responsibilities: Database Administration:

• Install, configure, upgrade, and maintain SQL Server instances across production, test, and development environments, automating patching and routine maintenance
• Implement and maintain backup, recovery, high-availability, and disaster-recovery solutions (e.g., Always On Availability Groups, clustering, and replication) to safeguard data availability and business continuity
• Monitor database health and performance, and conduct query tuning, indexing, and capacity planning to ensure optimal performance
• Manage database security, including user access, roles, permissions, and compliance with data governance standards

Data Architecture and Management:

• Design, implement, and maintain data architecture solutions-including data warehouses, databases, and data lakes-that support business objectives and data strategy
• Develop and optimize ETL processes to ensure data accuracy, quality, and reliability