Oracle Database Administrator Job Description
Oracle database administrator
provides database administration, maintenance and troubleshooting for multiple instances of the Oracle database in the laboratories and fielded sites.
Oracle Database Administrator Duties & Responsibilities
To write an effective oracle database administrator job description, begin by listing detailed duties, responsibilities and expectations. We have included oracle database administrator job description templates that you can modify and use.
Sample responsibilities for this position include:
Performed all aspects of database administration including installs, builds, upgrades, object sizing, object creation, users, backup/recovery, patches, monitoring, export/imports and SQL loader
Manage ASM storage migration, Creation of Diskgroup, Rebalancing the diskgroup and alter diskgroups
Implement Installation/Configuration of Data Guard Broker and testing all Failover scenarios
Perform SQL Server, Oracle and MONGO Database and Application server administration
Engage with external customer and internal service delivery team to gather new requirements
Creation of Business requirement documents
Creation of HLD and LLD documents to be shared for implementation
Participation in design reviews with other SME’s for projects
Investigation & troubleshooting of issues reported by customers/partners and internal users
Drive best practices across the service delivery team
Oracle Database Administrator Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Oracle Database Administrator
List any licenses or certifications required by the position: DBA, CE, II, IAT, ITIL, OCP, CISCO, DBMS, RAC
Education for Oracle Database Administrator
Typically a job would require a certain level of education.
Employers hiring for the oracle database administrator 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, Engineering, Technical, Information Technology, Education, Administration, Information Systems, Business, Design, Management
Skills for Oracle Database Administrator
Desired skills for oracle database administrator include:
SQL
PL/SQL
ASM
Data Guard
Partitioning
Triggers
Monitor and maintain database systems
Multiple database disciplines and technologies
Multiple utilities utilized to manage
Performing detailed performance analysis and resource utilization of the assigned systems
Desired experience for oracle database administrator includes:
Ability to master new and diverse technologies
Well-versed in various IT topics
Passion for documentation
Passion for best practice
Experience with other RDBMS databases like postgres, vertica, mysql
Prior Retail Industry experience is a plus
Oracle Database Administrator Examples
1
Oracle Database Administrator Job Description
Job Description Example
Our company is looking to fill the role of oracle database administrator. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for oracle database administrator
- Capacity and resource planning, Estimated the size of data files and redo log files
- Participate in the implementation of new projects, performance tuning, recommending solutions to enhance performance
- Perform 2nd and 3rd level support to all customers’ infrastructure and develop solutions to stabilize customer environments
- Oracle database installation, administration and support
- Database and Index reorganization
- Batch management, Patch management , disk space administration, performance tuning
- Backup/Restore, Systems tuning, Database backup/restore
- Review new applications and/or upgrades to assure achievement of corporate service level commitments
- Implement, review and maintain security settings and patches to achieve bank security standards
- Provide advice and guidance to the development community early in the development cycle to build “supportability” and “security” into new and/or revised applications
Qualifications for oracle database administrator
- Experience of Oracle 10g and above Database Administration on Unix and Windows distributed Platform
- Hands on experience in implementing business continuity or disaster recovery plan/portfolio
- Configuring OEM, Grid Control & Generating Stats pack Report
- Atleast 3+ years’ experience managing team of minimum 5 people and provide status reports to senior management
- Lead the team give technical solutions
- Should be able to do performance tuning of Oracle Servers
2
Oracle Database Administrator Job Description
Job Description Example
Our innovative and growing company is looking for an oracle database administrator. 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 database administrator
- Have good knowledge on oracle High Availability features, Disaster Recovery, Cluster Technology and FLASHBACK Technology
- Maintain the integrity, security and availability of multiple database(s)
- Assist other project members with analysis, evaluation and with the preparation of recommendations for system improvements, optimization, development, and/or maintenance efforts
- Evaluate requirements and recommend available DBMS products
- Participate in the implementation of new projects, recommending solutions to enhance performance
- Help establish and publish standards for configuring databases
- Support RMAN other export and import utilities
- Monitoring activities included verifying database operational status including tablespace, alert logs
- Maintains and supports the operations of the databases in test, training and production environments in cooperation with project leads, analysts and programmers as required
- Performs all aspects of database system management for multiple research projects and registries
Qualifications for oracle database administrator
- At least 2 years experience in Oracle applications Database Administration (DBA)
- 1+ years Oracle 10g or 11g DBA experience
- 6+ years overall IT experience - Formal training in Oracle database management system and database administration areas
- Minimum of 3 years experience in database administration using Oracle, preferably version 11g
- At least 3 years experience working in Unix/Linux/Windows environments
- At least 3 years experience insuring database meets security and control policies
3
Oracle Database Administrator Job Description
Job Description Example
Our innovative and growing company is hiring for an oracle database administrator. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for oracle database administrator
- Analyze and develop innovative solutions for complex problems involving availability and/or performance at the system level
- Interact with customers and provide leadership in developing and recommending solutions to business problems of high complexity
- Proactively monitor health of servers in production, test and development environments
- Create and maintain procedural and operational scripts and documentation, disaster recovery plans and other documentation that relates to database operating procedures
- Possible requirement to actively participate in an after-hours on call rotation, with carrying a pager and participating on Sev1 incident calls
- Acts as a participant to project and application management teams to promote standards and best practices, provide estimates, and plan and manage database activities on deliverables
- Develop and maintain project database documentation, including installation working instructions, configuration details, and production support handbooks
- Consult with business users to gather information about specific needs, objectives, functions, features, input and deliverables
- Travel/relocate to various unanticipated locations throughout the U.S. to interact with clients and train users for different short- and long-term assignments
- Lead the planning, analysis, design, implementation, maintenance, and control of the organization's server-class databases
Qualifications for oracle database administrator
- Build, maintain and support the database estate to include core database installation, configuration and upgrade, implementing and maintaining advanced high availability, security and performance tuning
- Interpretation and write up of business requirements, technical documents and program specifications
- Requirement analysis and component design including detailed design and resolving design issues
- Impact analysis of change requests and issues/incidents, and identification of solutions, including creation of appropriate documentation
- Planning and monitoring defect prevention activities
- Implementing and managing quality assurance processes
4
Oracle Database Administrator Job Description
Job Description Example
Our growing company is searching for experienced candidates for the position of oracle database administrator. We appreciate you taking the time to review the list of qualifications and to apply for the position. If you don’t fill all of the qualifications, you may still be considered depending on your level of experience.
Responsibilities for oracle database administrator
- Completes SQL tuning and database performance optimization, balancing usability and automation
- Work with development teams to identify and implement new database objects including tables, indices, packages and procedures
- Perform tuning activities
- Manage and maintain backup and recovery procedures
- Maintain documentation related to infrastructure and architecture of database systems
- Install, configure and troubleshoot Oracle 11g and 12c RAC clusters
- Configure, administer and troubleshoot Oracle Dataguard for disaster recovery
- Use Oracle Cloud Control for troubleshooting database performance issues
- Provide 24x7 on-call rotation support of production databases
- Setup RMAN backup and restore scripts
Qualifications for oracle database administrator
- Oracle Certification (OCM, OCE)
- Oracle Database administrator (DBMS) Installs, configures and upgrades RDBMS server software and related products
- This role establishes and maintains backup and recovery policies and procedures
- Sets up and maintains documentation and standards
- At least 2 years experience in PL/SQL
- Advanced Procedural Language (PL/SQL) experience and knowledge with Data Management Tools
5
Oracle Database Administrator Job Description
Job Description Example
Our innovative and growing company is looking to fill the role of oracle database administrator. 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 database administrator
- Assist users with problem resolution and answer database usage questions
- Work with users to schedule application of patches and configuration changes
- Proactively monitor database health and resource consumption
- Participate in capacity planning and benchmarking of application workloads
- Work with Oracle Support to resolve database outages and oracle problems
- Keep current with latest Oracle technologies, and evaluate new technologies as needed
- Administer Weblogic/OBIEE/Tableau/Informatica applications
- Perform Oracle Grid Control installation, configuration (Monitoring and Provisioning), patching and maintenance
- Perform backup and recovery procedures using RMAN
- Perform Application Installation and Configuration
Qualifications for oracle database administrator
- Basic knowledge of Operating Systems (Windows NT, W2K, XP, UNIX, SUN, AIX, Linux), IP Services
- Subject Matter Expert in Oracle DB architecture concepts
- Oracle Database Administration & Maintenance on Unix| Linux| & Windows platforms
- Backup and recovery methods
- Experience in a large database environment
- 3 + years of experience with Oracle DB administration