Senior Oracle Job Description
Senior oracle
provides guidance on best practices utilizing SQL and PL/SQL programming standards.
Senior Oracle Duties & Responsibilities
To write an effective senior oracle job description, begin by listing detailed duties, responsibilities and expectations. We have included senior oracle job description templates that you can modify and use.
Sample responsibilities for this position include:
Performance tuning of the Database both at the application level (SQL) instance
Reviews performance stats, recommend changes for tuning databases, servers, and storage configurations, application SQL
Designing and reviewing Oracle application architectures and ensuring that the resultant solutions meet the business objectives
Designing end to end solutions across the Oracle and clients’ legacy systems estate including integration and reporting technologies
Provide technical support of database environments/applications, including software installation, database creation, upgrades, patches, problem diagnosis, performance monitoring, database maintenance, process automation, evaluation, and tuning recommendations
Participate in all aspects of the lifecycle for database environments
Plan and coordinate security measures, ensure data integrity, and perform database backups and restores
Provide technical expertise in the use of the Oracle Database Management System
Responding to user support calls managing projects to ensure all applications are upgraded to appropriate version levels
Plan for transition of the development and/or production environment to Oracle 12c
Senior Oracle Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Senior Oracle
List any licenses or certifications required by the position: OCP, DBA, OCA, SQL, IAT, EPM, SSL, PMP, MS, II
Education for Senior Oracle
Typically a job would require a certain level of education.
Employers hiring for the senior 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, Technical, Engineering, Education, Business, Information Technology, Information Systems, Design, Management, Administration
Skills for Senior Oracle
Desired skills for senior oracle include:
SQL
Software development and support methodologies
PL/SQL
Data structures
Indexes
RMAN
Algorithms
OEM
ITIL framework
Vocabulary and best practices
Desired experience for senior oracle includes:
BS/BA or equivalent work experience, Masters Preferred
Experience supporting mission critical 24x7 eCommerce and ERP systems
Experience with replication technologies such as Streams, Goldengate, and IBM CDC (Datamirror)
Minimum of 2 years’ experience with Unix, Linux, and shell scripting
Ability to adhere to and define technical standards
Must understand full software development lifecycle, (Plan, Analysis & Design, Build, Test, Implement/Deployment and Post Production support)
Senior Oracle Examples
1
Senior Oracle Job Description
Job Description Example
Our growing company is searching for experienced candidates for the position of senior oracle. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for senior oracle
- These positions may require 30-50% travel to customer sites
- Creating and maintaining all oracle databases, performing ongoing tuning planning and implementing backup and recovery of the database
- Implements custom software releases
- Should have enough experience for database design, its implementation, application development, performance tuning, application support
- Database Administration Expertise in 11g and 12Cc is required
- Oracle Software Installs, Upgrades in version 10g, 11g, & 12c
- Monitoring Requirements
- Incident Support (Sev1)
- Release Resource Management
- Technical Baseline Owner - upgrades, patching, Security Baseline Management
Qualifications for senior oracle
- Experience with Oracle Spatial and GIS implementation is a plus
- Must have functional and technical skills of Oracle ERP R12
- 4 year degree in Accounting/ Finance, MIS or related field
- Create and maintain performance benchmarks and metrics make recommendations on application specifications for optimal database performance
- Support Oracle OLAP
- Proficiency in Oracle versions 10g, 11g and 12c and Oracle Cloud Control
2
Senior Oracle Job Description
Job Description Example
Our company is growing rapidly and is searching for experienced candidates for the position of senior oracle. 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 senior oracle
- Experience designing, coding, testing and maintaining database objects, tables, views, packages, functions, procedures, indexes, sequences and triggers using Oracle PL/SQL
- Perform database monitoring, maintenance, reorganizations, resource management, schema management, and capacity planning and performance tuning for the company's databases
- Apply patches to fix bugs and/or enhance functionality as required and in conjunction with the company's procedures for change control
- Provide technical architecture and design as required
- Create and modify database structure using Data Definition Language (DDL) statements to create tables and appropriate indices for optimal data access, database objects such as store procedures, functions, views, and triggers
- Ensure 24/7 systems availability and manage critical incidents by organizing resources
- Organize and perform monthly outage weekend and quarterly disaster recovery tests
- Provide development leadership in a functional area, module, or project
- Assist in the development and definition of test plans and scripts for performance, regression, and user acceptance test plans
- Provide training and documentation for knowledge transfer to other database team members, and communicate to nontechnical users database and applications team members
Qualifications for senior oracle
- Experience supporting Oracle production database including hands-on senior database administration experience with Oracle 12c, 11g, 10g and 9i
- Demonstrated knowledge working with Oracle databases larger than 500 GB and/or user population greater than 15,000
- General knowledge of report writing and data mining tools
- Three to five years of ERP experience, with at least one year in a consulting capacity within Oracle Cloud financial modules
- Familiarity with FRS, Smartview and OTBI
- You have demonstrated experience in problem solving and system troubleshooting
3
Senior Oracle Job Description
Job Description Example
Our company is looking for a senior oracle. 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 senior oracle
- Optimize Oracle resource utilization by tuning queries, recommending indexes, and configuring database instance parameters
- Identifying and resolving problems occurring in all database environments including performance related issues
- Supporting DBA utilities, reorgs, index builds, etc and DBA tools, Oracle Enterprise Manager
- Responsible for problem escalation to Development team and third parties as appropriate including open service requests with Oracle
- Support for application databases (Oracle)
- Support for new initiatives and projects
- Provide SME advice regarding Oracle architecture
- Coordinating change within a multi-vendor environment
- Lead full programme delivery for large client initiatives with a combination of
- Primary deliverable is Oracle Code Development
Qualifications for senior oracle
- LEO experience
- Shall have expertise with Oracle Middleware products used on LEO applications and address ongoing upgrades and complex issues associated with these COTS products
- Excellent troubleshooting and problem solving skills in-depth knowledge of Oracle Applications in the global environment is a must
- Very strong organizational skills and proper attention to detail
- Excellent customer service working in the global multi-cultural environment
- Availability for 24X7 support for Severity 1 Production issues
4
Senior Oracle Job Description
Job Description Example
Our company is growing rapidly and is hiring for a senior oracle. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for senior oracle
- Create and perform unit testing of all code developed
- Actively collaborate with multiple stakeholders in an agile environment across the business
- Must be able to work in an Agile, fast paced, enterprise environment
- Define requirements by analyzing current business processes andfacilitate “to be” process design
- Coordinate the activities related to running production/test/development Application environments
- Perform analysis on DBMS to support transition to new business
- Ensure all aspects of DBMS Disaster Recovery (DR)
- Provide technical leadership to our Oracle Commerce production support team to triage, resolve, and conduct RCA on Sev 1 and Sev 2 incidents that our clients’ sites experience
- Understand client implementations thoroughly in order to diagnose site issues and respond rapidly with solutions
- Oversee the team of Production Support engineers, both in the U.S. and globally, to ensure they are familiar with best practices for support delivery and following team protocols
Qualifications for senior oracle
- Self-directed team leader with strong ability to work independently with minimal supervision
- Ability to understand business concepts and evaluate the impact of business changes on systems
- Ability to learn new applications (Oracle and non-Oracle)
- Strong computer skills including Microsoft Office suite and Visio
- Proficiency in Spanish, Portuguese, or Hindi is a plus, but not necessary
- Minimum five years professional experience in support of Oracle eBusiness Suite applications or as a “super user
5
Senior Oracle Job Description
Job Description Example
Our company is growing rapidly and is looking for a senior oracle. 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 senior oracle
- Install and configure Oracle 12c instances in both dedicated, consolidated, RAC, and Exadata environments based on Configuration Standards
- Given physical data models, build database objects per standards
- Provide guidance with physical database design for large volume EDW platforms including ETL architecture, data retention (purging / archiving), and loading
- Work with System Admins to apply regular maintenance and critical patch updates and maintain security compliance
- Use Oracle and 3rd party tools to troubleshoot and resolve production issues
- Partner with offshore DBA resources and thoroughly document processes to ensure successful task implementation
- Provide 24/7 Incident Response to database alerts from production monitoring tools and Command Center personnel
- Maintain the integrity of data within the production environment including the execution of proper backup and restoration policies and procedures which provide point-in-time restore capabilities
- Enhance site / Oracle Gateway monitoring to improve high availability, performance SLAs, and proactive Health Checks
- Deploy database changes in strict accordance with ITIL change management policies and procedures -- maintain Configuration / Security Standards
Qualifications for senior oracle
- Experience with OBIEE functional support is highly desirable
- Understanding of relational databases and proficiency with TOAD/SQL or comparable tool
- Ability to troubleshoot effectively by creating SQL queries
- Prior experience in Finance and Accounting environment is a strong plus
- Excellent troubleshooting and problem solving skills in-depth knowledge of Oracle Applications in the global environment
- Excellent customer service skills working in the global multi-cultural environment