Sql database administrator

Job Description

Insight Global is seeking a Sr. SQL DBA to join their IT team. The SQL Database Administrator (DBA) will be responsible for maintaining and ensuring the ongoing availability of SQL Server systems, both on-premises and in the cloud (AWS SQL Server and Azure SQL). The DBA will take ownership of the complete understanding and optimization of multiple database products, ensuring their performance, security, and reliability.

Key Responsibilities:

• Maintain and ensure the availability of SQL Server systems, including on-premises, AWS, and Azure environments.

• Monitor system performance and implement necessary security updates and patches.

• Optimize and manage multiple database products to ensure high performance and efficiency.

• Quickly learn new product platforms and database technologies. Stay updated with the latest industry trends in database management.

• Improve standard practices and procedures within the team to enhance efficiency and effectiveness. Develop and implement best practices for database management.

• Troubleshoot and solve database-related issues effectively. Provide timely and efficient resolution to database problems.

• Continuously work to acquire deep skills in relevant DBA areas. Participate in training and development programs to enhance technical expertise.

• Understand the infrastructure environment and independently support an application's database platform. Ensure the database platform meets the application's requirements.

• Maintain solid proficiency in backup and recovery options. Develop and implement backup and recovery strategies.

• Perform database design tasks, including schema design, indexing, and normalization. Ensure database designs meet performance and scalability requirements.

• Maintain team's documentation and make updates and improvements as needed. Ensure documentation is accurate and up to date.

• Capacity planning of databases and regular performance assessments and implement tuning measures.

• Write and optimize T-SQL scripts for automating administrative tasks. Ensure scripts are efficient and maintainable.

This is a full-time, permanent position with 3 days working in office, and 2 days from home.

Compensation:

$140K to $150K per year annual salary.

Exact compensation may vary based on several factors, including skills, experience, and education. Benefits are provided.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to [email protected] learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy:

Skills and Requirements

• Bachelor's degree in Computer Science, Math or IT related field.

• Minimum of 10 years of experience with Microsoft SQL Server.

• At least 3 years of experience with native Azure SQL Database.

• Minimum 5 years of experience with Powershell or Python scripting. - DB Certification in Microsoft SQL Server or Azure SQL database preferred.

• MongoDB Atlas database management experience a plus.