Oracle / SQL DBA

HTC Global Services wants you. Come build new things with us and advance your career. At HTC Global you'll collaborate with experts. You'll join successful teams contributing to our clients' success. You'll work side by side with our clients and have long-term opportunities to advance your career with the latest emerging technologies.

At HTC Global Services our consultants have access to a comprehensive benefits package. Benefits can include Paid-Time-Off, Paid Holidays, 401K matching, Life and Accidental Death Insurance, Short & Long Term Disability Insurance, and a variety of other perks.

Position : Oracle SQL

Details : Required Skills

Experience with designing, developing, testing, and maintaining Oracle database servers (Oracle 11g and 19c in Cloud)

Data modeling, Data warehouse design, Knowledge of data warehouse tools (Oracle, Snowflake)

Complex SQL Query writing and performance tuning

Create and maintain stored procedures, functions, and packages using PL / SQL.

Technical and complex problem troubleshooting / mitigation and log file root cause analysis

Designing and enhancing reports using TIBCO Jaspersoft® Studio

Performing Oracle data pump imports and exports

Performing schema creation and adjustments

Managing release tasks including data, database and documentation

Linux administration and troubleshooting

Server disk capacity and utilization management

Large datafile transfers management

Complex shell scripting

Desired skills to include years of experience required in each :

Jasper Reports / TIBCO Jaspersoft® Studio : 2 years

Java : 2 years

Miscellaneous :

Required software : Oracle Database 11g / 19c, SQL Developer, Data warehousing tools (Oracle, Snowflake), Ireport / Jasper reports studio