Support and enhance a custom CRM analytical repository on Oracle/AIX. Design, develop, tune PL/SQL stored procedures, ETL processes, and data warehouse components. Provide production support, performance tuning, and collaborate with the ECRM team on analytics and campaign operations.
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- 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 modeling Experience a plus
- 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
- 5 plus years experience with major DBMS
- 5 plus years experience with coding, testing, and design
- 5 plus years experience with software development methodologies
Connect with me at https://www.linkedin.com/in/mir-hasham-ali/ (For Direct Clients Requirements)
** U.S. Citizens and those who are authorized to work independently in the United States are encouraged to apply. We are unable to sponsor at this time.
Note:-
- This is a Contract job opportunity for you.
- Only US Citizen, Green Card Holder, GC-EAD, H4-EAD, L2-EAD & TN-Visa can apply.
- No OPT-EAD & H1B candidates, please.
- Please mention your Visa Status in your email or resume.
** All your information will be kept confidential according to EEO guidelines.
Similar Jobs
eCommerce • Fashion • Retail • Sales • Wearables • Design
As a Supervisor II at Coach, you will lead, coach, and develop team members, ensure excellent customer service, and manage operational functions on the sales floor and in the stockroom while maintaining high morale and team spirit.
Digital Media • Information Technology • News + Entertainment
Sells Comcast mobile and integrated communication products to small and medium-sized businesses. Responsibilities include prospecting, cold calling, canvassing, lead generation, face-to-face presentations, territory development, relationship management, customer retention, competitive research, sales reporting, and meeting financial and unit targets. The role requires customer visits, persuasive communication, independent judgment, and availability for nights, weekends, variable schedules, and overtime.
Digital Media • Information Technology • News + Entertainment
Sells Comcast Business communication products and bundled services to small and medium-sized businesses. Responsibilities include prospecting, cold calling, canvassing, conducting face-to-face presentations, developing territories, cultivating business partnerships, negotiating sales, meeting revenue targets, retaining customers, and preparing activity reports. The role requires regular customer meetings, strong communication and persuasion skills, independent judgment, and flexibility to work nights, weekends, variable schedules, and overtime.
What you need to know about the Los Angeles Tech Scene
Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.
Key Facts About Los Angeles Tech
- Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
- Key Industries: Artificial intelligence, adtech, media, software, game development
- Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
- Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering
