Database Engineer (Structural and Architectural)

Job Description

Title: Database Engineer (Structural and Architectural)

Company Name: eNestBD

Vacancy: --

Age: 20 to 45 years

Job Location: Dhaka (Uttara)

Salary: --

Experience:

• At least 5 years

• Bachelor of Science (BSc) in Computer Science & Engineering
• Diploma in Engineering in Computer Science & Engineering

• At least 5 years

• Age 20 to 45 years
• Only Male

Experience:

• 2 to 5 years (at least accomplished 3 project)
• The applicants should have experience in the following business area(s): Software Company, IT Enabled Service. The applicants should have experience in the following IT Enabled Service, Develop WP Plugins and WooCommerce (addOns),

Additional Requirements:

• Certification on Database management system / or appropriate certification for desired post is preferred
• Work in IT/ITES projects as database administrator Strong knowledge of SQL, stored procedures, DDL and DML, triggers and functions.
• Knowledge of performance tuning, query optimization, indexing, archiving data, clustering of database, database backup and recovery is required.
• Experience with working secured web-based information system as database administrator
• Experience with all phases of SDLC using agile development methodology.
• Experience in using UML design artifacts (class diagram and sequence diagram) for database design
• Proven experience as a Full-Stack Database Developer or similar role.
• Strong proficiency in Core PHP and the Laravel framework.
• In-depth knowledge of JavaScript and React.js. and HTML5, CSS3, Tailwind/Bootstrap.
• Experience with relational databases, specifically MySQL, including schema design and query optimization.
• Solid understanding of API design and development.
• Excellent problem-solving and debugging skills.
• Ability to work independently and manage time effectively.
• Strong communication and teamwork skills.
• 3+ years of hands-on experience with React.js in commercial projects
• React js, API integration, dashboard and charts. Responsive design, tailwind CSS.
• Familiarity with Git/GitHub/GitLab.
• Familiarity with queues, caching, broadcasting (Laravel Echo, Reverb, or Pusher).
• Enthusiastic about continuous learning with strong potential for growth.
• Excellent communication skills, both verbal and written.
• Adaptable and willing to work across different technology stacks as needed.
• Self-motivated and capable of managing tasks independently.
• Committed to writing clean, maintainable, and standards-compliant code.
• Familiar with Agile methodologies and collaborative development practices.

Preferred Qualifications (Bonus Points for):

• Experience with state management libraries like Redux or Context API.
• Familiarity with containerization tools like Docker.
• Knowledge of cloud platforms such as AWS, Google Cloud, or DigitalOcean.
• Experience with automated testing.
• A portfolio of past projects or a GitHub profile.

Skills & Expertise:

• Bug Fixing, Problem Solving & Alternative Method Making Skill, Software Development, Web Application Development, Complex Functional Web Application

Job Description:

• Manage the overall Database Configuration, un-interrupted performance of database structural and architecture including read, write and retrieve functionalities.

• Plan, measure, monitor and improve the availability of database by ensuring performance level, redundancy and efficient resource utilization.

• Maintain RPO (Recovery Point Objective), RTO (Recovery Time objective) parameter and System's availability with redundancy that requires understanding of SAN Storage with data replication between DC & DR, OS Clustering with DB failover clustering, Log Shipping, DB backup and restore.

• Organize and manage back-end data, user access control to database objects in order to fulfill online application requirements.

• Owning, tracking and resolving database related incidents and requests

• Reviewing service-related reports (e.g.: database backups, maintenance, monitoring) on a daily basis to ensure service-related issues are identified and resolved within established SLAs.

• Provide support and work closely with the application development, network and other teams to make required enhancement, modification of database and implement those in different environments.

• Maintain database performance by regulating performance tuning of required parameters, implementing new releases, applying required patches, completing maintenance requirement and evaluating of computer/ server operating system.

• Database migration, installation, configuration, trouble shoot of SQL Server of different versions as required.

• Perform database backup, archiving and recovery as per policy.

• Responding to database related alerts and escalations and coming up with strategic solutions to recurring problems.

• Support capacity development initiatives by continuous exchange of knowledge between team members, providing training and conducting session on technical issues.

• Writing database documentation, including data standards, procedures and definitions for the data dictionary.

• Address day to day enhancement requirement in line with business rules, performance monitoring, security issues, patch management and redundancy.

Job Responsibilities

• Create role, privilege for database user

• Define data structure and policies

• Responsible for performance tuning and optimization of database

• Regular backup of the Database

• Ensure security of Database

• Write database queries, triggers and procedures

• Make configuration, import and maintenance of database

• Conduct data management activities

• Migration of database (if required)

• Fix any issues, bugs and functional gaps related to database

• Assist the Technical Lead in preparation of deliverables

• Ensure database inconsistency and ensure robustness database.

• Design and implement safety measures and data recovery plans

• Record transaction history for major business activities

• Make system compatible with higher version of web server and database.

Salary Review: Half Yearly (Base on Performance as per ACR) Festival Bonus: 2 Friendly working environment. Career growth opportunities. Child allowance - because parenting is part of life AC rooms Overtime Allowance + snacks Tea, coffee - always brewing Laundry, hygiene, & comfort 24/7 security Medical allowance Offday Fully subsidized meals - breakfast, lunch & dinner + snacks Affiliate & Referral Earning