PL SQL Developer Job Description
PL SQL developer
provides technical expertise to design efficient solutions to consolidate data from RDBMS (Oracle\MySQL\PostgreSQL\SQL Server), Enterprise Applications and 3rd party API through ELT processes.
PL SQL Developer Duties & Responsibilities
To write an effective PL SQL developer job description, begin by listing detailed duties, responsibilities and expectations. We have included PL SQL developer job description templates that you can modify and use.
Sample responsibilities for this position include:
Experienced in the Development and support of Java Web Applications and services as specified by our business partners
Exposure to powerhouse or any other 4GL language, core Java is an added advantage
Be the go-to expert for Oracle and PL/SQL
Participate in coding and enhancements
Tune, script, and extract, transform, and load
Support daily business operations related systems
Run systems manually (test files, re-runs, ) for exception cases
Development and support Applications and services as specified by our business partners
May serve as technical project lead
Use research, proof of concept, spike testing, to drive technology roadmap and make technology recommendations
PL SQL Developer Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for PL SQL Developer
List any licenses or certifications required by the position: CE, TIBCO, OCP, OCA, SA, BW
Education for PL SQL Developer
Typically a job would require a certain level of education.
Employers hiring for the PL SQL developer job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and University Degree in Computer Science, Technical, Engineering, Education, Software Engineering, Business, Information Technology, Mathematics, Information Systems, Statistics
Skills for PL SQL Developer
Desired skills for PL SQL developer include:
Data modeling concepts
Design fundamentals
Oracle PL/SQL packages
Procedure
Java
Oracle 12C
Oracle partitioning practices and data archival structures and processes
TOAD and ERWIN
Aggregate and analytic functions
Health care claims and health insurance industry
Desired experience for PL SQL developer includes:
Work in an agile environment interacting with architects, cross functional engineering teams, Product Management, QA, and Credit teams to ensure we develop the correct product for the job at hand
Be able to understand and contribute to technical domain architecture
Workload Management (AutoSys)
File Transfer solutions using FTP / MQFTE
The candidate should have a positive outlook, with the personality to work with the development committee present to business or IT senior managers as required
Minimum 5 + years PL/SQL
PL SQL Developer Examples
1
PL SQL Developer Job Description
Job Description Example
Our company is looking to fill the role of PL SQL developer. 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 PL SQL developer
- Should have a good knowledge in Advanced PL/SQL
- Should have very good communication skills/interpersonal skills and experience in interacting with North America counterparts/clients
- Should have exposure to Unix and shell scripting
- Exposure to debugging and troubleshooting is an added advantage
- Should be willing to work in North America shift timings and providing on-call support on weekends
- Exposure to the financial domain is an added advantage
- Responsible for the design, development, coding, testing, debugging and documentation of applications to satisfy the requirements of user areas
- May include hands-on new development support, maintenance or enhancement of existing applications
- Commit to and actively work to remain knowledgeable in latest coding languages, database software, system, standards
- Model, design and maintain data warehouse including table structures, stored procedures, views and functions
Qualifications for PL SQL developer
- Working knowledge of Quest SQL Navigator or Toad
- Implement shared components and frameworks using PL/SQL in a Linux/Solaris based environment
- Develop new batch processes for data migration and transformation
- The points below have been carefully considered as being essential for the role
- Excellent technical skills in Oracle PL/SQL, SQL
- Excellent skills with SQL (advance queries, tuning)
2
PL SQL Developer Job Description
Job Description Example
Our innovative and growing company is hiring for a PL SQL developer. 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 PL SQL developer
- Evaluates, understands and implements detailed business, functional, and non-functional technical requirements (including recovery, security, data volumes, performance and audit)
- Lead and support tasks on engagements related but not limited to Systems Implementation, Operations & Maintenance, Helpdesk Operations and Software Application Development & Maintenance
- Leads, analyzes, designs, develops, and implements modules relating to fulfillment, supply chain planning
- Working with application teams and other stakeholders
- Develop, test and support solutions utilizing Oracle RDBMS
- Work with Product Owner and Scrum Master to assess impact and provide estimates
- Interact with client on scrum calls to understand requirement
- Maintain project documentation and follow SDLC process obligations
- Design, develop, and maintain applications, reports and data structures needed for line of business applications in an Oracle 8i, 10G, 11G, 12C environments
- Participate in process analysis to help produce and refine requirements and create technical solutions
Qualifications for PL SQL developer
- Strong understanding of relational databases (including tables, views, indexes, table spaces )
- Good knowledge and understanding of Oracle API’s
- Help determine best design approaches
- Ability to work in a complex data environment the ability to partner with the business and IT to find creative data solutions to business problems
- Be involved in the planning of system and development deployment responsible for meeting software compliance standards
- Involved in all aspects of the software development life cycle
3
PL SQL Developer Job Description
Job Description Example
Our company is growing rapidly and is looking for a PL SQL developer. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for PL SQL developer
- Plan and coordinate security measures to ensure data integrity and maximize database efficiency
- Define indexes for tables
- Manage schema properties
- Developing data processing and ETL components on distributed database systems
- Developing database application schemas for business intelligence applications
- Developing scripting to support the production operation of data processing applications
- Design logical and physical databases or review description of changes to database design to understand how changes to be made affect physical database (how data is stored in terms of physical characteristics such as location, amount of space, and access method)
- Development and programming in PL/SQL technology
- Design and develop multiple reporting applications
- Design, develop and implement ETL processes to update the data warehouse
Qualifications for PL SQL developer
- 2 or more years Oracle PL/SQL experience
- Highly proficient in RDBMS concepts and Oracle SQL
- Ability to perform in-depth data analysis of production issues
- Engineering or MCA First class Graduate from a reputed University with a strong technical background in the software application development using Oracle, PL/SQL with a minimum experience of 7+ years
- Experience with complex SQL (Dynamic, Stored Procedures and Triggers)
- Informatica MDM (Nice to have)
4
PL SQL Developer Job Description
Job Description Example
Our innovative and growing company is looking to fill the role of PL SQL developer. 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 PL SQL developer
- Regularly contribute to the development of new concepts, techniques, and standards
- Apply expertise and possess knowledge of related disciplines
- Establish functional and technical specifications
- Participate in planning schedules and arranging own activities
- Respond to support requests (Help Desk tickets and end-user phone calls) in a timely and accurate manner
- Conduct seminars and presentations on topics of interest to the Software Development Group
- Proactively seek opportunities to broaden and deepen knowledge base and proficiency
- Design, develop, implement and maintain solutions, queries and procedures
- Work with users to define new or enhance existing reporting requirements
- Learn pre-designed insurance-specific data structures for transactional data, and data marts
Qualifications for PL SQL developer
- Expertise in creation of databases, table spaces, tables, indexes, users, grants
- Frequent use of computer
- 6+ years of .NET development experience, ideally with 2010 or higher
- 4+ years of front-end development experience utilizing ASP.NET
- 2+ years of PL/SQL experience accessing Oracle databases and writing triggers
- 6+ years of C# or VB.net experience
5
PL SQL Developer Job Description
Job Description Example
Our innovative and growing company is looking for a PL SQL developer. 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 PL SQL developer
- Work as part of a team to design, build and test PL/SQL tabels
- Requirements gathering, system analysis and design, documentation, coding, testing, implementation, monitoring production performance and production jobs, researching and resolving production problems, dealing with end users to resolve issues, acting as a point-of-contact (POC)
- Individual shall be tasked with creating and maintaining PL/SQL components that utilize advanced techniques, , designing database objects
- Individual shall participate in system requirements reviews, critical design reviews, test readiness reviews and post implementation reviews as part of the CMMI
- Prepare system change specifications, design documents and system documentation
- Design, code, test, debugs and document software according to the company’s systems standards, policies and procedures
- Evaluate and recommends software and hardware solutions to meet user needs
- Responsible for preparing design documentation, preparing test data for unit, string and parallel testing, may conduct performance and scalability testing
- Review and understand current system architecture and logic
- Present ideas for system improvements
Qualifications for PL SQL developer
- Experience with design patterns and Object-Oriented Design / Development
- Experience conducting end-to-end development is preferred
- Proficiency in PL/SQL programming
- Knowledge of Oracle Server Architecture
- Experience with UML/SQL/Oracle
- A minimum of 1 year of application development experience