Database Architect

Newton, MA - USA

Monthly Salary: Not Disclosed

Posted on: 6 hours ago

Vacancies: 1 Vacancy

Job Summary

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 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.

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 ...