What are the responsibilities and job description for the SQL DBA position at The Timberline Group?
Responsibilities
Qualifications
- Manage and maintain SQL Server instances across various environments, ensuring high availability, security, and performance.
- Implement and support geoclustering solutions to achieve disaster recovery and business continuity objectives.
- Monitor database performance, tuning SQL queries, and optimizing database configurations for improved efficiency.
- Develop and implement automation scripts using PowerShell, Python, or similar tools to automate routine DBA tasks, deployment processes, and monitoring.
- Handle table locks and concurrency issues effectively, ensuring minimal impact on production environments.
- Plan and execute database migrations and upgrades, including transitioning on-premises databases to Azure cloud services.
- Implement and manage SQL Server AlwaysOn Availability Groups for high availability and disaster recovery.
- Utilize performance monitoring tools such as SQL Server Management Studio (SSMS), Azure Monitor, or third-party tools to proactively monitor and analyze database performance.
- Collaborate with cross-functional teams to troubleshoot database-related issues and implement solutions promptly.
- Develop and maintain documentation related to database configurations, processes, automation scripts, and procedures.
- Implement and enforce database security best practices, ensuring compliance with organizational standards and regulations.
- Participate in on-call rotations and respond to database incidents in a timely manner.
Qualifications
- Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience).
- Proven experience as a SQL Server DBA in a large-scale production environment, with a strong emphasis on operational tasks.
- In-depth knowledge of SQL Server internals, including geoclustering, table locks, and concurrency management.
- Experience in designing and implementing database backup and recovery strategies.
- Proficiency in performance tuning, query optimization, and index management.
- Hands-on experience with database migration tools and methodologies, particularly to Azure SQL Database or Azure SQL Managed Instance.
- Strong scripting skills with PowerShell, Python, or similar languages for automation of DBA tasks and deployments.
- Experience with performance monitoring tools and techniques to identify and resolve database performance issues.
- Strong understanding of database security principles and best practices.
- Excellent troubleshooting skills and the ability to resolve database issues under pressure.
- Effective communication skills and the ability to collaborate with diverse teams.
- Relevant certifications (e.g., Microsoft Certified: Azure Database Administrator Associate) would be a plus.