Scalence L.L.C. · 2 months ago
Information Technology - Data/Database Administration - Database Developer (SQL Developer/DBA)
Montvale, NJ
Full-time
Onsite
Mid Level
$60/hr - $70/hrScalence L.L.C. is a consulting firm seeking a Database Developer (SQL Developer/DBA) for a contract position. The role involves designing and implementing data models, managing database systems, and optimizing performance while collaborating with cross-functional teams.
Information Technology & Services
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
Act with integrity, professionalism, and personal responsibility to uphold the firm’s respectful and courteous work environment
Qualification
Required
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
Preferred
Any Client Azure certification is a plus
Company
Scalence L.L.C.
In today’s dynamic and competitive market, success hinges on mastering three key areas: Data Intelligence, Business Resilience, and Digital Experience.
501-1000 employees
Funding
Current Stage
Late StageCompany data provided by crunchbase