Match score not available

Unlock Premium Benefits Today!
🚀 Elevate your career with priority access.
Stand out to top recruiters with Jobgether Priority Access:
  • ✅ Top Match: We help you identify job offers where you're a perfect fit.
  • ✅ Exclusive Referral Service: Connect directly with recruiters as a Jobgether Certified Premium User.
  • ✅ Personalized Feedback: Receive feedback and expert guidance on applications, and have your profile manually reviewed.

Start Your Free Trial Now!

Start my free trial

Remote - PL/SQL Developer

Remote: 
Full Remote
Work from: 
Texas (USA), United States

Offer summary

Qualifications:

Proven experience in PL/SQL development., Strong database design and modeling skills., Experience with performance tuning., Proficiency in Unix shell scripting..

Key responsabilities:

  • Develop and modify PL/SQL packages and procedures.
  • Design and implement data migration processes.

Resource Informatics Group, Inc logo
Resource Informatics Group, Inc SME https://www.rigusinc.com/
51 - 200 Employees
About Resource Informatics Group, Inc
We are a staffing solutions and IT Solutions company that provides you with a platform to find the right fit for your desired job profile. The employment situation is constantly shifting with the changing times, and we are here to ensure that you gather the workforce that compliments your long-term goals. We understand the struggle of the search for talent that accommodates the skills and qualifications for specific profiles, one that blends in with the theme of your organization. We aim to be the best available source for young talent to find their dream jobs, by helping them narrowing down their options to the most suitable work profiles available in the market. At RIG, we consistently work towards creating the latest technology that may not only simplify your work process but also provides you with the most cost-effective solutions. We work hard to make sure that your business strives in the market to be on the top in your field.
See all jobs

Job description

Job Title: PL/SQL Database Developer
Location: Remote
Duration: 12 months
Rates: DOE

Job Summary: We are seeking a skilled Database Developer to support our data migration,
performance tuning, and application enhancement efforts. The ideal candidate will have extensive
experience in PL/SQL development, database design, and production support.

Key Responsibilities:
1. Database Development:
* Develop and modify PL/SQL packages, procedures, triggers, functions, and indexes to
support data migration, new business requirements, and application enhancements.
* Create and modify database objects such as tables, views, synonyms, materialized views, and
stored procedures.
2. Data Migration:
* Design and implement data migration processes from legacy applications to new
applications, including the creation of XML files for data migration.
* Coordinate with other teams involved in the migration process.
3. Performance Tuning:
* Fine-tune database objects and SQL queries for optimal performance, using techniques such
as query rewriting, index optimization, query hints, and partitioning.
* Analyze query performance using explain plan tables and optimize SQL queries with subqueries, analytical functions, and inline views.
4. Production Support:
* Fix production issues, provide user training and support, and improve application
performance by rewriting SQL queries and optimizing PL/SQL code.
* Manage the packaging and release of code changes for applications in different
environments.
5. Database Design and Modeling:
* Create logical and physical data models using normalization techniques.
* Build and configure database structures, tables, views, constraints, and indexes to collect and
normalize business data.
* Generate SQL and PL/SQL scripts for database object creation and manipulation.
6. Scripting and Automation:
* Create and modify Unix shell scripts to support project requirements and client needs.
* Utilize Oracle utilities like SQL*Plus and PL/SQL Developer for database development tasks.
* Manage Autosys jobs for process automation.
7. Collaboration and Communication:
* Coordinate with business application owners, front-end teams, architects, and other teams
involved in upstream/downstream interfaces.
* Interact with various stakeholders to ensure seamless integration and functionality.

8. Qualifications:
* Proven experience in PL/SQL development and database management.
* Strong understanding of database design and modeling principles.
* Experience with performance tuning and production support.
* Proficiency in Unix shell scripting and Oracle utilities.
* Excellent communication and collaboration skills.

Required profile

Experience

Spoken language(s):
English
Check out the description to know which languages are mandatory.

Hard Skills

PL/SQLDatabase DesignPerformance TuningDevelopment SupportData MigrationSQL (Programming Language)Database DevelopmentShell ScriptOracle SQL DeveloperOracle DevelopmentSQL*Plus

Other Skills

  • Collaboration
  • Communication
Are you interested?

Related jobs

See more jobs