Database Solutions Architect - ConsultNet

Database Solutions Architect
Valencia, CA- 100% onsite
Direct Hire
$150k-$160k year

Immediate hire. Will be responsible for the design, implementation, integration, monitoring and error handling of the buildout of a new platform into and out of current company systems. Responsible for engineering and maintaining data integration interfaces. Manages IT data technology methods and Integrations between company systems (on-premise and cloud). Work closely with members of the IT team to ensure that all data workflows are consistently compliant with services (cloud, third party, database, analytics) and integrate with other company services. Responsible for maintaining company data workflows for best data management practices and governance. Produce and maintain complex data workflows to meet all the quality requirements of enterprise applications. Responsible for performance tuning of all MS SQL databases. Design and document dataflow architecture. Builds database schema, tables, procedures and permissions as necessary with DBA team. Creates, tests and executes data management for testing systems and applications. Develops reporting from various data systems. Participate in an Agile development environment by attending standups and sprint planning activities. Familiar with integrations to/from MS Azure and AWS environments; ability to diagnose, alert and monitor data. Understands and supports key applications for bi-directional data integrations to systems such as MS SQL backend systems: middleware, Proship manifest, Core2 (proprietary ERP), Epicor (ERP), Salesforce.com (CRM), and others as assigned.

Requirements:

• Minimum 5-7 years of systems and data pathway management experience in an enterprise environment.
• 6+ years of experience creating, interacting, and maintaining secure APIs (REST, SOAP).
• Expert knowledge of some data integration tools/applications (e.g., Jitterbit, EDI translaters, SSIS, SSRS, DMT, etc.).
• Strong experience with integrations (HL7, FHIR, EDI, cXML, etc.) to enterprise environments including EMR/EHR systems.
• Exposure to integrating cloud-based enterprise applications via real-time, batch, sync/async, ETL.
• Proficiency in at least one programming language is required.
• 4-Year BS / BA college degree preferred.

Welcome to ConsultNet and the family of companies, Tekne, SaltClick, TechBridge, and OmniMedia. As a premier national provider of technology talent and solutions, our expertise spans across project services, contract-to-hire, direct placement, and managed services both onshore and nearshore.

Celebrating more than 25 years of partnership with a diverse client base, we've crafted rewarding opportunities for our consultants, fostering high-performing teams that deliver impactful results.

Over the last few years thousands of consultants have found their calling with us in roles that have made a meaningful impact on their lives, enhanced their career, challenged them, and propelled them towards achieving their personal and professional goals. At the ConsultNet family of companies, we believe effective communication is crucial in aligning the right job with your unique skills and professional aspirations. To us, it's all about the personal approach we take and the values we uphold.

Our comprehensive service offerings cover a wide range of technology positions across key markets nationwide. Client more at www.consultnet.com .

We champion equality and inclusivity, proudly supporting an Equal Opportunity Employer policy. We welcome applicants regardless of Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other status protected by law.