Senior Azure & On Prem MS SQL Database Administrator will be responsible for the management of production and non- production databases; database maintenance activities; troubleshooting database-related issues; monitoring of database capacity and performance; installation, administration, and configuration of database server/instances/databases; installation and configuration of SSRS; Support release/code deployment activities (SSIS Packages, SSRS reports, SQL objects etc)
Roles and Responsibilities
Create new Microsoft SQL Server instances and configure them, including AlwaysOn availability groups and failover clustering
In charge of database backup and recovery methods, database access security and integrity, physical data storage design, and data storage administration
Assists in the selection of a database management system and the maintenance of database performance
Configure and maintain SQL Security controls
Make recommendations for system architecture per Microsoft SQL Server best practises
Manage database backup and recovery, as well as disaster recovery planning, in coordination with the IT manager and System Engineer
Create, change, and improve SQL Server Agent tasks and maintenance plans
Proactively monitor SQL Server maintenance tasks, troubleshoot failed processes, and address issues as soon as possible
Troubleshoot application sluggishness and poor performance
In charge of T-SQL query tuning
In charge of database migrations and server updates
Create documentation and training for routine database administration activities, as well as train server operations employees on them
In charge of big data ETL into SQL Server, as well as authoring and modifying SQL Server Reporting Services reports
Integrate SQL Server with corporate applications
T-SQL (Transact-SQL) Programming Perform any extra responsibilities that are allocated to you
Conduct Performance tuning and optimization (Stored procedures, Views, Functions, Queries, database) - In-depth SQL database advanced performance tuning experience – Stored Procedures, Views, Functions; skilled in analyzing and assessing query execution plans and DMVs; expertise in assessing and implementing indexes and partitioning; Tuning ETL Jobs - SSIS & Azure Data Factory
Strong database migration experience.
Expertise and experience monitoring Azure workspaces, VM's, VM drives, Memory etc.
Expertise and experience creating MS Visio diagrams as they relate to MS SQL and database design
Responsible for maintaining existing databases with high-availability solutions, replication, backup, restore, encryption, and disaster recovery solutions.
Configure & Monitor Performance/Storage/Memory alerts on all Production Azure Servers to ensure high availability of data
Expertise Microsoft SQL Server on VM, Azure SQL Managed Instance, Azure SQL
