Datanetiix Solutions Inc.
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
Automate database build, deployment, and rollback processes integrated with CI/CD pipelines.
Define and implement robust deployment and rollback strategies for database changes.
Establish version control practices for database scripts and maintain a clear, consistent source code repository structure.
Should have Flyway and Liquibase experience.
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 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.
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.
#J-18808-Ljbffr
Key Responsibilities
Automate database build, deployment, and rollback processes integrated with CI/CD pipelines.
Define and implement robust deployment and rollback strategies for database changes.
Establish version control practices for database scripts and maintain a clear, consistent source code repository structure.
Should have Flyway and Liquibase experience.
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 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.
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.
#J-18808-Ljbffr