Principal Database Developer  
Pakistan Single Window   More jobs from this company

  Email this job
Job Details Back to Job Listing
 
Job Title:   Principal Database Developer
Category:   Database Administrator (DBA)
Total Positions:   1
Job Location:   Islamabad, Karachi, Rawalpindi
Gender:   No Preference
Age:   25 to 40 years
Minimum Education:   Bachelors
Degree Title:   Minimum Bachelors (4 year) (HEC recognized) degree in Software Engineering, Computer Engineering.
Career Level:   Experienced Professional
Minimum Experience:   7 Years
Salary Range:   PKR 0 to 0 per Month
Apply By:   Jun 7, 2024
     
     
 
Job Description:

Duties & Responsibilities:

Design database systems:

Database Developers’ main responsibility is to analyze the needs of an organization and produce an effective database system according to their needs and specifications. This includes collecting data, analyzing the data, designing algorithms, drawing flowcharts and implementing code for the logic developed through the algorithms and flowcharts.

Test databases:

A database developer must be able to run performance testing procedures to ensure the proper operations of a database and to ensure that it’s error-free. If any errors are thrown when the code runs, they need to be corrected and the code needs to be re-tested. This involves troubleshooting any potential problems, creating and submitting test reports and database improvement.

Develop database documentation:

As a database is developed, the database developer must write documentation about the system and put together an operational manual. The documentation must include information regarding changes or improvements to the database as they are implemented.

Work with the front-end development team:

Once the databases are ready, and the front-end development is complete, a database developer must work with the front-end development team to integrate the modules together. Once this is done, the integrated code must again be tested and any errors must be fixed.

Qualification, Experience & Technical Competencies:

  • Minimum Bachelors (4 year) (HEC recognized) degree in Software Engineering, Computer Engineering.
  • At least 7+ years of experience in database design, development, and performance tuning.
  • Microsoft SQL Server
  • Visual Studio
  • Microsoft SQL
  • GIT, TFS
  • SQL Tools (Query Analyzer, Query Execution Plan, Profiler, Analytics)
  • SQL Server Database Diagram
  • Writing Queries
  • Database Analyzing
  • Root Cause Analysis
  • Query Optimization
  • Online Indexing
  • Database Tunning
  • Database Programming
  • Quality Assurance Testing
  • Code Reviews
  • Debugging and Trouble Shooting
  • Strong Interpersonal and Communication skills

Remarks:

  • Created Databases, Tables, Indexes, Stored Procedures, Views, database management policies and Constraints, Defaults, Rules, Functions, Triggers and Dynamic SQL queries.
  • Performance tuning by analyzing execution plans, creating, and maintaining indexes and working with front-end development team.
  • Analyze and deploy scripts and packages in test/productions from different developers.

Company Information
 
Company Name:  Pakistan Single Window
Company Description:
Pakistan Single Window (PSW) is an ICT-based system in Pakistan providing a single window for trade. PSW is a facility that allows parties involved in trade and transport to lodge standardized information and documents at a single-entry point to fulfill all import, export, and transit-related regulatory requirements. If information is electronic, then individual data elements need to be submitted only once.

PSW will connect relevant government departments with each other and with economic operators like importers, exporters, customs agents, shipping agents, transporters etc, in Pakistan for efficient management of cross border trade. It will provide the ease and transparency in achieving compliance with relevant regulatory requirements, through an on-line facility, that will intelligently handle the information for each transaction without the need to provide same information more than once or to physically visit such government departments.

Pakistan has committed to implement various provisions of World Trade Organization’s (WTO) Trade Facilitation Agreement that includes implementation of a National Single Window (NSW) system before February, 2022. Pakistan also needs PSW implementation to overhaul management of its external trade for reducing time, cost and complexity involved to improve its position in various global rankings on competitiveness and ease of doing business.
Guiding vision and mission objectives:

VISION: Pakistan will establish a world-class automated hub by 2022, offering services and creating efficiencies, to reduce cross border trade related costs, time and complications for improved trade facilitation and compliance.

MISSION: Improve cross-border trader processing by providing centralized ICT based services, simplified processes, effective and reliable automation, harmonized data exchange and risk-based selectivity in enforcement of government’s regulations.

Copyright 2024, National University of Science and Technology (NUST). All Rights Reserved