NOTE: This is a contract-to-hire role. Candidates must be willing to hire on as a full-time, W2 employee after 3 months. It is fully remote.
About the role:
We are seeking a skilled SQL Server Developer/DBA to join our team. The ideal candidate will be responsible for 50% database development and 50% DBA work, ensuring our databases are secure, reliable, and efficient. As a SQL Server Developer/DBA, you will be responsible for designing, implementing, and maintaining our databases and ensuring that they meet our company’s 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 Azure Synapse Analytics and/or Databricks is a plus
- 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.
Job Types: Full-time, Contract
Pay: $100,000.00 - $125,000.00 per year
Benefits:
- 401(k)
- 401(k) matching
- Dental insurance
- Employee assistance program
- Health insurance
- Life insurance
- Paid time off
- Professional development assistance
- Referral program
- Vision insurance
Schedule:
- 8 hour shift
- Monday to Friday
Education:
Experience:
- Azure SQL Development: 1 year (Required)
- Azure DevOps: 1 year (Required)
- Data modeling: 1 year (Required)
- Azure Data Factory: 1 year (Preferred)
- Azure Synapse: 1 year (Preferred)
- Azure Databricks: 1 year (Preferred)
Work Location: Remote