Description
You will design and manage database schemas to ensure long-term data integrity and performance.
Responsibilities
- Lead analysis and planning phases to define database schemas and data relationships.
- Design and implement data archival and purge strategies, including necessary schema modifications.
- Plan and execute data partitioning strategies to optimize storage and access.
- Optimize database performance through strategic indexing and schema design.
Required Skills
- 8+ years of experience in database architecture and design.
- Expert-level proficiency in SQL Server.
- Strong command of T-SQL scripting, stored procedures, and SQL Server Agent jobs.
- Deep knowledge of data modeling and database schema design principles.
- Proven experience implementing data partitioning and indexing strategies.
- Understanding of data retention requirements and regulatory compliance.
- Any Graduate degree.
Preferred Skills
- Strong analytical and problem-solving abilities.
- Proven leadership and communication skills.