Seeking PL/SQL resource with object oriented concept to develop and incorporate business processes to produce various reports, data extractions, interfaces, scheduling, data analysis, writing and tunning PL/SQL programs, improve performance.
Develop and incorporate business process to enhance systems. Write and modify pl/sql code based on requirement, enhancement and production support with specific emphasis on the development and changes related to data bound queries, sql tuning, pl/sql enhancements to get improved performance. develop data interfaces, data transfer, relational diagrams, scheduling and application code. Collaborate development activities with other team members. Create technical specification and other documents as required.
Develop and enhance PL/SQL code, tune sql code to get better performance
Provide emergency release and production support
Analyze and write data exchange interfaces, job scheduling
Identify issues with the application data, analyze and apply fixes
Support change management including test steps; code changes to build the knowledge base
Developing relational data models and system designs as needed
Provide support for application implementation
Collaborate development and integration activities with other team members and stakeholders
Work with business groups, internal-external team to understand requirement and implementation
Review application server issues, analyze and provide resolution as requested
Professional experience working with Web based applications using Oracle as the backend is required
In-depth knowledge of Oracle Database, SQL, PL/SQL programming
Strong designing, development, and troubleshooting skills required
Knowledge of object-oriented design concepts, XML, HTML, unix scripting, web scripting tools, Gitlab and CI/CD
Knowledge of scheduling, data exchange interfaces, data analysis and troubleshooting of issues required
Working experience with data security, data auditing, vulnerability scanning and report generation
Good oral and written communication skills are required
Applicants must have strong multitasking capabilities and the ability to work on multiple projects/issues simultaneously including off hours support as required
Applicants must have the ability to assess the impact of software upgrades and other environmental changes
Candidate should be able to translate functional requirement, build relational model and transfer relational model into technical design and- application code
Skills:
SkillRequired / DesiredAmountof ExperienceStrong working Experience with Oracle databaseRequired5YearsStrong PL/SQL and SQL experience including writing, tuning, enhancing and improving performanceRequired5YearsWorking experience with relational model and translating functional requirement and relational diagram/data model to an application codeRequired4YearsKnowledge of Object Oriented Design concept, XML, UNIX scripting, bi-directional data interfacesRequired2YearsScheduling jobs to automate processes, implementing and creating data auditing and reporting functionalitiesRequired2YearsReviewing, analyzing, troubleshooting and resolution of issues related to performance, data integrity, data interfacesRequired2YearsExperience with Web Toolkit, Web services development and file handling, GitLab and CI/CDDesired2Years
Powered by JazzHR
WcD4LayYQa
Seniority level
Mid-Senior level
Employment type
Contract
Job function
Information Technology
Industries
Internet Publishing
Referrals increase your chances of interviewing at Serigor Inc by 2x