Proactively monitor and support highly available SQL environments around the clock.
Ensure SQL code and schema development meet our standards through regular reviews.
Analyze SQL performance regularly and resolve inefficiencies by optimizing stored procedures, functions, indexing, and core MS-SQL configurations.
Microsoft SQL DBA must possess advanced SQL querying skills, including expertise in writing complex SQL queries, stored procedures, triggers, and optimizing SQL performance.
Proficiency in database administration tasks such as database creation, configuration, monitoring,
Implement and maintain global security standards and best practices (think GDPR, encryption, PCI-DSS).
Ability to diagnose and troubleshoot database-related issues effectively, using tools such as SQL Server Profiler, Dynamic Management Views (DMVs), and Extended Events.
Experience with PostgreSQL desired.
Experience with database backup, indexing, database performance optimization.