SQL Engineer

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.

SQL (Structured Query Language), Database Technology, SQL (Structured Query Language), Data Migration, Scripting (Scripting Languages), Windows PowerShell, Microsoft Transact-SQL (T-SQL), Stored Procedures, Microsoft SQL Server, High Availability, * 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.