MS SQL Database Administrator

Bounteous; United States; Remote; USD 60,000 - 80,000; Full time

Job summary

An established industry player is on the lookout for a skilled Database Administrator to enhance their database infrastructure. This dynamic role involves optimizing SQL queries, verifying configurations, and executing migrations. You will collaborate with development and operations teams to ensure seamless database operations, contributing to exciting projects that make a real impact. If you thrive in a collaborative environment and have a knack for problem-solving, this opportunity is perfect for you. Join a forward-thinking company that values innovation and teamwork, and take your career to the next level.

Qualifications

• Proven experience as a Database Administrator with expertise in SQL optimization.
• Strong knowledge of database architecture and performance tuning.

Responsibilities

• Ensure database integrity, security, and performance through monitoring and optimization.
• Plan and execute database migrations and upgrades with minimal downtime.

Skills

SQL Query Optimization

Database Configuration Management

Database Migrations

Problem-Solving Skills

Communication Skills

Education

Certification in Database Administration

Tools

MS SQL Server

MySQL

PostgreSQL

Oracle

Docker

Kubernetes

Job description

We are seeking a skilled and experienced Database Administrator (DBA) to join our growing team. This DBA role is a ninja role; we need a detail-oriented person who can dig into a variety of system backends and help find areas of performance and reliability risks in our database infrastructure.

The ideal candidate will be responsible for ensuring the integrity, security, and performance of our databases. This role involves monitoring and optimizing SQL queries, verifying database configurations, and performing database migrations and upgrades. The DBA will collaborate closely with our development and operations teams to maintain smooth database operations and support ongoing projects.

If you want to contribute to exciting projects and make an impact in a dynamic and collaborative environment, we want to hear from you.

KEY RESPONSIBILITIES

1. DATABASE OPERATIONS
2. SQL Query Optimization: Review and optimize SQL queries to enhance database performance and efficiency. Identify and address bottlenecks to improve query execution times.
3. Database Configuration Verification: Validate database configurations to ensure compliance with best practices and security standards. Implement necessary adjustments to optimize database settings for performance and security.
4. Database Migrations and Upgrades: Plan and execute database migrations and upgrades in coordination with development and operations teams. Ensure seamless transition with minimal downtime and data loss.
5. Backup and Recovery: Establish and maintain robust backup and recovery procedures to safeguard critical data. Regularly test backup integrity and implement disaster recovery strategies.
6. Performance Monitoring and Tuning: Monitor database performance metrics and proactively identify areas for improvement. Implement tuning strategies to optimize database performance and resource utilization.
7. Documentation: Assist in the upgrade and creation of system documentation of database configurations, procedures, and standards. Work directly with Operations Services team to draft runbooks and technical documentation of all database environments.

EXPERIENCE REQUIREMENTS

1. Proven experience as a Database Administrator, with expertise in SQL query optimization, database configuration management, and database migrations.
2. A strong working knowledge of how databases optimize and execute queries, with the ability to assist developers in building optimal high-performing database queries, transactions, and stored procedures.
3. Strong working background with MS SQL Server, and proficiency in other database technologies such as MySQL, PostgreSQL, or Oracle.
4. Strong understanding of database architecture, including indexing, storage, and caching mechanisms.
5. Experience with database migration tools and techniques, such as dump and restore, replication, or schema migration scripts.
6. Familiarity with version control systems and automated deployment pipelines.
7. Excellent problem-solving skills and attention to detail.
8. Strong communication and collaboration skills, with the ability to work effectively in a team environment.

PREFERRED QUALIFICATIONS

1. Certification in database administration (e.g., Oracle Certified Professional, Microsoft Certified Database Administrator).
2. Experience with cloud-based database platforms (e.g., Amazon RDS, Microsoft Azure SQL Database).
3. Knowledge of containerization technologies (e.g., Docker, Kubernetes) and their impact on database deployments.