Disaster Recovery Support Engineer Job in Chennai at Temenos

• You will be responsible for a good understanding of various features of the latest versions of Microsoft SQL servers, Azure, or AWS Cloud Solutions.
• You will be responsible for a good understanding of cloud database architecture and preferably Microsoft Azure.
• Understand the ticket logged details. Validate the completeness of information provided and if required, collect further information from Cloud Environments.
• You will be responsible for using the collected information to analyze the problem.
• You will Provide Production support on any critical DB issues, DB backup, Restore, and Disaster recovery.
• You will Evaluate and analyze custom SQL server programs/T-SQLs for high-performance issues.
• You will be responsible for a good understanding of advanced SQL server concepts (Performance Tuning, Larger subqueries, JOINS, PerfMon tooling)
• You will Analyze and tune queries based on CPU, I/O & throughput utilization and implement best practices recommended by the SQL server for improved performance.
• You will be responsible for tuning T-SQL queries using SQL server profiler, Execution Plan, Performance Monitor, DBCC Commands, Database Tuning Advisor,
• You will be Responsible for Index Fragmentation techniques to improve the database performance and ensure high availability.
• You will Participate in document improvement in the SQL level metrics CPU, I/O requests, throughput, Files, and file groups to a desirable level.
• You will report trace file comparisons for the required parameters before and after the optimization for the improvement of statistics.
• You will analyze trace files, and identify problem queries, I/O, Waits, Correlated subqueries, and Parameters validation.

Requirements:

• BE/BTech/ MCA graduate with 2+  relevant SQL server DBA experience.
• Should be able to deliver24/77 support to our global customer base in the cloud.
• Ready to work in a secure environment and willing to work on shifts for 24*7 support.
• Be available for on-call support as needed.
• Experience in Disaster recovery configuration in SQL on VM / Azure DBs.
• Working experience in Microsoft SQL server tools like SSMS and BI tools.
• T-SQL Development & Azure SQL Development knowledge.
• Experience in database backup & restore activities and HA configuration.
• Excellent written and verbal communication skills.
• Impeccable attention to detail.
• Professional certification in Azure or AWS cloud.
• Microsoft SQL server certified.
• Good to have experience with DB-centric Monitoring tools.