Oracle Database Engineer Job Description
Oracle Database Engineer Duties & Responsibilities
To write an effective oracle database engineer job description, begin by listing detailed duties, responsibilities and expectations. We have included oracle database engineer job description templates that you can modify and use.
Sample responsibilities for this position include:
Oracle Database Engineer Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Oracle Database Engineer
List any licenses or certifications required by the position: IAT, DBA, II, GCP, AWS, OCI, CE, OCP, CFA, ITIL
Education for Oracle Database Engineer
Typically a job would require a certain level of education.
Employers hiring for the oracle database engineer 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, Business, Information Systems, Software Engineering, Communication, Education, Computer Engineering, Information Technology
Skills for Oracle Database Engineer
Desired skills for oracle database engineer include:
Desired experience for oracle database engineer includes:
Oracle Database Engineer Examples
Oracle Database Engineer Job Description
- Enterprise Oracle RDBMs – for Data Warehouse processing, and OLTP with PHP, Java Applications
- Microsoft SQL Server – Relational, SSAS, SSIS, SSRS, TSQL and integration with Active directory, IIS and Sharepoint
- Open source database technologies such as PostgreSQL and MySQL
- Enterprise Technologies such partitioning, log mining, compression, replication and messaging
- HA technologies such as Veritas clustering and standby databases
- Virtualisation technologies such as VMware and native Solaris Zones
- Scripting and Job scheduling using SQL/PLSQL/Shell Scripts
- You will bring with you a core understanding of the underlying infrastructure and technologies of complex database systems is required
- Drives continuous improvement of design and delivery standards
- Good exposure to Centos and Redhat Linux
- Oracle EBS, OBI, Agile, Golden Gate, Data Warehouse experience is preferred
- Provide advice and support to development teams
- Ability to establish a high level of customer trust and confidence
- Able to work independently, and in groups to achieve project objectives/deliverables
- Oracle RAC experience is preferred
- Oracle database version 11g experience preferred
Oracle Database Engineer Job Description
- You will maintain Oracle procedures for use with the ETL process
- Leads a task force to develop and implement a database that addresses current and future business needs
- Develop and implement solutions for database sizing/capacity, server requirements and space requirements
- Administer Oracle Databases including cloning and patching
- Resolve help desk tickets as assigned and provide 24-hour on-call support for problem analysis and resolution to system problems during mission critical events
- Research, plan, and perform application of bug fixes, application upgrades, database upgrades to Oracle Database 12c, and the implementation of security patches
- Develop and implement, with other team members, the processes and procedures for daily transactional backups and weekly complete backups
- Distributed query optimization in our distributed in-memory cloud database system
- Optimize our MPP query execution engine in our share-nothing in-memory cluster system
- Parallel query optimization and execution
- DoD 8570 IAT Level 2 certified (baseline security certification CompTIA Security+ce) and (technical computing environment training or certification Server+) prior to start of work
- Experience in scripting languages like Python, JavaScript
- Excellent verbal and written skills in English in local language
- Oracle Database Development - 5 years
- Oracle Packages/Stored Procedures/Functions Development – 3 years
- Java Web Application Development (HTML,JS,CSS,JSP,Spring,WLS) - Nice to have
Oracle Database Engineer Job Description
- Query rewrite for materialized views
- Support multiple scrum development teams with their sprint delivery from a database perspective with development of database objects
- Design and implement solutions that follow efficient techniques and development that meet and exceed the intent of the data solution
- Lend support to technology and quality assurance teams as necessary during design, development and delivery to ensure solid, scalable, robust solutions
- Document database development guidelines, standards, and performance reviews
- Provide logical and physical database design
- Maintain and document data model, data dictionary and data flow diagrams
- Evaluate the latest versions of RDBMS software
- Oracle Database 11gR2 – 12c
- Oracle Golden Gate (desirable)
- Strong motivation for problem solving, analysis, and testing
- Experience with Windows, Unix, and Linux environments
- Thrives on tight deadlines
- Understanding of business concepts of Allocation and Unit Forecasting
- Work mostly stationary and is performed in a general office environment
- A minimum of 7 years' DBA and related experience with Oracle RDBMS
Oracle Database Engineer Job Description
- UNIX (Solaris and/or Linux)
- Oracle Exadata database machine
- Day to Day DBA activities
- Database and Query Tuning
- Database High availability Solutions (RAC / Dataguard)
- Good understanding of DB Objects (Partitioned Tables) & Features (Data Compression)
- Coordinating efforts with all stakeholders (customers, users, system administrators, storage management, and network administration teams)
- Reviewing and obtaining required approvals for all changes in accordance with the EBS change control and review processes
- Preparing and monitoring project schedules and budgets
- Analyzing existing Oracle database implementations
- Bachelor’s Degree in Computer Science or related field or at least 5+ years relevant work experience as Oracle DB Engineer/Developer
- Expertize in Metadata Management
- Expertise in large and complex SQL query development, SQL, PL/SQL, and Oracle development tools
- Diagnose and solve applications interfaces performance problems
- Knowledge of OEM Grid Control 12c
- Must be self-motivated, able to work independently and highly responsible in maintaining time critical projects schedule
Oracle Database Engineer Job Description
- Preparing and reporting current project status to senior leadership on an ongoing basis
- Assuring innovative approaches and strategies are utilized in the migration efforts
- Providing leadership, mentoring, and guidance to junior level engineers
- Working independently with little or no guidance
- Travel in support of the project as required
- Support an on call rotation as required
- Creates, maintain and support all databases environments includes development, testing, pre-prod and production
- Good knowledge and implementation skills on Database maintenance (Backup, Recovery, Index maintenance, .)
- Extensive operational experience with the implementation of Oracle Enterprise RDBMS and Oracle Application Server/Oracle Fusion Middleware 11g WebLogic Suite products in both dedicated server and shared server (multiple customer tenants on a single host) environments.to include at a minimum Advanced Security, Diagnostics and Tuning, Label Security, Data Warehousing, Configuration Management, Forms and Reports, PL/SQL and APEX, and tuning using AWR and ADDM reporting facilities
- Extensive experience with the implementation of Oracle Enterprise Manager to manage and support enterprise level database and application infrastructure
- Experience in scripting (PowerShell, VBScript, batch files, InstallScript, Wise Script)
- Knowledge of data interchanges technologies/architectures such as JSON, XML, Restful, SOAP and their support with Oracle products
- Knowledge of micro services concepts and various implementation patterns
- 3+ years’ experience with relational databases such as Oracle, MySQL, and Postgres
- Hands-on experience with NoSQL such as MongoDB and DynamoDB
- Passion for database technologies and new trends