Về công việc
Trách nhiệm chính
- Install, configure, and maintain SQL Server instances (on‑premises and/or cloud).
- Manage 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 to ensure 99.99% uptime.
- 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.
- 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.
- Implement database encryption, auditing, and access controls to ensure data security.
- 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.
Yêu cầu
- 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
Yêu cầu ưu tiên
- 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)
Hình thức làm việc
- Remote work with potential travel to client sites.
Thông tin khác
- This is a contractor position with the ability to work from home but may require travel to a client site.
- Atmosera is an equal opportunity employer and celebrates diversity.
- We may use artificial intelligence tools to support parts of the hiring process.