Job Description
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
MS SQL 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 those. Also MSSQL DBA would be tied up with CCC team [ SAAS clients] in co-ordination with the PACS-Support team to provide support across the cloud & on-premises clients.
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
Temenos is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to age, ancestry, color, family or medical care leave, gender identity or expression, genetic information, marital status, medical condition, national origin, physical or mental disability, political affiliation, protected veteran status, race, religion, *** (including pregnancy), ****** orientation, or any other characteristic protected by applicable laws, regulations and ordinances. We also consider qualified applicants regardless of criminal histories, consistent with legal requirements. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please let us know.
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
MS SQL 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 those. Also MSSQL DBA would be tied up with CCC team [ SAAS clients] in co-ordination with the PACS-Support team to provide support across the cloud & on-premises clients.
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
Temenos is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to age, ancestry, color, family or medical care leave, gender identity or expression, genetic information, marital status, medical condition, national origin, physical or mental disability, political affiliation, protected veteran status, race, religion, *** (including pregnancy), ****** orientation, or any other characteristic protected by applicable laws, regulations and ordinances. We also consider qualified applicants regardless of criminal histories, consistent with legal requirements. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please let us know.
💡 Quick Summary
Seeking a career-building opportunity? The MS SQL Server DBA |Product Support position is now open for candidates interested in the Bank Jobs sector. This role in Chennai offers a professional environment and growth potential.
Requirement Snapshot: Candidates should possess basic communication skills, a proactive attitude, and the ability to work in a team. Experience in Bank Jobs is a plus.