What are the responsibilities and job description for the Data Architect position at Jobs via Dice?
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Prophecy Consulting, is seeking the following. Apply via Dice today!
Experience : 15 years
Job Overview
We are seeking an experienced Data Architect PL/SQL to design, develop, and optimize enterprise data architecture solutions. The ideal candidate will have strong expertise in PL/SQL, database design, and performance tuning, with the ability to translate business requirements into scalable data solutions.
Key Responsibilities
Experience : 15 years
Job Overview
We are seeking an experienced Data Architect PL/SQL to design, develop, and optimize enterprise data architecture solutions. The ideal candidate will have strong expertise in PL/SQL, database design, and performance tuning, with the ability to translate business requirements into scalable data solutions.
Key Responsibilities
- Design, develop, and optimize enterprise data architecture solutions using PL/SQL.
- Create and maintain complex database objects (procedures, functions, packages, triggers).
- Develop and optimize data models to support analytics, reporting, and transactional systems.
- Collaborate with stakeholders to gather requirements and deliver technical solutions.
- Ensure database performance, scalability, and reliability through proactive tuning and optimization.
- Support ETL processes and data integration activities across multiple systems.
- Document data architectures, design patterns, and technical specifications.
- Provide guidance and mentorship to development teams on database and data architecture best practices.
- Strong expertise in PL/SQL programming for data architecture and development.
- Proven experience in designing and implementing enterprise data architectures.
- Proficiency in relational database design and data modeling (conceptual, logical, physical).
- Hands-on experience with performance tuning and query optimization.
- Ability to analyze business requirements and translate them into scalable solutions.
- Strong problem-solving and troubleshooting skills.
- Knowledge of ETL/ELT processes and integration with large-scale data platforms.
- Experience with cloud databases (Oracle Cloud, AWS RDS, Azure SQL, etc.).
- Familiarity with data governance and data quality frameworks.
- Strong communication and collaboration skills across technical and business teams.
