Description
Blend of performance DBA & application developer skillset - Experience in application development that helps with understanding how to tune application queries. - Experience in ORACLE 19c (such as Oracle optimizer, explain plans, SQL plans, hints, TKPROF, traces, structures). - Knowledge of Oracle Real Application Cluster (RAC) - Experience in SQL and optimizing queries - Experience in in developing PL/SQL and optimize PL/SQL code - Experience in optimizing database structures (indexes, Primary/Foreign keys, tables structures) - Some Java experience is preferred, but not required
Skills
SQL, Oracle, PL/SQL, 19c, RAC, Tuning, Real Application Cluster, Tune, Optimize, Query, Batch Jobs, OPtimization
Top Skills Details
SQL,Oracle,PL/SQL,19c,RAC,Tuning,Real Application Cluster,Tune,Optimize,Query,Batch Jobs,OPtimization
Additional Skills & Qualifications
Core Responsibility - Running batch jobs and looking at batch job optimization, SQL code that runs and gathers up a bunch of records, trying to streamline that with hints, explain plans, etc. Tools - SQLPLUS and PL/SQL. - Knowledge of procedure/packages/triggers. - Knowledge of SQL profiles and baselines. - Oracle Scripting in Unix a plus - SQLDeveloper - Experience in OEM - Using ASH and AWR reports (or even manually generating ASH and AWR reports) - Monitoring (or even monitoring with scripts)
Experience Level
Intermediate Level
Job Type & Location
This is a Contract position based out of Lansing, MI.
Pay and Benefits
The pay range for this position is $40.00 - $45.00/hr.
Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following: Medical, dental & vision Critical Illness, Accident, and Hospital 401(k) Retirement Plan - Pre-tax and Roth post-tax contributions available Life Insurance (Voluntary Life & AD&D for the employee and dependents) Short and long-term disability Health Spending Account (HSA) Transportation benefits Employee Assistance Program Time Off/Leave (PTO, Vacation or Sick Leave)
Workplace Type
This is a fully remote position.
Application Deadline
This position is anticipated to close on Jan 28, 2026.
>About TEKsystems:
We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.
The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
About TEKsystems and TEKsystems Global Services
We're a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. We're a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. We're strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We're building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.
The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
- Dice Id: 101054TS
- Position Id: JP-005784073
- Posted 18 hours ago