What are the responsibilities and job description for the SQL Server DBA position at Numentica LLC?
Job Description
We require skilled candidates that have experience in maintaining High-Availability (HA) MSSQL server environments.
Requirements
Experience working in Microsoft Azure SQL Offerings (Logical and Managed Azure SQL PaaS components)
Developing automation scripts for database engineering in PowerShell or other automation languages like Python.
Experience working in Microsoft Azure pipeline DevOps and coding ARM templates
Experience with backup/recovery/DR/monitoring, and tune for performance
Excellent communication, presentation, and teamwork skills.
Experience securing Windows OS, MSSQL Servers, and Windows Applications/Services
Experience in scripting, authoring custom PowerShell cmdlets and modules, PowerShell best practices Desired State Configuration (DSC)
Experience with cloud and hybrid compute and database architecture including Microsoft Azure.
Strong hands-on experience on SQL Server 2012/2014/2016/2017 for Database Administration
Deploy and trouble shoot SSIS packages and provide solutions.
Hands on with SQL Server failover cluster management.
Experience with T-SQL programming model including stored procedures, functions, views and Triggers.
Experience with performance tuning and execution plans.
Ability to work with and manage datawarehouse in Azure cloud
Exposure Azure Synapse with Azure data lake will be an added advantage
Job Type: Full-time
