Database administrator pleno

Join to apply for the Database administrator pleno role at Netvagas

1 day ago Be among the first 25 applicants

Join to apply for the Database administrator pleno role at Netvagas

Key Responsibilities

Database Administration:Manage and maintain SQL Server databases across multiple environments (development, staging, production) ensuring high availability, scalability, and security.

Key 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, identifying bottlenecks, and applying 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.

Requisitos

QUALIFICATIONS AND EXPERIENCE REQUIRED:

Experience

Experience with T-SQL development, including writing complex queries, stored procedures, and functions.

Proven experience in SQL Server performance tuning, optimization, and troubleshooting.

Expertise in Azure SQL Database and Azure SQL Managed Instance deployments, migrations, and management.

Technical Skills:English Language is mandatory to collaborate in a global environment, including writing, speaking and presenting.

Deep understanding of SQL Server architecture, including high availability and disaster recovery solutions.

Experience with PowerShell scripting for automating DBA tasks such as backups, database health checks, and job monitoring.

Experience with Change Data Capture (CDC) for tracking changes in the database.

Proficiency in setting up and configuring SSIS and SSRS for SQL Server data communications.

Familiarity with monitoring tools like Grafana, SolarWinds, and Azure Monitor for real-time database health tracking and issue resolution.

Knowledge of SQL Server Agent for job management and automation.

Soft Skills:Strong problem-solving and analytical skills, with the ability to handle complex issues independently.

Excellent communication skills, capable of collaborating with cross-functional teams and presenting complex technical concepts to non-technical stakeholders.

Ability to manage time efficiently and prioritize multiple tasks 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), SQL Server Reporting Services (SSRS).

Familiarity with database version control and deployment tools (e.g., Devops, Visual Studio,SSMS).

If you are an experienced SQL DBA with strong expertise in Azure Cloud, T-SQL, automation, and monitoring tools, we encourage you to apply and join our dynamic team. This is a great opportunity to work in a fast-paced, innovative environment with cutting-edge technologies.

Additional Information

Working Hours

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

Benefícios

Contrato CLT por tempo indeterminado

Plano de saúde com coparticipação (com inclusão de dependentes)

Plano odontológico

Seguro de vida

Gympass / Wellhub para acesso a academias

Vale-refeição

Vale-transporte

Laptop individual como ferramenta de trabalho

Modelo híbrido: 2 a 3 vezes por semana no escritório (Indaiatuba/SP)

• Seniority levelMid-Senior level

• Employment typeFull-time

• Job functionInformation Technology
• IndustriesHuman Resources Services

Referrals increase your chances of interviewing at Netvagas by 2x

We're unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.