SQL Database Developer

Reposted 3 Days Ago
Be an Early Applicant
Montvale, NJ, USA
In-Office
Mid level
Software
The Role
The Database Developer will design and implement database solutions, optimize queries, ensure data integrity, and collaborate with stakeholders to meet data needs.
Summary Generated by Built In

Orion Innovation is a premier, award-winning, global business and technology services firm.  Orion delivers game-changing business transformation and product development rooted in digital strategy, experience design, and engineering, with a unique combination of agility, scale, and maturity.  We work with a wide range of clients across many industries including financial services, professional services, telecommunications and media, consumer products, automotive, industrial automation, professional sports and entertainment, life sciences, ecommerce, and education.


Job Description:
• 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.
 
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.

Orion is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, creed, religion, sex, sexual orientation, gender identity or expression, pregnancy, age, national origin, citizenship status, disability status, genetic information, protected veteran status, or any other characteristic protected by law.

Candidate Privacy Policy

Orion Systems Integrators, LLC and its subsidiaries and its affiliates (collectively, “Orion,” “we” or “us”) are committed to protecting your privacy. This Candidate Privacy Policy (orioninc.com) (“Notice”) explains:

  • What information we collect during our application and recruitment process and why we collect it;
  • How we handle that information; and
  • How to access and update that information.

Your use of Orion services is governed by any applicable terms in this notice and our general Privacy Policy.


Skills Required

  • Bachelor's degree in Computer Science, Information Technology, or a related field
  • Proven work experience as a Database Developer or in a similar role
  • Strong knowledge of database management systems
  • Proficiency in SQL programming and query optimization
  • Experience with database design and data modeling concepts
  • Familiarity with database security and data privacy regulations
  • Understanding of software development methodologies and principles

Orion Innovation Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Orion Innovation and has not been reviewed or approved by Orion Innovation.

  • Wellbeing & Lifestyle Benefits Orion highlights health and well-being initiatives such as fitness, mindfulness, and flexibility/remote options, reinforced by recognition like Cigna’s Healthy Workforce Designation. Flexibility via hybrid/remote work is positioned as a consistent part of the overall rewards experience.
  • Fair & Transparent Compensation Pay is characterized as moderately satisfactory overall, with pockets where compensation is viewed as fair, particularly for some software engineering and certain U.S. roles. Public snapshots also indicate that competitiveness can be stronger in specific markets and functions.
  • Career-Linked Recognition & Rewards Performance-linked outcomes are implied through mentions that hikes can be good when performance is demonstrated. Learning and development programs are also emphasized as part of the broader value proposition tied to career growth.

Orion Innovation Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Edison, NJ
3,410 Employees
Year Founded: 1993

What We Do

Orion is a leading digital transformation and product development services firm. Headquartered in Edison, NJ, we have a global team of 6,200+ associates, with engineers in 14 major delivery centers across North America, Europe, Asia Pacific and Latin America. For over 25 years, Orion has been solving complex business problems for our clients. Our transformative business solutions are rooted in digital strategy, experience design, and engineering, empowering our clients to operate with agility at scale.​ Our mission is to serve as an agile and trusted partner for business transformation initiatives, providing deep emerging technology, experience design, and domain expertise.​ Our business has more than tripled over the last three years. ​ We have grown aggressively both organically and inorganically, adding new clients, complementary skills, domain expertise, and strengthening our global footprint.

Similar Jobs

STEM Xpert Logo STEM Xpert

Senior Database Engineer

Professional Services • Consulting • Industrial
In-Office
Jersey City, NJ, USA
125 Employees

ZS Logo ZS

Senior Director - Product Management - Field Incentives

Artificial Intelligence • Healthtech • Professional Services • Analytics • Consulting
Hybrid
5 Locations
15000 Employees

ZS Logo ZS

Advanced Data Science Associate

Artificial Intelligence • Healthtech • Professional Services • Analytics • Consulting
Hybrid
6 Locations
15000 Employees
105K-119K Annually

ZS Logo ZS

Consultant

Artificial Intelligence • Healthtech • Professional Services • Analytics • Consulting
Hybrid
3 Locations
15000 Employees
160K-177K Annually

Similar Companies Hiring

Hanover Park Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
42 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account