SQL Developer/DBA

Description

CLA is seeking a skilled SQL Developer/DBA to join our team. The ideal candidate will be responsible for 75% database development and 25% DBA work, ensuring our databases are secure, reliable, and efficient. As a SQL Developer/DBA, you will be responsible for designing, implementing, and maintaining our databases and ensuring that they meet our company’s standards. - 4 month contract-to-hire. Conversion salary 105k-117k - they aren't looking for reporting - SSRS and Power BI are irrelevant since another team handles reporting. 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 SQL Database, Azure Data Factory, Azure Synapse, Microsoft Fabric, and Cosmos. 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.

Skills

Azure Cloud, Sql, data modeling, ssis, Stored procedure, synapse, Azure Data Factory

Top Skills Details

Azure Cloud,Sql,data modeling,ssis

Additional Skills & Qualifications

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

Experience Level

Expert Level

About TEKsystems

We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

Key Skills

• Azure