Oracle Database Admin to support many Oracle initiatives such as Oracle database upgrade projects for Amos, Crunchtime, data center relocation and other applications. The application and database upgrades may include OS platform change as well as migration from Oracle Standard Edition to Enterprise Edition. Build database implementation, performance, rollback, test and execution plans for these initiatives for optimal uptime or the respective critical applications.
Responsible for the general Database Administration of Oracle server Databases on ship and shore which includes install, patching, upgrades, performance tuning, backup and recovery, refresh, configuration, development team support, user administration, security, database, deployment as needed and audit compliance and standards.
Review and QA Database Programs
Automation of data conversion scripts, refresh environments, documentation
Create, and maintenance of Database Systems documentation as needed.
Required skills/competencies:
Oracle Database Administrator, Operations Job Summary for Oracle DBA,
Part of the team responsible for the implementation, planning, coordination, configuration, installation, upgrade and ongoing management of all Oracle Databases. Very proficient with AWR, ADDM tools.
Key responsibilities include the identification and resolution of hardware, software or database problems/outages in any of the our services. These responsibilities require 24×7 coverage and response to systems alerts during after-hour periods. Specific database performance issues, error messages or service problems will be routed directly to the Database Administrator.
Work closely with Systems Engineering to test planned databases upgrades, including definitions, structures, and/or documentation, as well as provide input into long-range database requirements and operational guidelines. Additionally you will use best operating practices to establish and maintain security and integrity controls. The DBA will formulate and monitor policies, procedures and standards relating to database management; propose and implement enhancements that will improve the performance and reliability of the system; proactively research and locate necessary tools and processes to identify and proactively avert troublesome trends, as they develop in order to ensure a stable performance environment for the IT production environment.
Required Skills/Experience:
Bachelor’s degree
5-7 years Oracle DBA experience, 5+ years in a 24/7/365 environment
Experience with highly available database solutions / architectures such as Oracle RAC and Standby Databases.
Experience in database design required.
Experience with AIX, Linux and Windows are desired.
Oracle Performance Tuning Experience (AWR, ADDM)
Experience working in secure enterprise database environments
Experience with RMAN
Experience with Exp/Imp, dpexp/dpimp Oracle tools.
Extensive knowledge with ASM
Disaster Recovery Experience.
Strong SQL Programming, preferably Oracle with the ability to write complex SQL queries – understanding of views, stored procedures, triggers & an understanding of query optimization.
Excellent SQL and PL/SQL skills
Experience with database layouts on high performance disk subsystems required
In addition candidate must exhibit the following:
MUST have extensive experience working in structured change management processes for highly available enterprise database systems
Excellent communication skills, both written and verbal
Strong interpersonal and relationship building skills conducive to team development
Ability to perform needs assessment and handle technical objections
Additional Information:
Competency in writing/analyzing PL/SQL, Korn shell scripts, et al.
Competency with data conversion, re-platform and transfer of data from on-premises to cloud
Oracle database upgrade experience is a must from 11g to 12c/18g/19g.
– provided by Dice
source https://www.jobsinmiramar.com/other-general/oracle-dba-8d1f4a/
Scott Smith 