Prosyntix is currently seeking a SQL Database Administrator for one of their clients in the Greensboro, NC area:
Work with Infrastructure team and development to quickly identify and fix performance issues in Azure SQL Managed Instance environment
Propose and/or implement any necessary database design changes to improve performance.
Tune complex, high transaction volume SQL databases
Develop new and enhance existing standards, processes and procedures, and guidelines for database environments using industry experiences, best practices research, and business needs
-Experience with Azure SQL Managed Instance Expert level skills in SQL Development
-Ability to write and troubleshoot Transact SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, constraints).
-Expert knowledge in Performance Tuning and optimization, using native monitoring and troubleshooting tools.
-Expert knowledge of indexes, index management, and statistics.
-Experience in RLS in a high transactional production environment
-Ability to detect and troubleshoot SQL Server related I/O, memory, disk space, CPU, and other resource issues.
-Know what the query optimizer will do before it does.
-Knowledge of SQL Server tools (Profiler, SSMS, SSCM, DM views, system stored procedures).
-5+ years of experience in database administration