SQL Engineer

St. Louis, MO - USA

Monthly Salary: Not Disclosed

Posted on: 9 days ago

Vacancies: 1 Vacancy

Job Summary

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

Bachelors 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:

PO Box 385LebanonMO65536

Delivering quality solutions through quality people

Required Experience:

Skills needed:Database SchemasUnderstanding of SQL Agent JobsData Migration experiencePowerShell and/or T-SQL Scripting knowledgeData Conversion experienceSQL and Stored Procedure tuning experienceSQL EngineerMust have:TSQL SQL scripting and Data migrationManage and maintain SQL Server instances acr...

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

Bachelors 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.