Datanetiix Solutions Inc.
Database Architect (Newton)
Datanetiix Solutions Inc., Newton, Massachusetts, United States, 02165
Job Title: Database Architect
Location: Newton, MA (Onsite)
Duration: Contract
Job Description:
Database Architect Role (Database Architect including Dev Ops experience) 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. Should have flyway and liquibase experience 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 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.
Job Description:
Database Architect Role (Database Architect including Dev Ops experience) 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. Should have flyway and liquibase experience 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 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.