Senior Oracle Data Integration Engineer (Oracle PL/SQL) - Remote Job.
Morrisvile, North Carolina, United States
Bertoni Solutions
We are a technology consulting company specializing in digital transformation, IT staff augmentation, custom software development and quality assurance.Company Description
We are a multinational team of individuals who believe that with the right knowledge and approach, technology is the answer to the challenges that business face today. We have been bringing this knowledge and approach to our customers since 2016, helping them translate technology into their success.
With Swiss roots and our own development team in Lima and throughout the region, we offer the best of both cultural areas: the talent and passion of Latin American professionals combined with Swiss organization skills and mindset.
Job Description
We are seeking a highly skilled and experienced Senior Oracle Data Integration Engineer to join our dynamic IT team. The successful candidate will be responsible for designing, developing, integrating, and maintaining Oracle database solutions to support our client's organization's critical business applications.
The Senior Oracle Data Engineer will collaborate with cross-functional teams to analyze requirements, design efficient integration solutions, database structures, write complex SQL queries, optimize performance, and ensure data integrity. This role requires strong technical expertise in Oracle database development especially around data integrations with other systems, excellent problem-solving skills, and the ability to work independently as well as part of a team.
Responsibilities:
- Collaborate with business analysts and stakeholders to understand and translate application requirements into efficient database designs and integration solutions.
- Write complex SQL queries, stored procedures, ETLs, functions, triggers, and packages to implement business logic. Optimize database performance by analyzing query execution plans, indexing strategies, and tuning SQL statements.
- Ensure data integrity and security by implementing appropriate data validation rules and access controls.
- Perform database migrations, upgrades, and patching as required.
- Develop and maintain technical documentation, including data models, schema diagrams, and standard operating procedures.
- Stay up to date with the latest Oracle technologies and best practices.
- Review and validate solution design and ensure it covers all the technical aspects.
- Coordinate with the offshore teams on the development activities and participate in solution design discussions.
Qualifications
IMPORTANT: This opportunity is available only for candidates located in Central and South America. This is a Nearshore position (offshore candidates will not be considered).
- Proven experience as an Oracle data engineer/developer or similar role. Implementing Rest web services to fetch and push data.
- Experience dealing with large data, developing complex applications, and understanding creating data models, DDL, and using Oracle Database 19c.
- Experience with data warehousing/data lake and ETL processes.
- Evaluate and validate solution interfaces, integration points, and dependencies.
- Liaising with the engineering team for project completion, reviewing ongoing operations, and rectifying issues.
- Understanding project requirements and developing detailed structure.
- Implementing best practices and coding standards
- Proficiency in performance tuning techniques and query optimization.
- Advanced written and spoken English.
- Technologies: REST APIs, PL SQL, Microsoft Azure, OCI, AWS, Node JS, JavaScript, CSS, HTML, JQUERY, and AJAX.
Additional Information
- Excellent communication skills.
- Excellent Problem-solving skills.
- Critical thinking skills.
- Attention to detail.
- Decision-making.
- Teamwork.
- Adaptability.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: APIs AWS Azure Data Warehousing DDL Engineering ETL JavaScript Node.js Oracle Security SQL
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Lead Data Analyst jobs
- Open Data Science Manager jobs
- Open MLOps Engineer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Engineer II jobs
- Open Data Manager jobs
- Open Principal Data Engineer jobs
- Open Power BI Developer jobs
- Open Data Scientist II jobs
- Open Junior Data Scientist jobs
- Open Business Data Analyst jobs
- Open Data Analytics Engineer jobs
- Open Sr Data Engineer jobs
- Open Product Data Analyst jobs
- Open Business Intelligence Developer jobs
- Open Data Analyst Intern jobs
- Open Sr. Data Scientist jobs
- Open Senior Data Architect jobs
- Open Big Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Principal Data Scientist jobs
- Open Data Quality Analyst jobs
- Open Research Scientist jobs
- Open Azure Data Engineer jobs
- Open Data Product Manager jobs
- Open Data quality-related jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open Business Intelligence-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open PhD-related jobs
- Open Deep Learning-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open PyTorch-related jobs
- Open TensorFlow-related jobs
- Open APIs-related jobs
- Open NLP-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open CI/CD-related jobs
- Open LLMs-related jobs
- Open Generative AI-related jobs
- Open Kubernetes-related jobs
- Open Hadoop-related jobs
- Open Data governance-related jobs
- Open Airflow-related jobs
- Open Docker-related jobs