Senior Oracle SQL Developer
Join ABC Fitness and become part of a culture that’s as ambitious as it is authentic. We believe great work begins with great people and create an inclusive environment where every team member can bring their authentic self to work. We are doers, thinkers, and dreamers and empower you to reach new heights—personally and professionally.
Requirements
- 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.
Benefits
- Competitive PTO plans with 15 Earned accrued leave, 12 days Sick leave, and 12 days Casual leave per year
- 11 Holidays plus 4 Days of Disconnect – once a quarter, we take a collective breather and enjoy a day off together around the globe.
- Group Mediclaim insurance coverage of INR 500,000 for employee + spouse, 2 kids, and parents or parent-in-laws, and including EAP counseling
- Life Insurance and Personal Accident Insurance
- Best Life Perk – we are committed to meeting you wherever you are in your fitness journey with a quarterly reimbursement
- Premium Calm App – enjoy tranquility with a Calm App subscription for you and up to 4 dependents over the age of 16
- Support for working women with financial aid towards crèche facility, ensuring a safe and nurturing environment for their little ones while they focus on their careers
Originally posted on Himalayas