Job Description:
The primary responsibility will be to design, develop, and maintain databases, migrating data from older versions of customer databases, ensuring efficient data storage, retrieval and security, while also optimizing performance and ensuring data integrity.
Experience : 7 to 10 years of relevant experience.
Job Responsibilities:
Database Design and Development:
Designing database schemas and data models.
Developing and implementing database structures that meet specific business needs.
Ensuring data integrity and consistency.
Developing migration scripts and maintaining them for efficient and accurate data migrations across different versions of applications.
Performance Optimization:
Identifying and resolving performance bottlenecks.
Optimizing database queries, LINQ queries and data structures.
Monitoring database performance, indexing, partitioning, archiving and implementing improvements.
Data Security and Management:
Implementing and maintaining database security protocols.
Managing user access and permissions.
Ensuring compliance with relevant regulations and standards.
Backup, Recovery and Restoration:
Managing backup plans.
Restoration of DB from backup.
Managing ad-hoc backup requests.