Fortune500 firm seeking a PL SQL Developer for their global Production environment. This PL SQL Developer works throughout the software development life cycle and performs in a utility capacity to create, design, code, debug, maintain, test, implement and validate applications with a broad understanding of a variety of languages and architectures. Analyzes existing applications or formulate logic for new applications, procedures, flowcharting, coding and debugging programs. Maintains and utilizes application and programming documents in the development of code. Recommends changes in development, maintenance and system standards. Creates appropriate deliverables and develops application implementation plans throughout the life cycle in a flexible development environment.
Job Details:
- Create, design, code, debug, maintain, test, implement and validate applications
- Analyze existing applications or formulate logic for new applications, procedures, flowcharting, coding and debugging
- Maintain and utilize documents in the development of code. Recommends changes in development, maintenance and system standards.
- Owns appropriate deliverables and develops application implementation plans throughout the life cycle in an Agile development environment.
Essential functions:
- Develops basic to moderately complex code using front and / or back end programming languages within multiple platforms as needed in collaboration with business and technology teams for internal and external client software solutions.
- Designs, creates, and delivers routine to moderately complex program specifications for code development and support on multiple projects/issues with a wide understanding of the application / DB to better align interactions and technologies.
- Provides support to leadership for the design, development and enforcement of business / infrastructure application standards to include associated controls, procedures and monitoring to ensure compliance and accuracy of data.
Required Experience:
• 6 – 8 years of development experience using PL/SQL in Oracle environment
• Very good knowledge of SQL (aggregation functions, Joins and various built-in SQL functions and data types).
• Experience in a high volume, highly scalable transaction processing environment (very large tables)
• Sound knowledge of advanced SQL, which includes analytical SQL, hierarchical SQL, dynamic SQLs and regular expressions.
•Sound knowledge of advanced PL/SQL, PL/SQL collections, external subroutines, web-interface, n/w interface, file handling functions.
• Sound knowledge for SQL performance tuning, analyzing SQL joins execution plan, indexing, partitioning and optimizer hints.
• Sound knowledge of PL/SQL performance tuning, AWR, ASH analysis, database statistics gathering.
• Good problem-solving, troubleshooting and communication skills
• Flexible with multitasking in a rapidly changing environment
• Ability to work well within a team/good collaboration skills
• In-depth knowledge of Oracle database objects – tables, indexes, collections, directories, sequences, triggers, packages, etc
Preferred Qualifications:
• Basic knowledge of Oracle database 11g and above
• Good knowledge of UNIX commands, basic understanding of Shell scripting.
• Good knowledge of Advanced Queuing, DBMS_SCHEDULER and setting up CRON jobs.
• Experience using software development tools including source control (Git, SVN), quality management ( Agile Central), and Continuous Integration tools (Jenkins, XL Release) is a plus.
• Experience with Java or other object-oriented languages helpful
Excellent benefits including full suite of medical benefits, matching 401(k), 100% remote work, excellent growth potential and much more. Please send your LinkedIn profile & detailed resume today!