SQL Server Engineer

Deutsche Bank

Pune

Not disclosed

Work from Office

Full Time

Min. 5 years

Job Details

Job Description

LDH / SQL Server Engineer

Job Description:

Job Title: LDH / SQL Server Engineer

Corporate Title: AVP

Location: Pune, India

Role Description

We are in sought of an Candidate with a Techno functional SME on Eagle STAR, ACCESS and PACE Products and hands-on experience in the below:

Experience in Managing/Architecting/Developing Enterprise Solutions catering to Asset Management domain
Domain experience includes Strong knowledge on the Securities Reference Data, Fund Accounting, Trade Clearing & Settlements, Reconciliation, and Trade Life Cycle frame works.
Provide hands-on support for Global Client Reporting Platforms on accurate Fund Accounting Ledgers, AuM’s and NAV related consolidations
Experience with Security Reference Manager (SRM) to setup message based service used to validate and enhance security reference data against a list of customizable validation rules (edits/checks).
Setup payload orchestration for processing Composite Security Engine to build and validate a master security record from multiple data sources, such as Bloomberg, IDC and Reuters, and setup identify and resolve validation errors.
Participated in the design and development of Eagle Message Center application to enable a routing system that allows external data transmission systems (Brokers, Bloomberg, etc.) to send and receive transaction and ref-erence data to the Eagle suite of products.
Setup Message Center based data pro-cessing and distribution mechanism to allow for communication between disparate sources.
Facilitate migration of data between systems by translating, reformatting, and mapping data as needed.
Set up Outbound data exports to Message Center from the Eagle STAR and PACE applications, with protocols and apply various translation (mapping) rules that convert outbound data
Co-ordinate with external trading partners and various internal application/infrastructure teams as required
Support application migration workstream i.e. migrate and configure metadata to new Cloud Environment.
Candidate has been a skilled communicator with honed relationship management, team building, planning, and analytical abilities. Specialized in Agile development and delivery models.
Any of the working experience into GCP Technologies/Hosting or re-platforming
ITIL, CMM level, ITSM and Service Management

What we’ll offer you

As part of our flexible scheme, here are just some of the benefits that you’ll enjoy

Best in class leave policy
Gender neutral parental leaves
100% reimbursement under childcare assistance benefit (gender neutral)
Sponsorship for Industry relevant certifications and education
Employee Assistance Program for you and your family members
Comprehensive Hospitalization Insurance for you and your dependents
Accident and Term life Insurance
Complementary Health screening for 35 yrs. and above

Your key responsibilities

Actively participating in gathering Business requiements and System Specifications from System Users
Involve in development of regulatory projects and other major activities kike upgrades and new feature implementation. For ex: MIFID, PRG, EAGLE 13, 11 and 9 version upgrades.
Adopt Control-M Scheduler to order/schedule the loader, Uploader and exporter jobs
Extensively use SQL * Loader to load the data from flat files to the database and validate the data marts
Develop back-end PL/SQL Packages, Building Unix Shell scripts for data migration and batch processing
Coordinate offshore and onsite teams to ensure Production Stablity
Involve in tuning of SQL queries by using central tools and manual by Explain plan, Range Indexes
Involve in handling central Xref mapping for Security, Trade, Portfolio, Client and Account setups and Accounting look through for ledgers
Involve in handling central repository for time zone based Datamart snapshot for Prices received through several Brokers and external sources

Your skills and experience