Job Description: SQL Server Database Administrator (DBA)
We are seeking a skilled SQL Server Database Administrator (DBA) to manage and maintain our SQL Server database systems, ensuring data integrity, performance, and security.
Responsibilities:
Database Administration:
Install, configure, and maintain SQL Server (versions: 2012, 2014, 2016, 2019, 2022)
Implement backup and recovery strategies (Full, Differential, Transaction log backups, Point-in-time recovery)
Manage High Availability (HA) & Disaster Recovery (DR) solutions: Always On Availability Groups, Transactional Replication
Ensure security and compliance: role-based security, TDE, data masking, auditing, GDPR/HIPAA compliance
Performance Tuning & Optimization:
Optimize queries, manage indexes and statistics, use tools like SQL Profiler, Extended Events, DMVs
Tune I/O, CPU, Memory; optimize TempDB; troubleshoot deadlocks
SQL Development & Scripting:
Write complex T-SQL queries, stored procedures, functions, triggers, views
Work with CTEs, Dynamic SQL, XML/JSON; automate with PowerShell; manage SQL Server Agent jobs
Cloud & Hybrid Skills:
Manage Azure SQL Database, SQL Server on VMs, Managed Instances, Azure Data Factory
Implement cloud backup and DR strategies
ETL & Data Integration:
Use SSIS for data migration and transformation
Handle data warehousing, reporting (SSRS, Power BI, Tableau), CDC, change tracking
Monitoring & Automation:
Perform health checks, use third-party tools (Redgate, DataDog, SentryOne), automate maintenance and alerts, monitor activity logs
DevOps & CI/CD:
Automate database deployment (Flyway, Liquibase, Redgate), integrate with version control (Git, Azure DevOps, SVN), set up CI/CD pipelines (Jenkins, Azure DevOps, GitHub Actions)
Soft Skills:
Strong problem-solving, troubleshooting, documentation, communication skills
Experience with JIRA, team leadership, mentoring junior DBAs, working under pressure, fluent in English
Benefits and Company Culture:
Conheça já alguns benefícios que a Indicium oferece! Nossa cultura inclui gestão moderna, ambiente inovador, cultura data-driven, autonomia, crescimento acelerado, home office, e mais.
Professional Development & Well-being:
Oferecemos plano de carreira, feedback contínuo, programas de certificação, aulas de inglês, iniciativas de liderança, onboarding estruturado, e suporte à saúde e bem-estar, incluindo planos de saúde, atividades físicas, e benefícios diversos.
#J-18808-Ljbffr