Database Administrator - 1113

  • Capital
  • Wakapi
We are passionate about what we do and we strive to be better with each day that goes by.  We want to contribute to the generation of a technological community powered by the conviction that, through small actions, we can help create a better world. The Role: We are looking for a database administrator to join our "AD" team, responsible for managing administrative tasks for SQL Server databases as well as Azure hosted data lake houses. You'll have the opportunity to develop and thrive in an environment where cutting-edge technology is a reality. Responsibilities: Install, configure, manage, and secure SQL Server database servers in a 24/7 production environment, including version upgrades and patch management. Proficient in database and server performance tuning, including indexing, query execution, and concurrency control to enhance efficiency. Diagnose and resolve database performance issues (e.g., SQL timeouts, deadlocks, blocking), capacity constraints, and high availability challenges (e.g., replication). Drive technical and procedural improvements to ensure database security, high availability, and reliability. Provides support and ensures availability and performance requirements are met outside of normal working hours to support 24/7 operations. Proactively maintain the health of the SQL Server database environment Maintain the Azure Cloud Synapse environment, including configuration, monitoring, and performance optimization. Have knowledge of Azure cloud environment configuration. Collaborate with application developers to design, test, implement, and maintain efficient data models. Optimize and maintain backup jobs, schedules, and environments (Production, DR, Development). Troubleshoot database and data issues, create, and manage administrative scripts, and document data processes. Help maintain database administration documentation and best practices. Requirements: 3-5 years of hands-on DBA experience Expertise in managing large SQL Server databases. Experience in Azure cloud environments. Experience in administering Azure databases, including Synapse Analytics Knowledge of administering Data-bricks is a plus. Proficient in T-SQL Skilled in indexing, statistics maintenance, security, and partitioning Experienced in managing highly available environments.  Wakapi Web