MS SQL Database Administrator

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 detailed 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

DATABASE OPERATIONS

SQL Query Optimization: Review and optimize SQL queries to enhance database performance and efficiency. Identify and address bottlenecks to improve query execution times.

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.

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.

Backup and Recovery: Establish and maintain robust backup and recovery procedures to safeguard critical data. Regularly test backup integrity and implement disaster recovery strategies.

Performance Monitoring and Tuning: Monitor database performance metrics and proactively identify areas for improvement. Implement tuning strategies to optimize database performance and resource utilization.

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

Proven experience as a Database Administrator, with expertise in SQL query optimization, database configuration management, and database migrations.

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.

Strong working background with MS SQL Server, and proficiency in other database technologies such as MySQL, PostgreSQL, or Oracle.

Strong understanding of database architecture, including indexing, storage, and caching mechanisms.

Experience with database migration tools and techniques, such as dump and restore, replication, or schema migration scripts.

Familiarity with version control systems and automated deployment pipelines.

Excellent problem-solving skills and attention to detail.

Strong communication and collaboration skills, with the ability to work effectively in a team environment.

PREFERRED QUALIFICATIONS

Certification in database administration (e.g., Oracle Certified Professional, Microsoft Certified Database Administrator).

Experience with cloud-based database platforms (e.g., Amazon RDS, Microsoft Azure SQL Database).

Knowledge of containerization technologies (e.g., Docker, Kubernetes) and their impact on database deployments.