Principal Oracle IT Data Engineer

Role Description

Join ABC Fitness and become part of a culture that’s as ambitious as it is authentic. Let’s transform the future of fitness—together!

Responsibilities:

• Design, develop, test, implement, and maintain PL/SQL code, UNIX scripts, and 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, 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 SQL tuning, use SQL Plans and AI tools to identify bottlenecks 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.

Qualifications

• 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.

Requirements

• 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.
• Experience developing using Oracle APEX.
• Proficient in a variety of computer programming languages, such as SQL, PL/SQL, Unix shell scripting.
• 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.
• 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.

Benefits

• Purpose led company with a Values focused culture – Best Life, One Team, Growth Mindset.
• Time Off – with our open PTO policy, we offer flexibility in how and when you take PTO!
• Days of Disconnect – once a quarter, we take a collective breather and enjoy a day off together around the globe.
• Parental & Pawternity Leave – we offer leave for when your family grows by two feet or four paws!
• Best Life Perk – we are committed to meeting you wherever you are in your fitness journey with a quarterly reimbursement.
• Medical/Dental/Vision coverage.
• EAP – we get you help when you need it. Period.
• Premium Calm App – enjoy tranquility with a Calm App subscription for you and up to 4 dependents over the age of 16.
• And more! – so many benefits we couldn’t even fit them all here!