Responsibilities

Establish standards and practices to configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security
Onboard and operationalize new businesses brought on by acquisition in order to bring them up to our standard and ensure that they can scale
Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end
Identify new opportunities and help refine automation of regular processes, track issues, and document changes
Work in an Agile Scrum or equivalent models
Solve/Assist in complex query tuning and schema refinement
Expert in troubleshooting performance issues
Join the on-call rotation with other Engineers
Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members

Skills and Qualifications

8+ years of experience writing performant/maintainable/scalable SQL
6+ years MS SQL Server experience required
Matured experience in T-SQL and scripting skills.
Advance knowledge of Query Optimizer and query performance tuning
Working knowledge of SQL Server Internals, wait types, scheduling, etc.
Working knowledge of query parallelism and worker thread utilization
Working experience in Windows Clustering, partitioning, purging concepts
Knowledge of Microsoft Azure Cloud (IAAS)
Excellent written and verbal communication
Ability to organize and plan work independently is critical.
Ability to work in a rapidly changing environment
Ability to multi-task and context-switch effectively between different activities and teams
Knowledge on Microsoft cloud managed DBs/Systems, e.g. Managed SQL Instance, Azure SQL DB etc. will be a big plus
.NET or other object-oriented development experience a big plus
Domain knowledge and experience in the banking/fintech industry is a plus

Required Skills : - Extremely knowledgeable on SQL Server performance, SQL queries tuning, and database monitoring - The client LOVES people that are very outgoing and confident. They have turned down individuals that get hesitant in their answers or are quiet on the interview.

Basic Qualification :

Additional Skills : 100% remote.

Background Check :Yes

Notes :- 2 rounds of interviews that will be 30 minutes long with the HM and the Team Lead. 1st will be soft skills and 2nd will be more technical. - 6 month contract. Possibility for extension. - Client is looking for a diverse individual (more than just a financial background). - We have minimal competition here.

Selling points for candidate :100% remote.

Project Verification Info

Exclusive to Apex :No

Face to face interview required :No

Candidate must be local :No

Candidate must be authorized to work without sponsorship ::No

Interview times set : :No

Type of project :Development/Engineering

Master Job Title :Dev: SQL Server Database

SQL Database Engineer

Job description