Key Responsibilities:
Database Assessment & Migration Strategy
- Analyze on-premises and Azure-based transactional database environments.
- Evaluate database landscapes and define migration strategies for Azure adoption.
- Assess database dependencies, compatibility requirements, and migration risks.
- Design migration architectures for large-scale database modernization initiatives.
Database Migration & Development
- Develop and enhance PL/SQL and T-SQL scripts for database migration activities.
- Perform heterogeneous database migrations across Oracle, SQL Server, PostgreSQL, MySQL, MariaDB, MongoDB, Cassandra, and Cosmos DB.
- Execute migration planning, validation, and cutover activities.
- Ensure data integrity and consistency throughout migration processes.
Architecture & Solution Design
- Create detailed migration designs and technical architecture documentation.
- Design Azure-based database solutions aligned with enterprise architecture principles.
- Recommend best practices for database deployment, scalability, availability, and performance.
- Define migration frameworks and reusable methodologies for multiple environments.
Testing & Validation
- Develop comprehensive test plans and test cases to validate migration success.
- Conduct database readiness assessments post-migration.
- Validate application compatibility, data accuracy, and performance benchmarks.
- Support User Acceptance Testing (UAT) and production readiness reviews.
Performance Optimization & Troubleshooting
- Analyze and optimize database performance across various platforms.
- Identify migration bottlenecks and implement corrective measures.
- Investigate and resolve complex database and middleware issues.
- Develop workarounds for migration-specific challenges and edge-case scenarios.
Database Administration & Operations
- Manage backup, recovery, replication, monitoring, and maintenance activities.
- Design and implement High Availability (HA) and Disaster Recovery (DR) solutions.
- Establish database monitoring and operational support frameworks.
- Ensure compliance with security, governance, and operational standards.
Cloud & Platform Enablement
- Support Azure Infrastructure (IaaS) and Azure Kubernetes Service (AKS) environments.
- Collaborate with application, infrastructure, and cloud teams during migration initiatives.
- Drive cloud adoption strategies and modernization programs.
- Provide technical leadership and guidance throughout migration projects.
