MSSQL DBA (MSSQL DBA Product Support experience)

30 years

0 Lacs

Posted:1 day ago| Platform: SimplyHired logo

Apply

Work Mode

On-site

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

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Temenos logo
Temenos

Financial Software

Geneva

RecommendedJobs for You