Role overview

Qualifications

5 years of programming experience as an Oracle PL/SQL Developer
3 years of creating Shell Scripts experience for invoking SQL scripts
5 years of Oracle performance-related features such as Query Optimizer, Execution Plans, and Indexes
5 years of client-server application development using Oracle 19c, PL/SQL, SQL *Plus, and TOAD

Responsibilities

Knowledgeable about data integration tools like Actian/Pentaho
Robust abilities in database design and data modeling
Comprehensive grasp of backup and recovery strategies
Skilled in monitoring and enhancing database performance

Key facts

Remote from: California (USA)
Fixed term
Senior (5-10 years)
English

Hard skills

PL/SQL Database Management SQL (Programming Language) Database Design Data Modeling Backup And Restore

Other skills

Communication

About the company

US Tech Solutions

Human Resources, Staffing & Recruiting

USTECH SOLUTIONS is the largest privately owned diversity workforce partner with a global footprint. For 20+ years, we have partnered with leading MSPs and some of the world’s largest enterprises to deliver a flexible workforce. We serve Fortune 500 giants and growing businesses alike, reinventing the role of humans in a digital workforce. ‘Reinventing Human’ is about connecting you with top talent and seamlessly integrating new hires into your programs through our next gen AI powered Talent platforms. As the largest private diversity supplier in the US, we champion inclusion and unlock hidden potential. We work with leading MSPs and are a trusted strategic partner to the world’s top brands. At USTECH SOLUTIONS, we're inverting the talent hiring pyramid by offering a range of solutions from curated talent pools, workforce management services, and IT services resourcing to IC compliance. Our legacy and close affinity to the computing industry has equipped us with the expertise and vision to provision AI platform solutions that help organizations to innovate faster. Considering Statement of Work? Meet US Tech Digital (ustechdigital.com). We're helping businesses achieve digital leadership through our tailored SOW solutions, utilizing market-leading technology products and our proprietary in-house developed platform solutions. Explore our full range of services and solutions by visiting our website: ustechsolutions.com

Company details

Company typeLarge

IndustryHuman Resources, Staffing & Recruiting

Company size1001 - 5000

Links

Website LinkedIn See all jobs

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

Duration: 12 Months

Job Description:

language i.e., Bash, C, KornShell, Bourne shell - Knowledgeable about data integration tools like Actian/Pentaho
Excellent verbal and written communication
Extensive expertise in one or multiple database management systems (DBMS) such as Oracle, Microsoft SQL Server, MySQL, PostgreSQL, or MongoDB, encompassing tasks such as installation, configuration, maintenance, and troubleshooting of these systems
Robust abilities in database design and data modeling, encompassing tasks such as crafting efficient database schemas, establishing relationships between tables, maintaining data integrity, and enhancing database structures for optimal performance
Comprehensive grasp of backup and recovery strategies to formulate backup plans, schedule backup procedures, validate restore processes through testing, and execute disaster recovery plans.
Skilled in monitoring and enhancing database performance by addressing performance bottlenecks, fine-tuning SQL queries, adjusting database parameters, deploying indexing strategies, and analyzing database statistics
Proficient in one more Unix scripting

Experience Required:

5 years of programming experience as an Oracle PL/SQL Developer
3 years of creating Shell Scripts experience for invoking SQL scripts
5 years of Oracle performance-related features such as Query Optimizer, Execution Plans, and Indexes.
5 years of client-server application development using Oracle 19c, PL/SQL, SQL *Plus, and TOAD
5 years of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-write and Transportable table spaces
2 years of experience with data warehouse concepts, ETL

About US Tech Solutions:
US Tech Solutions is a global staff augmentation firm providing a wide range of talent on-demand and total workforce solutions. To know more about US Tech Solutions, please visit www.ustechsolutions.com.

US Tech Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, colour, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

AI Statement: By applying, you acknowledge that AI-assisted tools may be used during hiring.

#LI-AS140