Senior Oracle Job Description
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:
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:
Desired experience for senior oracle includes:
Senior Oracle Examples
Senior Oracle Job Description
- 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
- 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
Senior Oracle Job Description
- 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
- 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
Senior Oracle Job Description
- 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
- 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
Senior Oracle Job Description
- 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
- 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
Senior Oracle Job Description
- 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
- 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