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!