logo

View all jobs

SQL Engineer

St. Louis, Missouri
Skills needed:
  • Database Schemas
  • Understanding of SQL Agent Jobs
  • Data Migration experience
  • PowerShell and/or T-SQL Scripting knowledge
  • Data Conversion experience 
  • SQL and Stored Procedure tuning experience
SQL Engineer 
Must have: TSQL, SQL scripting and Data migration
  • 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.

 
The Timberline Group
Phone: 636-209-5537
623 Missouri Ave #104, Sullivan, Mo 63080
"Delivering quality solutions through quality people"

Share This Job

Powered by