Atmosera

Cloud transformation, managed services, training

SQL Server Database Administrator - Database Administrator

Database AdministrationConfirmed live in the last 24 hours

Full-timeNo salary listed

About the Job

Requirements

At least 3 years of experience as a SQL Server Database Administrator.
Expertise in SQL Server Always On Availability Groups and other high-availability and disaster-recovery 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, including Azure SQL, AWS RDS, and Google Cloud SQL.
Experience with PowerShell, automation scripts, and monitoring tools.
Understanding of database security principles and compliance standards.

Responsibilities

Install, configure, and maintain SQL Server instances on premises and/or in the cloud.
Manage database security, roles, permissions, and backups.
Proactively monitor database health and performance.
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 to ensure data security.
Perform timely patching and upgrades to mitigate vulnerabilities.
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.

Desired Qualifications

Experience with NoSQL or hybrid cloud databases, such as Databricks.
Knowledge of CI/CD pipelines and DevOps tools related to databases.
Relevant certifications, such as Microsoft Certified: Azure Database Administrator Associate or MCSA: SQL Server.
Experience with cloud-based backup and recovery platforms, such as Rubrik, Veeam, and Commvault, including use of the backup and restore interface.

Atmosera empowers businesses to redefine what's possible with modern technology and human expertise. Our exceptional experience across Applications, Data & AI, DevOps, Security, and the Microsoft Azure platform enables organizations to accelerate innovation, enhance security, and optimize operational agility. As a Microsoft Partner with seven specializations, GitHub AI Partner of the Year, a member of the GitHub Advisory Board, and a member of the prestigious Microsoft Intelligent Security Association (MISA), Atmosera expertly delivers cutting-edge, integrated solutions that deliver business value.

Key Responsibilities

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.

Required Qualifications & Skills

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.

Preferred Qualifications (Nice to Have)

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.

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. We celebrate diversity and are committed to creating an inclusive environment for all employees. We do not discriminate based upon race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics. All employment is decided on the basis of qualifications, merit, and business need.

About the Company

Atmosera

Cloud transformation, managed services, training

Atmosera helps enterprises modernize and optimize their IT environments by offering cloud transformation services focused on Microsoft Azure. They provide expert professional services, managed operations, and technical training to implement AI and data engineering solutions, secure and scale cloud workloads, and drive ROI. Their approach centers on delivering high-value services through a single service platform that aligns with Microsoft standards, distinguishing them with Azure Expert MSP status and a track record of productive outcomes. The company aims to enable clients to scale securely, improve efficiency, and achieve measurable ROI through cloud modernization.

Company size: 51-200
Company stage: Growth Equity (Venture Capital)
Total funding: Not listed
Headquarters: Lake Oswego, OR
Founded: 1995

Recently Posted Jobs

Explore more opportunities at Atmosera

See more jobs