Senior Database Developer

We are seeking a Senior Database Developer with strong experience in Oracle Exadata SQL PL/SQL database design performance tuning ETL/data migration NoSQL cloud technologies reporting and application support. The role involves developing scalable secure and high-performance database solutions and collaborating with applicationand business teams.

• Design and implement complex database models aligned with business requirements.
• Create and manage reports tables indexes views partitions materialized views and other database objects in Oracle Exadata.
• Analyse execution plans and optimize SQL/database performance through query tuning indexing partitioning and resource optimization.
• Develop and manage ETL data migration validation cleansing reconciliation and integration processes using Oracle MySQL Oracle Goldengate and related tools.
• Design and maintain data replication and synchronization across systems with minimal downtime.
• Support integration between relational databases NoSQL databases APIs data warehouses and cloud platforms.
• Design and support NoSQL databases such as MongoDB Cassandra DynamoDB or Redis including data modelling indexing partitioning replication and performance tuning would be a plus.
• Support cloud and hybrid-cloud database environments using OCI AWS Azure or GCP.
• Support database migration modernization backup disaster recovery security and high-availability initiatives in on premises & cloud environments.
• Create and optimize dashboards reports and analytical queries providing support for dashboard infrastructure and performance.
• Collaborate with application teams on development integration testing deployment and production support.
• Perform unit integration regression performance and data-validation testing.

• Design databases with appropriate security access control data integrity and protection mechanisms.
• Provide technical support mentoring and knowledge sharing to team members.
• Support payment-related systems and financial institution integrations where required.
• Support PMU and WFP Nutrition teams with reports data analysis dashboards and capacity building.
• Prepare and maintain technical documentation including database architecture data models ETL processes technical specifications and operational procedures.
• Provide technical evidence and support for audit activities & reconciliation.
• Troubleshoot database application integration and performance issues in production environments.
• Create/Manage dashboard data models power BI and tableau.
• Perform database administration and production support including health and performance monitoring user/access management backup and recovery.
• Perform other responsibilities assigned by the Reporting Manager.

• 6 years of Strong hands-on experience with Oracle Database and Exadata SQL & NOSQL database.
• Advanced SQL and PL/SQL development skills can normalize existing non-normalized databases.
• Experience with complex queries stored procedures triggers functions cursors jobs and schedulers.
• Strong knowledge of database performance tuning indexing partitioning and execution plans.
• Experience with at least one NoSQL database such as MongoDB Cassandra DynamoDB or Redis.
• Experience with cloud platforms preferably OCI AWS Azure or GCP.

• Experience with dashboards reporting and data analytics using Power BI tableau and any other tool.
• Strong troubleshooting documentation communication and team-collaboration skills.

• Bachelors/masters degree in computer science IT Engineering Data Management or a related field.
• Relevant experience in enterprise database development preferably with Oracle Exadata and large-scale data environments.