Sign upLog in
See more jobs

SQL Dba

The Timberline Group

  • Saint Louis, Missouri
  • 30+ days ago

    Highlights

    Utilize performance monitoring tools such as SQL Server Management Studio (SSMS), Azure Monitor, or third-party tools to proactively monitor and analyze database performance. Develop and implement automation scripts using PowerShell, Python, or similar tools to automate routine DBA tasks, deployment processes, and monitoring.

    Numbers & Facts

    LocationSaint Louis, Missouri

    Description

    Responsibilities
    • 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.

    Similar Jobs