Position: Senior Oracle DBA
Company: GlobalLogic
Category: SQL
Experience required: 5y
English level: intermediate
Published: 2021-09-01T00:00:00+03:00

**Job Description**
7 years of experience with Oracle

5 years as Oracle application DBA

Experience in performance analysis and data modeling

Ability to investigate bottlenecks in the schema design and database architecture

Knowledge of the tool limitations of Oracle Database Standard Edition

Strong English writing and speaking skills

 

**Job Responsibilities**
Review the DB for missing indexes (FKI)

Assess the efficiency of the relational DB model

Analyze the DB execution plans and identify slow running queries

Review the SQL statements and identify improvements

Propose changes to improve the issues identified as a result of the activities above

Make the required changes in database configuration/database resources

Discover high loaded parts/bottlenecks of inventory/services database and main resource-consuming Use Cases

Discover if optimization can be done within the database with no or minimal impact on OSS/BSS code

Discover if optimization can be done in OSS/BSS code (e.g. rewrite resource-consuming queries, bypass ORM system in high loaded Use Cases etc)

Make an estimation on required development work if optimization is possible with the means of Database and OSS/BSS

Make changes in code for discovered items 

**Project Description**
GlobalLogic Kharkiv team is seeking a self-motivated and energetic Senior Oracle DBA Engineer with 5+ years of relevant experience. The right candidate must be a team player with strong communication skills and be comfortable working in a fast-paced environment. This position requires starting automation on the project from scratch. The project requires strong knowledge of Oracle DBA and wide experience so that the candidate could independently analyze the problematic areas and propose enhancing solutions for optimization. Candidates will collaborate with QA team members, development team members, and project managers.