Senior Cloud Database Administrator

New

P&P SolutionsInsurance

Locations: Warszawa, Łucka 15, Warszawa, Country code: PL; 100% zdalnieContractSenior

Salary145 - 165 PLN per hour

Apply NowOpens the employer's application page

Job Details

Have strong knowledge of Azure SQL Database (PaaS) and practical experience maintaining and optimizing multi-terabyte databases.
Understand Azure SQL General Purpose tier constraints, including IOPS, IO latency, log rate limits, memory per vCore, and tempdb.
Have advanced MS SQL Server and T-SQL skills.
Be able to optimize queries and analyze execution plans, indexes, and statistics.
Know Query Store, plan regression, parameter sniffing, and forced plans.
Have experience analyzing wait statistics and DMVs and resolving CPU, memory, blocking, and deadlock issues.
Have practical knowledge of Azure Monitor and Azure Log Analytics.
Know Active Geo-Replication, Auto-failover Groups, and Readable Replicas.
Have experience with System-versioned Temporal Tables and Table-Valued Parameters (TVPs).
English at a minimum B2 level.

Analyze and tune SQL queries, execution plans, indexes, and statistics in a multi-terabyte database.
Identify and resolve production issues involving CPU, memory, blocking, deadlocks, long-running processes, and unstable API response times.
Conduct a health check of the Azure SQL environment and assess General Purpose tier limitations.
Recommend Azure SQL configuration and architecture changes.
Analyze temporal tables, queries using Table-Valued Parameters, and index and statistics maintenance strategies.
Improve monitoring and alerting.
Analyze read replica usage and assess high-availability and disaster-recovery solutions.
Support redesign of the data access layer for Rating APIs.
Document changes and recommendations and transfer knowledge to the client team.

View Full Description & ApplyYou'll be redirected to the employer's site