JobRialto
Data Engineer
JobRialto, Nashville, Tennessee, United States, 37247
Worksite Address
8 Music Sq W, Nashville, Tennessee, United States,37203
Job Summary:
We are seeking an experienced Data Engineer with strong expertise in Oracle Database Development and deep proficiency in Oracle PL/SQL to support the design and development of modules in Client's proprietary application. This application is housed in Oracle, and the role will involve a comprehensive range of database development tasks across the full software development lifecycle. The ideal candidate will have extensive experience working with large datasets, optimizing performance, and integrating data workflows in a cloud-based development environment.
Key Responsibilities: Oracle Database Development: Design, develop, and optimize custom Oracle PL/SQL packages, stored procedures, functions, and triggers for Client's proprietary application. Create high-performance SQL queries to process large datasets efficiently, ensuring scalability and reliability. Integrate the Oracle Scheduler for on-demand tasks and automation requirements. ETL Development:
Develop ETL workflows using External tables, SQL Loader, and Oracle's UTL_FILE package.
Implement dynamic SQL and leverage BULK Collection methodologies to process large data volumes efficiently
Scripting and Automation:
Write DDL and DML scripts for creating and modifying database objects.
Implement Linux shell scripting for automation and integration with Oracle databases and other tools.
Collaboration and Code Management:
Work in a collaborative AWS Workspace development environment.
Utilize GitLab and SourceTree for source code versioning and management.
Performance Tuning:
Analyze database queries and optimize them for high performance.
Identify potential bottlenecks and design solutions to ensure optimal query performance and efficient data processing.
Communication:
Work closely with other engineers, architects, and stakeholders to understand complex technical issues and deliver effective solutions.
Document development processes and communicate technical concepts effectively across teams.
Required Skills & Qualifications:
Experience:
5+ years of hands-on experience in Oracle Database Development through all development life cycle phases. Extensive experience with Oracle PL/SQL, including the analysis, design, and creation of custom packages, stored procedures, functions, and triggers. Strong experience in writing high-performance SQL queries to handle very large datasets. Technical Skills:
Proficient in Oracle Scheduler integration for on-demand and automated tasks. Solid experience with ETL functions using External tables, SQL Loader, and UTL_FILE package. Expertise in dynamic SQL, BULK Collection methodologies, DDL, and DML scripting. Experience with LINUX shell scripting for automation and process integration. Familiarity with Quest Toad for Oracle or similar database development IDEs. Familiar with AWS Workspace development environment and deployment practices. Experience using GitLab code repositories, and tools like SourceTree for version control. Soft Skills:
Strong communication and interpersonal skills for understanding complex technical issues and collaborating with cross-functional teams. Ability to deliver clear explanations and documentation for technical solutions. Preferred Skills (Enterprise Req Skills): Experience with ETL, Big Data, and Cloud technologies. Proficiency in Python and its use in data engineering tasks. Familiarity with SQL and general data engineering practices in cloud environments, particularly AWS.
Experience Level:
Intermediate Level with 5+ years of relevant experience in Oracle Database Development.
Education:
Bachelors Degree
8 Music Sq W, Nashville, Tennessee, United States,37203
Job Summary:
We are seeking an experienced Data Engineer with strong expertise in Oracle Database Development and deep proficiency in Oracle PL/SQL to support the design and development of modules in Client's proprietary application. This application is housed in Oracle, and the role will involve a comprehensive range of database development tasks across the full software development lifecycle. The ideal candidate will have extensive experience working with large datasets, optimizing performance, and integrating data workflows in a cloud-based development environment.
Key Responsibilities: Oracle Database Development: Design, develop, and optimize custom Oracle PL/SQL packages, stored procedures, functions, and triggers for Client's proprietary application. Create high-performance SQL queries to process large datasets efficiently, ensuring scalability and reliability. Integrate the Oracle Scheduler for on-demand tasks and automation requirements. ETL Development:
Develop ETL workflows using External tables, SQL Loader, and Oracle's UTL_FILE package.
Implement dynamic SQL and leverage BULK Collection methodologies to process large data volumes efficiently
Scripting and Automation:
Write DDL and DML scripts for creating and modifying database objects.
Implement Linux shell scripting for automation and integration with Oracle databases and other tools.
Collaboration and Code Management:
Work in a collaborative AWS Workspace development environment.
Utilize GitLab and SourceTree for source code versioning and management.
Performance Tuning:
Analyze database queries and optimize them for high performance.
Identify potential bottlenecks and design solutions to ensure optimal query performance and efficient data processing.
Communication:
Work closely with other engineers, architects, and stakeholders to understand complex technical issues and deliver effective solutions.
Document development processes and communicate technical concepts effectively across teams.
Required Skills & Qualifications:
Experience:
5+ years of hands-on experience in Oracle Database Development through all development life cycle phases. Extensive experience with Oracle PL/SQL, including the analysis, design, and creation of custom packages, stored procedures, functions, and triggers. Strong experience in writing high-performance SQL queries to handle very large datasets. Technical Skills:
Proficient in Oracle Scheduler integration for on-demand and automated tasks. Solid experience with ETL functions using External tables, SQL Loader, and UTL_FILE package. Expertise in dynamic SQL, BULK Collection methodologies, DDL, and DML scripting. Experience with LINUX shell scripting for automation and process integration. Familiarity with Quest Toad for Oracle or similar database development IDEs. Familiar with AWS Workspace development environment and deployment practices. Experience using GitLab code repositories, and tools like SourceTree for version control. Soft Skills:
Strong communication and interpersonal skills for understanding complex technical issues and collaborating with cross-functional teams. Ability to deliver clear explanations and documentation for technical solutions. Preferred Skills (Enterprise Req Skills): Experience with ETL, Big Data, and Cloud technologies. Proficiency in Python and its use in data engineering tasks. Familiarity with SQL and general data engineering practices in cloud environments, particularly AWS.
Experience Level:
Intermediate Level with 5+ years of relevant experience in Oracle Database Development.
Education:
Bachelors Degree