• Design conceptual and logical data models and flowcharts, choosing the best technology stack, lead to build the Database architecture.
• Analyzed existing database structure, recommend how to decentralize and/or build new decentralize database.
• 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.
• Own database designs and all data related operations, issues, enhancements etc.
• Analyze the needs of an organization and produce an effective database system according to their needs and specifications as well as for future scalability.
• Collaborate with application/system architects, information technologists, and other staff members regarding data storage practices, network operation, and other data related issues.
• Includes collecting data, analyzing the data, designing algorithms, drawing flowcharts and implementing code for the logic developed through the algorithms and flowcharts.
• Implementing migration methods for existing data, improving the system performance by conducting tests and troubleshooting, and defining security and backup procedures.

Requirements

• 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

Benefits

• Competitive salary
• Fuel Card
• Health benefits
• Professional development opportunities
• Inclusive work culture & much more