Job Description
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.
We are looking for an experienced Database Architect to design and govern scalable, secure, and high-performing database solutions across enterprise applications. The ideal candidate should have strong expertise in database architecture, data modeling, performance tuning, cloud databases, security, and DevOps-enabled database deployments.
This role will work closely with application teams, DevOps, infrastructure, and business stakeholders to define the right database strategies and ensure robust, future-ready solutions.
Key Responsibilities
- Design logical, physical, and conceptual data models
- Define database architecture standards, schema design, naming conventions, and best practices
- Design scalable, multi-tenant, and high-availability database solutions
- Evaluate and recommend the right database technologies such as SQL Server, Azure SQL, PostgreSQL, DB2, and NoSQL platforms
- Optimize database performance through indexing, query tuning, partitioning, and execution plan analysis
- Design and implement security controls including access management, encryption, masking, and auditing
- Ensure compliance with standards such as GDPR, SOX, HIPAA, PCI, where applicable
- Define backup, restore, disaster recovery, and data integrity strategies
- Support CI/CD and automated database deployments using DevOps practices
- Collaborate with development and architecture teams to review and approve database designs
- Create ER diagrams, architecture documents, and runbooks
- Mentor developers / DBAs on database best practices
Required Skills
- Strong experience in SQL Server / Azure SQL Database
- Good experience in PostgreSQL and DB2
- Strong knowledge of data modeling, normalization, and database design
- Expertise in SQL performance tuning, indexing, query optimization, and execution plans
- Experience with cloud database architectures, preferably on Azure
- Understanding of high availability, failover, backup, and disaster recovery
- Knowledge of database security, access control, and compliance-driven design
- Experience with Git, CI/CD, Terraform / Bicep / ARM, Azure DevOps or GitHub Actions
- Good understanding of microservices, distributed systems, and integration-heavy applications
- Strong documentation, communication, and stakeholder management skills
Preferred
- Experience with NoSQL databases such as Cosmos DB / MongoDB / DynamoDB
- Exposure to regulated industries like Banking, Insurance, Healthcare, etc.
- Strong architectural thinking with ability to balance scalability, security, and business needs
Soft Skills
- Strong analytical and problem-solving ability
- Excellent communication and collaboration skills
- Ability to influence and challenge design decisions constructively
- Mentorship and leadership mindset
THIS IS 5 DAYS WORK FROM OFFICE OPPORTUNITY
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.