IDB Bank is seeking a Junior SQL Server Database Engineer to support commercial bank application databases and perform production database administration. The role involves working closely with cross-functional team members and requires skills in performance tuning, database administration, and production support.
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
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
- Experience with Cybersecurity tools such as CyberArk, Crowd Strike, Qualys scan and Firewall - tufin implementation are mandatory
- 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
Benefits
- 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
- Tuition reimbursement
- Hybrid schedule
Company Overview
IDB Bank® is a New York-based private and commercial bank licensed by the State of New York and a member of the Federal Deposit Insurance Corporation. It was founded in 1949, and is headquartered in New York, NY, US, with a workforce of 501-1000 employees. Its website is http://www.idbny.com.