Job Description
Job Title: Database Architect
Location: Newton, MA (Onsite)
Duration: Contract
Job Description:
Database Architect Role (Database Architect including Dev Ops experience)
We are seeking a highly skilled Database Architect with deep expertise in Oracle and Microsoft SQL Server to design, implement, and optimize enterprise-level database solutions. This role involves creating scalable, secure, and high-performing database architectures that align with business objectives and technical standards.
Key Responsibilities:
Database Build and Deploy Operations
- Automate database build, deployment, and rollback processes integrated with CI/CD pipelines.
- Define and implement robust deployment and rollback strategies for database changes.
- Create sanitized, lightweight databases for feature development environments.
- Establish version control practices for database scripts and maintain a clear, consistent source code repository structure.
- Should have flyway and liquibase experience
Database Architecture & Design:
- Develop logical and physical data models for complex applications.
- Design schemas, tables, indexes, and relationships for optimal performance.
- Define data governance policies, standards, and best practices.
Technology Strategy & Planning:
- Create database architecture roadmap aligned with business goals.
- Evaluate and recommend database technologies (Oracle RAC, SQL Server Always On, cloud solutions).
Plan for high availability, scalability, and disaster recovery.
Performance & Optimization:
- Design for query efficiency, indexing strategies, and storage optimization.
- Collaborate with DBAs and developers for performance tuning.
Integration & Security:
- Define data integration strategies across systems and platforms.
- Ensure compliance with security standards and regulatory requirements.
Collaboration & Leadership:
- Work closely with application architects, business analysts, and DBAs.
- Provide technical guidance and mentorship to development teams.
Required Skills & Qualifications:
Technical Expertise:
- Strong experience in Oracle 12c/19c and SQL Server 2016/2019 architecture.
- Proficiency in data modeling, PL/SQL, T-SQL, and performance tuning.
- Knowledge of ETL processes, data warehousing, and cloud databases (Azure SQL, Oracle Cloud).
Additional Skills:
- Familiarity with enterprise architecture frameworks.
- Strong understanding of high availability solutions (Oracle RAC, AlwaysOn Availability Groups).
- Excellent analytical and problem-solving skills.
Experience:
- 10+ years of experience in database design and architecture.