SQL Developer

Position Title: Database Administrator Duration:15 Months Contract work with huge possible extension Work Location: Hybrid in (Montvale, NJ) Job Description: This is a hybrid role-3 days on site in Montvale. Skills to qualify for interview – • SQL Developer with performance tuning experience • Azure Data Lake and Azure Data Factory • Preferred certifications – AZ- 300 or AZ - 400 Job Description: 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. 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. § Any Microsoft Azure certification is a plus.