SENIOR DATABASE & MIGRATION SPECIALIST

Technical Skills and Experience 

Essential:
 

• Minimum 5 years of hands-on experience in enterprise database development
• Strong expertise in database architecture, including schema design, ER modelling, and long-term stability planning
• Intermediate to advanced MSSQL expertise, including:
• Complex stored procedures
• Ability to refactor advanced T-SQL programming
• Query tuning and optimization
• Triggers, functions, and transactions handling
• Index strategies and database performance tuning

Tasks and Accountabilities 
 

• Design, develop, enhance, and maintain enterprise-grade relational databases
• Create advanced stored procedures, functions, views, and complex T-SQL logic
• Architect and optimize database schemas, indexing strategies, and data models
• Perform database performance tuning, query optimization, and execution plan analysis
• Lead and execute database migration projects (cross-version, cross-platform, or cross-technology)
• Support enterprise application migration projects involving modernization, refactoring or re-platforming
• Develop backend data flows, integration pipelines, and high-volume processing routines
• Ensure database scalability, reliability, and compliance with best practices
• Create documentation including ERDs, data dictionaries, and data architecture standards