Senior SQL Developer with DBA

Project description

You'll be working in the Client Discovery, Planning and Wealth Way team. We provide engineering services to WMA business divisions of the Global Investment Bank. Together as a team, we provide solutions to unique business/market requirements per established Corporate IT Standards. As a database specialist, you'll play an important role in developing functionalities and client-facing applications.

Responsibilities

1. Design and develop large-scale applications
2. Collaborate to refine user requirements through test-driven development (TDD)
3. Work on creating end-to-end pipeline to load data by reading from multiple sources and load to landing layer or SQL tables
4. Analyze root causes of incidents and provide the solution
5. SQL Programming and DB administration
6. Work on performance running in MSSQL / Azure SQL

SKILLS

Must have

1. 5+ years of experience in SQL programming
2. Strong experience in performance tuning and DBA activities
3. Excellent understanding of relational transactional databases like MSSQL, Azure SQL and cloud-based frameworks like MS Azure
4. Experience with Cloud platforms/tools (Azure is preferable)

Nice to have

1. Experience in TSQL (MSSQL/SYBASE) code development, performance tuning, query optimization and extensive batch or ETL creation experience with better error handling.
2. Strong knowledge of Extraction Transformation and Loading (ETL) processes using frameworks like Azure Data Factory or Synapse or Databricks.