Senior SQL Server DBA

Description

Job Summary: The Senior SQL Server DBA will be responsible for SQL Server installation, configuration, administration, lifecycle management, backup and restore operations, performance tuning, and support for various teams. Key Highlights: 1. On-premises SQL Server and Microsoft Azure administration 2. Query performance tuning and optimization 3. Support for SSIS, SSAS, SSRS, and various teams #### **About the Senior SQL Server DBA Role** Syffer is an all\-inclusive consulting company focused on talent, tech and innovation. We exist to elevate companies and humans all around the world, making change, from the inside to the outside. We believe that technology \+ human kindness positively impacts every community around the world. Our approach is simple, we see a world without borders, and believe in equal opportunities. We are guided by our core principles of spreading positivity, good energy and promote equality and care for others. Our hiring process is unique! People are selected by their value, education, talent and personality. We dont present ethnicity, religion, national origin, age, gender, sexual orientation or identity. Its time to burst the bubble, and we will do it together! **What You'll do:** * SQL Server installation, configuration, and administration; * Management of version lifecycles; * Administration of on\-premises and Microsoft Azure instances; * Management of data files, log files, and TempDB; * Definition and execution of backup and restore strategies; * Execution of recovery testing; * Administration of SQL Agent Jobs; * Management of transactional replication; * Analysis of processes, transactions, blocking, and deadlocks; * Performance tuning and query optimization; * Index and statistics management; * Migrations between servers, versions, and platforms; * Security management, including logins, users, roles, privileges, and auditing; * Support for SSIS, SSAS, and SSRS; * Troubleshooting of database incidents; * Support for Development, Integration, BI, Application, and Infrastructure teams; * Documentation and runbook creation and maintenance; * Support for implementation and evolution of monitoring via Zabbix; * Hybrid work model; **Who You Are:** * Senior-level experience as a SQL Server DBA; * Strong operational experience; * Ability to assume ownership of a hybrid, complex, and mission-critical environment; * Experience with multiple versions of Microsoft SQL Server; * Experience administering on\-premises and Microsoft Azure environments; * Experience with Azure SQL Database, Azure SQL Managed Instance, and SQL Server on virtual machines; * Experience working with SQL Agent Jobs; * Experience with transactional replication; * Knowledge of SSIS, SSAS, and SSRS; * Experience in mission-critical 24x7 environments;  **What you'll get:** * Wage according to candidate's professional experience; * Remote Work whenever possible; * Delivery of work equipment adjusted to the performance of functions; \- Benefits plan; * And others. Work together with expert teams on projects of large magnitude and intensity, long term together with our clients, all leaders in their industries. Are you ready to step into a diverse and inclusive world with us? **Together we will promote uniquess!**