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.

Primary 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. Advocate cross functional team
Experience with Cybersecurity tools such as CyberArk, Crowd Strike, Qualys scan and Firewall - tufin implementation are mandatory

Required Qualifications & Skills

Bachelor’s degree in Computer Science or equivalent.
Large scale database integration experience in an Agile model
Self-motivated when it comes to multitasking and development planning
Great communication skills and confidence to manage up
RDBMS: SQL Server 2022, and 2019 RDBMS versions
Operating System: Windows 2019, 2022, RHEL 8.x, 9.x

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 monitoring using tools such as System Center Operations Manager (SCOM), Nice Management Pack configuration for Oracle DB instance and SolarWinds monitoring and alerts to create auto tickets in ServiceNow
Exposure with Artificial Intelligence and Machine Learning experience in data engineering is a plus

Compensation

The expected annual salary for this position is between $70,000 and $80,000 at the start of employment. A salary offer is determined on an individualized basis, taking into consideration factors such as an individual’s skills and experience. In addition to base salary, our total rewards package also includes eligibility for an annual bonus, medical, pharmacy, dental, and vision plans, life and disability insurance, employee wellness program, retirement and savings plans with employer contributions, generous holiday and paid time off schedules, parental leave, and tuition reimbursement.

Additional information

The Bank will make reasonable accommodations to the following employees to allow them to perform the essential functions of their position, except where doing so would result in undue hardship to the Bank:

Those with a known mental or physical disability.
Pregnant individuals and/or individuals with pregnancy or childbirth-related medical conditions.
Victims of domestic violence, sex offenses or stalking.
Employees with religious observance and practice obligations.

Any employee who believes he or she needs an accommodation for any of the above reasons should contact their supervisor or a member of Human Resources to request such an accommodation. In each case, the Bank will engage in a good faith written or oral dialogue concerning the individual’s accommodation needs; potential accommodations that may address the individual’s accommodation needs, including alternatives to a requested accommodation; and the difficulties that such potential accommodations may pose for the employer.

The Bank retains the ultimate discretion to choose the appropriate reasonable accommodation. Upon reaching a final determination at the conclusion of the cooperative dialogue, the Bank will provide the requesting individual with a written final determination identifying any accommodation granted or denied. In addition, the Bank will maintain any information regarding the employee’s request and status in the strictest confidence, except as requested by the employee, as required on a need-to-know basis or as otherwise required by law.

Disclaimer

The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities from time to time, as needed.

All your information will be kept confidential according to EEO guidelines.

We are operating on a Hybrid schedule.

NO AGENCIES PLEASE.

IDB BANK, INCLUDING ITS SUBSIDIARIES AND DIVISIONS, PROVIDES EQUAL EMPLOYMENT OPPORTUNITIES TO ALL EMPLOYEES AND APPLICANTS FOR EMPLOYMENT WITHOUT REGARD TO RACE, COLOR, RELIGION, SEX, SEXUAL ORIENTATION, NATIONAL ORIGIN, AGE, DISABILITY, GENETIC STATUS, CITIZENSHIP STATUS, MARITAL STATUS, MILITARY OR VETERAN STATUS, CURRENT UNEMPLOYMENT OR ANY OTHER LEGALLY PROTECTED CATEGORY IN ACCORDANCE WITH APPLICABLE FEDERAL, STATE AND LOCAL LAW. NOTHING IN THIS SITE CONSTITUTES A PROMISE OR OFFER OF EMPLOYMENT.

Learn more about this Employer on their Career Site

Oracle Database Engineer