Course: Programmer/Developer
DG Infotech Limited is recruiting two Programmer/Developer positions based in Gulshan, Dhaka, with an application deadline of 16 May 2025. The job posting, published on 17 April 2025, requests candidates with 2 to 3 years of practical experience and asks applicants to submit a Video CV. Educational requirements include a BSc or MSc in Computer Science & Engineering or a BSc in Software Engineering, with preference given to students and graduates from specific Bangladeshi universities such as DIU, SUST, AIUB, NSU, and MIST. Responsibilities emphasize collaboration with teammates, translating client requirements into production-ready software, and developing aesthetic front-end interfaces using frameworks like React or Angular. The role also requires designing and optimizing database schemas, understanding advanced database concepts (sharding, partitioning), and implementing REST APIs using back-end technologies such as Python, Java, or Node.js. Candidates should be familiar with software testing practices (unit testing, load testing), debugging, performance scaling, and integrating third-party services. The company stresses adherence to software development methodologies and recommends tools like Jira, alongside a strong expectation for technical documentation in line with CMMI level 4 standards. Security awareness is prioritized, with explicit attention to threats such as CSRF, ransomware, input validation flaws, and SQL injection. Compensation is negotiable and includes benefits such as partial lunch subsidies, mobile bill coverage, and two festival bonuses. The position is full-time, on-site work at the company’s Gulshan office on Rangs FC Enclave, Road-32. DG Infotech’s business focuses on identity solutions, mobile e-payment platforms, AI-driven financial solutions, biometric smart cards, IT infrastructure, and data center installations — all contexts that make security and scalable architecture central to the developer role. Prospective applicants should highlight their experience with scalable backend services, database optimization, front-end frameworks, and documented adherence to secure coding and CMMI-compliant documentation in their applications and Video CV submissions.Lesson
Topic: DG Infotech Limited — Programmer/Developer (Job Overview & Skills)
Learning Outcomes
- Identify core job requirements and preferred educational backgrounds for the Programmer/Developer role.
- Describe the essential technical responsibilities including front-end frameworks, REST APIs, and database optimization.
- Explain security considerations and documentation standards (CMMI level 4) expected by the employer.
- Prepare a concise Video CV and application aligned with the job posting and deadline.
Conceptual Explanation
This section outlines the job posting details, responsibilities, and company profile so learners can map required competencies to practical tasks.
| Field | Details |
|---|---|
| Company | DG Infotech Limited |
| Position | Programmer/Developer |
| Vacancy | 2 |
| Location | Dhaka (Gulshan) — Rangs FC Enclave, Level-4, Plot-6/A, Road-32, Gulshan Avenue |
| Experience | 2 to 3 years |
| Deadline | 16 May 2025 |
| Education | BSc/MSc in CSE or BSc in Software Engineering; preference for DIU, SUST, AIUB, NSU, MIST |
| Tech Stack Highlights | React/Angular (front-end), Python/Java/Node.js (back-end), REST API, SQL DB optimization |
| Benefits | Mobile bill, partial lunch subsidy, 2 festival bonuses |
Key responsibilities include requirement analysis, UI development, core business logic maintenance, database design and optimization, third-party integrations, testing, troubleshooting, and producing CMMI level 4-compliant technical documentation.
Bilingual (EN → বাংলা)
English: DG Infotech Limited seeks two Programmer/Developer candidates for full-time, on-site roles in Gulshan, Dhaka with an application deadline of 16 May 2025.
Answer
বাংলা: DG Infotech Limited ফুল-টাইম, অফিস-ভিত্তিক দুইজন প্রোগ্রামার/ডেভেলপার নিয়োগ দেবে, তাদের আবেদন করার শেষ তারিখ ১৬ মে ২০২৫।
English: Applicants are encouraged to submit a Video CV and must demonstrate experience with front-end frameworks, REST APIs, and database optimization.
Answer
বাংলা: আবেদনকারীদের একটি ভিডিও সিভি জমা দেওয়া উৎসাহিত করা হয়েছে এবং তাদের ফ্রন্ট-এন্ড ফ্রেমওয়ার্ক, REST API এবং ডাটাবেস অপ্টিমাইজেশন বিষয়ে অভিজ্ঞতা প্রদর্শন করতে হবে।
Important Notes
- Prepare a succinct Video CV that highlights 2–3 years of relevant projects and specific contributions (scaling, testing, security).
- Emphasize documentation practices consistent with CMMI level 4.
- Mention experience with database sharding, partitioning, query optimization if available.
- Security-first mindset: note how you prevent CSRF, SQL injection, and other threats.
- Salary is negotiable; outline compensation expectations clearly in the interview/application process.
Exercises
True / False
- DG Infotech requires applicants to work remotely only.
Answer
False — the posting specifies work at office (on-site) in Gulshan, Dhaka.
- Applicants with database sharding knowledge are considered aligned with the job requirements.
Answer
True — the posting lists sharding and partitioning under advanced database concepts.
- CMMI level 4 documentation is optional and not mentioned.
Answer
False — proficiency in writing technical documentation following CMMI level 4 standards is required.
- Video CV submission is discouraged by the employer.
Answer
False — applicants are encouraged to submit a Video CV.
Fill in the Blanks
- The job location is _____ (City/Area).
Answer
Dhaka (Gulshan)
- Preferred educational backgrounds include BSc or MSc in _____ & _____ .
Answer
Computer Science & Engineering; Software Engineering
- One recommended project management or tracking tool mentioned is _____.
Answer
Jira
- The company expects documentation aligned with _____ level 4.
Answer
CMMI
Multiple Choice Questions (MCQ)
- Which front-end frameworks are explicitly mentioned in the posting?
- A. Vue / Svelte
- B. React / Angular
- C. jQuery / Backbone
Answer
B. React / Angular
- Which back-end technologies are listed as examples for creating REST APIs?
- A. Python, Java, Node.js
- B. PHP, Perl, Ruby
- C. Go, Rust, Scala
Answer
A. Python, Java, Node.js
- What is the number of vacancies for this position?
- A. 1
- B. 2
- C. 5
Answer
B. 2
Matching
Match the item in column A (responsibility) with column B (technology/term).
| Column A | Column B |
|---|---|
| 1. Create aesthetic UI | A. Sharding |
| 2. Database partitioning | B. React / Angular |
| 3. Design REST API | C. REST (HTTP, JSON) |
| 4. Optimize SQL queries | D. Query optimization, indexing |
Answer
1 → B (Create aesthetic UI → React / Angular)
2 → A (Database partitioning → Sharding/Partitioning)
3 → C (Design REST API → REST (HTTP, JSON))
4 → D (Optimize SQL queries → Query optimization, indexing)
Descriptive
Prompt: Briefly describe how you would approach optimizing a slow SQL query in a production system.
Answer
Model answer: First, reproduce the slow query in a staging environment and capture execution plans using EXPLAIN/EXPLAIN ANALYZE. Identify full table scans, missing indexes, or inefficient joins. Add or adjust appropriate indexes (composite where needed), rewrite queries to avoid unnecessary subqueries or correlated queries, and simplify joins by selecting only required columns. Consider partitioning or sharding if table size or access patterns justify it. Evaluate caching options (application-level caching, materialized views) for frequently accessed results. After changes, measure improvements in response time and load, run regression tests, and deploy with monitoring and rollback plans.
Creative
Prompt: Create a 60-second Video CV script outline that highlights the skills relevant to this DG Infotech role.
Answer
Script Outline: (0–10s) Greeting: name, current title, years of experience, and job applied for. (10–25s) Key technical highlights: front-end frameworks (React/Angular), back-end stacks (Python/Node.js), REST API experience, and a one-line mention of CMMI-compliant documentation. (25–40s) Impact statement: one or two project achievements demonstrating scaling, database optimization (sharding/partitioning), or critical bug fixes with measurable outcomes. (40–55s) Security & testing focus: mention secure coding practices (preventing SQL injection, CSRF), unit and load testing, and use of Jira for workflow. (55–60s) Closing: contact details, availability, and a prompt to view linked portfolio or code samples.
Activities, Vocabulary, Homework, Practice Task
Activities
Answer
Group activity: In pairs, analyze a sample job posting and create a tailored 30-second Video CV script that emphasizes three matched skills. Role-play a short interview equally split between front-end and back-end questions.
Vocabulary
Answer
Key terms to learn: REST API, CMMI level 4, sharding, partitioning, CSRF, SQL injection, unit testing, load testing, Jira, biometric smart card, e-payment platform.
Homework
Answer
Prepare a one-page technical summary of a past project that demonstrates database optimization and include a CMMI-style documentation checklist. Submit a 30–60 second Video CV draft highlighting the skills requested in this posting.
Practice Task
Answer
Implement a simple REST API endpoint (GET /items) in your preferred back-end language that returns paginated results from a sample SQL table and document the design in a short technical note following CMMI-style headings (Overview, Requirements, Design, Testing, Deployment).
Company Profile: DG Infotech Limited — Identity solutions, mobile e-payment platforms, AI-based financial solutions, biometric smart cards, IT infrastructure, and data center services.