Senior Database Developer

Roles & Responsibilities

• Manage database migration and database management by conducting data calls to include the coordination, analysis and gathering efforts from existing data sources.
• Develop reports and aggregate application systems attributes such as OS, hardware information, programming languages, technology and license versions, account management and release schedules.
• Design, architect, and plan database solutions to meet the business need. Applies comprehensive business processes and functional knowledge in problem resolution. Proposes and defines solutions and standards.
• Implements PL/SL Programming especially in areas of Views, cursors, Stored Procedures, Normalization, Multiple table queries, Materialized Views, SQL Tuning etc.
• Develop and modify triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Prioritize and develop database solutions for high transaction environments.
• Install and upgrade database software and resolve database software problems.
• Automate database tasks, perform health checkups through the use of tools or via scripting.
• Expertise in database performance tuning and application query tuning.
• Test the system after the migration process as well as the resulting data to find errors.
• Perform performance testing and rewrite production Code/SQL statements & procedures performing badly, identified by database administrators.

Requirements

• Bachelor's Degree in Computer Science or other related discipline
• 7+ years of experience in database development and support in Oracle environments
• 7+ years of experience using Oracle
• Experience with Oracle 19.c and cloud database architectures and environments
• Experience with Data Warehousing technologies
• Strong understanding of Master Data Management policies including cleansing, normalization and standardization
• Demonstrated experience with Configuration Management tools