Ms SQL Server Dba

**ABOUT TEMENOS**

We’re passionate about helping banks to perform better, so we solely focus on creating banking software. Temenos offers cloud-native, cloud-agnostic, API-first digital banking, core banking, payments, fund management, and wealth management software products, enabling banks to deliver consistent, frictionless customer journeys and achieve market-leading cost/income performance. Our products combine the richest end-to-end packaged country model bank functionality and the most advanced technology, helping our clients go-live faster, giving them the freedom to innovate and deliver personalized experiences.
We are technology first, with 700+ published APIs, we partner with 100+ Fintechs in our marketplace. We have been recognized year after year by Gartner, IBS, and Forrester for our award-winning solutions.
Temenos is the 4th largest European Software company, with over 3000 clients in 150 countries. We are proud of our 7500+ Temenosians working across the globe to make banking better

**THE ROLE**

**OPPORTUNITIES**
- Understand the ticket logged details. Validate the completeness of information provided and if required, collect further information from client. Use the collected information to analyze the problem
- Provide Production support on any critical DB issues, DB backup, Restore and Disaster recovery
- Evaluate and analyze custom SQL server programs/T-SQLs for high performance issues
- Creating SQL objects like Tables, Views, Indexes, Stored Procedures, Triggers, Rules, Defaults and user defined functions
- Hands on experience in advance SQL server concepts (Performance Tuning, Larger subqueries, JOINS, PerfMon tooling)
- Analyze, tune & test identified top 30 programs, integrations and reports based on current CPU, I/O & throughput utilization and implement best practices recommended by SQL server for improved performance
- Proficient in tuning T-SQL queries using SQL server profiler, Execution Plan, Performance Monitor, DBCC Commands, Database Tuning Advisor, Index Fragmentation techniques to improve the database performance and ensure high availability
- Participation in document improvement in the SQL level metrics CPU, I/O requests, throughput, Files and File-groups to a desirable level
- Report trace files comparison for the required parameters before and after the optimization for the improvement of statistics
- Analyzing trace files, Identify problem queries, I/O, Waits, Correlated sub queries and Parameters validation
- Tune the queries and use Materialized or temp tables if required, Re-write the logic for better performance if required
- Replace Correlated sub queries, reducing Loop Overhead for DML Statements and Queries
- Writing Computation-Intensive Programs in T-SQL & Monitoring SQL Performance and IO

**SKILLS**
- BE/ BTec/ MCA graduate with 4 to 6 years relevant SQL server DBA experience
- Experience in database backup & restore activities and HA configuration
- Should be able to deliver 24 X 7 support to our global customer base
- Working experience in Microsoft SQL server tools like SSMS and BI tools
- T-SQL Development & Azure SQL Development knowledge
- Excellent written and verbal communication skills.

**VALUES**
- ** Care** about transforming the Banking landscape
- ** Commit** to being part of an exciting culture and product evolving within the financial industry
- ** Collaborate** effectively and proactively with teams within or outside Temenos
- ** Challenge** yourself to be ambitious and achieve your individual as well as the company targets