Job Description

ABOUT TEMENOS

Temenos powers a world of banking that creates opportunities for billions of people and businesses everywhere. We have been doing this for over 30 years through the pioneering spirit of our Temenosians who are passionate about making banking better, together.


We serve over 3000 clients from the largest to challengers and community banks in 150+ countries. We collaborate with clients to build new banking services and state-of-the-art customer experiences on our open banking platform, helping them operate more sustainably.


At Temenos, we have an open-minded and inclusive culture, where everyone has the power to create their own destiny and make a positive contribution to the world of banking and society.

THE ROLE

The Product Analysis and Customer Support (PACS) team provides expert-level support to clients using Temenos products, including those in the implementation phase as well as live customers. PACS manages all client support requests, ensuring seamless product experience and client satisfaction.



MSSQL Database Administrator (DBA) is required to support our Production SQL server DB and Core instances in support model. The SQL server DBA will be responsible for performance tuning, administrating, monitoring, troubleshooting performance issues, recovering the database from any critical state of the SQL server databases. Would be responsible for reviewing application/databases, identify performance bottlenecks and fixing


Work shifts applicability : Work Shifts: Work Shifts on Rotation applicable (Work from office - 3 days from office and 2 days from home)

OPPORTUNITIES

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 Create SQL objects like Tables, Views, Indexes, Stored Procedures, Triggers, Rules, Defaults and user defined functions. This role requires strong expertise in advance query concepts that includes Dynamic SQL scripting, Recursive CTE and Partitioning management Perform all 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 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 Analysis on 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 & Monitor SQL Performance and IO

SKILLS

BE/Btech candidate with 7 to 9 years of experience as SQL server DBA Experience in database backup & restore activities and HA configuration Working in 24/7 critical environment Using Microsoft SQL server tools like SSMS and BI tools Knowledge on T-SQL Development & Azure SQL Development Excellent written and verbal communication skills Nice to have: Microsoft SQL server certified & Skills on Linux/Unix or any other OS

VALUES

Care

We care and listen to each other, our clients, partners and the communities we serve

Commit

We commit with determination and persistence to make things happen

Collaborate

We collaborate within Temenos and across a wider partner ecosystem

Challenge

We challenge the status quo, try to look at things differently and drive change

SOME OF OUR BENEFITS include:

Maternity leave:

Transition back with 3 days per week in the first month and 4 days per week in the second month

Civil Partnership:

1 week of paid leave if you're getting married. This covers marriages and civil partnerships, including same sex/civil partnership

Family care:

4 weeks of paid family care leave

Recharge days:

4 days per year to use when you need to physically or mentally needed to recharge *

Study leave:

2 weeks of paid leave each year for study or personal development