Oracle DBA Job Description
Oracle DBA
provides guidance to application teams, business users where appropriate in terms of best practices for SQL development and database usage.
Oracle DBA Duties & Responsibilities
To write an effective oracle DBA job description, begin by listing detailed duties, responsibilities and expectations. We have included oracle DBA job description templates that you can modify and use.
Sample responsibilities for this position include:
Proactive career management and promotion opportunities
Comprehensive training and personal development plan for each individual to help enrich talent
Develop and establish department standards and procedures
Coordinate technical support and direction to programming, operations and other departments
Assume overall responsibilities for project status, meetings, reporting, scope changes, financials, administrative and technical issues
Serve as the primary liaison for Technical & Business teams
Provide 24/7 support of production database services to ensure the highest standards of availability resilience, integrity, security and performance
Manage and maintain backups and recovery procedures
Install and maintain database server, replication and client environments
Develops and implements plans to oversee the database administration function and ensures smooth transition to new technology
Oracle DBA Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Oracle DBA
List any licenses or certifications required by the position: DBA, AWS, II, IAT, OCP, ITIL, CISSP, CE, CASP, JNCIE
Education for Oracle DBA
Typically a job would require a certain level of education.
Employers hiring for the oracle DBA 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 Oracle DBA
Desired skills for oracle DBA include:
Partitioning
ASM
Oracle OEM
Datapump
Materialized views
Development cycle of a rapidly paced dev env
SQL
RMAN
ITIL framework
Vocabulary and best practices
Desired experience for oracle DBA includes:
Familiarity with standard database monitoring tools (OEM)
Able to use documentation tools to follow and maintain technical plans and procedures
Excellent verbal communication during project & Senior stakeholder meetings
Good verbal communication skills representing Database team during strategic planning and database architectural reviews with projects
Communicating on technical challenges to project managers & service owners
At least 6 years experience in Data Guard
Oracle DBA Examples
1
Oracle DBA Job Description
Job Description Example
Our company is searching for experienced candidates for the position of oracle DBA. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for oracle DBA
- Oracle Real Application Clusters (RAC) and ASM support
- Strong database and operating system concepts
- Should have good previous experience in administering Oracle DBs versions 9, 10, 11 in a high availability environment, experience in implementing DB upgrades
- Participate in client/project meeting(s) for needs assessment and design review
- Analyze the needs and requirements of users of existing and proposed database systems and develops technical, structural and organizational specifications to include access methods, access time, job control language, statistical methodologies, device allocation, validation checks, protection and security
- Design, develop, implement and maintain database for internal and external users/clients
- Create, document and implement standards and/or modeling to monitor and enhance the capacity and performance of the database
- Program and write codes as necessary
- Develop data import and export routines to automate data loading
- Build windows, screens and reports
Qualifications for oracle DBA
- Oracle certification such as Administrator Certified Associate/Professional and additional knowledge and/or experience working with Hadoop are a plus
- Experience with GoldenGate, VeriData, Streams a plus
- Must have experience installing, administrating and upgrading Oracle 10G, 11g and 12c
- Experience and knowledge in Database Administration of Oracle Databases
- Minimum 5 years experience as an Oracle DBA in a production environment
- 5 to 7 years experience as an Oracle DBA in a production environment, with experience in both 10g and 11g versions
2
Oracle DBA Job Description
Job Description Example
Our company is growing rapidly and is looking to fill the role of oracle DBA. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for oracle DBA
- Database conversions - 65%
- Migrating code, database changes and data through the various stages of development - 10%
- Database patching and upgrade support
- Follows, defines and manages enterprise level policies and procedures that ensure the security, optimization and integrity of Oracle database environments
- Anticipates and resolves database performance, capacity and replication issues
- Diagnose and address database performance issues
- Understands standard concepts, practices and procedures relating to database and associated technologies
- Manages database backup & recovery procedures, disaster recovery preparation and the associated exercises
- Produces reports on database systems related to availability, performance, capacity management and SLAs
- Collaborates with SAN, server, applications and operational staff in support of database objectives
Qualifications for oracle DBA
- DR and High Availability solutions such as Data Guard, RAC
- Experience in implementing operational automation using shell scripts, PERL , AWL, SED
- Hands-on" experience with general Oracle Database Administration
- Familiarity with Oracle utilities
- Have knowledge to support very large databases with heavy OLTP and batch activities
- Have knowledge in performance monitoring & tuning
3
Oracle DBA Job Description
Job Description Example
Our company is growing rapidly and is hiring for an oracle DBA. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for oracle DBA
- Tune the database to ensure optimum use of resources
- Creation and support of system documentation and maintenance scripts
- Research, propose and implement new solutions, features, and improvements
- Willing to work hands-on 7/24/365 and participate in on-call schedule to resolve problems
- Support and troubleshoot Oracle SSO for EBS R12 using OAM 11g
- Automate manual procedures, streamline and standardize processes where necessary
- Support developers with database design (schema structure) for both OLTP and Data Warehousing applications
- Serve as a Schema Administrator to support backup and recovery of schemas
- Monitor space usage including capacity planning
- Define and execute ORACLE performance tests
Qualifications for oracle DBA
- Ability to obtain and maintain the required customer clearance - MBI
- Participate 24 x 7 in database administration, software, and hardware support
- Consult on technical solutions that include hardware design, server networking design, high availability Oracle database designs, data models and schema objects
- Support lower environment and production Oracle databases including concurrent development efforts
- Deploy and maintain Windows and Unix scripts to ensure the database build and change processes are efficient
- Develop, perform, and monitor database backups ensuring that backup process is efficient and reliable
4
Oracle DBA Job Description
Job Description Example
Our company is growing rapidly and is looking to fill the role of oracle DBA. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for oracle DBA
- Assess deploy and where necessary correct SQL Scripts delivered by various engineering rooms
- Optimizes database accessibility by developing load balancing architectures and processes to eliminate down time for backup processes
- Implements and supports database security regulations, policies, and guidelines
- Work on the existing complex application databases while planning and implementing the right technologies to support growth objectives
- Work with complex application databases in order to sort through critical issues as they arise
- Manage multiple day-to-day priorities while driving more reliable and sustainable approaches for the future
- Track and resolve database related incidents and requests, and escalate as necessary
- Apply regular and proactive database patches, updates and performance enhancements
- Provide technical support for development activities
- Adhere and improve “best practices” documentation
Qualifications for oracle DBA
- Experience with Oracle 12c container/pluggable databases and database encryption technologies such as TDE
- Experience on data replication tools such as Shareplex, Golden Gate, Delphix, for large scale and high volume OLTP transactional databases
- Experience on deployment, administration and maintenance of large scale DBs using oracle Exadata database machine, super cluster and or database appliances
- Experience on deployment, administration and maintenance on database virtualization technologies such as SNAP Clone in Oracle Exadata environment
- Experience on cloud deployment, migration and integration using DEVOPS agile-development tools such as Jenkins, Ansible and REST API
- Strong knowledge of Oracle database administration in Solaris/Linux/Unix/virtual environments
5
Oracle DBA Job Description
Job Description Example
Our company is growing rapidly and is hiring for an oracle DBA. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for oracle DBA
- Plan, perform and monitor database backups using Oracle RMAN Recovery Manager and Storage solutions such as EMC Recover Point, San Copy
- Familiarity with SQL Server backups, restores, replication and log shipping
- Seek opportunities to improve standard Environment Services procedures/processes, document and distribute to technical team
- Perform physical and logical database administration functions as required for HRS applications
- Review with clients on new Database Management System (DBMS) releases to understand the business and technical impacts
- Ensure integrity of all database components, Table definitions, structure definitions, statistic and indexes status
- Hands-on Experience of Exadata environment
- GoldenGate Installation,configuration in Classic Mode and Integrated Mode (uni-directional and Bi-directional)
- GoldenGate Upgrade / patching
- Troubleshoot Database / Goldengate related issues
Qualifications for oracle DBA
- Two to four or more (2-4+) years of Oracle database administration experience
- Strong database experience – Oracle 10g and later versions
- Strong understanding of server, SAN and networking technologies
- Strong general knowledge of operating systems, storage and overall system design and management
- Deep understanding of HA and DR including RAC and Data Guard
- Experience around Oracle upgrades and migrations are a must