Description & Requirements
Minimum work experience: 7+ Years
Detailed JD:
• Deep knowledge of MSSQL environment starting from MSSQL 2012.
• Experience in managing and maintaining geographically dispersed MSSQL environment.
• Strong understanding of MSSQL platform, configuration dependencies and licensing – MSSQL versions and edition, usage, limitations, hardware, resources configurations, etc.
• SSRS, SSAS, SSIS knowledge
• Experience with MSSQL high availability solutions and replication – Always-On, log shipping, mirroring, etc.
• Understanding of MSSQL security concepts, risks, and best practices – authentication, roles, credentials, encryption, extended protection, etc.
• Experience in backup/restore and disaster recovery solutions
• Deep knowledge about optimal deployment and management of MSSQL instances
· Ability to collaborate with project teams to plan, design and implement secure and optimal database solution adequate to their needs.
· Cloud knowledge – DBaaS solutions on Azure (Azure SQL, Managed instances) and AWS (RDS); storage solutions, monitoring, backup/restore, VMs.
· Deep knowledge of Microsoft Server environment and components
· Experience in working within Active Directory environment.
· Deep knowledge of T-SQL and PowerShell
· Scripting ability to automate processes and daily tasks.
· Experience within development area (be able to code on basic level and be familiar with devops concept).
· Experience in troubleshooting and optimizing databases.
· Experience in at least one of other database flavors (MySQL, PostgreSQL, Oracle).
Good to have
· Other programming languages knowledge – Python, .NET
· Ability to build and develop applications.
· Knowledge of other database flavors (MySQL, PostgreSQL, Oracle).
· Knowledge of Linux system and components
Key Skills and Competencies:
· Must be able to work independently, communicate with business users and document requirements & architectures.
· Good documentation skills.
· Good analytical and decision-making skills using data & experience.
· Good written & verbal - communication & presentation skills.
· Technical background with demonstrated skills in at least one or multiple IT technologies / disciplines
· Should be able to work in a fast-paced environment handling multiple projects at a time.