Cbse Technical Advisor

Administering Microsoft SQL Server ****/** [Certificate Validation Number: G743-3156]

Azure Administrator Associate [Certificate Validation Number: H751-3581] Name : Himanshu Total years of Work Experience : 5+ Years Graduation : B.E. (DBIT, VTU) Cloud (Azure, AWS & GCP) : 2.3 Years Email : ************@*****.*** Power BI : 1 years

Phone : +91-979*******, +91-721*******

himanshu-singh-612460121

PROFILE SUMMARY:

A customer focused individual who possesses a friendly and presentable approach along with strong time management skills and the ability to listen carefully to client requirements. Having insatiable energy to produce results and being able to build outstanding customer relationship. I perform effectively even within a highly pressurized working environment. I love automating routine tasks.

• +5 years of experience in Database Administration and AZURE Support Consultant for multiple international clients based in USA, U K, South America, and Europe.

• Responsible for Infrastructure, Designing, Sizing, Documenting, Installing, and maintaining of MS SQL On Premise, Azure SQL IaaS, and PaaS, PowerBI, Azure DevOps and AWS RDS.

• Created a “Trusted Technical Advisor” relationship with customer’s technologists and internal technical teammates.

• Proactive and diligent in identifying and communicating scope, design, development issues and recommending potential solutions.

• High Level expertise in HA and DR strategies such as Log Shipping, Clustering, Mirroring, Replication and Always On.

• Hands-on experience on real time Migration and DR Drills with Minimal Downtime.

• Good exposure on Performance Tuning, PowerShell Scripting, Partitioning, Auditing, Encryption, TSQL and on SSIS and SSRS.

• Also have participated in regional marketing events to promote Azure SQL Managed Instance.

• Have successfully managed and coordinated proof of concepts (POC’s). Developed POC plans with agreed use cases and worked with presales support teams to execute on the POC. TECHNICAL SKILLS/HIGHLIGHTS:

• Certified SQL DBA and Azure Administrator Associate.

• Received MAD (Made a Difference) Award.

• Cloud- Azure, AWS and GCP.

• Scripting- TSQL, PowerShell and BASH.

• Databases- MS-SQL Versions (2000 up to 2019), MySQL and Postgres SQL.

• OS- Windows Version (2003 up to 2019).

PROFESSIONAL EXPERIENCE:

RESPONSIBILITIES-

1) Regular monitor of servers, which includes Disk space, Servers monitoring and Health Checkups using SolarWinds.

2) Providing solutions and implementing best practices for Azure Virtual Machines and Azure SQL PaaS Databases.

3) Responsible for the management of 50+ Azure VM IAAS DB Servers, 250+ SQL IaaS Databases and 150+ OnPrem DB Servers with maximum Database Size of 4.1 TB. 4) Implementation of efficient Disaster Recovery Strategies and High Availability as per the requirements. 5) Migration of ON Prem Databases to PaaS with Single/Elastic DB Model and SQL Managed Instance. 6) Implementation of PowerShell Scripts to automate database/Server level activities like DB Backups, Disk Space Alerts, Service Alerts and Installation of SQL Servers. 7) Recommend and implement database security policies that are consistent with security Guidelines and best practices.

8) Implementations of Geo- Replication, Auditing, TDE, automatic tuning on SQL PaaS Databases. 9) Co-ordination with Network, Security, Service Desk and other Vendors. 10)Cost estimation and Optimization of Azure resources. RESPONSIBILITIES-

1) Regular monitor of servers, which includes Disk space, Servers monitoring and Health Checkups using IDERA.

2) Implementation of efficient Disaster Recovery Strategies and High Availability as per the requirements. 3) Responsible for the management of 100+ Production Instances and 500+ SQL Databases. 4) Migration of ON Prem Databases to PaaS and on AWS EC2 Instance. 5) Developing strategies in migrating old legacy DB Servers from SQL 2000 to SQL 2019 with minimal downtime.

6) Determining customer requirements and depending on performance, recommending Azure SQL Database for cost saving benefit.

7) SQL Query Tuning and providing recommendations to ERP jobs, time/CPU consuming queries. 8) Configuring SQL Azure Firewall and NSG for security mechanism. 9) Creation and Management of SOP's for PCI/DSS and HIPAA Compliance. 10)Implementation of OLA Hallengren scripts to take System & User DB Backups and Index & Statistic Maintenance.

RESPONSIBILITIES-

1) Regular monitor of servers, which includes Disk space, Servers monitoring and Health Checkups using SCOM.

2) Provide DBA support 24* 7 and technical expertise for multiple applications in Development, QA and Production.

3) Responsible for the management of 200+ Production Instances and 800+ SQL Databases. 4) Ensured databases adhere to corporate standards and policies, including Database auditing. 5) Responsible for fine tuning of the database, troubleshooting, user administration and memory management.

6) Developing the DR strategies such as Log Shipping and Mirroring. 7) From time to time recover the databases to a specific point of time, as per the requests. RESPONSIBILITIES-

1) Regular monitor of servers, which includes Disk space, Servers monitoring and Health Checkups using internal tool.

2) Provide DBA support 24* 7 and technical expertise for multiple applications in Development, QA, and Production.

3) Responsible for the management of 50+ Production Instances and 500+ SQL Databases. 4) Creation of Logins and Users for accessing the Database. 5) Maintaining indexes and monitoring CPU and Disk I/O. 6) Creation of SQL Server jobs as per the requirements. 7) Managed SQL Server based Applications.

8) Fine Tuning Server/Database level setting for optimal performance. 9) Achieved 99.9% uptime on all SQL Servers.

EDUCATION:

• B.E. (CSE) from VTU (Visvesvaraya Technological University) 2015.

• Senior Secondary from CBSE Board – 2011.

• Matriculation from CBSE Board – 2008.

Contact this candidate