Data Base Administrative

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 TSQL 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
TSQL (TransactSQL) Programming Perform any extra responsibilities that are allocated to you
Conduct Performance tuning and optimization (Stored procedures Views Functions Queries database) Indepth 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 highavailability 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