Senior Oracle Developer Senior Oracle Developer Job Description: This individual will work to deliver enterprise grade software solutions with high customer impact. They will lead architecture and development activities with a specialization in at least one major enterprise IT application, one major database platform (eg, MySQL, Oracle, SQL Server), and one major operating system (eg Linux).
The Senior Data Engineer also performs all aspects of the development life cycle. They will act as the senior technical programmer for the assigned enterprise system and/or application of responsibility. Finally, they will deliver results through independent contributions and through mentoring of junior engineers.
Senior Oracle Developer Minimum Qualifications: Bachelors degree 5+ years experience designing and developing in the Oracle E-Business Suite Senior Oracle Developer Preference: A deep understanding of Oracle database architecture, Oracle SQL, PL/SQL programming, and performance tuning. Experience with Oracle database versions 19c, 12c, 11i are all acceptable. Several years of hands-on experience working with Oracle E-business with a focus on the financial applications.
Creating efficient, maintainable, and optimized PL/SQL stored code. Analyze and improve query performance, database indexing, and use Oracles performance monitoring tools. Strong documentation skills Team player that listens and contributes ideas Attention to detail Senior Oracle Developer Key Responsibilities: Works with Development staff in all application interface design, installation, maintenance and troubleshooting.
Coordinates the installation, configuration and monitoring of both systems and business-level monitoring that provides 24*7*365 feedback on systems health. Designs and develops custom software/production technology to meet LSIs business requirements. Designs and implements solutions to solve business requirements using third-party hardware and software solutions.
Documents solutions and train LSI personnel on implemented solutions. Designs, develops, and maintains Oracle database stored code and objects, including schema design, table structures, indexes, and data modeling. Optimizes database performance by fine-tuning queries, identifying and resolving bottlenecks, and implementing indexing strategies.
Develops complex PL/SQL procedures, functions, triggers, and packages to implement business logic and data manipulation. Creates and maintains database scripts, including stored procedures, views, and materialized views. Performs unit testing and debugging of PL/SQL code to ensure functionality, accuracy, and adherence to business requirements.
Proficiently handles creating and parsing XML and JSON structures and their interfaces within Oracle database applications. Troubleshoots and resolves database issues, including performance problems, data corruption, and connectivity errors. Interfaces with communication gateways to link and share relevant metadata between LSIs enterprise IT applications