Daily Discussion with client for day to day scenarios.

Knowledge of Performance Tuning Optimization.

Knowledge of Blocking, locking and Deadlocks.

Knowledge of Monitoring tools like Solar Winds and Idera.

Research and evaluate new tools/features Azure and assist in building Proof-of-Concept.

Work with external users/vendors to set up processes to extract/deliver data as needed.

Assist with streamlining and improving data integration efficiencies, reducing effort related to development and support, while providing security, flexibility and scalability.Develop and implement database/reporting policies and procedures, including those for architecture, security, disaster recovery, performance, and service provision.Assist with managing source code and deployments, and implement best-practices.Own all aspects involved with maintaining a high level of uptime and performance for all databases and above services.Administer and manage Reporting Services (SSRS) and PowerBI.

Install, maintain, and upgrade databases systems (on VM), and apply service packs.Monitor Database and Reporting Jobs and provide first level of support where applicable.Monitor SQL Servers, disk space, resource utilization and ensure capacity needs are met.Define and implement procedures for disaster recovery and high availability.Work with developers on indexing and query-tuning, and provide guidance in building optimal code.Identify system bottlenecks, and optimize performance to ensure timely deliverables.Architect and create databases, and provide access to users while meeting security requirements.Making Weekly and Monthly usages reports.Administer SQL Servers in Azure either on VM, Managed Instances, or SQL DBs.

Network traffic monitoring tools