Information Technology - Data/Database Administration - SQL Developer/DBA

Location:

Montvale, NJ 07645 (2-3 Days onsite/hybrid work)

Salary Range:

$60.00-$70.00/hr on W2

Introduction

We are seeking a skilled and experienced SQL Developer/DBA to join our team. The ideal candidate will have a strong background in database management and cloud technologies, with a focus on Azure platforms. This role requires a proactive individual who can ensure the reliability, security, and performance of our database systems.

Required Skills & Qualifications

• Proven experience as a SQL Developer/DBA with expertise in stored procedures and performance tuning.
• Strong knowledge of Azure SQL, ADLS, and data lake integration.
• Experience with Azure Data Factory and pipeline management.
• Familiarity with database sharding concepts and practices.
• Proficiency in using SQL dacpac projects for database deployment.
• Experience with Azure DevOps for managing deployment pipelines.
• Strong problem-solving skills and attention to detail.
• Excellent communication and collaboration skills in an agile development setting.
• Ability to manage multiple tasks and projects simultaneously, meeting deadlines and ensuring quality.
• Prior work experience at client or in client's Industry.
• Applicants must be able to work directly for Artech on W2.

Preferred Skills & Qualifications

• Any Client Azure certification is a plus.

Day-to-Day Responsibilities

• Design and implement robust data models to support application and business requirements, ensuring scalability and efficiency.
• Define and maintain database schemas, ensuring proper structure and adherence to best practices.
• Develop and optimize indexing strategies to enhance query performance and database efficiency.
• Manage data ingestion processes, ensuring seamless integration of data from various sources into the database.
• Oversee data export processes to support reporting, analytics, and external system integration needs.
• Act as the primary owner of all database systems, ensuring their reliability, security, and performance.
• Review and validate database-related work committed by other team members to ensure quality, consistency, and adherence to standards.
• Provide mentorship and guidance to team members on database design, development, and optimization practices.
• Establish and enforce database governance policies, including naming conventions, documentation, and access controls.
• Monitor and analyze database performance, identifying and addressing bottlenecks or issues proactively.
• Design, develop, and maintain complex SQL stored procedures to support application development and data processing.
• Perform performance tuning and optimization of SQL queries and databases to ensure efficient data retrieval and processing.
• Integrate with Azure Data Lake Storage (ADLS) for seamless data storage and retrieval.
• Manage and maintain Azure SQL databases, ensuring high availability and security.
• Implement data lake integration strategies to support data analytics and reporting needs.
• Develop and manage Azure Data Factory (ADF) pipelines for data movement and transformation.
• Oversee database management and sharding concepts to ensure scalability and performance.
• Utilize SQL dacpac projects for streamlined database deployment and version control.
• Manage deployment pipelines using Azure DevOps, ensuring smooth and efficient release processes.
• Coordinate and manage production deployments, providing support and troubleshooting as needed.
• Collaborate with cross-functional teams in an agile development environment to deliver high-quality solutions.
• Provide ongoing support and maintenance for database systems, addressing issues and implementing improvements.
• Stay updated with the latest industry trends and best practices in database management and cloud technologies.

Company Benefits & Culture

• Competitive salary and benefits package.
• Opportunities for professional development and growth.
• Collaborative and innovative work environment.

For immediate consideration please click APPLY to begin the screening process with Alex.