Oracle PL-SQL Job Description
Oracle PL-SQL Duties & Responsibilities
To write an effective oracle PL-SQL job description, begin by listing detailed duties, responsibilities and expectations. We have included oracle PL-SQL job description templates that you can modify and use.
Sample responsibilities for this position include:
Oracle PL-SQL Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Oracle PL-SQL
List any licenses or certifications required by the position: CE, PGDCA, MCA, OCP, OCA
Education for Oracle PL-SQL
Typically a job would require a certain level of education.
Employers hiring for the oracle PL-SQL job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Master's Degree in Computer Science, Education, Engineering, Technical, Information Technology, Software Engineering, Software Development, Information Systems, Business, Technology
Skills for Oracle PL-SQL
Desired skills for oracle PL-SQL include:
Desired experience for oracle PL-SQL includes:
Oracle PL-SQL Examples
Oracle PL-SQL Job Description
- Setting up the goals for the team in alignment with the Enterprise Data architecture guidelines
- Partner with multiple offshore and onshore partners to deliver the best in class database solution on time
- Identify and improve engineering practices in data space by brining in best of the world practices and process
- Guide/Develop, communicate and oversee implementation of high-level and low-level design in compliance with roadmap, architecture and design standards defined by FIMT
- Drive resolution to technical issues
- Ensure development teams follow coding guidelines and practices, and conduct formal code reviews
- Drive initiatives that contribute in development of software that is efficient, re-usable and reliable
- Be part of an agile team, share knowledge, do code reviews, pro-active communication
- Boost the effectiveness of our team by helping us in optimizing our development processes
- Prepare documentation to standards for Information Systems Development, Data Operations, I.S
- Experience in ETL Tool
- Oracle DBA knowledge
- Good knowledge of Unix (Preferred)
- Good knowledge of PERL
- Fluent in the Windows platform and use of command windows, batch files, UNC paths, RDP, ODBC setup
- Must have excellent communication skills written verbal
Oracle PL-SQL Job Description
- In-depth knowledge and experience in information system architecture, software design methodologies
- To provide full impact anaylysis on the system enhancement and the testing required for the changes
- Formulate and implement systems development policies, best practice, standards and procedures for compliance
- Develop alternative procedures to solve problems or implement improvements within department
- Designing, coding, maintaining an infrastructure of data extraction and analytics processes
- Providing data analytics, prototyped solutions, and recommendations for internal and external informatics
- Developing customer metrics informatics solutions using a variety of software tools
- Developing, executing, and supporting unit tests for data, server, and client software
- Supporting existing software, infrastructure, and informatics solutions
- Designing technical solutions based on reading and understanding business and functional requirements
- Be able to provide requested support/information quickly and accurately within a multi-tasking environment
- 7 to 9 years working experiences
- Proven expertise in data analysis and facilitation
- Developer with 3 Years’ experience in Oracle PLSQL development and oracle database design
- Experience with Oracle PLSQL development in Oracle EBS environment is preferred
- Code auditing tools Sonar
Oracle PL-SQL Job Description
- Acquires knowledge of our multiple types of operations data with the desire to understand how the information is used by the business
- Work with Architects to understand new designs
- Responsible for insuring team designs and delivers code in alignment with published standards
- Experienced developer with 6+ years in development and support with proficiency Oracle/PLSQL database
- Candidate must be strong and balanced, technically and analytically
- Expert-level SQL and PL/SQL development skills
- Experience in handling large datasets in Oracle
- Experience in writing complex and optimized SQLs/Stored Procedures/Functions etc in Oracle
- Good understanding of core Oracle concepts
- Good knowledge of Oracle advanced querying techniques and writing high performing and optimized queries
- Experience in Data Modelling tools Designer or Oracle Data Modeller
- Identify data source and conduct data profiling to understand data and its quality
- Create a logic that needs to be incorporated in the architecture to ensure the data meets the requirements
- Create POC to conduct the feasibility of the requirement, as required
- Demonstrable knowledge in developing SQL and PL/SQL (Oracle)
- Ability to quickly understand the business and project need
Oracle PL-SQL Job Description
- Coding, Code Reviews & Unit Testing
- Reviewing and tuning SQL and PL/SQL code
- Deliverables to be error free while meeting requirements
- Works on periodic maintenance releases of applications, including enhancements and defect corrections
- Effectively collaborate and interact with production support, development and testing teams
- Manage workload effectively to meet timelines with good quality
- Provide prompt and proactive status updates on assigned activities
- Notify/raise issues to supervisor in a timely manner to resolve them early
- Must have a good understanding of Service Delivery Life Cycle (SDLC) Processes
- Hands on developer – migrating procedural SQL code from other DBMS to robust, high quality and performant PL/SQL code and Linux shell scripts
- Strong knowledge on RDBMS, Enterprise Data architecture
- Good development background in oracle or similar RDBMS
- Strong understanding of SDLC (having worked on Agile is a plus)
- Must working experience in Data Life Cycle, Enterprise, Logical & Physical Data Model, Data Reference Model
- Strong people management skills and exposure
- Expertise in data analysis and excellent debugging skills
Oracle PL-SQL Job Description
- Significant knowledge of PL/ SQL including tuning, triggers, and stored procedures
- Strong understanding of the different storage options used in an Oracle Database
- Knowledge & experience in how to recover a database/table/table spaces using the above mentioned methods
- Experience working with large Oracle databases in Linux environments
- Experience in refreshing databases across similar and dissimilar hardware
- Experience in the design, development, and maintenance of ETL processes
- Experience in designing the appropriate data access layer for near real-time and batch applications
- Good understanding of database design concepts to support transactional and data mart or data warehouse environments
- Experience in working with source control systems (preferably Clearcase)
- Data movement and ETL experience (Informatica) is a plus
- Financial systems knowledge (preferably brokerage or mutual fund knowledge with an emphasis on portfolio modeling/allocation, fund-of-funds, separate account management)
- Work with minimal supervision directly with investment professoinals