Job Description :
Interview: Phone and Skype to hire
Years of work experience: 10+ year(s)
Job Description:
The profile we are looking for is for a SQL DBA with strong azure cloud knowledge. Some of the key skills we need are:
experience
Azure DevOps Experiencia (pipelines, deployments, etc)
Hybrid cloud (Azure + on Prem)
Azure portal knowledge
SQL Tuning
SSIS knowledge
Lead requirements gathering, analysis and solution development for Database Administration and migration projects
Lead projects, remotely, in a hands-on role driving database, cloud migration/adoption from inception to production
Partner with project teams, functional architects, systems specialists, and other technical resources and customers
Design and implement relational database models
Apply expertise in Microsoft SQL Server internals, optimizer, and tools
Administer large, high-volume production database environments
Optimize performance
Ensure cross-platform schema synchronization
Perform regular log reviews and health checks
Diagnose and correct errors
Basic Qualifications
BS in CS or equivalent work experience.
Experience leading cloud migration projects from MS SQL Server to Azure SQL
8+ years'' experience in SQL Server architecture and Production Support DBA.
Current knowledge of Microsoft SQL Server 2012 – 2019 Suite including (SSMS, SSIS, Query Profiler)
Expert knowledge of Relational Database Modeling and SQL Server Internals
Extensive understanding of relational database design, common table expressions (CTEs), and Test-Driven Development (TDD)
Expert knowledge of DMVs, System Stored Procedures, User Defined Functions, and Custom Types
Advanced knowledge of SQL Server''s "Always On" Availability Group feature
Expert knowledge in OLTP and Linked Servers including how to secure them
Expert understanding of SQL Server security at both server and database levels
Advanced knowledge and demonstrated ability in Query / Index tuning using Performance monitor statistics
Sound knowledge of database migration best practices for low risk and minimum downtime
Excellent communication and organizational skills
Preferred Qualifications
In-depth knowledge of backing up, restoring, and moving SQL databases along with the ability to plan and implement sophisticated Disaster Recovery strategies.
.
Database Design, Maintenance, Security, Management and Analysis.
Experience using SQL Sentry to monitor, troubleshoot and resolve performance issues.
High-level knowledge of Windows and Windows security and how they affect SQL Server.
Possess a strong understanding of database theories, principles, and best practices.
Excellent analytical and problem-solving skills.
Excellent written and verbal communication skills.
Be self-motivated, able to work independently as well as in a collaborative
PowerShell scripting.
Experience and knowledge of SQL Server Reporting Services and T-SQL development.