Sr. Oracle C2M Data Architect - SQL

<p><b>Role: </b>Sr. Oracle C2M Data Architect - SQL</p>

<p><b>Duration: 5-</b>6+ Months (W2) (Extension Possible)<br />
L<b>ocation: </b>Richmond VA. (Candidates should be available to be onsite at least once a month.)</p>

<p><strong>Key Skills: Oracle Utilities Application Framework (OUAF), C2M/CCS, MDM, Oracle PL/SQL, Power BI</strong></p>

<p>The ideal candidate <b><u>must have a deep understanding of the Oracle Customer Cloud Solution (C2M/CCS) database table model</u></b> and possess advanced / expert level SQL query writing skills.</p>

<p><b>Responsibilities: </b></p>

<p>• Develop, optimize, and maintain complex SQL queries to identify and extract required data.</p>

<p>• Collaborate with project team members to understand complex data requirements and translate them into efficient database queries to retrieve the required data. </p>

<p>• Document &amp; organize authored queries for future reference.<br />
• Design, implement, and maintain efficient database queries to support Testing, Reporting, Conversion teams and other project needs as required<br />
i. Project objectives:<br />
• Ensure schedule, scope and budget are maintained.<br />
• Ensure end-user readiness</p>

<p><br />
<b>Performance standards: </b></p>

<p>• Expert knowledge of the CCS, Power BI, MDM tables and OUAF data model </p>

<p>• Expert level knowledge of Oracle SQL and PL/SQL developer tools </p>

<p>• Expert in writing and optimizing complex SQL queries against large datasets to retrieve specific data • Proficiency in Data Analysis and SQL Tuning </p>

<p>• Experience using analytical functions to extract data such as rank and row number. </p>

<p>• Excellent problem-solving skills, attention to detail and work well under pressure.</p>
 <br />
Email your resume to<u>: </u><a href="mailto:usjobs@mavensoft.com">usjobs@mavensoft.com</a> <br />
To learn more about Mavensoft visit us online at <a href="http://www.mavensoft.com/">http://www.mavensoft.com/</a>