Database Architect

Neotech Global; Newton (MA); On-site; USD 150,000 - 210,000; Full time

Job summary

A technology consulting firm is seeking an experienced database architect to design and implement high-performance database solutions. The ideal candidate will have over 10 years of experience in database design and architecture, with strong proficiency in Oracle and SQL Server. Responsibilities include developing data models, defining governance policies, and ensuring system security and compliance. This role requires excellent analytical skills and the ability to mentor teams while collaborating closely with various stakeholders.

Qualifications

• 10+ years of experience in database design and architecture.
• Strong understanding of high availability solutions (Oracle RAC, AlwaysOn Availability Groups).
• Familiarity with enterprise architecture frameworks.
• Experience with enterprise architecture frameworks and high availability solutions (Oracle RAC, AlwaysOn).
• 10+ years of experience in database design and architecture.

Responsibilities

• 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.
• Evaluate and recommend database technologies (Oracle RAC, SQL Server AlwaysOn, cloud solutions).
• Plan for high availability, scalability, and disaster recovery.
• Plan for high availability, scalability, and disaster recovery.
• Design for query efficiency, indexing strategies, and storage optimization.
• Collaborate with DBAs and developers for performance tuning.
• Define data integration strategies across systems and platforms.
• Ensure compliance with security standards and regulatory requirements.
• Work closely with application architects, business analysts, and DBAs.
• Provide technical guidance and mentorship to development teams.

Skills

Oracle 12c/19c expertise

SQL Server 2016/2019 architecture

Data modeling

PL/SQL

T-SQL

Performance tuning

ETL processes

Data warehousing

Cloud databases (Azure SQL, Oracle Cloud)

Analytical skills

Problem-solving skills

Analytical problem-solving

Job description

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.

• 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.
• 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.
• Work closely with application architects, business analysts, and DBAs.
• Provide technical guidance and mentorship to development teams.