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.
Follow best practices for database design.
Perform capacity analysis and oversee database tuning.
Maintain technical documentations for reference purposes.
Write complex codes and queries and participate in code reviews.
Write ETL codes, update SQL statements and create shell scripts.
Develop monitoring tools to report any system events.
Perform design review, modify codes and test upgrades.