Database Administrator

Apply Now

Company: Codeforce360

Location: Chicago, IL 60629

Description:

Required Skills:
  • Senior Oracle Apps DBA - experience with multi-tenant instances a big plus.

Project Overview:
  • The DBA will be responsible for Project DBA tasks.
  • This will include upgrades of Oracle RDBMS versions 11g/12c to the latest Oracle 19c RDBMS release utilizing multi-tenant container/pluggable RDBMs on Oracle Engineered Systems (Exadata).
  • The Project DBA will work within the TIPMO (Project Management Office) process using Client PMLC methodology.

Contractor's Role:
  • In this role, the Oracle DBA will design, build, test, and deploy quality database solutions that are consistent with PMLC project objectives and NTRS technology architecture standards and best practices.
  • The Oracle DBA, as part of a project team, will execute all database tasks from design phase to deployment phase utilizing their expertise to direct design, make configuration suggestions, and implement database solutions that maximize system availability, efficiency, effectiveness, integrity, recoverability, and supportability.
  • The DBA will actively collaborate with the GDP Engineering team to develop standards and guidelines to guide database infrastructure strategy.

Experience:
  • Level 3[8+ years].

Qualifications
  • Ability to cope in a technically complex and fast-changing environment, and to respond calmly and rationally to changing priorities in a deadline-driven situation.
  • Strong planning and organizing skills including the ability to manage several work streams simultaneously.
  • Ability to think strategically and evaluate options in the short, medium and long term.
  • Good communication skills with a capacity to present, discuss and explain issues coherently and logically both in writing and verbally.
  • Clear decision-making ability with the facility to judge complex situations and assess when to escalate issues.
  • Ability to balance conflicting and changing demands through prioritization and a pragmatic approach.
  • Good team player, self-motivated and able to work on own initiative.
  • Minimum of 10 years of experience in administrating medium to large databases in complex enterprise environments.
  • BS in Computer Science or equivalent experience.
  • Database experience from either working in a support organization or project team. Deep experience in working on large database clusters.
  • Experience with management of Oracle Databases:
  • Experience with Oracle 11g, 12c, 19c, Oracle RAC and Oracle Data Guard.
  • Experience with Oracle Multitenant (Containers and Pluggable databases), in addition to it's features such as Hybrid Columnar Compression.
  • Knowledge of Oracle engineered (Exadata) hardware platforms, networking, storage and subsystems.
  • Experience with Oracle Enterprise Manager (OEM).
  • Experience with Installation/Upgrade/Patching of database software and related Exadata tasks.
  • Experience with backup/recovery design, DR implementation, monitoring implementation, performance tuning and optimization.
  • Experience with storage management, provisioning, and optimization.
  • Experience with software and firmware maintenance of all Exadata components, including OS, grid, database, storage cells, and Infiniband.
  • Deep experience with the Linux operating system and shell scripting.
  • Good understanding of fundamental technologies like TCP/IP, HTTP, FTP, SMTP, DNS, Load balancer, NFS.

Nice to Haves:
  • Experience with Golden Gate and the migration of very large databases.
  • Experience with Delphix.
  • Knowledge of Oracle In Memory database.
  • Encryption technologies and experience a plus.
  • Understanding and execution of the IT processes of Incident Management (Service Now), Problem Management, Change Management, and Configuration Management.

Tasks & Responsibilities:
  • Perform activities in support of a 24x7 global support model for all environments.
  • Experience working within a project management processes:
  • Partner with business, technical, and application partners to discuss the project requirements and to help plan and develop solutions for he Oracle Database architecture.
  • Ability to plan and complete projects based on high-level requirements with minimal or no guidance.
  • Methodical and accurate while delivering tasks, working within project deadlines.
  • Systematic approach to identifying issues and pursuing paths to resolution.
  • Experience installing and building new solutions or improving existing applications.
  • Ability to foresee relevant issues and assist in proposing possible solutions, Performance and Tuning expertise a must, root cause analysis in a Firecall situation.
  • Lead upgrades and migration of Oracle legacy software versions (Lifecycle).
  • Participate in the design, configuration and implementation of secure and scalable enterprise Oracle 19c RDBMs.
  • Management of multiple schemas/databases through system development, User Acceptance testing and production environment.
  • Plan, coordinate and implement security measures (Encryption) to safeguard information against accidental or unauthorized damage, modification or disclosure.
  • Develop and execute data migration strategies for VLDB, review and improve lifecycle upgrade processes, contribute to project best practices for Engineered Systems (Exadata).
  • Communicate and educate Application teams regarding Oracle RAC, the Exadata platform and the process of rolling maintenance plans for engineered systems.
  • Troubleshoot and resolve issues affecting Oracle 19c projects which may impact go-live dates.

Similar Jobs