Responsibilities:

Collaborate with business analysts to understand business requirements and translate them into technical specifications.
Act as a liaison between business and technical teams, ensuring clear communication and mutual understanding.
Design system architecture and create detailed system design documents.
Develop and maintain entity-relationship (ER) diagrams to model database structures.
Create and update comprehensive Data Dictionaries to ensure data consistency and accuracy.
Draft detailed software development specifications (SDS) for development teams.
Conduct gap analysis to assess current systems and recommend improvements.
Work closely with developers to clarify technical specifications and ensure alignment with business goals.
Design, model, and optimize databases to support business applications and reporting needs.
Create and validate data migration plans, ensuring smooth transitions between legacy and new systems.
Oversee and manage data migration processes, including data cleansing, mapping, and validation.
Ensure that system designs meet both business and technical requirements.
Review and validate system designs and specifications with stakeholders.
Provide technical support during system testing and troubleshooting.
Oversee the implementation of system modifications and upgrades.
Ensure compliance with industry standards and best practices in system design, database design, and documentation.
Create user guides and technical documentation to support system implementation and maintenance.
Conduct system performance analysis to identify bottlenecks and suggest optimizations, including database tuning.
Manage and track changes to system requirements and database throughout the project lifecycle.
Report any incidents to Line Manager in proper and effectively.