Behind the scenes of every data-driven operation is a Database Engineer, a critical role responsible for designing, implementing, and maintaining the databases that store and organize vast amounts of information. Let’s delve into the intricate responsibilities and crucial role of a Database Engineer.

Table of Contents

Responsibilities of Database Engineer:

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.
Analyze current production database, evaluate performance issues and document so it can be avoided in new database design.
Analyze the needs of an application and produce an effective database system according to its need and specification.
In addition, data engineer will be collecting data, analyzing the data, designing algorithms, drawing flowcharts, and implementing code for the logic developed through the algorithms and flowcharts.
Contribute towards designing the database using current production data.
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.
Troubleshooting any potential problems, creating, and submitting test reports and database improvement.
Database developer would document current system’s database details, stored procedures, functions, triggers, views etc.
Database developer must work with the frontend and backend development team to integrate the modules together. Once this is done, the integrated code must again be tested and any errors must be fixed.
Experience of splitting big database into small databases is a plus.

Database Engineer Job Details:

Title	Details
Posted On	28 June 2024
Job Type	Regular
Sector	Govt
Industry	Pakistan Single Window (PSW)
Department	Information Technology (IT)
Total Position	03

Database Engineer Skills and Experience:

At least 4+ years of experience in database design, development, and performance tuning.
Proficient in Microsoft SQL Server and its tool
SQL Tools (Query Analyzer, Query Execution Plan, Profiler, Analytics)
Query Writing and Optimization
Database Analyzing, Root Cause Analysis
Database Tuning, Online Indexing, SQL Server Database Diagram
Database Programming, GIT, TFS
Quality Assurance Testing
Code Reviews, debugging and Trouble Shooting
Strong Interpersonal and Communication skills
Minimum Bachelors (4 year) (HEC recognized) degree in Software/computer related engineering