Similar Jobs

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:

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

1. Substantial
2. Excellent oral communication skills, captivating on-air presence and interviewing skills
3. Creativity in presenting information in an entertaining and informative manner
4. Ability to give actionable recommendations
5. Creativity in presenting information in an engaging and entertaining manner
6. Familiarity with trade facilitation, import/export procedures, and the concept of single-window platforms will be an added advantage
7. 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, 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. Review key communication materials before 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 the 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,