SQL Server Database Administrator - DBA (Remote LATAM)

Database Administration & Maintenance

• Install, configure, and maintain SQL Server instances (on-premises and/or cloud).

• Manage security, roles, permissions, and backups.

• Monitor database health and performance proactively.

High Availability & Disaster Recovery (HA/DR)

• 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.

Performance Tuning & Optimization

• 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.

Monitoring & Troubleshooting

• Utilize SQL Server Profiler, Extended Events, DMVs, and third-party monitoring tools (e.g., SolarWinds, Redgate, SQLSentry).

• Diagnose and resolve database connectivity and replication issues.

• Automate monitoring and maintenance tasks for efficiency.

Security & Compliance

• Implement database encryption, auditing, and access controls to ensure data security.

• Ensure timely patching and upgrades to mitigate vulnerabilities.

Collaboration & Documentation

• Work 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.

• Experience with NoSQL or hybrid cloud databases (e.g., Databricks).

• Knowledge of CI/CD pipelines and DevOps tools related to databases.

• Relevant certifications (e.g., Microsoft Certified: Azure Database Administrator Associate, MCSA: SQL Server).

• Experience with cloud-based backup and recovery platforms (e.g., Rubrik, Veeam, Commvault), including use of the backup and restore interface.