Senior Oracle developer
Social development bank
Total years of experience :8 years, 0 Months
design, develop and maintain applications that use the Oracle
database management system. This involves creating database schemas,
writing SQL queries and stored procedures, and developing application code
that interacts with the database.
Specifically:
• Designing database schemas: design database schemas that are efficient,
scalable, and meet the requirements of the application.
• Writing SQL queries and stored procedures: write SQL queries and stored
procedures to retrieve, update, and delete data from the database.
• Developing application code: develop application code that interacts with the
database.
• Testing and debugging testing and debugging the code to ensure that it works
as intended.
• Performance tuning: optimize the performance of the database and application
code to ensure that the application runs efficiently.
• Collaboration: work with other developers, database administrators, and project
managers to ensure that the application meets the requirements of the business
Oracle Database 10g & 11g &12c &18c &19c
• SQL & PL/SQL
• Using Toad and SQL developer in Create tables, indexes, function, stored
procedure…etc.
Also using it in writing tuning and optimizing SQLs statements and PL-SQL.
• Using SQL loader to load or update bulk of data into external table.
• Build Internet and desktop Applications (Forms) 12c and 6i.
• Reports (Report builder).
• WebLogic Application Server installation and configuration. (11g & 12c).
• Trying to apply the concept of design principles and design patterns as much as
possible to avoid a commonly occurring problem
in the software.
• Using Jira tool to apply an agile development methodology that helps us deliver
valuable software despite uncertainly and risk.
• Starting on an Oracle APEX 20.2 well versed with RDBMS like Oracle 19c.
• Adept at responsive web techniques. (HTML5, CSS3, JavaScript).
• Knowledge in REST web services.
• Installing APEX, Configuring ORDS.
• Deploying APEX on an application server (Tomcat).
projects • Integration (HRMS) of Oracle Cerner company with (SCM) of Oasis system.
• Integration with (NPHIS) as a third party with oasis system (HRMS) and Insurance
companies regarding to (CCHI).
Technical design, development and maintenance of current application.
• Participate in all phases of software development life cycle including
functional analysis, development of technical requirements, prototyping,
coding, testing, deployment and support.
• Participate in peer design and code review, analyse, and troubleshoot issues in
complex environments.
• Model, analyse and develop or extend persistent database structures which are
non-intrusive to the base application code and which effectively and efficiently
implement business requirements
• Research and understand capabilities to recommend best
design/implementation approaches and meet business requirements.
• Updates job knowledge by researching new technologies and software
products.
Coordinate with Managers, Architects and Analysts to develop Oracle database systems.
Perform system design, upgrades, and maintenances according to business needs
Develop schemas, tables, triggers, indexes, sequences, constraints, functions and
procedures. Understand business requirements and accordingly develop database models
Provide optimal design solutions to improve system quality and efficiency.
company
Coordinate with Managers, Architects and Analysts to develop Oracle database systems.
Develop schemas, tables, triggers, indexes, sequences, constraints, functions and
procedures. Develop monitoring tools to report any system events.
.