PL/SQL Developer at SonSoft Inc. in Torrance, CA

Company Description

Sonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.

Job Description

Job Description:

• Seeking an experienced Senior Developer who specializes in Oracle database and PL-SQL / Data warehouses / Unix servers and shell scripting

• Ability to design solutions and conduct data analysis is required

• Informatica knowledge is a plus

• Auto industry, CRM and knowledge of marketing concepts are pluses

Responsibilities:

• The position will be supporting a custom CRM application, specifically the analytical repository

• The repository is an Oracle database, the OS is Unix AIX 6.x

• The responsibilities for the position include the analysis, design, development and 24/7 support of the production processes and applications

• The candidate will work under the supervision of the ECRM team lead

• Will be part of a team responsible for supporting CRM analytics and Campaign operations

Required Skills:

Oracle Database

• Strong understanding of Oracle PL/SQL techniques to write stored procedures, triggers and packages that analyze several million rows across several database tables

• Ability to grasp relational data models quickly and program using SQL and PL/SQL

• Clear understanding of SQL’s analytical processing capabilities such as RANK, DENSE RANK etc.

• Strong understanding of Oracle dynamic SQL and ability to write complex procedures using dynamic SQL

• Performance tuning methodologies and understanding of Relational database join techniques like HASH, NESTED LOOPS etc. and the use of Oracle Hints

• Advanced knowledge of Oracle Indexing techniques like BIT Map indexes and Index Organized tables

• Optimize and tune stored procedures, embedded SQL, taking advantage of Oracle specific features

• Oracle Data Partitioning techniques to manage, support and performance tune very large databases (VLDB’s)

• Understanding of Parallel execution features of Oracle to dramatically reduce response times for data intensive operations

• Bulk Collect functionality, pipelined functions and other features of Oracle PL/SQL

• Ability to write efficient PL-SQL procedures

• Design complete solutions

Data transformation (ETL)

• Knowledge of Informatica is a plus

• Familiarity with Extraction, Transformation and Loading (ETL tools) to facilitate loading large amounts of data

• Strong ETL design and development abilities

• PL-SQL and Stored Procedures to upload data from different sources

Unix OS

• Experience working with Unix servers

• Experience with Shell scripting

Database/Other

• Experience in the analysis, design, development, deployment & tuning of large scale databases

• Experience in the design and development of data warehousing

• Expert knowledge of SQL

• Ability to write and understand complex SQL required

• Query analysis and tuning experience (hints, explain plan, TKPROF)

• Expert knowledge of Oracle PL/SQL best practices and development methodologies or standards

• Stored Procedures, Packages, Triggers, Debugging, Tuning

• Data modeling Experience a plus

• Data Warehousing experience a plus

• Bachelor's degree in Computer Science or related discipline or have equivalent experience

Business Experience

• 5 plus years experience with major DBMS

• 5 plus years experience with coding, testing, and design

• 5 plus years experience with software development methodologies

Qualifications

Desired Skills:

• Motivated self starter

• Ability to work in a fast paced environment

• Ability to work in a team environment where team conducts code and design reviews prior to implementation

• Ability to lead minor tasks and follow up on progress specially if depending on others to do their tasks

Additional Information

Note:- This is a Full-Time & Permanent job opportunity for you. Only US Citizen, Green Card Holder, GC-EAD, H4-EAD & L2-EAD can apply. No OPT-EAD, H1B & TN candidates please. Please mention your Visa Status in your email or resume.