Database Architect

Role: Database Architect

Location: Newton, MA (Onsite)

Type: Contract

Job Description:

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 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 a database architecture roadmap aligned with business goals.
• Evaluate and recommend database technologies (Oracle RAC, SQL Server AlwaysOn, 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.