Posted Apr 23, 2024 155 views
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.
Job Details
Pakistan Single Window
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.
What is your Competitive Advantage?
Aqib Irshad
Head of HR, Training & OD
FINCA
Babar Ahmed Khan
Territory Sales Manager
Engro Foods
Ali Aziz
CEO
Shopistan
Ayesha Shaukat
Social Media Marketing Manager
Ivoke
Muzammil Baig
Digital Marketing Manager
IT Services Group
Usman Habib
Recruitment & Training Executive
ACS Synergy (Pvt) Ltd.
Mona Sharif
Senior Team Lead
Konext PVT. LTD
Zubair Anjum
Business Excellence Specialist
Nestle Pakistan
Zohaib Ali
Marketing Manager
Digital Online Devices
Sehrish Azhar
Motivational Speaker & Blogger
Living Upbeat
