Hari Har Email and Phone Number
Having 9.4 Years of experience as SQL Server Database Administration,• Extensive SQL Server DBA experience in support on a 24x7 production.• Installing and configuring SQL Server 2005/2008/2008R2/2012/2016/2017/2019, applying service packs and Cumulative updates.• Backup and restore azure database.• Migrating the SQL Server databases and instances from lower version to higher version.• Successfully resolving SQL Server problems which involve in-depth knowledge of SQL Server backup/restore, database corruption, security etc.• Creation and maintenance of Databases, Troubleshooting the backup failures and recovering databases from the point of crash.• On-Call responsibilities for Production database systems.• Performing Database refresh tasks from Dev-Staging/Pre-prod to Dev/UAT to Pre-prod servers.• Creating and Scheduling JOBS (Daily, Weekly, Monthly) and Maintenance.• Troubleshooting blockings, deadlocks and fixing them by adding permanent fixes.• Troubleshooting the disk space issues and handling the database file growth settings to make assure the capacity utilization.• Extensive Experience in providing Production support for Database and Applications.•Installing service packs on stand-alone servers as well as cluster environment, adding SQL nodes to the existing cluster.• Good hands on in Incident /Change management & ITIL Process standards.• Troubleshoot performance problems, fine-tuning of databases and index Analysis. 24x7 Production Database on Call Support.• Successfully resolving SQL Server problems which involves in-depth knowledge of SQL Server architecture, connectivity, backup/restore, database corruption, security & HADR solutions like log shipping, mirroring, Failover clustering & always on. • Configured a new job in all Prod servers to copy logins from DC to DR. In case of production database failure, we can bring database online along with logins same as production.• Automated DB SQL server health report on daily basis for production server• Worked on MS SQL Server 2016 Query Store on performances issues like indexes,blockings, deadlocks.
Tech Mahindra
View- Website:
- techmahindra.com
- Employees:
- 109765
-
Team LeadTech Mahindra Dec 2019 - PresentHyderabad, Telangana, IndiaDESCRIPTION:I am part of the team which handles database migrations for the Asahi. As a team we are responsible to handle infrastructure migrations Azure from on-premise to azure using azure migrate lift and shift methodology. Working on migration strategies and execute the same for app, web, database servers.Roles and Responsibilities:• Support migration to azure SQL database/Azure VM.• Handling pre and post migration activities and migration planning.• Working exclusively on provisioning and capacity planning of SQL environments for multiple projects. • Support daily operation tasks of sql databases handling by tech Mahindra • Backup and restore azure database. • Have prepared User-Manuals and Technical documents for the project, which includes ED (Environment Description) documents/ Run Books / RCA's within the teamProject Names Asahi Europe LtdClient AsahiCOMPANY Tech Mahindra LimitedDuration June 2022 to Till NowRole Project Lead (SQL DBA)Team Size 5Environment SQL SERVER 2016 & 2019, Azure Portal, SERVICE NOWMS SQL SERVER DBA• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security policies.
-
Team LeadTech Mahindra Dec 2019 - PresentTelangana, India
-
ConsultantSonata Software Dec 2017 - Dec 2019Hyderabad, Telangana, IndiaDESCRIPTION: Microsoft has engaged Sonata to provide a managed IT Services to support the technological landscape of their business and manage the databases and Providing support for MSSQL Servers for Worldwide users. Connecting with users and troubleshoot the issue.Roles and Responsibilities:• Installed SQL Server 2008R2/2012/2014/2016 versions of instances on Prod and Dev VM's and Applying Service Packs for the Servers as released/requested.• SQL Server upgrades with new service packs and hot fixes.• Performing Database Refresh tasks as per Service Request by the users from prod to pre-prod and prod to dev etc.• Creating the logins and assigning the privileges to the users in database level as requested by the end users/application team.• Creating user defined roles and assigning to the users in database level as requested by the end users/application team.MS SQL SERVER DBA• Creating the linked servers between prod-prod, prod-pre prod, Dev-Dev.• Creating and Scheduling JOBS (Daily, Weekly, Monthly) and Maintenance. • Working on Disk space issues.• Troubleshooting connectivity issues raised by Application users.• Working on Performance Tuning as High CPU, IO, Long Running Queries and Over Running Jobs.• Performing the Database maintenance activities like Rebuild or Reorganize index in case of performance degradation or end users are concerned. -
Senior Assoicate (Sql Dba)Tata Communication Limited. - Tcl Jun 2015 - Dec 2017Chennai, Tamil Nadu, IndiaDESCRIPTION: Julius Bar Group Ltd. is a Swiss private banking group which is the parent company of Bank Julius Baer, a traditional private bank based in Zurich, Switzerland. The firm dates itself back to 1890,when an exchange office was founded by Ludwig Hirschhorn and Theodor Grob. Joseph Michael Uhl and Julius Baer joined in 1896, In 1901, Julius Bär acquired the bank and remained as partner until 1922.From 1988 until 2012, last as Chairman of the board of Julius Baer Holding Ltd. Michael Baer. joined the bank in 1992 and was active in various senior operating functions, last as a member of the group executive committee until 2005.In July 2014 Julius Baer announced that it had purchased the private banking assets of Israeli Bank Leumi. Baer is buying Leumi's private bank in Luxembourg and Leumi will also transfer the clients of its Swiss private bank to Baer.Roles and Responsibilities:• Installation and configuration of MS SQL Server 2008, 2008R22012.• Migrating databases from SQL Server 2005 to 2008 and SQL Server 2008 to 2012.• Resolving Tickets which include creating and maintaining databases, monitoring Disk Space,• database integrity, identifying missing Indexes, handling blocking• Configuring and troubleshooting high availability scenarios like Log Shipping.MS SQL SERVER DBA• Ensure and maintain sound backup and recovery policies and procedures.• Backup and restoring the databases from production to test environment• Detecting queries causing deadlocks and informing the developers.• Performing the Cluster installation and adding the nodes in the respective servers in SQL Server2008R2.2012.• Working knowledge on Mirroring implementation in the project• Troubleshooting clustering issues and performing failover on a cluster from one node to another• Preparing documentation for the server documentation and updating it constantly.• Knowledge on Domain Controller• Participating in weekly and monthly meetings• Performing daily check list
Hari Har Education Details
-
Computer Engineering
Frequently Asked Questions about Hari Har
What company does Hari Har work for?
Hari Har works for Tech Mahindra
What is Hari Har's role at the current company?
Hari Har's current role is Team Lead at Tech Mahindra.
What schools did Hari Har attend?
Hari Har attended Veermata Jijabai Technological Institute (Vjti).
Who are Hari Har's colleagues?
Hari Har's colleagues are Bethu Shravankumar, S. Uma, Patel Pratik, Mithilesh Kumar, The Devil Gaming, Kiran Pawaskar, Inderjeet Pal.
Not the Hari Har you were looking for?
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial