Oracle Database Developer Job Description
Oracle database developer
provides support to database modeling and design, rational database architecture, metadata and repository creation, and configuration management.
Oracle Database Developer Duties & Responsibilities
To write an effective oracle database developer job description, begin by listing detailed duties, responsibilities and expectations. We have included oracle database developer job description templates that you can modify and use.
Sample responsibilities for this position include:
Develop, tune, execute, and manage Oracle PL/SQL stored procedures, functions, packages and database triggers
Support the data architecture with some data integration
Monitoring database performance and tuning SQL queries and identifying and resolving scalability issues
Developing and amending stored procedures and PL/SQL code to implement business logic
He/she will also provide subject matter expertise and level 3 support to ensure the smooth running of systems and quick recovery from outages/downtime
Providing L2 and L3 support on Oracle Databses Platform used within the Bank
Desing and Creatre new solution for implementation within entire Oracle infrastructure (automatizition, scripting, tools)
Preapre new Oracle platform version rollouts (including testing and documentation)
Integrate standard Oracle platform within solution used in wider IT Infra environement (OS, storage, virtualization, security)
Ensure required documentation is in-place and up to date for all data management solutions
Oracle Database Developer Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Oracle Database Developer
List any licenses or certifications required by the position: OCP, OCA, IAT, AWS
Education for Oracle Database Developer
Typically a job would require a certain level of education.
Employers hiring for the oracle database developer 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, Software Engineering, Education, Information Technology, Business, Information Systems, Statistics, Design
Skills for Oracle Database Developer
Desired skills for oracle database developer include:
Oracle database server architecture
Project Management
SQL Tuning
Triggers
Architecture
Data modeling and understanding of different data structures and their benefits and limitations under particular use cases
Database architecture design
Database performance optimizations concepts
Database replications tools
Design and business processes
Desired experience for oracle database developer includes:
75/25 with operational and production support/new development respectively
On call rotation once every other month
Collaborate with other internal or external teams on projects such as sourcing data feed, working with vendors
Experience creating logical entities and defining their attributes defining the relationships between the various data objects
You will also be responsible for performance tuning including tuning complex queries to perform on a large historical data
Excellent knowledge of Oracle Exadata is a must
Oracle Database Developer Examples
1
Oracle Database Developer Job Description
Job Description Example
Our company is looking to fill the role of oracle database developer. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for oracle database developer
- Develop PL/SQL Packages, Stored Procedures, Functions, Triggers, SQL statements in Oracle 12c
- Create tables, views, indexes, triggers, types, packages and other database objects as needed
- Installation and patching of Oracle Relational Database Management System (RDBMS) for Oracle EBS on Linux
- Installation and patching of MS SQL Server Databases on Windows
- Implementing SOX controls on new and existing databases and developing and documenting formal processes and procedures
- Reviewing audit reports and defining / setting up new logging when needed
- Moving changes to the Production environments and tuning / optimizing (PL)/SQL queries
- Ensuring backup and recovery of all data, for Oracle data using RMAN
- Developing scripts for reporting, data manipulation and automation of daily tasks
- Providing support to Development and QA teams on applications/database issues
Qualifications for oracle database developer
- 4-7 years experience developing PL/SQL procedures, functions, packages
- Must have experience using bulk loading methods - Oracle sqlldr, external tables
- Prior experience in performance tuning of database queries, materialized views
- Or similar (development environment)
- The ideal candidate will be capable of documenting small-to medium scale projects with minimal supervision, and may be involved in developing and delivering presentations
- Designs, develops, and supports solutions utilizing Oracle relational database management system
2
Oracle Database Developer Job Description
Job Description Example
Our company is looking to fill the role of oracle database developer. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for oracle database developer
- Administration and support of Oracle’s Business Intelligence and Informatica, Oracle’s Hyperion and ODI
- Design and develop batch and OLTP solutions
- Participate in various projects and new initiatives
- Develop and maintain requirements, system documentation including technical specifications, data mapping, program logic and flowcharts
- Support master data development using Oracle EDQ for profiling, standardization and matching
- Develop/Design, update, and maintain CDR relational databases in ORACLE RAC and Linux environment
- Provide support of development database design schema for integrating source data into data management systems
- Provide support in developing and optimizing SQL queries and tuning database operations both proactively and reactively
- Provide support to co-ordinate, organize and deliver database code
- Communicate with the data modelers about design implications from database developer point of view
Qualifications for oracle database developer
- You must have good working experience on UNIX platform (commands and shell scripting) and should be comfortable writing SQL queries on DBMS Skills ( PLSQL/Oracle DBA
- 5+ years of experience in the Design, Maintenance, and Administration of Relational Databases
- Proficient with Oracle 11g for Oracle EBS on a Linux environment
- Participates in the design
- Analyzes and determines information needs and elements
- Assignments may include design of data dictionaries
3
Oracle Database Developer Job Description
Job Description Example
Our innovative and growing company is searching for experienced candidates for the position of oracle database developer. 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 developer
- Design Logical Data Models and their physical schema design in ORacle 12c databases
- Build databases depicting the physical design
- Create Tables, Views, Indexes and Sequences
- Develop routines in Oracle using SQL*Loader
- Assist the development team in the design, development, testing, tuning, and implementation of the database
- Ensures that application design is scalable and maintainable
- Ensures that all deliverables are thoroughly documented and tested
- Contribute to the development and maintenance of reusable standards and libraries – Industrialization for continual improvement
- Engage with stakeholders and manage expectations from inception through to final solution
- Troubleshoot ETL processes, investigate application logs, find and eliminate performance bottlenecks
Qualifications for oracle database developer
- Oracle Text
- 5+ years of experiences in Oracle database administration
- BS in computer Science or equivalent with a minimum of 4 years of Oracle DBA experience
- Excellent analytical ability, strong judgment and problem analysis techniques, an in-depth knowledge of the business units functions and applications, and a broad knowledge of diverse data administration methodologies, data base technologies, tools and alternatives
- Excellent communication and consultative skills, and the ability to work effectively with clients and other data processing managers
- Experience with database migrations and provide database support to MMM Installation and Help Desk teams with respect to database backup / recovery, connectivity, and performance issues
4
Oracle Database Developer Job Description
Job Description Example
Our company is growing rapidly and is looking to fill the role of oracle database developer. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for oracle database developer
- This is not a DBA role but knowledge of AWR reports, Oracle administration, Oracle RAC is desired
- Extensive experience troubleshooting and solving complex technical problems
- Developer will be working on Cash and OTC Valuations and Reporting platform, which involves interacting with various IT systems and dealing with large amount data on daily basis
- Design, develop and implement distributed software platforms for financial messaging
- Apply innovative technologies, implementation concepts to high availability and performance systems in a distributed environment (clustering)
- Focus on team-play in an Agile development environment
- Education to Master’s degree level in Computer Science or other technical related fields, or have equivalent capabilities
- Advanced experience with Maven, Spring, Hibernate/JPA, Junit
- Advanced experience with Messaging systems such as MQ, JMS, HornetQ
- Develop Audit Vault/Database Firewall business rules, alerts and reports
Qualifications for oracle database developer
- Must be able to obtain and maintain 8570 certification within 30 days from date of hire
- Comptia Security+ exam and proof of certification
- Oracle database related certification (Oracle Certified Associate, Oracle Certified Professional, Oracle PL/SQL Developer, Oracle Database SQL Certified Expert)
- Should have hands-on design and development experience in Oracle database
- Candidate should provide status of BAU work and issues to the Manager in a timely manner
- Candidate must have excellent listening, communication and influencing skills
5
Oracle Database Developer Job Description
Job Description Example
Our growing company is hiring for an oracle database developer. 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 developer
- Developing complex database processes with PL/SQL containing batch or ETL functionality
- Developing and enhancing an existing DataMart in an OLAP schema
- Designing logical and physical ERD diagrams, process flow diagrams, or related data processing documentation
- Leveraging Oracle 11G/12C features to their fullest on a large-scale multi-terabyte system
- Assisting Decision Support team members including DBAs, database developers, requirements analysts, and others, in understanding data and meeting user requirements
- Participating in project work groups with Subject Matter Experts and stakeholders to understand data specific needs
- Participating in performance tuning activities
- Providing production deployment and production support as needed
- Experience in developing logical and physical data models
- Provide governance to translate functional specification into technical specifications and ensure functionality and features will work with existing systems/platforms
Qualifications for oracle database developer
- Strong database skills – prefer Oracle
- Experience with banking and/or financial service companies
- Oracle PL/SQL on Oracle 10g/11g with hands on coding skills in writing packages, procedures, functions, analytical functions
- OLTP
- Any prior experience in BI tools (Business Objects/SSRS) and ETL technologies (Datastage, Informatica, SSIS) will be a strong advantage
- Should have a strong background in query tuning and performance optimization