投标管理团队
Developer - Oracle
职位简介
R+L Carriers 信息技术部门正在扩大规模，现有一个高级 Oracle 开发人员职位空缺。成功的候选人将在信息技术部门工作，使用 Oracle 19c 或更高版本的 SQL/PLSQL 编程语言进行开发和优化工作。候选人将作为跨职能团队的关键成员，支持公司的企业软件开发计划，与不同利益相关者合作，理解现实世界中的业务需求，并开发或优化企业级解决方案。
主要职责和任务：
- 在 Oracle 19c 中开发 PL/SQL 包、存储过程、函数、触发器和 SQL 语句
- 性能调优，包括优化 SQL 代码和 PL/SQL 包
- 维护共享工具，包括用于分片和清理的 PL/SQL 包
- 基于索引的优化，包括统计信息收集和执行计划优化
- 使用 Oracle Enterprise Manager（Cloud Control）监控和优化 SQL 语句
- 改进应用程序架构，防止高并发应用中的死锁
- 监控并减少 SQL 计划退化
- 实施 SQL 配置文件和 SQL 计划基线，以解决关键生产问题
- 为 Oracle 开发人员提供指导和支持
任职要求
- 在 Oracle 19c 中有丰富的 SQL 和 PL/SQL 编程经验（5 年以上）
- 有 Oracle 性能调优的实际经验
- 有支持关键系统并提供技术解决方案的丰富经验
- 有处理高吞吐量事务数据库的经验
- 有使用 TOAD 等开发工具的经验
- 有使用 OEM 工具如 Cloud control 的经验
- 具备强大的分析和解决问题的能力
- 具备良好的口头和书面沟通能力
我们提供全面的福利包，包括医疗、牙科、视力保险、人寿保险、401(k) 退休计划，以及在佛罗里达州迪尔比奇、加利福尼亚州大熊湖、北卡罗来纳州海洋岛海滩和田纳西州鸽子瀑布的员工度假村免费度假住宿。
最初发布于 喜马拉雅山
查看英文原文
Job Summary
R+L Carriers Information Technology Department is growing and has an immediate opening for a Senior Oracle Developer. Successful candidates will work within the Information Technology Department performing development and optimization activities in the SQL/PLSQL programming language in Oracle 19c or higher. The candidates will be key members of an interdisciplinary team supporting the company’s enterprise software development initiatives, working with different stakeholders to understand real world business requirements and to develop or optimize enterprise level solutions.
Essential Duties and Responsibilities:
- Develop PL/SQL Packages, Stored Procedures, Functions, Triggers, SQL statements in Oracle 19c
- Performance Tuning including optimizing SQL code and PL/SQL packages
- Maintaining shared tooling including PL/SQL packages that facilitate partitioning and purging
- Index based optimization, including statistics gathering and optimizing execution plans
- Work with Oracle Enterprise Manager (Cloud Control) to monitor and optimize SQL statements
- Improve application architecture to prevent deadlocks in highly concurrent applications
- Monitor and reduce SQL plan degradation
- Implement SQL profiles and SQL plan baselines to help with critical production issues
- Provide mentoring and support to Oracle developers
Qualifications
- Extensive Experience (5+ years) in SQL and PL/SQL Programming in Oracle 19c
- Proven Experience with Oracle Performance Tuning
- Extensive experience supporting critical systems and providing technical solutions
- Experience working with high volume transactional databases
- Experience working with development tools like TOAD
- Experience working with OEM tools like Cloud control
- Strong analytical and problem-solving skills
- Strong verbal and written communication skills
We offer a comprehensive benefits package that includes medical, dental, vision, life, a 401(k)-retirement plan and free vacation lodging at our employee resorts in Daytona Beach, FL, Big Bear Lake, CA, Ocean Isle Beach, NC and Pigeon Forge, TN.
Originally posted on Himalayas