SQL Server Developer/DBA (Azure)

Posted on March 19, 2024

Location

Remote
010875

Position Details

Full-Time

Job Summary

Beacon Technologies is seeking a SQL Server Developer/DBA (Azure) for our client partner. The ideal candidate will be responsible for 50% database development and 50% DBA work, ensuring our client's databases are secure, reliable, and efficient. As a SQL Server Developer/DBA, you will be responsible for designing, implementing, and maintaining our client's databases and ensuring that they meet company standards.

Essential Job Functions:

  • Develop, design, and maintain complex SQL Server databases, including designing and implementing schemas, tables, indexes, views, and stored procedures.
  • Create and optimize complex SQL queries, including the ability to write complex stored procedures and functions.
  • Manage database security and access control, including developing and implementing security policies and procedures, performing database backups, and implementing disaster recovery plans.
  • Identify and troubleshoot database issues and performance problems, including analyzing database performance metrics, diagnosing problems, and tuning databases to optimize performance.
  • Collaborate with software developers and other stakeholders to ensure that databases meet their needs and requirements.
  • Work with database vendors to stay up to date with new technologies, features, and trends.
  • Document database design, data flow, dependencies, and integrations for support.
  • Analyze data and identify performance related gaps and provide solutions wherever applicable.
  • Develop monitoring plans for proactive support of databases both on-prem and in the cloud.
  • Create, document and support disaster recovery planning and procedure development.

What you will need:

  • Bachelor's degree in computer science, information technology, or related field.
  • Minimum of 3 years of experience in SQL Server development on the Azure Cloud platform.
  • Strong proficiency in SQL Server development tools, including SQL Server Management Studio, Azure Data Studio, and Azure SQL Database.
  • Experience in Azure Cloud platform features such as Azure Resource Manager, Azure SQL Database, Azure Data Factory, Microsoft Fabric, and Azure Virtual Machines.
  • Experience with database security, backup, and recovery procedures.
  • Familiarity with database security, backup, and recovery procedures in the Azure Cloud.
  • Strong knowledge of T-SQL programming, database design, and optimization techniques.
  • Familiarity with database performance tuning and optimization techniques.
  • Ability to write complex stored procedures, functions, and SQL queries.
  • Excellent problem-solving and analytical skills.
  • Strong communication and collaboration skills.

 

About Beacon Technologies

Are you looking to advance your career in information technology? Beacon Technologies offers career advancement opportunities, extensive training, and excellent benefits including paying for health and dental premiums for salaried employees. In addition to providing interesting opportunities, Beacon Technologies provides that old fashioned, personal touch, so you feel like a part of the Beacon team.

Beacon Technologies, Inc. is an equal employment opportunity employer with a functioning Affirmative Action Plan. It is the policy of Beacon Technologies, Inc. to ensure equal employment opportunity without discrimination or harassment on the basis of race, color, religion, sex, sexual orientation, gender identity or expression, age, disability, marital status, citizenship, national origin, genetic information, ethnicity, ancestry, disability, medical condition, military and veteran status, or any other characteristic protected by law. Beacon Technologies, Inc. prohibits any such discrimination or harassment.