Oracle Database Administrator/Architect at Datavail

Posted in Information Technology 5 days ago.

This job brought to you by eQuest

Type: Full-Time
Location: Dallas, Texas





Job Description:

Datavail

*****Please Note***** This position requires candidate to be US Citizen or GC Holder.  Non residents of the US (even with H1b and I140) can not be considered due to ITAR requirements.

Title: Oracle DBA/Architect

Location: Just outs side Dallas Texas (Hurst, TX) - This position is onsite at our client location.  Will be working with two offsite DBAs who are based at Datavail HQ.

Datavail is seeking a Oracle DBA/Architect to be an onsite point person for a managed service engagement he/she and two other Datavail DBAs will optimize production systems as well as assist with the creation of a DBaaS service offering. The onsite DBA will be the customer facing member of a team of three working this long term engagement.

The Ideal candidate will have the following Skills and Experience. 

Education: 
Bachelor’s degree in MIS/CS or equivalent experience

RDBMS Systems:
Required: Oracle
Preferred:  PostgreSQL, MySQL, MongoDB

Oracle:
15+ years of experience with Oracle version 8i-19c

Database Workloads:


  • 6+ years’ experience with DB workloads on the following enterprise systems: PLM, ERP, MES, Timekeeping, PMO

  • 6+ years of experience with monitoring systems: OEM 12c – 13c

Experience with following Oracle features:


  • 6+ yrs advanced database performance tuning and optimizations on enterprise class applications and OLTP applications in excess of 300K transactions/second

  • 4 + yrs RAT (SPA and Replay)

  • 4+ yrs Engineered Oracle Appliances

  • 3+ yrs Oracle Advanced Security: OUD, EUSM, Kerberos

  • 4 + yrs RAC and ASM

ANSI SQL Tuning\Optimization:


  • Expert level understanding of the database optimizer, heuristics and indexes.

  • Ability to change indexes, statistics, and setup baselines, SQL profiles, SQL patches, and analyze traces for performance investigation and parameter optimizations.

  • Usage of SPA\Replay to eliminate query plan changes introduced through database upgrades and or re-platforms. Preferred experience leveraging this toolset to migrate enterprise application(s) to new database versions and or platform with nominal query plan variance introduced by optimizer and or application behavior changes.

  • Drive out abusive usage of cursors in favor of using set based operations and advanced ANSI SQL design patterns.

Database Architecture:


  • Implement database CMDB and document standards and processes in order to achieve DBaaS.  This process should include standardized repositories and marts to document CIs in the environment and ensure each new application and database follows ITSM and ITIL documentation and processes.

  • Database automation and orchestration using REST, bash, PowerShell, OEM.

  • In-depth understanding of Oracle Process architecture and designing HA solutions that meet and exceed business expectations.

  • In-depth understanding of DBMS backup solutions and integrations with various backup solutions and replication topologies.

Analytics and Reporting:


  • Data Warehouses (Design\ETL\Performance Tuning\Maintenance)

  • ETL and asynchronous near real time change data capture patterns

  • ETL and real time data flows using Kafka/Spark

  • In-depth understanding and implementation of data replication topologies such as GoldenGate, Attunity,DataGuard , ANSI SQL replication patterns.

About Datavail:

Datavail provides a broad range of IT services in support of IT infrastructure, Microsoft solutions, databases, analytics, and applications and specializes in Oracle, Oracle E-Business Suite, OBIEE and OBIA, Hyperion, Microsoft SQL Server, MySQL, MongoDB, DB2 and SharePoint. Datavail is a leading provider of data integration and database administration services in North America, offering 24×7 managed services, design, architecture, and consulting.

With more than 1000 employees on payroll and core operations in four countries, Datavail offers deep technical expertise in a flexible, agile engagement model that focuses on customer success. Founded in 2008, Datavail is based in Broomfield, Colorado and supports enterprise clients located worldwide. For more information, visit www.datavail.com.

As part of the Datavail team, you’ll have the opportunity to work on exciting projects with a mandate to innovate, create, and deploy some of the best technology solutions in the world. Additionally you will have the opportunity to work alongside our broad team of experts to learn, grow and build your career can only be found in one place – Datavail. Working at Datavail is not just a career, but an opportunity to be a part of something bigger.  Come grow with us!

See Job Description