Senior Database Developer

Position Name: Senior Database DeveloperContract Duration: 01 Year (Extendable)Duty Station: IslamabadNumber of Position: 01Job Overview: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 application and business teams.

Key Responsibilities

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.Required Skills & Experience: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.Education & Experience:Bachelor's/master's 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.