Engineer-PL/SQL

Job Description

We are looking for a SQL developer with a minimum of 6 years of relevant experience, who will be responsible for designing databases and ensuring their stability, reliability, and performance. You will also work other developers optimizing in-application SQL statements as necessary, and establishing best practices. You will help solve all database issues and come up with ideas and advice that can help avoid such problems in the future. Experience in Banking Industries and a good understanding of Core Banking systems/flow is preferred.

Responsibilities

Help write and optimize in-application SQL statements

Ensure performance, security, and availability of databases

Prepare documentation and specifications

Handle common database procedures such as upgrade, backup, recovery, migration, etc.

Writing Test Cases

Profile server resource usage, and optimize and tweak as necessary

Identifying and defining Facts and Dimensions

Collaborate with other team members and stakeholders

Skills and Qualifications

Strong proficiency with SQL and its variation among popular databases like- Oracle, MS SQL Server, MySQL, Oracle PL/SQL is MUST

Skilled at optimizing large, complicated SQL statements

Knowledge of best practices when dealing with relational databases

Capable of configuring popular database engines and orchestrating clusters as necessary

Ability to plan resource requirements from high level specifications

Knowledge of best data security practices

Data masking, encryption/decryption