Skip to Main Content
← Back to Jobs

Oracle Performance Tuning DBA's

PeopleNTech LLC Washington, DC
  • Posted: over a month ago
  • Other

Role: Oracle Performance Tuning DBAs

# of positions: Two (2)

Location: Washington, DC 20416

All resources must be able to work onsite M-Thu

Duration: 12 months

Work Status: Must be US EAD or US Perm Resident or US citizens in good standing (in order to quickly obtain Public Trust clearance upon hire)

Start date: Immediate (July)

Interview: 1) Phone interview with Managing Director and ERP Specialist Master and 2) Final technical phone interview

Performance Tuning/Architecture DBA

Level: Sp Sr. /Sp M and PDM equivalents

Position Description

The Database Administrator role is to evaluate, monitor, troubleshoot and implement performance tuning strategies, methodologies and techniques to improve and maintain databases for a large federal enterprise data warehouse while ensuring high levels of data availability and performance. The DBA will work in a Data Warehouse environment that leverages Informatica PowerCenter ETL to source data from oracle EBS, Oracle Business Intelligence for Information Delivery, Oracle Database on engineered systems as RDBMS.

Typical tasks for this position include:

Analyze current environments and workloads to identify performance bottlenecks in reports and ETLs

Create solutions and plans for short term and long term improvements

Performance tune SQL queries generated from Informatica, OBIEE in OBIA and EBS using Oracle native tools (explain plan, tkprof, 100** events, AWR, SQLT, RDA)

Optimize database, exadata, Informatica and OBIEE configuration parameters

Refine and optimize infrastructure architecture and create architectural prototypes as required

Identify partitioning keys and partition tables and indexes

Participate with responsibility and accountability in design sessions for new projects to understand underlying design and create performant solutions

Create programs to automate tasks such as identifying and remediating fragmentation/chained rows, identifying and reporting change in query plan etc.

Migrate changes following established change management processes

Create validations and test cases to test solutions for performance, regression and integrity

Liaison with Oracle product and hosting provider on a day to day basis to troubleshoot and resolve issues

Work with developers and functional resources to understand underlying requirements to design for performance

Create review and maintain architecture documentation

Demonstrate detailed analysis, problem solving skills and a strong drive to continuously improve the current environment

Handle multiple tasks and adapt to a constantly changing environment

Train, instruct, and mentor new team members

Required skills and experience:

7+ years IT experience

3-4 years' experience with Oracle database configurations, structures and architectures, principles, and tuning practices.

Have a bigger picture/solution architecture mindset to look at issues

Hands on experience in handling Oracle databases over 10TB in size on Oracle Supercluster and Exadata platforms

Excellent knowledge of in-memory processing, storage architecture and database concepts such as indexing, partitioning, stats gathering, parallel processing and multithreading techniques, performing analysis for performance issues, debugging wait events, resolving errors, digging beneath the surface to debug issues that may exhibit symptoms but not error messages

Strong understanding of data warehousing concepts, relational and dimensional data models

Hands on experience in Performance Tuning of sources, targets, transformations and sessions.

Good communication skills, systematic approach, and quick adaptability to new technologies and new working environment.

Ability to translate ideas into work plans

Self-starter with ability to work independently and take initiative

Desired Skills/Certification:

Oracle DBA Professional certification

Experience designing, developing, testing or maintaining applications and databases as part of a larger IT team

Knowledge of Oracle Data Administration Console (Optional)

Knowledge of CPU architectures, distributed file systems and Big Data technologies

Position Requirements:

This position requires a U.S Government Public Trust/Suitability determination

PeopleNTech LLC

Address

Washington, DC
USA

What email should the hiring manager reach you at?

By clicking the button above, I agree to the ZipRecruiter Terms of Use and acknowledge I have read the Privacy Policy, and agree to receive email job alerts.

What email should we contact you at once we get salary info from the hiring manager?

By clicking the button above, I agree to the ZipRecruiter Terms of Use and acknowledge I have read the Privacy Policy, and agree to receive email job alerts.

Our qualification feature is only available to registered members - what email address would you like for us to keep on file?

By clicking the button above, I agree to the ZipRecruiter Terms of Use and acknowledge I have read the Privacy Policy, and agree to receive email job alerts.