Senior Software Engineer

About Us

Founded in 1973, O’Neil Digital Solutions (ODS) is a leading IT consulting firm specializing in the optimization of complex end-to-end business process systems for a multitude of business verticals including Financial Services, Digital Media, Healthcare, and Transportation industries. ODS provides high-touch bespoke software engineering, systems integration, and infrastructure management services to clients of all sizes and industries. From large scale mass communication projects to highly secure and confidential data analytics using Big Data frameworks like Hadoop and AWS Redshift, ODS has a broad set of proven technical capabilities that help companies make complex digital transformations. ODS offers state of the art publishing solutions through our customer-centric applications and services include electronic document delivery, web applications, high-speed digital printing (color and black & white), automated composition, offset printing, warehousing and fulfillment services. ODS is headquartered in Los Angeles, CA and also has offices/plants in Texas and North Carolina centrally located to serve clients across the country

Summary

We are seeking a Senior SQL Software Engineer to lead the architecture, development, and optimization of SQL-driven systems that power our mission-critical applications. This role extends beyond writing queries—it's about setting engineering standards, guiding team members, shaping database architecture, and accelerating delivery through CI/CD, automation, and AI-assisted tooling.

Duties and Responsibilities

• Design, build, and optimize SQL Server solutions, including stored procedures, SSIS packages, and database schemas.
• Lead performance tuning efforts, conduct root-cause analysis, and drive improvements across SQL systems.
• Collaborate closely with business stakeholders, QA, and infrastructure teams to define requirements and deliver complete technical solutions.
• Implement and enhance CI/CD pipelines for SQL deployments using GitLab or comparable platforms.
• Use tools such as VS Code, SSMS, and Visual Studio to develop, debug, and scale solutions.
• Enforce Git best practices—including feature branching and pull requests—and perform peer code reviews.
• Mentor junior engineers and foster strong documentation and knowledge-sharing practices.
• Champion AI-powered development tools (e.g., Copilot, ChatGPT) to improve efficiency, automate workflows, and elevate code quality.

Qualifications & Requirements

Preferred Technical Skills (not all required):
SQL Server, T-SQL, SSIS, stored procedures, user-defined functions, linked servers, synonyms, ASP.NET, C#, .NET Framework/.NET Core, Python, Web API development, Entity Framework, Git/GitLab, VS Code, Visual Studio, Postman, CI/CD pipelines, unit testing frameworks (xUnit, pytest), and familiarity with Azure or AWS.

Additional Requirements:

• 4–6 years of professional experience with SQL Server, T-SQL, SSIS, and stored procedure development.
• Bachelor’s degree in Computer Science, Information Systems, or related field, or equivalent professional experience.
• Strong communication skills with demonstrated leadership and mentoring experience.

Bonus Experience

• Experience with cloud data platforms (Azure SQL, AWS RDS, etc.).
• Background in relational modeling, OLTP systems, or BI/reporting infrastructures.
• Familiarity with data privacy regulations such as HIPAA or GDPR.

Working Conditions

Must be able to perform the essential job duties. Work is performed primarily in an office environment. Typically requires the ability to sit for extended periods of time (66% each work day), ability to hear the telephone, ability to enter data on a computer and may also require the ability to lift up to 10 pounds.

Equal Opportunity Employer

The work environment characteristics described here are representative of those an employee encounters while performing the essential duties of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. The information in this position description indicates the general nature and level of work to be performed. It is not designed to be interpreted as a comprehensive inventory of all duties, responsibilities, and qualifications required of employees assigned to this job. Management reserves the right to revise the job description or require that other tasks be performed when the circumstances of the job change (for example, emergencies, change in personnel, workload, or technical development). This does not alter the nature of the at-will employment between the employer and employee where either party can end the relationship at any time, for any reason or no reason, with or without notice.