Database Architect

Newton, MA - USA

Monthly Salary: Not Disclosed

Posted on: 3 days ago

Vacancies: 1 Vacancy

Job Summary

Job Role: Database Architect

Job Location: Newton MA (Onsite)

Job Type: Contract

Need 12 years of experience resumes.

Database Architect Role Overview:

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.

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 modelling 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 Always on Availability Groups).
- Excellent analytical and problem-solving skills.
Experience:
- 10 years of experience in database design and architecture.

Thanks & Regards

Akhil

Job Role: Database Architect Job Location: Newton MA (Onsite) Job Type: Contract Need 12 years of experience resumes. Database Architect Role Overview: We are seeking a highly skilled Database Architect with deep expertise in Oracle and Microsoft SQL Server to design implement and optimize e...