This site uses cookies. To find out more, see our Cookies Policy

Start Your Job Search:

View All Jobs at TA-Petro

Lead Oracle Developer in Westlake, OH at Travel Centers of America Petro

Date Posted: 11/18/2018

Job Snapshot

Job Description

The primary objective of the Lead Oracle Developer is to provide support and independently work on Oracle Database development. In this role, they will help design, develop, code review, and deploy quality database solutions that are consistent with project objectives, technology, architecture standards and departmental best practices. They will design and implement database strategies that adhere to industry best practices. Application space will span both the transactional and Data Warehousing areas.

Specific responsibilities include:

  • Assist the team and developers with database activities
    • Oracle Database - SQL and PL/SQL optimization including performance tuning, query optimization and supportability.
    • General technical trouble shooting and consulting with to development teams. Deep problem solving for production and other issues from a database perspective will be needed.
    • Develop and socialize a process and  schedule and manage Oracle database design and code reviews for the team
  • Design, develop, implement, and maintain
    • PL/SQL utility software to be utilized by development teams to perform common database tasks
    • An automated, controlled, and consistent database change management process
  • Ability to perform Oracle performance tuning and a good knowledge of how Oracle acquires and manages resources.
  • Work on Oracle-heavy projects across the organization as a developer and ensure that agreed upon timeframes and deliverables are met.
  • Work with operations/infrastructure DBA to provide support, including driving root cause analysis (RCA), preventative action follow-through, and participation in weekly operations reviews as needed

Job Requirements:

Must Have Technical Skills

  • Must have 8+ years Oracle working experience
  • Strong skills in SQL, PL/SQL, Linux Shell Scripting, tuning and debugging
  • Experience in Data Modeling
  • Experience in understanding Applications and how they are supported by Oracle in a short period of time
  • Experience with Management, Maintenance and Best Practices of Oracle LOB’s.

Must Have Non-Technical Skills

  • Ability to earn the respect of developers, DBA’s and Architects by demonstrating competency, dependability and leadership and helping the initiatives achieve their goals. High engagement and sense of ownership is a must.
  • Excellent analytical and organizational skills and attention to detail
  • Sense of urgency and drive to meet dates and deadlines
  • Proactive approach, willingness and learning ability to understand and support tools and technologies coming into the team
  • Strong verbal and written communication skills w/preparing reports, presentations and documentation
  • Ability to work well with development and infrastructure teams
  • Highly adaptable with ability to work in a fast paced demanding environment
  • Ability to prioritize competing demands and workload with minimum supervision

Nice to Have Skills

  • Experience with Oracle 11g to Oracle 12.2c migration is a plus
  • Experience with Virtualized Environments and Oracle EE
  • Experience with Oracle Application Express (APEX)
  • Understanding of high availability and disaster recovery requirements and solutions
  • Experience with Informatica ETL development
  • Experience supporting .NET applications
  • Experience supporting Java applications
  • Experience with Subversion, BitBucket, Bamboo, Git, Docker, Puppet, and continuous integration is a plus.

Not Ready to Apply Yet?

Why not join our talent network! Talent Networks enhance your job search and application process. Whether you choose to apply or just leave your information, we look forward to staying connected with you.