Oracle Database Administrator

Position Summary:

We're looking for a skilled and driven Oracle Database Architect who thrives in a data-rich environment. You will focus on managing and optimizing our existing data ecosystem, with a strong emphasis on SQL development for Oracle, Big Query, and Tableau data sources, alongside NoSQL with MongoDB. You will also contribute to our Lakehouse development and will play a key role in ensuring data accuracy while supporting the scalability of our data infrastructure.

Responsibilities: 

SQL Development & Optimization:

• Develop, optimize, and maintain SQL queries for Tableau data sources, ensuring efficient and accurate data delivery. 
• Write and optimize complex queries for Oracle and BigQuery databases to support business reporting needs. 
• Work with MongoDB, querying semi-structured data for analytics and reporting purposes. 
• Collaborate with BI developers and analysts to enhance data processing efficiency and report accuracy.

Datawarehouse / Lakehouse Initiatives: 

• Participate in early development efforts related to Lakehouse architecture initiatives. 
• Assist in preparing existing data workflows for integration with modern cloud-based data platforms. 
• Stay informed about emerging data technologies and contribute to modernization strategies. 

Data Quality & Analysis:

• Perform thorough data validation and reconciliation to ensure consistency across different data sources. 
• Identify and resolve discrepancies by working closely with data analysts and business stakeholders. 
• Support data quality assurance processes, implementing best practices to improve reliability.

Requirement:

Experience:

• Bachelors degree in Computer Science, Data Engineering, Information Systems, or a related field. 
• 5+ years of experience working with SQL and managing data pipelines. 
• Strong proficiency in SQL, with experience in Oracle and Big Query databases. 
• Experience querying MongoDB, including working with semi-structured data.

Technical Skills: 

• Advanced SQL skills for query performance tuning and optimization. 
• Knowledge of ETL/ELT processes and experience optimizing data transformations. 
• Experience working with relational (Oracle, BigQuery) and NoSQL (MongoDB) databases. 
• Experience with Python or scripting for automation. 
• Familiarity with cloud platforms such as AWS, GCP, and Azure. 
• Advantage: Hands-on experience with BI tools such as Tableau.

Collaboration and Leadership: 

• Strong analytical and problem-solving abilities. 
• Excellent collaboration and communication skills. 
• Ability to work independently and manage multiple priorities in a fast-paced environment.