PL / SQL Developer

Career Area: Information Technology

Occupation Group: Database Specialists

Salary

Percentile wages tell how much a certain percentage of an overall population in a geographic area or within a given industry or field makes. The percentile wage estimate is the value of a wage below which a certain percent of workers fall.

An example would be the 25th percentile, 25 percent of workers employed in that occupation earn less and 75 percent earn more than the estimated wage value. At the 75th percentile, 75 percent of workers employed in that occupation earn less and 25 percent earn more than the estimated wage value.

A typical PL / SQL Developer earns the following wages (national and state):

State

The average salary in North Carolina for those pursuing this career is $104,325

National

The average salary in the United States for those pursuing this career is $100,637

What Does a Professional in this Career Do?

Develops, test and maintains database structures and processes. Specializes in the Procedural Language / Structured Query Language (PL / SQL) processes and structures. Provides support for software, product and client needs addressed through the database systems.

Employment Trends

The job demand and job growth statistics shown here were derived from job posts over the past year. Expected job growth projections are extrapolated from year-over-year job post listing history.

Job demand and job growth is expected at the following rates:

Skills

A professional in this position typically utilizes the following skills in the course of everyday work in this exciting and challenging field:

Baseline Skills

The following are baseline skills every PL / SQL Developer is expected to have in order to experience success in this field:

• Troubleshooting: Troubleshooting or dpanneuring is a form of problem solving, often applied to repair failed products or processes on a machine or a system.
• Communication Skills: The ability to convey information to another effectively and efficiently.
• Writing: Experience expressing business messages effectively in written form. This may include planning drafting and revising as necessary.
• Teamwork / Collaboration: Experience working in collaborative efforts with a team to achieve a common goal or to complete a task in the most effective and efficient way.
• Problem Solving: Problem solving consists of using generic or ad hoc methods, in an orderly manner, for finding solutions to problems.

Specialized Skills

These skills are specific to working in this career:

• Oracle PL/SQL: PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database.
• SQL: SQL ( ESS-kew-EL or SEE-kwl, Structured Query Language) is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS).
• Oracle: Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is an object-relational database management system produced and marketed by Oracle Corporation.
• Extraction Transformation and Loading (ETL): In computing, Extract, Transform, Load (ETL) refers to a process in database usage and especially in data warehousing.
• Performance tuning: Working experience of Performance tuning, which is the improvement of system performance. Typically in computer systems, the motivation for such activity is called a performance problem, which can be either real or anticipated. Most systems will respond to increased load with some degree of decreasing performance. A system's ability to accept higher load is called scalability, and modifying a system to handle a higher load is synonymous to performance tuning.

Distinguishing Skills

Any PL / SQL Developer that possesses the following skills will stand out against the competition:

• Data Warehouse Processing: Working experience of Data Warehouse Processing, which involves extracting, transforming and loading data from source systems and placing it into a data warehouse.
• Datastage: IBM InfoSphere DataStage is an ETL tool and part of the IBM Information Platforms Solutions suite and IBM InfoSphere.
• SQL Server Reporting Services (SSRS): SQL Server Reporting Services (SSRS) is a server-based report generating software system from Microsoft.
• Transact-SQL: Transact-SQL (T-SQL) is Microsoft's and Sybase's proprietary extension to the SQL (Structured Query Language) used to interact with relational databases.
• PostgreSQL: PostgreSQL, often simply Postgres, is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance.

Salary Boosting Skills

A professional who wishes to excel in this career path may consider developing the following highly valued skills:

• Data Architecture: In information technology, data architecture is composed of models, policies, rules or standards that govern which data is collected, and how it is stored, arranged, integrated, and put to use in data systems and in organizations.
• Relational DataBase Management System (RDBMS): A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as invented by Edgar F.Codd, of IBM's San Jose Research Laboratory.

Experience

This position typically requires the following level of experience. The numbers presented in the pie charts below were derived from actual job posts over the past year. Not all job postings list experience requirements.

Common Job Titles

It is possible to find work in this field in positions commonly listed as the following job titles:

• Pl/Sql Developer
• Oracle Database Developer
• Senior Pl/Sql Developer
• Oracle Pl/Sql
• Pl Sql Developer

Similar Occupations

If you are interested in exploring similar occupations, you may want to research the following job titles:

• SQL Server Developer
• SQL Developer
• Database Analyst / Developer
• SQL Server Database Administrator