Apexsync Technologies · 1 day ago
Database Architect
Boston, MA
Contract
Onsite
Senior Level, Lead/Staff
10+ years expApexsync Technologies is seeking a Database Architect responsible for designing a dimensional Data Warehouse that supports optimized information for Data visualization and integration with AI. The role involves maintaining, securing, and operating databases to ensure data accessibility, accuracy, and protection while optimizing performance and managing backups.
Staffing & Recruiting
Hiring Manager
Aravindan Chandrasekaran
Responsibilities
Having 10+ years of experience in designing and implementing Data Warehouse solutions
Leading data migration initiatives to cloud platforms like Snowflake and ensuring smooth integration of data lakes, data warehouses, and distributed systems on Cloud (AWS/Azure)
Must have hands on experience in Data modelling and Data Warehouse design and should be familiar with data modelling tools like Erwin or similar
Able to handle different databases like Oracle, SQL Server and Snowflake
Must be hands on with SQL and PL/SQL is required
Must have good understanding of Metadata management, Database schema creation and management and Data Integrity and Data quality concepts
Experience in customer-facing roles to provide data related Solutions for Data use cases
Good understanding on OLTP and OLAP data models is required
Good understanding on monitoring and Performance Tuning and optimization
Excellent communication & leadership skills
Qualification
Required
10+ years of experience in designing and implementing Data Warehouse solutions
Leading data migration initiatives to cloud platforms like Snowflake and ensuring smooth integration of data lakes, data warehouses, and distributed systems on Cloud (AWS/Azure)
Must have hands on experience in Data modelling and Data Warehouse design and should be familiar with data modelling tools like Erwin or similar
Able to handle different databases like Oracle, SQL Server and Snowflake
Must be hands on with SQL and PL/SQL is required
Must have good understanding of Metadata management, Database schema creation and management and Data Integrity and Data quality concepts
Experience in customer-facing roles to provide data related Solutions for Data use cases
Good understanding on OLTP and OLAP data models is required
Good understanding on monitoring and Performance Tuning and optimization
Excellent communication & leadership skills
Languages – Java, Python
AWS - Glue, Azure – ADF, Synapse
Snowflake
ETL – Informatica/SSIS
Company
Apexsync Technologies
Apexsync Technologies is a premier IT staffing firm, specializing in connecting top tech talent with leading organizations across industries.
51-200 employees
H1B Sponsorship
Apexsync Technologies has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (14)
Funding
Current Stage
Growth StageCompany data provided by crunchbase