Oracle Database Administrator Job Description
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:
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:
Desired experience for oracle database administrator includes:
Oracle Database Administrator Examples
Oracle Database Administrator Job Description
- 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
- 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
Oracle Database Administrator Job Description
- 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
- 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
Oracle Database Administrator Job Description
- 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
- 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
Oracle Database Administrator Job Description
- 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
- 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
Oracle Database Administrator Job Description
- 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
- 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