What are the responsibilities and job description for the Oracle Technical Lead – Data Management Consultant position at Care IT Services Inc?
Oracle Technical Lead – Data Management Consultant | Sacramento, CA (Hybrid)
Location: Sacramento, CA – Hybrid
Duration: 12 Months
Employment Type: Contract
We are seeking an experienced Oracle Technical Lead – Data Management Consultant to lead enterprise-scale Oracle data warehouse initiatives for a high-impact public sector engagement. This role requires a strong combination of hands-on Oracle technical expertise, leadership, data architecture experience, and client-facing consulting skills.
The ideal candidate will drive the vision of an Enterprise Data Warehouse (EDW) program while mentoring teams, leading Oracle implementations, and engaging directly with executive stakeholders.
Key Responsibilities
Lead and execute enterprise Oracle Data Warehouse implementations
Drive the technical vision and delivery of EDW initiatives
Serve as the primary Oracle technical expert for architecture and implementation
Lead and mentor cross-functional data teams including DBAs, Data Modelers, ETL Developers, BSAs, and BI Analysts
Translate business and functional requirements into scalable technical solutions
Design and implement Star, Snowflake, and Hybrid dimensional data models
Develop requirements specifications and technical design documents
Perform advanced data analysis and predictive data modeling
Provide strategic guidance on data governance, architecture, and best practices
Ensure data security, backup, recovery, and disaster recovery planning
Present technical and business solutions to executive leadership and operational teams
Identify automation opportunities and recommend process improvements
Support proposal development and client-facing consulting initiatives
Required Qualifications
10 years of experience in Data Management and Data Warehousing
5 years of hands-on Oracle Database and Oracle Data Warehouse experience
5 years in consulting, technical leadership, or solution architecture roles
2 years of hands-on experience with Oracle Cloud Infrastructure (OCI)
Strong expertise in Oracle Autonomous Data Warehouse (ADW) in OCI environments
5 years of hands-on Oracle ETL development experience
Strong PL/SQL and Oracle Database development skills
Experience designing and implementing enterprise data warehouse solutions
Expertise in data modeling, data governance, and architecture documentation
Experience with backup, recovery, and disaster recovery planning
Strong communication and executive presentation skills
Experience working with Star, Snowflake, and Hybrid schemas
Preferred Qualifications
Bachelor’s Degree in Computer Science, Information Systems, or related field
OCI Associate Certification
Oracle Database SQL Certified Associate
Oracle Database Administration certifications
Public sector experience preferred
Experience in transportation or healthcare domains
Multi-domain consulting experience solving complex enterprise data challenges
Technical Skills
Oracle Database
Oracle Autonomous Data Warehouse (ADW)
Oracle Cloud Infrastructure (OCI)
Oracle ETL Tools
PL/SQL
Data Warehousing
Data Modeling
Star Schema
Snowflake Schema
Predictive Data Modeling
BI & Analytics
Data Governance
Disaster Recovery & Backup Planning
Soft Skills
Strong leadership and mentoring abilities
Excellent client communication and stakeholder management
Ability to engage with technical and non-technical audiences
Strategic thinking and problem-solving mindset
Strong consulting and presentation capabilities
Why Join Us?
Opportunity to lead enterprise-scale Oracle transformation initiatives
High-visibility consulting role with executive stakeholder interaction
Collaborative hybrid work environment
Long-term project stability with impactful public sector programs
Apply today if you are a hands-on Oracle Technical Leader passionate about enterprise data transformation and cloud-based data warehousing solutions.
Salary : $70 - $75