Offered Salary 1000
Career Level Others
Experience 8 Years +
Qualifications Degree Bachelor
Who we are!
At 4Ci our mission is to build long term relationships, based on trust, integrity, and knowledge with all our employees and business affiliates. 4Ci has been in business for 20 years and has employees working on mission critical projects nationwide. We provide computer programming, testing, and system design services to develop and maintain multi-year, multi-million-dollar mission critical applications for the US Government. Examples of such applications are Medicaid MMIS systems, Health Insurance Exchange, Child Support, Food Stamps, and Unemployment Insurance. We hire people that have desire, aptitude, and attitude to work with our clients such as big 3 consulting firms and US State Government and others.
While employed with us you get hands on experience with very large-scale mission critical applications that use latest in technology trends and software tools. We invest in training our resources and retool their expertise to meet our project needs.
More importantly our employees have a well-defined social and business purpose to help our clients deliver social and welfare benefits to millions of needs families by use of technology and knowledge.
What we do
We partner with big 3 consulting firms to design, develop, and maintain complex, heterogeneous, and client facing web-based automation systems that deliver social and welfare benefits to millions of families, nationwide. To develop such highly complex web applications we need professionals with broad range of experience and skills ranging from subject matter experts, computer programmers, project managers, tester, systems analysts and others. We invest in training our employees and retool their expertise to meet our project needs.
Job Title: PL/SQL Developer (Job ID – 1477)
Location: Richardson, TX.
Job Description: Create database objects like tables, views, materialized views, triggers, procedures, functions, and packages to implement business logic using oracle tools like Toad, PL/SQL Developer and SQL* plus. Design and create scripts to create new tables, views, SQL queries for new enhancement in the application. Prepare and create Indexes on the tables for faster retrieval of the data to enhance database performance. Develop SQL and PL/SQL scripts to transfer tables across the schemas and databases. Develop SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling. Perform SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE. Use Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines. Use advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL. Conducted and be involved with Data Extraction, Transformation and Loading (ETL process) from Source to target and worked on Windows Batch scripting, scheduling jobs and monitoring logs. Create control files and loaded the data into the database tables from flat files by using SQL*Loader. Create indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries. Fine-tune procedures/SQL queries using Oracle Hints for maximum efficiency to direct the optimizer to choose an optimum query execution plan.
Education: Requires a Master’s Degree in Computer Science or Electrical Engineering or foreign equivalent and one (1) year of experience in the job offered or one (1) year of experience in creating database objects like tables, views, materialized views, triggers, procedures, functions, and packages to implement business logic using oracle tools like Toad, PL/SQL Developer and SQL* plus; and Conducting and involving with Data Extraction Transformation and Loading (ETL process) from Source to target and worked on Windows Batch scripting, scheduling jobs and monitoring logs.
Location: Richardson, TX. Job will require travel to unanticipated client sites. Employee should also be willing to re-locate to client location for short term assignments, as well as long term assignments. 40 hours per week. M-F. Must be authorized to work in the U.S. Email resumes to firstname.lastname@example.org or mail to Attn: HR, 4Consulting, Inc., 1050 West Campbell Road, Ste. 100, Richardson, TX 75080. Please visit www.4ci-usa.com for more information. Please mention Job Id: 1477 while applying.
4 Consulting Inc. offers a comprehensive compensation and benefits package. 4Ci is an affirmative action-equal opportunity employer. 4Ci complies with all applicable federal, state and local laws regarding recruitment and hiring. All qualified candidates are considered for employment without regard to race, colour, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other category protected by applicable federal, state or local laws.