O SEU PRÓXIMO CAPÍTULO
SQL Server Database Administrator, DBA
Sobre a vaga
• Install, configure, and maintain SQL Server instances on-premises and/or in the cloud
• Manage database security, roles, permissions, and backups
• Monitor database health and performance proactively
• Design, implement, and maintain Always On Availability Groups, Failover Clustering, Log Shipping, and Replication
• Ensure 99.99% uptime and meet high-performance standards
• Conduct automatic failover testing, backups, and disaster recovery planning
• Identify and resolve SQL query performance issues using execution plans, indexing strategies, and query optimization
• Implement best practices for indexing, partitioning, and resource allocation
• Analyze and optimize T-SQL queries and stored procedures
• Use SQL Server Profiler, Extended Events, DMVs, and third-party monitoring tools such as SolarWinds, Redgate, and SQLSentry
• Diagnose and resolve database connectivity and replication issues
• Automate monitoring and maintenance tasks
• Implement database encryption, auditing, and access controls
• Ensure timely patching and upgrades to mitigate vulnerabilities
• Collaborate with developers, DevOps, and infrastructure teams to optimize database solutions
• Provide technical support and guidance for application teams
• Document database architectures, processes, and recovery plans
• 3+ years of experience as a SQL Server DBA
• Expertise in SQL Server Always On Availability Groups and other HA/DR solutions
• Strong understanding of T-SQL scripting, indexing, and query tuning
• Experience with SQL Server 2016, 2019, and/or 2022
• Knowledge of Windows Server Failover Clustering (WSFC)
• Familiarity with cloud-based SQL solutions (Azure SQL, AWS RDS, Google Cloud SQL)
• Experience with PowerShell, automation scripts, and monitoring tools
• Understanding of database security principles and compliance standards
• Experience with NoSQL or hybrid cloud databases (e.g., Databricks) (preferred)
• Knowledge of CI/CD pipelines and DevOps tools related to databases (preferred)
• Relevant certifications, such as Microsoft Certified: Azure Database Administrator Associate or MCSA: SQL Server (preferred)
• Experience with cloud-based backup and recovery platforms such as Rubrik, Veeam, or Commvault (preferred)
• Ability to travel to a client site when required
• Ability to work from home
• Contractor position
• Equal opportunity and inclusive work environment