Remote Database Administrator

Description:

• Kahuna Workforce Solutions is seeking a mid-career hire as a Database Administrator focused on the design, implementation, and support of their proprietary software’s databases, Kahuna.
• The role involves bridging the gap between core human resources processes and operational development to satisfy competency assurance and development requirements.
• As a Database Administrator, you will help design, implement, monitor, and support the organization's product storage needs.
• The ideal candidate is an accountable team player who is eager to make an impact.

Requirements:

• You will manage and optimize Microsoft SQL Server 2019 databases running on Linux across multiple Azure data center regions to support SDLC environments for a multi-tenant SaaS product.
• You must implement and maintain a scalable database infrastructure, managing hundreds of databases across development, staging, and production environments.
• You should analyze and troubleshoot SQL Server performance issues using monitoring tools like Dynatrace and apply performance optimization techniques to improve database speed and efficiency.
• You will oversee schema changes and prevent schema drift across hundreds of customer databases, ensuring consistency and accuracy in automated deployments.
• You need to design and execute an effective index management and SQL job strategy, handling index fragmentation, maintenance, and optimization at scale.
• Conducting in-depth T-SQL analysis and query tuning to optimize the performance of critical database queries is essential.
• You will lead capacity planning efforts to assess the need for additional servers and proactively scale the database infrastructure to support growth in customer demand.
• Collaboration with engineering and DevOps teams to plan and schedule database jobs (e.g., backups, indexing, statistics updates, and caching) is required to ensure smooth operation with minimal downtime.
• You must develop best practices and processes for managing SQL Server jobs (reporting, caching, backups, index updates) and document approaches to ensure consistency across environments.
• Providing guidance and recommendations on SQL Server maintenance on Linux, including upgrades, backups, and disaster recovery planning is necessary.
• You will support multi-region failover strategies and high availability in an Azure environment.

Benefits:

• Kahuna Workforce Solutions offers a competitive salary and benefits package for this full-time position.
• The company provides the flexibility of a remote work option for candidates not located in Houston, Texas.
• Employees will have the opportunity to work with a leading provider of competency management software, contributing to innovative solutions that improve workforce management.
• Kahuna is committed to empowering organizations and their people with valuable, data-driven insights, fostering a competency-centric approach to talent management and development.