PL-SQL developer remote position 10+ Years MUST at Remote, Remote, USA |
Email: [email protected] |
From: Eli, RCube Creative Consulting [email protected] Reply to: [email protected] Position: PL/SQL developer remote position Location: Remote Compensation: Open on CTC Contract: Long Term Years Of Exp : 10+ Years MUST Client: Transport Firm jd is below- Participate in business requirement discussions, design meetings, functional and technical discussions, brainstorming sessions. Study and understand the existing data model like logical (LDM), physical (PDM) and entity relationship diagrams (E-R) using oracle. Designing, modifying, developing, writing and implementation of software programming applications Creation of database (PL/SQL) objects like Tables, Views, Materialized Views, Sequences, Procedures, Functions and Packages etc., as per the business requirements to make new enhancements. Creation of database (PL/SQL) objects like Indexes, Bulk Binds, Constraints and implementing the Bulk Processing (Bulk Collect/For All) and Hints on Tables/SQLs for Performance Tuning of the database by making use of Explain Plan, TKPROF & DBMS Profiler. Creation of packages, procedures, pipelined table functions, jobs, programs, triggers, Object types, leveraging Oracle 12cs new features. Participate in full development life cycle of enterprise scaled software applications utilizing Oracle, object-oriented analysis, design, and implementation of web-based applications. Analyze and solve application issues in various environments like DEV, TEST, UAT and Production. Provide debugging and code analysis support and support implementation of application software releases and other related activities like scheduling and running the jobs. Work closely with the QA and business team to investigate issues and find out the root cause for issues and resolve any data discrepancies in the Waterfall and Agile Data Models. Participate in the testing process through test review and analysis, test witnessing and certification of software system analysis, design and implementation of web-based applications. Provide production support for system issues to include warranty support for software solutions that involves both On Call and after hours support. Skills & Tools used: Oracle Database 12c, PL/SQL Developer, Oracle performance tuning, HP Quality Center, TOAD. Control-M, Unix, Linux, MS Power Point, MS Word, MS Excel. Keywords: quality analyst rlang hewlett packard microsoft procedural language |
[email protected] View all |
Mon Sep 25 19:00:00 UTC 2023 |