What are the responsibilities and job description for the Database Architect position at Smart IT Frame LLC?
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.