Oracle DBA

Skills

Description

Sr level Oracle DBA needed who will also be supporting/maintaining 100 DB2 databases (test/QA/production) and 25 in DR......running on AIX/Linux (aprox 10% of time). Primary role is applying patches and monitoring with some change management.

Will join a team of approx 20 DBAs including offshore (Oracle and SQL Server) responsible for all duties related to Oracle database administration and troubleshooting - mostly monitoring, performance tuning and materialized views along with some possible upgrade and migration work (Postgres and AWS)

Environment Oracle 1500+ prod/non-prod and SQL Server (2008r2 thru 2017) 1000+ prod/non-prod

Please note this role provides 2nd level support on a rotational basis along with development activities.

Responsibilities

• Deep knowledge in installing, configuring and maintaining enterprise Database Technology environments such as Oracle and PostgreSQL in an on premise and AWS Cloud infrastructure
• Extensive knowledge installing, upgrading and performing Disaster Recovery efforts with Oracle DB's
• SQL Tuning and Database Performance Evaluation and Configuration
• Systems engineering experience, including AIX / Linux performance, memory management, I/O & Performance tuning, security, clusters and troubleshooting.
• Experience working directly with customers, resolving database, systems and infrastructure-related issues and also providing systems architecture leadership
• Working knowledge of relational database internals (locking, consistency, serialization, disaster recovery)
• Coding skills in at least one scripting language a must (TCL, Perl, Python, PowerShell, etc.)
• Minimum 5 years of experience engineering, administering and managing multiple relational database technologies (e.g. Oracle, PostgreSQL, etc)
• Experience in Agile/Scrum methodology
• Experience in shell and python scripting with focus on DevOps tools, CI/CD
• Significant exposure in various OS administration tasks
• Analytical Problem Solving
• Effective Written Communications
• Effective Verbal Communications