Oracle PL-SQL Job Description
Oracle PL-SQL
provides thought leadership regarding: Industry practices around collecting data, staging data, cleansing data, standardizing data, and publishing data into data marts.
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:
Learn the details and provide design and coding support on the core MarLo (Marketing Logistics) system, an in-house comprehensive supply chain management application with powerful print-on-demand capabilities
Identify potential issues and limitations, monitor and improve application performance
Active contribution to Application Software development including requirements analysis, testing, performance tuning, optimization, re-use, and scalability of products
Develop and maintain application code using C#, ASP.NET, and Ajax controls following principles of Service Oriented Architecture
General team management duties, including moral encouragement, corrections to weaknesses and best-practices training
Build and oversee independent IT projects for customized print production (“mail-merge” with more complex business rules) and eDistribution
Participate in sales demos with our customers and prospects from a place of mastery of our systems and our business space – the healthcare arena
Hands-on experience with Technical Design & Development of Database modules and components such as database packages and procedures
Communicate with senior technical management collaborate with peers and business users in a dynamic environment
Creates and maintains all PL/SQL required for development, testing, education and production usage
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:
Data modeling concepts
Design fundamentals
Oracle PL/SQL packages
Procedure
Oracle 12C
Aggregate and analytic functions
Application
Data Marts and ODS
Data and infrastructure architecture disciplines
Health insurance industry
Desired experience for oracle PL-SQL includes:
Solid SQL Tuning, Trace, and Performance experience for 11g Oracle databases
Familiar with TDD and Unit Testing Frameworks and Test Automation
Managing Oracle objects including tables, indexes, views, constraints, db links, jobs, snapshots
Oracle PLSQL Developer, Data Modeling and Datawarehousing
Excellent verbal, written, interpersonal, organizational and time management skills is a must
Experience with leading/managing small scale teams
Oracle PL-SQL Examples
1
Oracle PL-SQL Job Description
Job Description Example
Our company is growing rapidly and is searching for experienced candidates for the position of oracle PL-SQL. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for oracle PL-SQL
- 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
Qualifications for oracle PL-SQL
- 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
2
Oracle PL-SQL Job Description
Job Description Example
Our innovative and growing company is searching for experienced candidates for the position of oracle PL-SQL. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for oracle PL-SQL
- 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
Qualifications for oracle PL-SQL
- 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
3
Oracle PL-SQL Job Description
Job Description Example
Our company is looking for an oracle PL-SQL. We appreciate you taking the time to review the list of qualifications and to apply for the position. If you don’t fill all of the qualifications, you may still be considered depending on your level of experience.
Responsibilities for oracle PL-SQL
- 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
Qualifications for oracle PL-SQL
- 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
4
Oracle PL-SQL Job Description
Job Description Example
Our innovative and growing company is looking for an oracle PL-SQL. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for oracle PL-SQL
- 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
Qualifications for oracle PL-SQL
- 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
5
Oracle PL-SQL Job Description
Job Description Example
Our company is looking for an oracle PL-SQL. We appreciate you taking the time to review the list of qualifications and to apply for the position. If you don’t fill all of the qualifications, you may still be considered depending on your level of experience.
Responsibilities for oracle PL-SQL
- 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
Qualifications for oracle PL-SQL
- 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