Oracle Database Administrator

Job Description

The Oracle Database Administrator must have at least 7+ Years of experience. Primary responsibilities of the Database Administrator include supporting database operations including but not limited to database performance monitoring, query optimization, code deployments, stored procedure development, access management and database analysis.
In this role, you will be responsible for operating in Oracle and Exadata (Informix and SQL Server a plus) and supporting database re-platforming efforts. You will be responsible for creating database objects, investigating performance issues, and monitoring database performance. Golden Gate experience is a plus.
You will work closely with the current DBA team, Data Architects, Data Analysts, and database owners to support both short-term work requests and long-term strategic implementation. For this role, you must have strong technical and communication skills coupled with the ability to convey your findings and recommendations to large groups.

Primary Responsibilities:

• Support ongoing efforts and provide technical support for multiple database re-platforming efforts to Exadata.
• Assist in setup and implementation of GoldenGate data replication.
• Optimization and tuning of SQL queries and indexes in database environments.
• Monitoring of the database performance as it relates to memory usage, proper backups, active sessions, long-running queries, tablespace configuration, and space allocations.
• Coordinate with Data Architects and Data Analysts on the building of schemas, tables, functions, views, stored procedures, and roles with an extensive knowledge of best practices.
• Coordination with the Automation teams for the scheduling of various jobs to be executed on multiple databases.
• Provide DBA supervision and Oracle best practices guidance for custom application development and routine database administrative efforts.

Education:

Bachelors degree in Computer Science, Electrical/Electronic Engineering, Information Technology or another related field or Equivalent.

Qualifications:

• 5+ Years of both logical and physical DBA experience, including experience across Oracle and Exadata.
• Experience with Informix, SQL Server, Hadoop, MongoDB or Microsoft Access database a plus.
• Extensive working knowledge of all aspects of ETL processing, including GoldenGate (Informatica a plus).
• 5+ Years of Data Governance experience and working knowledge of best practices.
• Familiarity with JIRA workflow processes and Agile methodology.
• Working experience with Microsoft SQL Server Management Studio, DBeaver, TOAD, or Oracle SQL Developer.
• Good Communication skills.
• Self-Motivated.
• Capable of presenting to all levels of audiences.
• Works well in a team environment.
• Experience with MDM methodology and tools a plus.
• Working experience with Denodo Data Virtualization a big plus.