Ishvarya B

• Experience in working on various MS SQL Database versions 2016,2017, 2019, 2022
  Experience in applying SQL Server service packs and database upgrades on same server and new server.
  Managing SQL Server databases.
  Configuring and maintaining database servers and processes.
  Monitoring system's health and performance.
  Ensuring high levels of performance, availability, sustainability and security.
  Analysing solving and correcting issues in real-time.
  Providing suggestions for solutions.
  Refining and automating regular processes, tracking issues, and documenting changes.
  Installations and configurations Database creations and configuration
  Backup and Restoration and Connectivity Configuration and troubleshooting
  Managing security & Maintenance of databases-Re-indexing and update statistics.
  Basic knowledge about DB corruption
  Basic Knowledge about managing performance Issues
  Providing 24x7 support for critical production systems.

● Migration of SQL On-premise databases to Azure cloud Managed Instance.

● Creation of Logins, Roles and granting rights.

● Backup and restore databases, jobs, logins, and roles in Azure cloud Environment

● Responsible for doing SQL discovery for SQL server upgradation.

● Installation & Configuration of SQL Server 2012 &2014 Enterprise Edition. (PI) post installation task , Responsible for solving the database related queries

● Creation of Logins, Roles and granting rights.

● Backup and restore in Cohesity configuration tool.

SQL Monitoring Support

Monitoring SQL jobs, SQL Packages and SQL procedure.

Watching FTP scheduler for file processing.

Analysing Package procedure failures and fixing issues in the respective servers ⮚ Monitoring File processing and Replication.

Generating various reports, like daily status, weekly status, and monthly reports.

Managing Call log details and cycle graph details.

Maintain logs for future reference. Critical job monitoring and rectification. Monitoring Windows servers through SQL commands.● Understanding the requirement and carrying out the impact analysis.

● Carrying out the High Level and Detailed Analysis for any request or incident.

● Monitoring various business critical jobs in SD, MM and CRM modules.

● Providing maintenance, configuration, and incident support.

● Maintaining SLA of ticket and consistently maintaining TMF score more than 90%. ● Maintaining 25% FCR (First call resolution) of tickets from our end. ● Basic L0 trouble shooting.

SAP Support:

● Providing application support for 11 Modules in SAP, Providing maintenance support.

● User creation and providing roles to user in MDM Portal.

● SAP BI (Business Intelligence) job monitoring and rectification.

● Monitoring various business critical jobs in SD, MM and CRM modules.

Windows and AD Support:

● Creating User account and modifying user attributes in AD.

● AD Replication monitoring and troubleshooting.

● Group Policy management & Monitoring Windows servers through SQL commands.

● Deploying encryption policy in Client system. ● Managing McAfee End point protection.

• Analytical Skills: Strong ability to analyze data and identify trends.
• Research Skills: Proficiency in conducting online research and gathering information.
• Data Mining and Sourcing Skills: Experience in extracting and compiling data from various sources.
• Communication Skills: Ability to communicate research findings clearly and concisely.
• Technical Skills: Familiarity with web analytics tools and platforms.
• Problem-Solving Skills: Ability to identify and resolve issues related to website performance and user experience.
• Software Proficiency: Good knowledge of MS Office and other relevant software.
• Interpersonal Skills: Ability to work effectively with others.
• Learning Attitude: Willingness to learn and adapt to new technologies and methodologies.