SQL Server DBA

• Responsible for a wide range of daily operational tasks critical to maintaining the health and performance of over 100 SQL Server databases across 102 servers.
• Activities included monitoring system resources and identifying expensive queries, reviewing SQL Server and Windows logs for anomalies, and managing scheduled jobs and notifications.
• The role involved troubleshooting SSRS reporting issues, performing real-time problem resolution, managing user permissions, and supporting data migrations and upgrades from legacy SQL Server versions.
• The DBA also conducted performance tuning, index analysis, and space management based on alerts, while collaborating with various teams on ETL processes, SSIS package updates, and application support.
• Security responsibilities included implementing access controls and ensuring data protection for applications.
• Additionally, the DBA supported development efforts by assisting with schema refinement, query optimization, and pre-production code reviews, while actively participating in project meetings and knowledge transfer sessions.

• 8+ years of SQL Server Administration: Extensive experience managing large-scale SQL Server environments, including installation, configuration, and version upgrades (e.g., SQL Server 2012/2016/2019).
• 8+ years of Database Performance Monitoring & Tuning: Proven ability to monitor system health (CPU, memory, I/O), analyze slow-running queries, and optimize indexes, statistics, and query execution plans.
• 8+ years of Backup & Recovery: Deep knowledge of backup strategies, disaster recovery planning, and restoration processes using native SQL Server tools and cloud-based platforms (e.g., Azure SQL).
• 8+ years of Security & Access Control: Experience implementing role-based access, user authentication, encryption, and compliance with data protection standards.
• 8+ years of ETL & SSIS Development: Strong background in managing and modernizing SSIS packages, supporting ETL workflows, and assisting developers with schema refinement and query tuning.
• 8+ years of Job Scheduling & Automation: Skilled in creating and managing SQL Server Agent jobs, Notification Services, and automating routine maintenance tasks.
• 8+ years of Log Analysis & Troubleshooting: Ability to interpret SQL Server, Windows system, application, and security logs to identify and resolve issues proactively.
• 8+ years of Index & Storage Management: Experience conducting full index analysis, managing space utilization, and resolving storage-related alerts and bottlenecks.
• 8+ years of Migration & Upgrade Projects: Hands-on experience planning and executing database migrations across environments and SQL Server versions, including dev/test/prod stacks.
• 8+ years of SSRS & Reporting Services: Familiarity with configuring and troubleshooting SSRS environments to support reporting needs across teams.
• 8+ years of Collaboration & Knowledge Transfer: Demonstrated ability to work cross-functionally with infrastructure, application, and security teams, and to document and share knowledge effectively.
• 8 + years of Cloud Integration: Experience with Azure SQL, including BacPac file generation, cloud restoration, and hybrid environment support.

• Competitive compensation and benefits, including health, dental, vision, life, accident, and disability insurance.
• Great work-life balance.
• Work on high profile projects.

This is a contract opportunity based in Austin, TX and no sponsorship can be provided. Luna Data Solutions, Inc. provides equal employment opportunities to all employees. All applicants will be considered for employment and prohibits discrimination and harassment of any type without regard to age, race, color, religion, sexual orientation, gender identity, sex, national origin, genetics, protected veteran status, and/or disability status.