Oracle Database Engineer

Overview IDB Bank is seeking for a Junior SQL Server database engineer to support commercial bank application databases and perform production database administration. Candidate with 0 to 1 year of experience. This position is responsible to work closely with both onshore and offshore cross-functional team members.

This is a fast-paced environment and forward-thinking skills are essential. Good team player skills, production support 24/7, Hygiene maintenance, Performance tuning and possible cloud exposure are essential to perform the job function.

Responsibilities

Serve as Onshore DBA for bank data infrastructure, and data architecture to assist mission critical 24X7 production databases with Microsoft SQL Server Partnership effectively with application development, production application support teams to optimize the performance of the various application’s databases. Advocate database objects design such as Partition tables, Triggers, Index analysis, Stored Procedures, Views turning, User defined functions, and various data types. Implement and support High Availability and Disaster Recovery (HA-DR) automated solutions such as SQL Server – Always on Availability Groups to sync Production and disaster recovery environments Participate annual disaster recovery test planning and execute to achieve successful result to have bank on-premise data infrastructure robust and resilient Partnership with Cybersecurity and Infrastructure team members to implement monthly critical patching, Upgrade, Cloning, building best practices documentation and Database Migrations.

Implement CIS security standards to hardening the data infrastructure Weekly basis time sheet submission and providing status report for various projects are key to perform the job function. Candidate will follow SDLC standards, change control best practices, assist internal and external audits. Candidate should have previous experience or adopt to fast-paced environment (High volume of work, Rapid changes, tight deadlines, urgency and multitasking) Implement SQL Server - SSIS, SSAS and SSRS product features.

Should have strong ETL, ELT experience to optimize the data warehouse batch jobs to narrow the execution of the data load Implement Backup encryption, TLS certificates to encrypt the communication in the data infrastructure and Hygiene best practice implementation to secure the daily, weekly and monthly backups in AWS-S3 storage Collaborate with third party fintech vendors to modernize, portfolio optimization and rationalization of the database estate Candidate will implement dynamic data masking through tools such as Delphix to virtualize the database environment with masked data in non-production environment to secure bank data infrastructure Candidate should have hands on experience with PowerShell, Shell scripts, Python, TSQL, PL/SQL programming to review the code and optimize as necessary.

Required Qualifications

Skills Bachelor’s degree in Computer Science or equivalent.

Nice To Have

: Exposure with F5 Load balancer implementation to route the sessions in HA-DR environment and advance database features such as Transparent data encryption (TDE), Policy management, Resource Governor, and Extended events Exposure with data center migration from on-premise to cloud is a plus Exposure with NoSQL products: Apache Ignite, SQL Lite, MongoDB, and Cassandra, Couchbase AWS or Azure cloud certification and previous implementation in AWS – Databricks, Data Warehouse, Data Lakehouse or Snowflake in public cloud Implement database