MS SQL Database Administrator
Job Summary
Job Description
The Database Administrator (DBA) will be responsible for ensuring the integrity, security, and performance of our databases. This role involves optimizing SQL queries, verifying database configurations, and performing database migrations and upgrades. The DBA will collaborate with development and operations teams to maintain smooth database operations and support ongoing projects. The candidate should be able to dig into system backends and help find areas of performance and reliability risks in our database infrastructure.
Must have:
- SQL query optimization to enhance database performance and efficiency.
- Validate database configurations to ensure compliance with best practices and security standards.
- Plan and execute database migrations and upgrades in coordination with development and operations teams.
- Establish and maintain robust backup and recovery procedures to safeguard critical data.
- Monitor database performance metrics and proactively identify areas for improvement.
- Assist in the upgrade and creation of system documentation of database configurations, procedures, and standards.
- Proven experience as a Database Administrator.
- Strong working knowledge of how databases optimize and execute queries.
- Strong working background with MS SQL Server.
- Strong understanding of database architecture, including indexing, storage, and caching mechanisms.
- Experience with database migration tools and techniques.
- Familiarity with version control systems and automated deployment pipelines.
- Excellent problem-solving skills and attention to detail.
- Strong communication and collaboration skills.
Good to have:
- Certification in database administration.
- Experience with cloud-based database platforms.
- Knowledge of containerization technologies.
9 skills required
Job Details
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.
Similar Jobs
Lionsgate
Santa Monica, California, United States (On-Site)
• 2 Months ago
Zelis
Hyderabad, Telangana, India (On-Site)
• 1 Year ago
BioFire
Hazelwood, Missouri, United States (On-Site)
• 2 Months ago
Get notifed when new similar jobs are uploaded
Similar Skill Jobs
Open Systems Technologies
Boston, Massachusetts, United States (On-Site)
• 1 Month ago
Zinnia
Atlanta, Georgia, United States (Remote)
• 2 Months ago
Get notifed when new similar jobs are uploaded
Jobs in India
Get notifed when new similar jobs are uploaded
Programming Jobs
Get notifed when new similar jobs are uploaded
