PL SQL Developer Job Description
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:
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:
Desired experience for PL SQL developer includes:
PL SQL Developer Examples
PL SQL Developer Job Description
- 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
- 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)
PL SQL Developer Job Description
- 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
- 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
PL SQL Developer Job Description
- 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
- 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)
PL SQL Developer Job Description
- 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
- 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
PL SQL Developer Job Description
- 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
- 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