DBA-Oracle Job Description
DBA-Oracle Duties & Responsibilities
To write an effective dba-oracle job description, begin by listing detailed duties, responsibilities and expectations. We have included dba-oracle job description templates that you can modify and use.
Sample responsibilities for this position include:
DBA-Oracle Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for DBA-Oracle
List any licenses or certifications required by the position: DBA, AWS, II, IAT, OCP, ITIL, CISSP, CE, CASP, JNCIE
Education for DBA-Oracle
Typically a job would require a certain level of education.
Employers hiring for the dba-oracle job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Master's Degree in Computer Science, Education, Technical, Engineering, Information Technology, Information Systems, Business, Administration, Design, Science
Skills for DBA-Oracle
Desired skills for dba-oracle include:
Desired experience for dba-oracle includes:
DBA-Oracle Examples
DBA-Oracle Job Description
- Design and automate monitoring and carry out regular tuning as indicated, to measure performance and ensure continuing optimum performance and reliability
- Implement systems performance reviews and action schedules to ensure performance targets are met
- Create and implement more advanced database application programs beyond training / experience of development teams, to enable complex data manipulation
- Maintain and promote awareness of new database functionality as appropriate to and required by the business
- Give 24 / 7 call-out support on all production databases to maximise availability to users
- Stay informed of Oracle patches for bug fixes and recommended upgrades
- Install, upgrade and maintain Microsoft database software
- Create appropriate databases and database structures based on application usage
- Define and implement appropriate utilities to monitor database functions and activity
- Develop and maintain shell scripts
- Ability to work well independently within a team environment
- May oversee and monitor annual budget process including
- Assign, coordinate and review work of staff
- The successful candidate possesses dynamic leadership capabilities to build and manage a highly effective organization and develop high-performance teams that may be geographically dispersed
- The candidate will have worked for at least 3 years in a large global organisation that had a dedicated DBA team for Oracle
- Experience of 24x7 production support of a database real-estate that contains Oracle, UDB, MySQL and Informatica technologies
DBA-Oracle Job Description
- Configuration and support of Data Guard and Data Guard Broker
- Configuration and support of Oracle GoldenGate replication and Veridata
- Support of Oracle ZFS storage appliance
- Working experience with Oracle Database security and products
- Implementing Oracle Maximum Availability Architecture (MAA) best practices for Databases
- Assisting with SuperCluster and ODA and one-off patching
- Supports and collaborates with Solaris and WebLogic administrators
- Supports and collaborates with the Application Database administrators as required
- Participates in Disaster Recovery and database capacity planning
- Develop, maintain and support an Oracle DB ODS (operational data store) and the ETL processing to produce the Vantage product
- Bachelor’s degree in Computer Science or other relevant technical discipline with 15 years of related experience
- Experience with RMAN backup and recovery export/import
- Experience with DB utilities such as exp, imp, sql loader, expdp, impdp
- Low level Script (perl)
- Experience in managing Database Migration/Upgrade projects complex database reorganizations and maintenance tasks
- All candidates must have a minimum of Bachelor's Degree and not require sponsorship
DBA-Oracle Job Description
- Develop and manage SOPs
- Manage database and application users, roles, and privileges
- Implement and validate Oracle patch sets and critical patch updates
- Documenting of processes and outcomes
- Provide overall database architecture, design, installation, configuring, technical support and maintenance of Oracle Databases in a Storage Area Network (SAN) and Cluster Server environment
- Performing installation, configuration, customization, creation, implementation and support
- Diagnose and troubleshoot operational issues impacting deployment of solutions
- Oracle R12 application administration, including concurrent request scheduling and installation, request set configuration, setting profile options, custom responsibilities & menus, user account management
- Troubleshoot and correct challenging Oracle technical issues, including utilizing Oracle Diagnostic programs
- Assist DBA/Development team with availability of the development, test, and production environments
- Have strong SQL/PL-SQL knowledge
- Experience with Dataguard and ASM
- Selected candidate will be subject to security investigation and must meet eligibility requirements of DoD clearance
- Minimum of 6 years of experience as Oracle DBA on Unix/Linux platforms
- Cassandra DB experience
- Support development teams with database object creation, PL*SQL, procedures, triggers
DBA-Oracle Job Description
- Use Oracle Grid Control (OEM12c) for monitoring
- Collect and assess information contained in the asset management systems and manage appropriate performance reporting, communicating performance outcomes/metrics/asset status to stakeholders in accordance with approved Platform technology Management plans
- Design, install, configure, upgrade, and manage Oracle RDBMS 11g
- Represent database administration team in operational project activities
- Implement & configure DB appropriate to business requirements (OLTP, decision support, standby DB, replication)
- Create and generate various database reports to help plan for capacity and performance
- Investigates and resolves technical database issues
- Performs analysis and determination of database performance characteristics, data relationships and attributes, data flow and storage requirements, and data output and reporting capabilities for multiple applications
- Defines logical attributes and data inter-relationships and designs data structures to accommodate database implementation, storage, maintenance and accessibility to enhance performance
- Develops and documents standards, procedures, work instructions for database support that help in increased productivity for operations
- Operating knowledge of RMAN, Dataguard, OEM, Audit Vault
- Maintain database to meet IRS and local internal security standards
- Resolve IRS database audit concerns and remediate known vulnerabilities
- Maintain currency in database, data management, and industry trends through research/education/self-motivated training and personal development
- Experience on Oracle RAC deployment, administration and maintenance of large scale DBs of 70 TB +
- Experience on Oracle Data Guard replication, backup and support of large scale databases of 70 TB +
DBA-Oracle Job Description
- Database Upgrade / migration experience from Oracle 11g to 12C RAC and Non RAC databases using manual / DBUA / GoldenGate
- Working knowledge of Suse or Redhat Linux
- As the business evolves you may be required to perform other duties as assigned
- Set up Oracle and Unix environment components
- Maintain/Administer test environment databases
- Housekeeping of Unix file systems
- Backup/Restore Oracle Databases (Ad-hoc and Scheduled) & Applications
- Provide environment support (including defects, requests and data cut-down)
- Raise defects against Documentation, Code and configuration required for deployment
- Advise projects on database requirements and provide input to Coordinators/Test Leads and Release Managers on environment capacity
- Experience with sql tuning, trouble shooting SQL statements and PL/SQL programs (statistics can include CPU usage, block I/O, record I/O, table scans, sorts)
- Bachelor’s degree in Computer Science or related field or equivalent related experience
- 3-5 years’ experience with oracle and sql database Administration (Oracle certification is a plus!)
- Experience in oracle exadata administration is a plus
- Must have the ability to multi-task in a very fast-paced environment
- Ability to handle high pressure situations and quickly respond and resolve production problems