Senior Oracle SQL Developer

Junte-se à ABC Fitness e faça parte de uma cultura tão ambiciosa quanto autêntica. Vamos transformar o futuro do fitness — juntos!

Acreditamos que um grande trabalho começa com grandes pessoas. Por isso, nossa cultura é construída com base no respeito, na confiança e no sentimento de pertencimento. Criamos um ambiente inclusivo onde cada membro da equipe pode trazer sua autenticidade para o trabalho — porque perspectivas diversas impulsionam a inovação e geram impacto significativo.

Somos realizadores, pensadores e sonhadores. Na ABC Fitness, o seu crescimento é o nosso investimento. Por meio de aprendizado contínuo, mentoria e oportunidades de desenvolvimento profissional, capacitamos você a alcançar novos patamares — pessoal e profissionalmente.

Desde o primeiro dia, você fará parte de uma equipe que colabora, celebra e se importa. Agimos com rapidez, apoiamos uns aos outros e nos divertimos ao longo do caminho. Porque quando você prospera, todos prosperamos.

• 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 and experience with using SQL Plans 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.

• Minimum 5 years experience programming using Oracle SQL and PL/SQL.

• Minimum 2 years experience of shell scripting.

• Experience with Oracle Scheduler, UNIX Crontab and OEM.

• Experience using both Oracle Transactional Database and Oracle Data warehouse.

• 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 with SQL Server.

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