2

Remote Oracle Performance Tuning Jobs in Rowlett, TX

Oracle APEX Developer * Full time contract (1099/C2C) * Contract length: 12 months + extension ... Conduct testing, debugging, and performance tuning to ensure reliability and accuracy. * Create and ...

* 100% Remote. Our client in Richmond, VA is seeking Oracle Apex developer (788519) For a contract ... Required 10 Years Query optimization, performance and tuning (PL/SQL) using SQL Trace, Explain Plan ...

Enterprise Architect (Remote Opportunity)

Dallas, TX · On-site +1

$68.25 - $88/hr

Performance tuning, query optimization, and system diagnostics * Integration with downstream ... IRIS/Cache, Oracle, and SQL Server. * Demonstrated expertise in high-availability systems ...

Senior Data Engineer Remote

Prosper, TX · Remote

$97K - $131K/yr

... performance tuning and efficient data access patterns Create and manage workflow orchestration using Apache Airflow or similar tools, ensuring reliable scheduling, dependency management, and ...

next page

Showing results 1-20

Remote Oracle Performance Tuning information

What is the difference between Remote Oracle Performance Tuning vs Remote Database Administrator?

AspectRemote Oracle Performance TuningRemote Database Administrator
CertificationsOracle Certified Professional (OCP), Oracle Performance Tuning certificationsOracle Certified Professional (OCP), Database Administration certifications
Work EnvironmentFocus on optimizing Oracle database performance, often specialized in tuning tools and scriptsManage overall database health, backups, security, and user access
Industry UsageCommon in companies with large Oracle databases requiring performance enhancementsWidespread across industries managing diverse database systems

Remote Oracle Performance Tuning specialists focus on optimizing database speed and efficiency, while Remote Database Administrators handle broader database management tasks. Both roles require Oracle certifications and are vital in organizations using Oracle databases, but their core responsibilities differ significantly.

What are the key skills and qualifications needed to thrive as a Remote Oracle Performance Tuning Specialist, and why are they important?

To thrive as a Remote Oracle Performance Tuning Specialist, you need deep expertise in Oracle database architecture, SQL optimization, and troubleshooting, usually supported by a degree in computer science or related certifications such as Oracle Certified Professional (OCP). Hands-on experience with Oracle Enterprise Manager, AWR/ASH reports, and various performance monitoring and tuning tools is essential. Strong problem-solving skills, attention to detail, and clear communication help you diagnose issues and collaborate with remote teams effectively. These abilities ensure databases run efficiently, minimizing downtime and maintaining business continuity in distributed environments.

What is a Remote Oracle Performance Tuning specialist?

A Remote Oracle Performance Tuning specialist is an IT professional who analyzes, optimizes, and resolves performance issues in Oracle databases from a remote location. They use specialized tools to diagnose slow queries, bottlenecks, and configuration problems, implementing solutions to improve database speed and reliability. These specialists work with database administrators and developers to ensure efficient, high-performing Oracle database environments without needing to be physically present at the client's site.

What are some common challenges faced by professionals in remote Oracle Performance Tuning roles, and how can they be addressed?

Remote Oracle Performance Tuning professionals often face challenges such as limited direct access to on-premises systems, communication barriers with onsite teams, and the need to coordinate troubleshooting across different time zones. To overcome these, it's important to establish clear communication channels, use secure remote diagnostic tools, and maintain thorough documentation of performance issues and resolutions. Building strong relationships with database administrators, developers, and IT support teams helps ensure smooth information flow and effective problem-solving.
What are popular job titles related to Remote Oracle Performance Tuning jobs in Rowlett, TX? For Remote Oracle Performance Tuning jobs in Rowlett, TX, the most frequently searched job titles are:
What cities near Rowlett, TX are hiring for Remote Oracle Performance Tuning jobs? Cities near Rowlett, TX with the most Remote Oracle Performance Tuning job openings:
Remote - Oracle HCM Fast Formula Developer || W2 || USC, GC, EAD

Remote - Oracle HCM Fast Formula Developer || W2 || USC, GC, EAD

HYR GLOBAL SOURCE INC

Dallas, TX • Remote

Contractor

Retirement

Posted 5 days ago


Job description

Remote - Oracle HCM Fast Formula Developer
Job Type: W2
Work Authorization: USC, GC, EAD

Professional Summary: Senior Oracle HCM Fast Formula Developer with 10+ years of experience designing, developing, testing, and supporting complex Oracle HCM Cloud Fast Formulas across Payroll, Benefits, Absence Management, Compensation, Workforce Compensation, Recruiting, Time & Labor (OTL), HCM Extracts, and HDL Data Conversion projects. Proven expertise translating complex business requirements into scalable, high-performance Fast Formula solutions supporting enterprise-wide HCM implementations, integrations, payroll processing, and post go-live support activities.

Technical Skills: Oracle HCM Cloud | Fast Formulas | Payroll | Benefits | Absence Management | Compensation | Workforce Compensation | OTL | Time & Labor | HCM Extracts | HDL | HSDL | OTBI | BI Publisher | OIC | REST APIs | SQL | User Defined Tables | Value Sets | Lookups | DBIs | Routes | Arrays | Contexts | Change Contexts | Performance Tuning | Data Conversion | Production Support

Core Responsibilities
  • Worked directly with Payroll Managers, Benefits Administrators, Compensation Teams, HRIS organizations, Time & Labor users, Talent Management teams, and business stakeholders to document functional requirements and design complex Fast Formula solutions.
  • Designed, developed, tested, deployed, and supported Oracle HCM Fast Formulas across multiple formula types including: Payroll Calculation Formulas and HDL Transformation Fast Formulas
  • Demonstrated deep expertise in Fast Formula language architecture, including: Contexts and Change Contexts, Database Items (DBIs), Routes and Route Optimization and Array and Array Processing and Nested Logic Structures
  • Developed highly complex Fast Formulas, including those supporting Union Payroll Rules, Shift Differentials, Overtime Calculations, Retroactive Payroll Adjustments and  Bonus Calculation 
  • Designed reusable and modular Fast Formula frameworks utilizing User Defined Tables, Value Sets, Lookups, Global Values, and configurable business rules to minimize future maintenance efforts.
  • Developed HDL Transformation Fast Formulas supporting large-scale Oracle HCM Cloud data conversion projects from PeopleSoft, Oracle EBS, SAP HR, Lawson, Workday, and legacy HR systems.
  • Developed HCM Extract Fast Formulas to support complex outbound interfaces for Payroll Providers, Benefits Carriers, 401(k) Vendors, Insurance Providers, Tax Authorities, Financial Institutions, Data Warehouses, and downstream enterprise systems.
  • Worked extensively with Oracle HCM Extracts, HDL, HSDL, BI Publisher, OTBI, REST APIs, and Oracle Integration Cloud (OIC) where Fast Formulas were utilized for transformation logic, data validation, business rule enforcement, and integration processing.
  • Created detailed Functional Design Documents (FDD), Technical Design Documents (TDD), Unit Test Scripts, Regression Test Plans, and Production Support Documentation for Fast Formula implementations.
  • Performed extensive unit testing, integration testing, regression testing, and edge-case validation including expected-result testing, negative testing, boundary testing, and performance validation.
  • Supported post go-live Oracle HCM environments by troubleshooting Payroll, Benefits, Compensation, Absence, OTL, HDL, and HCM Extract Fast Formula issues and redesigning formulas to support evolving business requirements.
  • Collaborated with Oracle Support through Service Requests (SRs), quarterly patch testing, release validation, root cause analysis, and issue resolution activities involving complex Fast Formula processing.
  • Conducted peer reviews, code reviews, architecture reviews, and performance optimization initiatives to ensure adherence to Oracle HCM Fast Formula development standards and best practices.
#LI-SS3