Similar Jobs

Pakistan Single Window

Database Architect

Pakistan Single Window. Pakistan

Karachi, Pakistan

2025-01-20

Duties & Responsibilities:

  1. Design conceptual and logical data models and flowcharts, choosing the best technology stack, lead to build the Database architecture.
  2. Analyzed existing database structure, recommend how to decentralize and/or build new decentralize database.
  3. The focus will be on designing, developing, and managing large-scale databases to store and organize vast amount of data, follow data compliance and security policies as per industry standards for data governance.
  4. Own database designs and all data related operations, issues, enhancements etc.
  5. Analyze the needs of an organization and produce an effective database system according to their needs and specifications as well as for future scalability.
  6. Collaborate with application/system architects, information technologists, and other staff members regarding data storage practices, network operation, and other data related issues.
  7. Includes collecting data, analyzing the data, designing algorithms, drawing flowcharts and implementing code for the logic developed through the algorithms and flowcharts.  
  8. Implementing migration methods for existing data, improving the system performance by conducting tests and troubleshooting, and defining security and backup procedures.

Qualification, Experience & Technical Competencies:

  • Minimum Bachelors (4 year) (HEC recognized) degree in Software Engineering, Computer Engineering. 
  • At least 9+ years of experience in database design, development, and performance tuning. 
  • Experience developing large scale database as database architect.
  • Advance SQL concepts and experience, writing Queries, Database Analyzing
  • Excellent data management skills including ensuring data integrity, data access, security and archiving procedures.
  • Query Optimization, online Indexing, database Tunning, database Programming
  • Proven ability to work in distributed systems.
  • Code repository e.g., GIT, TFS 
  • Microsoft SQL Server 
  • SQL Tools (Query Analyzer, Query Execution Plan, Profiler, Analytics) 
  • SQL Server database diagram 
  • Code Reviews, Debugging and Trouble Shooting
  • Knowledge and understanding of parallel programming, thread programming, concurrency control and scalability.
  • Strong Interpersonal and Communication skills 

Skills:

MS SQL Server, Git, Data Management, Advance SQL, Communication Skills,
 

Salary 350000
Job Type First Shift (Day)
Qualification Bachelor
Experience 9 Years
Sectors Database Administration (DBA
Gender No Preference
Industry Information Technology
Career Level Experienced Professional
Job Expiry Date 2025-02-07