It Database Administrator - Mid Senior

buscojobs Brasil; São Paulo; Híbrido; BRL 80.000 - 120.000; Tempo integral

Resumo da oferta

A tech-driven recruitment platform in São Paulo is seeking an experienced Database Administrator to manage and optimize SQL Server databases, particularly in Azure environments. Candidates should have over 6 years of experience in database management, demonstrating strong technical and soft skills. The role includes responsibilities from ensuring database security to performance tuning and automation of tasks. This position offers a hybrid work model with standard hours from Monday to Friday.

Qualificações

• 6+ years of experience in managing SQL Server databases.
• Proficient in SQL Server architecture and high availability solutions.
• Strong problem-solving and analytical skills.

Responsabilidades

• Manage and maintain SQL Server databases ensuring high availability.
• Administer SQL on Azure cloud and perform migrations.
• Develop T-SQL queries and automate DBA tasks.

Conhecimentos

SQL Server management

Performance tuning

Azure cloud management

T-SQL development

PowerShell scripting

Change Data Capture (CDC)

Ferramentas

Azure SQL Database

Grafana

SolarWinds

Descrição da oferta de emprego

Overview

The Database Administrator is responsible for the design, installation, configuration, upgrading, and maintenance of databases. They ensure the smooth running of database systems by optimizing performance, performing regular backups, and managing database security. The role requires an in-depth understanding of database management systems (DBMS), SQL, performance tuning, and high availability solutions.

Responsibilities

• Database Administration: Manage and maintain SQL Server databases across multiple environments (development, staging, production) ensuring high availability, scalability, and security. Perform routine database maintenance tasks such as backups, restores, reindexing, and monitoring database performance. Implement and manage database replication, clustering, Always On availability groups, and other HA / DR strategies. Ensure database security by managing access permissions, roles, and implementing security best practices.
• Azure Cloud Management: Administer SQL Server instances hosted on Azure SQL Database, Azure SQL Managed Instance, and Azure Virtual Machines. Implement and manage database migrations from on-premises to Azure cloud, ensuring minimal downtime and data consistency. Optimize database performance in the cloud environment, using Azure monitoring tools and recommendations.
• T-SQL Development: Develop and optimize complex T-SQL queries, stored procedures, and functions to meet business requirements. Troubleshoot and resolve performance issues in complex queries and database workloads. Design and implement database schema changes, indexes, and other structures to support efficient data storage and retrieval.
• Automation of Repetitive DBA Tasks: Automate routine DBA tasks, including backup / restore, health checks, and database maintenance using PowerShell and SQL Server Agent Jobs. Create and maintain T-SQL scripts for automating tasks related to data migration, database optimization, and health monitoring.
• Backup and Restore Operations: Perform and automate backup and restore processes between on-premises and cloud (Azure) databases, ensuring reliable disaster recovery mechanisms and testing recovery procedures.
• Change Data Capture (CDC): Implement and manage CDC (Change Data Capture) to track changes in the database for auditing, data synchronization, and real-time reporting.
• Job Monitoring and Alerts: Set up monitoring and alerting for SQL Server jobs and system health, ensuring proactive identification and resolution of potential issues. Monitor job execution and performance using SQL Server Agent, Grafana, SolarWinds, and other third-party monitoring tools.
• SSL Implementations: Configure and manage SSL / TLS encryption for SQL Server instances to secure data in transit between servers and clients.
• Performance Tuning & Optimization: Continuously monitor database performance, identify bottlenecks, and apply optimizations to ensure high-performance queries and data access. Use execution plans, indexing, and other techniques to tune SQL Server for efficiency.
• Collaboration & Support: Collaborate with development teams to ensure database designs support application requirements. Provide on-call support for critical production issues, troubleshooting complex SQL-related problems. Work with stakeholders to gather requirements and ensure database architecture aligns with business goals.

Qualifications

• Experience: 6+ years of experience in managing, maintaining, and optimizing SQL Server databases.
• Technical Skills: Proficiency in English for global collaboration; deep understanding of SQL Server architecture, high availability, disaster recovery, PowerShell scripting for automating DBA tasks, Change Data Capture (CDC), SSIS/SSRS, and monitoring tools (Grafana, SolarWinds, Azure Monitor). Knowledge of SQL Server Agent for job management and automation.
• Soft Skills: Strong problem-solving and analytical skills; excellent communication; ability to collaborate with cross-functional teams and manage time in a fast-paced environment.

Desired Qualifications

• Microsoft Certified: Azure Database Administrator Associate or Microsoft Certified: Azure Solutions Architect Expert.
• Experience with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Familiarity with database version control and deployment tools (e.g., DevOps, Visual Studio, SSMS).

Additional Information

Working hours: Monday to Friday - 08:00 to 17:00 Hybrid Work