MS SQL Engineer

Prague, Czech Republic

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.

DESCRIPTION


Currently we are looking for a Middle 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.

Responsibilities

  • Take participation in developing SQL objects, like stored procedures, functions, views, etc;
  • Take participation in developing SSIS packages;
  • Write functional tests;
  • Provide last line support for production incident;
  • Provide assistance to business users, in their custom requests.

Requirements

  • Be familiar with MS SQL database technology stack:
    • Theoretical knowledge in relational theory;
    • Normal Forms;
    • ACID.
  • Performance optimization skills:
    • Isolation levels;
    • Indexes;
    • Locks;
    • Statistics.
  • At least theoretical knowledge in Partitioning;
  • Average experience in SQL Programming:
    • Stored procedures;
    • Functions;
    • Views;
    • CTE;
    • Analytical (window) functions.
  • At least theoretical knowledge of SSDT;
  • At least theoretical knowledge of writing tests for SSDT solution, and common CI principles;
  • At least theoretical knowledge of Git\Bitbucket\Stash;
  • At least theoretical knowledge of TeamCity (or Jenkins) build server;
  • Jira knowledge;
  • Intermediate SSIS knowledge:
    • Be able to create simple SSIS package;
    • Be familiar with how SSIS packages are organized;
    • Be familiar with common SSIS execution flow.
  • 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.

Nice to have

  • Knowledge of AutoSys (Enterprise scheduler system);
  • Knowledge of QlikView;
  • Knowledge of SAP BO.

We offer

  • 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.