1. Design conceptual and logical data models and flowcharts, choosing the best technology stack, lead to build the Database architecture.
2. Analyzed existing database structure, recommend how to decentralize and/or build new decentralize database.
3. The focus will be on designing, developing, and managing large-scale databases to store and organize a vast amounts of data, follow data compliance and security policies as per industry standards for data governance.
4. Own database designs and all data-related operations, issues, enhancements, etc.
5. Analyze the needs of an organization and produce an effective database system according to their needs and specifications as well as for future scalability.
6. Collaborate with application/system architects, information technologists, and other staff members regarding data storage practices, network operation, and other data-related issues.
7. Includes collecting data, analyzing the data, designing algorithms, drawing flowcharts, and implementing code for the logic developed through the algorithms and flowcharts.
8. Implementing migration methods for existing data, improving the system performance by conducting tests and troubleshooting, and defining security and backup procedures.

Skills:

MS SQL Server, Git, Data Management, Advance SQL, TFS,
 

Main Responsibilities:

1. Ensure good quality standards for product delivery and their compliance with user requirements
2. Evaluate and test software applications according to business and functional requirements
3. Provide feedback and recommendations to developers on software usability and functionality
4. Document test results, create/update requirements and test plan documentation as needed
5. Ensure testing is on schedule and in line with the processes
6. Communicating with team members to streamline the execution of test cases, test plans, and processes with them
7. Good database testing concepts
8. To design and develop test suites for software functional and performance testing

Required Skill Set:

• In-depth knowledge of automation testing, automation test scripts, framework design, and implementation (Selenium, TestNG)
• Ability to write test cases, test scripts, test scenarios, and testing procedures (Unit, BAT, Regression, Functional, Systems, Stress & Scale, Smoke & Sanity)
• Experience in cross-platform/cross-browser testing
• Experience in Performance Testing (LoadRunner, JMeter, etc.)
• Understanding of software testing principles, standards, and test cycles
• Knowledge of existing QA best practices and methodologies to design, implement and automate processes
• Understanding and hands-on testing experience of REST & SOAP APIs (POSTMAN, SOAPUI)
• Self-motivated, quick learner and a responsive team player.
• Excellent written/oral communication, presentation, and interpersonal skills.
• Ability to work under pressure, within agreed targets and timescales, and deliver quality outcomes.

Skills:

Bug Tracking, Microsoft SQL, JMeter, Selenium Testing, Quality Assurance, Automation Testing,
 

Main Responsibilities:

1. Install, configure, and manage SQL Server 2019 Databases ensuring optimum performance.
2. Design, implement, and manage processes to ensure the availability and integrity of the data stored in databases
3. Ensure Databases are being properly backed up as per company policy and ensure backup integrity
4. Implement disaster recovery strategies to meet business's Recovery Point Objectives (RPO), Recovery Time Objectives (RTO)
5. Set up and monitor DB performance, troubleshoot issues; implement and enforce DB access controls
6. Manage multiple high-availability SQL Server 2019 failover clusters and Always-On Availability Groups
7. Setup and manage Replication among different databases/sites
8. Patch SQL Server installations by patch management processes
9. Be available 24/7 to provide technical assistance, in support to critical business operations

Required Skill set:

• Implementation and management experience in SQL Server High Availability and Disaster recovery solutions; including clustering, Availability groups and Replication.
• Experience with database security design and Database automation.
• Well-versed in SQL Server Performance tuning & troubleshooting using DMVS, Extended Events, Profiling, Wait Statistics etc.
• Good understanding of the database underlying infrastructure such as Storage, Networking components and Server Hardware
• Experience in setting up and managing SSIS/SSRS
• Self-motivated, quick learner and a responsive team player with ability to work under pressure, and deliver quality outcomes 
• Write clear, concise, and well-organized technical documentation to maintain standards and procedures
• Excellent written/oral communication, presentation, and interpersonal skills

Skills:

Database Management, DMVS, SQL,
 

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.

1. At least 7+ years of experience in database design, development, and performance tuning.
2. Microsoft SQL Server
3. Visual Studio
4. Microsoft SQL
5. GIT, TFS
6. SQL Tools (Query Analyzer, Query Execution Plan, Profiler, Analytics)
7. SQL Server Database Diagram
8. Writing Queries
9. Database Analyzing
10. Root Cause Analysis
11. Query Optimization
12. Online Indexing
13. Database Tunning
14. Database Programming
15. Quality Assurance Testing
16. Code Reviews
17. Debugging and Trouble Shooting
18. 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.

Skills:

Database Design, SQL Queries, Database Development,
 

Job Responsibilities:

1. Convert user flows, wireframes, and prototypes into quality web-based product features and user experiences.
2. Design and implement efficient and responsive user interfaces, collaborating with UX/UI designers to create visually appealing and user-friendly web applications.
3. Develop web pages using React.js and utilize React.js workflows (Flux/Redux).
4. Implement state management libraries like Redux.
5. Ensure high code quality, security, and adherence to coding standards.
6. Participate in code reviews, provide constructive feedback, and mentor junior developers.
7. Troubleshoot and debug issues in production and development environments.
8. Contribute to the documentation and knowledge sharing within the team.
9. Participate in scrum meetings to ensure the delivery as per plan.

Skills:

Redux Toolkit, GraphQL, Javascript, TypeScript, React JS, WebPack, React Hook,
 

PURPOSE OF THIS ASSIGNMENT:

PSW Marketing & Communications seeks to engage a professional and skilled Podcast Host on a short-term contract under the overall responsibility and direct supervision of the HOD Marketing and Communications. The main purpose of this role is to enhance awareness of, and engagement with PSW through a series of informative and engaging podcasts under the name of Trade Talks. The host will present these podcasts and actively provide input for planning.

BACKGROUND:

The Pakistan Single Window is an integrated digital platform that allows parties involved in trade and transport to lodge standardized information and documents with a single-entry point to fulfill all import, export, and transit-related regulatory requirements. It aims at reducing the time and cost of doing business by digitalizing Pakistan’s cross-border trade and eliminating paper-based manual processes. The PWSC, a public sector company incorporated under section 42 of the Companies Act, 2017 by Pakistan Customs, has been notified as the ‘operating entity’ of the PSW system by the Federal Government under the provisions of the Pakistan Single Window Act, 2021.

To create greater buy-in and widespread voluntary adoption among various stakeholders, and the private sector in particular, the PSW communication strategy employs an integrated communications approach to unify marketing communication elements, such as public relations, social media, audience analytics, business development principles, advertising, and promotion into a brand identity that remains consistent across distinct media channels to reach target audiences and ensure mass adoption of the services provided through PSW.

SCOPE OF WORK:

The Marketing & Communications Department seeks to promote the core work and services of PSW through social media. In this regard, we are looking to engage a professional and skilled Podcast Host to present and moderate a series of informative and engaging podcasts in support of PSW’s integrated marketing and communications strategy. The podcast host will play a crucial role in presenting the content in an engaging and accessible manner to a wide range of audiences, including importers, exporters, government officials, and trade professionals.

Under the supervision of HOD Communications, the specific roles and responsibilities of the Podcast Host are:

Planning and Research:

1. Research and analysis to develop an insightful and strategic understanding of PSW’s core work and services, key messages and target audiences
2. Develop an understanding of topics related to trade facilitation, import/export procedures, and the role of the Pakistan Single Window
3. Collaborate with the PSW Marketing and Communications team to understand the key messages and objectives of each podcast episode
4. Assist with script development for each episode, ensuring clarity, accuracy, and alignment with overarching communications objectives

Hosting:

• Host Trade Talks podcast episodes, creating a welcoming and conversational atmosphere
• Conduct Trade Talks podcast interviews with subject matter experts, industry leaders, and stakeholders in an insightful manner
• Moderate interviews and conversations to highlight PSW’s core work and services and/or key messages in a smart and subtle manner
• Appear in content created for the promotion of each episode

Communication and Collaboration:

• Maintain regular and effective communication with the PSW team to align on podcast topics, guest speakers, and podcast schedules
• Collaborate with the PSW team to ensure accuracy and consistency of the content presented
• Seek feedback and incorporate suggestions provided by the PSW team to improve the quality and relevance of the podcast
• Note: All tasks/work done by the Podcast Host are dependent on the discussion and approval of the Communications team and HOD Marketing and Communications.

DELIVERABLES & ASSIGNED DUTIES:

1. Captivating and dynamic hosting for each podcast episode
2. Adherence to the agreed-upon schedule for timely delivery of episodes (at least, but not limited to one per month)
3. Regular communication and collaboration with the PSW Marketing and Communications team
4. Assistance in the development of the podcast script

LOCATION AND SCHEDULE:

For the foreseeable length of this agreement, the podcast will be recorded once a month in Islamabad, Pakistan. The frequency may increase and any changes to this will be communicated well in advance by the PSW team.

REQUIRED SKILLS AND QUALIFICATIONS:

• Substantial
• Excellent oral communication skills, captivating on-air presence and interviewing skills
• Creativity in presenting information in an entertaining and informative manner
• Ability to give actionable recommendations
• Creativity in presenting information in an engaging and entertaining manner
• Familiarity with trade facilitation, import/export procedures, and the concept of single window platforms will be an added advantage
• Ability to work collaboratively and adapt to feedback and suggestions

EXPERIENCE:

Relevant field experience experience in hosting broadcast shows, with a proven track record of successful programs

Skills:

Critical Thinking, Active Listening, Outstanding Time Management,
 

Job Requirement:

This is a multi-faceted role where you will support the execution of PSW’s communications strategy and campaigns. Besides having a knack for content creation and branding, you will also provide support on communications initiatives by ensuring effective coordination and documentation across campaigns. The incumbent will ensure consistent branding and provide communications support pertaining to methods, materials and channels.

Responsibilities:

Content Development:

1. Produce well-researched content for publication online and in print, on industry-related topics (combining online sources, interviews and studies)
2. Develop related high-quality content for multiple print and digital platforms, such as websites, email marketing, product descriptions, videos, and blogs
3. Follow an editorial calendar for communications content development, collaborating with other members of the communication team to ensure timely delivery of materials
4. Proofread content for errors, inconsistencies and polishing existing content to improve readability
5. Work with the Communications team to ensure high quality communication products – such success stories, photos, videos, annual reports, newsletters, blogs, etc.

Media Engagement:

• Provide event coordination and support to the Deputy Communications Manager (invitations, venue/vendor liaison, on-site coordination, post-event report)
• Support in design and coordination of media visits
• Support media outreach activity
• Any other work assigned by the Deputy Communications Manager

Coordination and Support:

1. Support in developing and regularly updating the PSW website
2. Coordinate with internal PSW departments to ensure high quality communication products – such as rollout updates, photos, annual reports, newsletters, blogs, videos etc.
3. As required, support with the development and execution of special communications initiatives including PSW webinars and podcast
4. Track and document sessions and campaign activities with record sheets, detailed notes, photos, videos & any other means deemed appropriate.
5. Efficient and timely coordination with other departments (finance, procurement etc.) to ensure internal SOPs are followed to the letter and there are no delays/hindrances in the smooth working of the Marketing and Communications department

Qualifications and Education:

• Bachelor's degree in communications, marketing, English, journalism, or related field.
• Excellent written and verbal communication skills in Urdu and English.
• Proven content writing or copywriting experience.
• Working knowledge of content management systems.
• Working knowledge of design tools such as Canva, Photoshop etc.
• Proficient in all Microsoft Office applications.
• The ability to work in a fast-paced environment.
• The ability to handle multiple projects concurrently.

Skills:

Adobe Photoshop, Canva, Microsoft Office Applications,
 

Key Responsibilities

Under the direction of the Head of Marketing & Communications (HOD), the Communications Manager will lead the execution of PSW’s communications operational plan, support the communications department to develop and deliver on the objectives and operational work plans of the department. The Communications Manager oversees financial and human resources to deliver the department’s objectives.

In this position, you will oversee producing high-quality content that engages customers, builds brand recognition, and promotes PSW’s services. The Communication Manager will be responsible for all internal and external communications with strategic direction from the HOD. The duties will also include managing external and internal communication, social media, PSW’s website and digital channels, media relations, content development, planning and executing campaigns and promoting PSW’s brand and services.

Communication Planning & Operations:

1. Support and supervise the implementation of the communication operational plan and communications strategy, stakeholder engagement plan, and information dissemination mechanisms for PSW including information on objectives, audiences, messages, resources, timescales, tools, and activities.
2. Implementation of the department operational plan aligned with the Communications Policy. Create, implement, and oversee communications programs, internal and external, that effectively describe and promote PSW and its services.
3. Implementation of the CSR operational plan aligned with the CSR Policy. Successful and timely implementation of all activities reflected in the CSR operational plan.
4. Creation and implementation of monthly operational plans for all Communications: media & PR, social media, paid advertising, content and design, websites (PSW & Tradeverse) and digital channels, events & campaigns.
5. Creation and implementation of SOPs for all internal and external communications and branding. Ensuring that the correct protocols are followed for all communications internally and externally.

Team Management:

• Leads, mentors, motivates and provides clear direction to the Communications team.
• Oversees development of team and individual work plans, line manages, and conducts performance evaluations for all team members.
• Oversees hiring and on-boarding of new Communications Department staff.
• Fosters a positive team environment and provides team building and professional development initiatives.
• Provides leadership and advocates on key issues related to the communications strategy.
• Liaises with other departments to promote linkages between them and our stakeholders through campaigns and communications initiatives.
• Oversees and supports staff to manage communication project budgets, including leading annual team departmental budgeting processes, monitoring disbursements of project funds and ensuring accurate and timely financial reporting on all initiatives.

Communications Strategy and Brand Management:

1. Ensures the execution of PSW’s overarching Communications Strategy, including media and social media, content, and storytelling.
2. Ensures delivery of dynamic content and compelling stories of PSW’s work and its impact.
3. Supports team to deliver priority communications assets and products.
4. Liaises with other departments to identify communications support needs and triage requests.
5. Reviews key communication materials prior to publication for quality control and to ensure consistent messaging and tone.
6. Serves as the point of contact for communications-related issues, ensuring the HOD is kept well informed, and issues are appropriately escalated.
7. Supports the HOD and Senior Management Team with crisis communications when necessary.
8. Ensures all content is compliant with global accessibility standards and meets PSW branding guidelines.
9. Develops monthly editorial calendars for communications content development. Organizes writing schedules to produce quality pieces that appeal to target audience, attract relevant stakeholders and boost brand awareness.
10. Helps design, develop, implement, and supervise communication and outreach/advocacy strategies, including media strategies and developing digital platforms (print, electronic, website, social, and other media).

Skills:

Branding Research, Social Media Strategies, Communication Skills,
 

Pakistan Single Window (PSW) is looking for a dynamic individual responsible for creating and administering content on all social media platforms, such as LinkedIn, Facebook, Instagram, Twitter and TikTok, to build an audience and ensure customer engagement. The Specialist will also monitor site metrics, respond to reader comments, and oversee creative design. This position will require you to promote the brand, service, and product to the associated audiences on social media. Your goal will be to create a new following for market and brand awareness, for which you will need to have the strategic sense required to build or optimize social media strategy. It is also essential that you are aware of social trends and can conduct a thorough media analysis. You will work with our marketing team to help develop brand awareness about our company through social media.

Responsibilities:

Planning:

1. Conceptualize, optimize and execute a social media strategy for PSW that aligns with the company’s overall communications objectives
2. Use data to analyze what’s working, what’s not, and reinforce or refocus key messages accordingly
3. Help convert our brand fans into loyal customers with engaging, responsive, responsible, surprising, and captivating social media interactions
4. Work with the Communications Manager to create and maintain social media content calendar and manage social media spending/boosting plan
5. Understand the targeted audience for each social channel and create tailored and persuasive content that strikes a chord with the intended audience
6. Analyze data and sentiment metrics to create a better understanding of the target audience and other stakeholders
7. Extract insights and make data-driven recommendations   
8. Stay ahead of the curve by keeping up with the latest social media trends, emerging platforms, and best practices

Creative:

• Write long- and short-form social media messages that attract new users and engage current users
• Keep social media platforms up to date with high-quality content assets that elevate our social media presence
• Assess new platforms to reach a broader market
• Develop and launch organic and paid campaigns to build PSW’s following and engagement

Technical:

1. Leverage social media marketing tools such as Buffer, HubSpot or Hootsuite for scheduling, monitoring, listening and analysis
2. Use Canva or Adobe Creative Suite to create static and animated visual assets for social media

General:

• Collaborate and coordinate with internal teams to ensure promotion of all PSW-related products, modules, and other updates or events.
• Other relevant tasks assigned by the Communication Manager

Qualifications, Experience & Technical Competencies: 

1. Bachelors in Communications, Marketing, Business, New Media, or Public Relations
2. Proven working experience in Social Media Marketing or as a Digital Media Specialist
3. Demonstrable social networking experience and social analytics tools knowledge
4. Positive attitude, detail and customer-oriented with good multitasking and organizational ability
5. Excellent communication skills in English (level C1 and above), and Urdu, with the ability to communicate effectively
6. Excellent consulting, writing, editing (photo/video/text), presentation and communication skills
7. Strong creative thinking, problem-solving abilities, and an eye for visual aesthetics to curate compelling social media posts
8. Knowledge of online marketing and a good understanding of major marketing channels

Skills:

Canva, Digital Media Management, Corporate Social Media Coordination,
 

Design and develop Software Architecture and applications as per specification by following the guidelines and best practices.

1. Maintain and support software applications in different stages.
2. R&D to explore new technologies and trends.
3. Experience of distributed systems, RESTful APIs, and message brokers (e.g., RabbitMQ, Kafka).
4. Develop REST & GraphQL APIs.
5. Experience with API gateways, load balancers, and service discovery mechanisms.
6. Collaborate with Data architect to design data architecture solutions. Participate in design discussions, providing insights and suggestions using data principles.
7. Assist in designing and implementing efficient data integration workflows. Contribute to developing processes and scripts, ensuring data is securely transformed.
8. Work alongside database administrators and developers to optimize data retrieval and query performance. Assist in identifying and resolving performance bottlenecks by suggesting indexing strategies or query-tuning techniques.
9. Develop easy-to-use data structures for efficient dataset access and organization. Collaborate with Business analysts and project managers to understand ad-hoc analysis requirements and recommend available data.
10. Conducting data analysis if needed, integrating data with other applications, developing data visualizations, and troubleshooting data problems.
11. Ensure the quality of code through guidelines and unit testing.
12. Participate in code reviews, provide constructive feedback and mentor junior developers.
13. Participate in scrum meetings to ensure the delivery as per plan, and contribute with the Project Manager for release planning.
14. Cross-Functional Collaboration.
15. Continuous Improvement and Innovation, good knowledge of Emerging Technology.

Skills:

Micro Services Architecture, MVC, Design Patterns, OOAD, React JS, .Net, Data Structures Command,
 

Responsibilities:

1. Review, analyse and ensure timely resolution of software issues escalated from L2 support team.
2. Collaborate with product development & product testing teams to identify and prioritize product enhancements and bug fixes based on stakeholders feedback or self-identification.
3. Collaborate with DevOps, Systems, Networks, L2 Support and Database Administration Teams to ensure that reported production issues are tracked, prioritized, and resolved in a timely manner.
4. Provide technical expertise and guidance to team members as needed and stay up-to-date on industry trends and best practices of software services management.
5. After deployment of release, analyze transactional system databases to ascertain data damage or inconsistency. Plan and execute corrections, ensuring data integrity.
6. Maintain the database of reported issues, root cause analysis and effected transactions to publish monthly software defect report to stakeholders.
7. Continually develop knowledge of the PSW suites of software applications and keep up to date with newly releases.
8. Any other task assigned by respective line manager to improve the efficiency of software support functions.
9. Monitor and analyse production incidents, identifying trends, patterns, and areas for improvement to prevent future disruptions.
10. Ability to managing a team of software support specialists.
11. Ensuring that the team provides timely and effective support to stakeholders, including troubleshooting and issue resolution.

Skills:

Queues, Splunk, SQL Queries,
 

Main Responsibilities:

1. Design & Develop Software applications as per specification by following the guidelines and best practices
2. Develop REST & GraphQL APIs
3. Ensure the quality of code through guidelines and unit testing
4. Participate in scrum meetings to ensure the delivery as per plan
5. Maintain and support software applications in different stages
6. R&D to explore the new technologies and trends

Required Skill Set:

• Strong software engineering fundamentals in OOAD, design patterns, MVC, data structures, algorithms, etc.
• Experience or knowledge of C#, .NET Core, ReactJS, AngularJS, Typescript, CSS, HTML, SQL Server or other RDBMS, Entity Framework Core
• Experience or knowledge of Rest & GraphQL API development
• Experience or knowledge of source control (Git, SVN) & unit testing tools
• Knowledge of Golang, NoSQL and Graph Database would be a plus
• Strong interpersonal, written, and verbal communication skills
• Ability to perform comfortably in a fast-paced, deadline-oriented, agile environment
• Self-motivated, quick learner and a responsive team player
• Strong problem-solving, debugging and analytical skills
• Knowledge and understanding of microservices

Skills:

REACT.JS, .Netcore, C, #HTML, Angular JS, ASP.Net,