Course: Programmer
Secura Bangladesh Limited has advertised a Programmer position with an application deadline of 16 May 2025. The vacancy calls for one male candidate aged between 25 and 30 years, to be based in Narayanganj. The company is a joint venture with Secura Singapore Pte Ltd and is noted as the first private security instruments printing firm in Bangladesh. Applicants should hold a B. Sc. in Computer Science & Engineering or a Bachelor in Engineering from a reputed university. Required professional experience is two to four years, preferably with exposure to trading or export/import business areas. The role emphasizes strong object-oriented programming fundamentals and practical coding experience in ASP.NET, ASP.NET MVC, C#, and Web API. Candidates must demonstrate database design skills in Microsoft SQL Server or MySQL and the ability to write SQL queries, functions, triggers, and stored procedures. Familiarity with Crystal Reports and front-end scripting using JavaScript and jQuery within ASP.NET applications is expected. The programmer will be responsible for coding, testing, debugging, maintaining applications, writing database scripts, and providing software support under the technical supervision of the Information department. The position requires full-time office work, offers a negotiable salary with yearly reviews, and provides two festival bonuses annually. Fluency in Bangla and English, strong problem-solving, and decision-making abilities are mandatory. Applicants should be willing to analyze problems independently and seek guidance from seniors or online resources when necessary. Interested candidates can contact Secura Bangladesh Limited at Rahman Chamber, Motijheel C/A, Dhaka-1000 for further information.
Lesson
Topic: Secura Bangladesh Limited — Programmer Job Requirements and Skills
Learning Outcomes
- Identify core technical requirements for the Programmer role at Secura Bangladesh Limited.
- Explain object-oriented programming concepts relevant to ASP.NET and C# development.
- Demonstrate basic database design and SQL concepts used in Microsoft SQL Server/MySQL.
- Interpret job posting details to prepare an effective application and interview responses.
Conceptual Explanation
The Programmer role requires mastery of object-oriented programming (OOP) principles: encapsulation,
inheritance, polymorphism, and abstraction. In an ASP.NET/ASP.NET MVC environment, developers structure
applications into models, views, and controllers to separate concerns and improve maintainability. C#
is the primary language for business logic and Web API development, enabling RESTful endpoints for
internal and external integrations. Database design for Microsoft SQL Server or MySQL involves defining
normalized tables, keys, indexes, and relationships; writing stored procedures, functions, and triggers
optimizes performance and enforces business rules. Crystal Reports is a reporting tool used to create
formatted reports from database sources, and front-end scripting with JavaScript and jQuery enhances
user interactions within ASP.NET pages. Strong problem-solving entails diagnosing runtime issues, using
debugging tools, tracing SQL queries, and collaborating with seniors or documentation for complex fixes.
Bilingual (EN → বাংলা)
| English |
বাংলা |
| Programmer / Software Engineer |
প্রোগ্রামার / সফটওয়্যার ইঞ্জিনিয়ার |
| Object-Oriented Programming (OOP) |
অবজেক্ট-ওরিয়েন্টেড প্রোগ্রামিং |
| Database Design |
ডাটাবেস ডিজাইন |
| Crystal Report |
ক্রিস্টাল রিপোর্ট |
| Deadline |
আবেদনের শেষ তারিখ |
Important Notes
| Field |
Detail |
| Company |
Secura Bangladesh Limited (Joint venture with Secura Singapore Pte Ltd) |
| Position |
Programmer |
| Vacancy |
1 |
| Location |
Narayanganj (Work at office) |
| Age Requirement |
25 to 30 years |
| Gender |
Only Male |
| Education |
B. Sc. in CSE / Bachelor in Engineering |
| Experience |
2 to 4 years (Trading or Export/Import preferred) |
| Skills |
ASP.NET, ASP.NET MVC, C#, Web API, SQL Server/MySQL, Crystal Report, JavaScript/jQuery |
| Benefits |
Negotiable salary, yearly review, 2 festival bonuses |
| Application Deadline |
16 May 2025 (Published 17 Apr 2025) |
Exercises — True / False / Fill in the Blanks / MCQ / Matching / Descriptive / Creative
True / False
| # |
Statement |
Answer |
| 1 |
The job requires experience with ASP.NET MVC. |
AnswerTrue — ASP.NET MVC is explicitly listed among required skills. |
| 2 |
Crystal Report is not a required skill for this position. |
AnswerFalse — Using reporting tools 'Crystal Report' is required. |
| 3 |
The position allows remote work as the default workplace. |
AnswerFalse — The workplace is listed as "Work at office" and full-time. |
| 4 |
Applicants must be fluent in both Bangla and English. |
AnswerTrue — Fluency in Bangla & English is required. |
Fill in the Blanks
| # |
Question |
Answer |
| 1 |
The application deadline is ______. |
Answer16 May 2025. |
| 2 |
Required database systems include Microsoft SQL Server and ______. |
AnswerMySQL. |
| 3 |
The job posting specifies gender as ______. |
AnswerOnly Male. |
| 4 |
Two annual ______ bonuses are provided. |
Answerfestival. |
Multiple Choice Questions (MCQ)
| # |
Question |
Options |
| 1 |
Which language is central to the back-end development for this role? |
AnswerCorrect: C#. (Options: A) Java, B) Python, C) C#, D) Ruby) |
| 2 |
Which reporting tool should applicants know? |
AnswerCorrect: Crystal Report. (Options: A) Crystal Report, B) JasperReports, C) Tableau, D) Power BI) |
| 3 |
Which of the following is not explicitly required? |
AnswerCorrect: Mobile app development. (Options: A) ASP.NET MVC, B) Web API, C) Mobile app development, D) SQL stored procedures) |
| 4 |
What is the preferred educational background? |
AnswerCorrect: B. Sc. in Computer Science & Engineering or BEngg. (Options: A) BBA, B) B. Sc. in CSE/BEngg, C) BA in History, D) Diploma in Graphic Design) |
Matching
Match the skill with its typical use.
| Letter |
Skill |
Number |
Use |
| A |
ASP.NET MVC |
1 |
Builds web application structure (Model-View-Controller) |
| B |
Crystal Report |
2 |
Designing formatted database reports |
| C |
Stored Procedures |
3 |
Encapsulating SQL logic on the database server |
| D |
jQuery |
4 |
Simplifying DOM manipulation and AJAX in web pages |
| Answers |
|
AnswerA → 1, B → 2, C → 3, D → 4. |
Descriptive
-
Explain how understanding OOP benefits maintenance of a large ASP.NET application.
Answer
OOP enforces modular design via classes and objects, which encapsulate data and behavior, making code easier to test, reuse, and extend. In ASP.NET applications, using OOP allows developers to separate concerns (models, controllers, services), implement interfaces for dependency injection, and manage complexity with clear abstractions — all of which improve maintainability and reduce regression risk.
-
Describe steps to diagnose a slow SQL query reported by a web application user.
Answer
Steps include: reproduce the query, capture the exact SQL and parameters, use EXPLAIN/Execution Plan to inspect indexes and joins, check indexing and statistics, look for missing indexes or table scans, review server resource usage (CPU, I/O), optimize query or add indexes, consider caching or denormalization if needed, and test performance after changes.
Creative
Draft a concise 60–80 word cover paragraph that highlights your fit for this Programmer role.
Answer
I am a C# and ASP.NET developer with three years’ experience building web applications and designing relational databases in Microsoft SQL Server. I have implemented Web APIs, authored stored procedures, and created reports using Crystal Report. Fluent in Bangla and English, I combine strong OOP fundamentals with practical problem-solving and collaborative communication, making me well-equipped to support Secura Bangladesh Limited’s internal systems and reporting needs.
Activities, Vocabulary, Homework, Practice Task
Activities
- Review an ASP.NET MVC sample project and identify the controller actions and views.
- Design a simple database schema for an inventory table and write two stored procedures.
Vocabulary
| Term |
Definition |
| Web API |
An interface that allows applications to exchange data over HTTP. |
| Stored Procedure |
A saved collection of SQL statements executed on the database server. |
Homework
- Prepare a one-page résumé highlighting relevant projects in ASP.NET and database work.
- Implement a small ASP.NET MVC page with a connected SQL table and a Crystal Report export.
Practice Task
Write a SQL function that returns the total quantity of items in inventory grouped by product category; include comments explaining your logic.
Answer
Example approach: create a function or stored procedure that SELECTs product category and SUM(quantity) FROM inventory GROUP BY category; include input parameters if filtering by location or date, and ensure proper indexing on category fields for performance.
Company Address: Rahman Chamber (1st floor), 12-13 Motijheel C/A, Dhaka-1000, Bangladesh.