Company:
Sonsoft Inc
Location: Torrance
Closing Date: 29/10/2024
Salary: £100 - £125 Per Annum
Hours: Full Time
Type: Permanent
Job Requirements / 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
- 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.
- A 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 Warehousing experience a plus.
- Bachelor's degree in Computer Science or related discipline or have equivalent experience.
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 especially if depending on others to do their tasks.
Qualifications
- 5 plus years experience with major DBMS .
- 5 plus years experience with coding, testing, and design .
- 5 plus years experience with software development methodologies .
Share this job
Sonsoft Inc
Useful Links