Oracle Database Job Description
Oracle Database Duties & Responsibilities
To write an effective oracle database job description, begin by listing detailed duties, responsibilities and expectations. We have included oracle database job description templates that you can modify and use.
Sample responsibilities for this position include:
Oracle Database Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Oracle Database
List any licenses or certifications required by the position: DBA, CE, II, IAT, OCP, ITIL, SQL, CISCO, DBMS, RAC
Education for Oracle Database
Typically a job would require a certain level of education.
Employers hiring for the oracle database 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, Technical, Information Technology, Engineering, Education, Information Systems, Administration, Business, Design, Management
Skills for Oracle Database
Desired skills for oracle database include:
Desired experience for oracle database includes:
Oracle Database Examples
Oracle Database Job Description
- Provide advice and guidance
- Convert legacy utility modules to current standards
- Install, analyze, and configure operating system and/or database products to achieve optimal system performance
- Develop and maintain applications and databases
- Build RAC Database in Oracle 11g real application clusters
- Check backup status of OCR file, cluster, node status, load balancing and services
- Design and Handle backup strategy
- Ensure Installing/Upgrading/Downgrading Oracle 11g/10g/9i/8i
- Ensure Adding/Deleting Nodes from RAC Cluster
- Ensure Moving Instances across RAC Cluster
- Should have customer facing experience along with coordination with different teams/departments
- Hands on experience implementing Database Security & Auditing
- Extensive direct experience with the design, administration, and management of Oracle databases
- Extensive experience in the administration and operation of the Oracle Real Application Cluster (RAC) technology and the application and utilization of the Oracle Recovery Manager (RMAN)
- Extensive database development skills, application knowledge, and business experience with the ability and desire to lead technical solutions
- 10 + years direct experience in Oracle Database Administration
Oracle Database Job Description
- Apply predictive analytics to massive data sets (billions of rows, several hundred terabytes of data)
- Tunes databases for efficiency, and manage scalability demands as required
- Supports transition of current applications to the Oracle 10g environment
- Assists with application migration/upgrades to the Oracle 10g environment and other data loads(ETL) in support of research projects
- Ensures database systems management including installations, configuration, cloning, backups/restores/reorganization, tune performance, upgrades, patches/updates
- Designs and controls DBMA operational procedures and support including, data modeling, database design, replication, administration, maintenance, performance monitoring, optimization, capacity/capital planning, space management and recovery
- Follows appropriate processes and procedures, including for coding standards and code control methods, or SOPs for regulatory requirements, organization-wide competencies
- Assists with system/network configuration planning and adjustments to maintain efficient and cost effective operations
- Assists in system operational support to maintain the stability of live systems, which may include being on-call evenings or weekends to handle emergencies
- Perform technical trouble shooting and consulting to development teams
- Experience handling complex technical issues with Oracle vendor and assist in problem resolution
- Experience designing and implementing Oracle database utilities (backup & recovery) and using Oracle diagnostic and monitoring tools
- Capability to present complex database issues to senior IT and non-IT management
- Experience in supporting critical production environment
- Sound reasoning, analytical, and problem solving aptitude
- Interaction with end users to gather requirements
Oracle Database Job Description
- Manage the day to day operations of the RDBMS environment and High availability systems
- Evaluate Oracle features and Oracle related products by using Oracle 9i, 10g, 11g and 12c
- Use RAC to deliver high performance, increased throughput, and high availability
- Maintain single, two and four node Clusters on non-Exadata and Exadata machine
- Apply policy to protect application data, Access control
- Authentication method, preventing unauthorized ad-hoc access by using Database Vault
- Build audit vault to gather information from remote databases, monitor for audit data
- Monitor the web logic service and escalate to owner of the system
- Monitor routing policies, maintaining OID server, starting/stopping services
- Participate in the design and implementation of new Oracle Database platforms
- Providing direction and guidance to a team of developers, including allocation and management of workload
- Experience with Oracle 11g/12c Database Administration and Management on AIX platforms
- Requires excellent analytical skills and attention to detail
- Good in Oracle RDBMS architecture and concepts
- Experienced usage of dictionary views
- Working knowledge on Dataguard
Oracle Database Job Description
- PL/SQL coding for standard database maintenance tasks
- Linux Administration in an Oracle 11g environment
- Oracle SQL scripting for data acquisition supporting federal law enforcement agencies
- Configure and administer Flash Recovery Area
- Work with other database administrators and system administration staff on configuration, backup/recovery and security issues
- Work with developers, QA and other administrators to develop and implement standard deployment practices
- Open Oracle Support Requests for all database related errors and proactively apply patches
- Write Datapump scripts to refresh UAT and DEV environments
- Partition large tables and provide data modeling support to development groups
- Upgrade databases from Oracle 11g to 12c
- At least 3 years experience in Oracle RDBMS 10g/11g and SQL/PLSQL
- At least 2 years experience in Database Performance and General High Availability Technology (RAC/Standby DB/DataGuard/ASM)
- Knowledge of Operating Systems (W2K, UNIX, SUN, AIX, Linux), IP Services
- RMAN skills
- At least 3 years of experience in administration of Oracle database
- DBA-Oracle-Core skills would be an advantage
Oracle Database Job Description
- Ability to self-manage and work in dependently with other database administrators
- Experience monitoring database management systems evaluating database performance to maximize efficiency
- Perform Datapump Import/Export operations
- Perform Unix/Database/Application patch
- Ability to perform software installs, upgrades and patch installs
- Performs routine maintenance, including upgrades and patches
- Manages conversions of data from legacy/acquired systems as required
- Ensures operational data integrity for core application systems through designing, implementing, maintaining, and monitoring database systems
- Anticipates future database capacity trends for hardware usage and user load
- Interacts directly with other information systems teams
- Identify oracle network related problems and implement solutions
- Oracle 12c Cloud control, RMAN for backup and Recovery and Data guard Maintenance
- Star schemas
- Data Warehouse methodology
- Current Oracle certification
- Bachelor’s degree from an accredited college or university with a curriculum or major field of study which provides substantial knowledge useful in managing large, complex AIS projects, is closely related to the work to be automated, and/or in a computer science, information system, web design or other IT related discipline or an advanced training certificate in his/her field