MSSQL DBA/ MYSQL DBA - Support

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

MSSQL DBA/ MYSQL 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.

Key Responsibilities
• 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 and Extensive Knowledge of advance query concepts that includes Dynamic SQL scripting, Recursive CTE and Partitioning management
• Hands on 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 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
• Work Shifts on Rotation applicable (Work from office 3 days and work from home 2 days)

Skills & Experience
• BE/BTech/MCA candidates with Minimum 7 to 10 years of experience in as SQL server DB
• Working in 24/7 critical environment
• Using Microsoft SQL server tools like SSMS and BI tools
• T-SQL Development knowledge
• Azure SQL Development knowledge
• Excellent written and verbal