Striving for excellence is in our DNA. Since 1993, we have been helping the world’s leading companies imagine, design, engineer, and deliver software and digital experiences that change the world. We are more than just specialists, we are experts.
Currently we are looking for a Senior MS SQL Engineer for our Prague office to make the team even stronger.
Our client is an investment bank, which provides large corporate, government and institutional clients with a full spectrum of solutions to their strategic advisory, financing and risk management needs.
The main function of the project is to consolidate, streamline and simplify the generation, analysis and visualization of risk within the investment bank onto strategic, cross-asset platforms. The migration from a legacy, siloed, asset class-specific environment to a shared, cross-asset, platform is a complex one and we are running that work as a program.
The candidate will join the project delivering regulatory driven improvements in credit risk methodology with significant impact on the bank’s RWA. As part of the program, the project is delivering new credit risk valuation and simulation capability as well as infrastructure components. The scope includes large spectrum of products across the asset classes (Fixed Income, FX and Equities) with varying degree of complexity presenting a highly interesting technology challenges. We do not use MS SQL Reporting services, MS SQL Analyses Server, and any other RDBMS systems, except MS SQL. Current version used in production is MS SQL Server 2008R2.
Design and implement changes to Risk Engine valuation results data store in SQL Server DB;
Design and implement ETL processes, using SSIS services;
Design, review and implement a scalable data model for CR framework;
Be responsible for performance tuning and refactoring of the existing DB processing routines;
Provide assistance in transformation business requirements into technical.
Excellent knowledge of MS SQL database technology stack:
Pure theoretical knowledge in relational theory;
Performance optimization skills:
Experience in database design;
Experience in Partitioning;
Experience in SQL Programming:
Analytical (window) functions.
Experience in SSDT;
Experience in writing tests for SSDT solution, and common CI principles;
Experience in Git\Bitbucket\Stash;
Knowledge in TeamCity (or Jenkins) build server;
Strong Jira knowledge;
Excellent SSIS knowledge:
Be able to build complex (conditional) ETL packages;
Be able to debug SSIS package;
Be able to use C# custom tasks.
Experience in Test/Behavior-Driven Development (including test automation and mocking tools);
Understanding of Agile methodologies and SDLC phases;
Keen, enthusiastic and willing to learn;
Strong team player with ability to work independently and proactively;
Strive to own end-to-end solutions to problems;
Ability to build productive working relationships with other IT groups, business users and support teams in multiple geographic locations;
Excellent problem solver;
Professional presentation and communication skills.
Nice to have
Knowledge of AutoSys (Enterprise scheduler system);
Knowledge of QlikView;
Knowledge of SAP BO.
Opportunity to work in a successful international company with stable background;
Possibility to work in friendly multicultural environment, using English on daily basis and growing professionally within worldwide EPAM;
We offer guaranteed professional growth through the technology trainings and technology communities inside EPAM;
Large space for self-fulfillment and participation in new projects;
Motivating financial evaluation (negotiable, based on an expertise and achieved results);
Competitive compensation depending on experience and skills;
Benefit program (5 weeks of vacation, 5 sick days, wage compensation for the first three days of illness, meal vouchers, flexi pass, annual coupon of Prague city public transport, multisport cards);
Comfortable and modern offices in Prague 4;
Start ASAP / Negotiable.
Senior MS SQL Engineer Prague, Czech Republic
Спасибо! Ваша заявка принята. Мы свяжемся с вами в ближайшее время.