Principal Oracle IT Data Engineer

ABC Fitness is the #1 software provider for fitness businesses worldwide, supporting a vast network of clubs and members. They are seeking a Principal Oracle IT Data Engineer to design, develop, and maintain data solutions while collaborating with various teams to enhance data processes and performance.

Responsibilities:

• Design, develop, test, implement, and maintain PL/SQL code, UNIX scripts, Views for reporting and other needs
• Versioning and ETL changes as per the requirements, experience with a variety of transformations like Aggregate, Derived Column, Conditional Split and Data Conversion, Transaction, Checkpoints, SSIS Package Management, Debugging, Error handling and logging, SSIS Package deployment etc
• Design and develop solutions using SQL and PL/SQL with DBLinks from heterogeneous data sources
• Create/Modify complex and large queries, writing/modifying stored procedures, functions, implementing error handling logic, performance tuning and query optimization, bug fixing, data auditing and Production Job monitoring
• Create/Modify tables, keys and indexes
• Perform sequel tuning, use SQL Plans and AI tools to identify bottleneck in performance
• Strong concepts of Data Warehousing, strategies for ETL
• Work closely with different teams for manual processes as well as resolving issues
• Troubleshoot data and workflow issues within the data warehouse, as well as transactional databases
• Work closely with team members, DBAs, and business analysts to implement a sound solution, while adhering to agile methodology and lean integration techniques
• Automate and monitor jobs, rectifying issues within a timely manner ensuring SLAs are met
• Logical and physical database design following best practices and standards
• Work efficiently to resolve production support issues, escalating issues as needed
• Maintain proficiency in a variety of computer programming languages, such as SQL, PL/SQL, Unix shell scripting, in order to successfully complete the tasks of the role
• Provide documentation of new processes, as well as update and maintain existing documentation as needed

Requirements:

• Typically, 8+ years' of programming experience using Oracle SQL and PL/SQL
• Minimum 5 years' of programming experience using scripting
• Experience with Oracle Scheduler, UNIX Crontab and OEM
• Experience using both Oracle Transactional Database and Oracle Datawarehouse
• Bachelor's degree in Information Technology or related field from an accredited college or university
• In depth knowledge of relational database systems, specifically Oracle
• Minimum 2-3 years Data Warehousing experience
• Hands-on experience with gathering business requirements, documenting the reporting and analysis specifications, designing technical architecture, installing and configuring all components of an ETL tool, creating complex mappings, sessions, and workflows. Demonstrates sound understanding of development methodology
• Experience developing using Oracle APEX
• Proficient in a variety of computer programming languages, such as SQL, PL/SQL, Unix shell Scripting, to successfully complete the tasks of the role
• In-depth knowledge of relational database systems
• Update and maintain Entity Relational Diagrams as required
• Able to set and achieve standards, goals, and objectives with minimal supervision. Ability to clearly prove value to the company and achieve profitable results
• Ability to fit, mold, and adapt within the dynamics of multi-functional, self-directed workgroups. Ability to encourage and assist peers in reaching their individual and team-oriented goals and objectives
• Effectively convey the needs of our products to vendors and prospective suppliers. The ability to effectively convey the capabilities and limitations of equipment, hardware, drivers, etc. to ABC Developers, Business Analysts, and other internal staff. Ability to write reports that effectively convey information in concise, readable terms
• Ability to effectively present ideas and solutions to small or large audiences of customers, clients, vendors, suppliers, managers, and other stakeholders. Able to relate to both technical and non-technical users
• Build and foster positive interpersonal rapport with internal and external stakeholders
• Ability to discern when the business goals and objectives of others might take precedence over assigned goals and objectives
• Must be able to identify problems based on subtle indicators. Must be able to develop options to solve problems in a timely manner and apply logic and reasoning to determine and implement optimum solutions
• Ability to solve problems using deductive reasoning skills in a timely manner
• Flexibility and adaptability to frequent change