Role Overview – Prophecy Technologies is seeking an experienced Senior Database Engineer to support Azure SQL migration and modernization initiatives. This offshore position based in India offers remote work flexibility and is ideal for database professionals with 6+ years of experience who specialize in Azure SQL migration, assessment, and optimization of SQL Server workloads on Azure cloud platform.

Azure SQL Migration and Assessment – You will assess SQL Server workloads for Azure PaaS compatibility, discover and document SQL Server instances, databases, jobs, and dependencies, analyze schemas and objects to identify migration blockers, develop remediation strategies, and lead migration planning activities that ensure successful transition of SQL Server workloads to Azure environments.

Database Performance and Optimization – You will leverage your strong expertise in SQL Server database internals and performance tuning, collect and analyze workload metrics including CPU, IO, memory, and execution plans, optimize T-SQL queries, identify performance bottlenecks, implement tuning strategies, and ensure optimal database performance on Azure SQL Database and Azure SQL Managed Instance platforms.

Migration Tools and Automation – You will utilize Azure migration tools including Data Migration Assistant (DMA) and Database Migration Service (DMS), develop PowerShell, T-SQL, and Azure CLI scripts for assessment, inventory, and validation, automate migration workflows, perform data migration operations, and ensure efficient and repeatable migration processes.

Capacity Planning and Architecture – You will perform sizing and capacity planning for Azure environments, determine appropriate DTU and vCore configurations, plan storage and networking requirements, recommend optimal Azure migration strategies and target architectures, design scalable solutions, and ensure proper resource allocation for migrated workloads.

High Availability and Disaster Recovery – You will implement and manage HA/DR solutions including AlwaysOn Availability Groups, log shipping, Geo-replication, and Auto-failover groups, design resilient database architectures, configure backup and recovery strategies, test failover scenarios, and ensure business continuity for critical database workloads on Azure.

Security and Compliance – You will implement Azure security features including Azure Active Directory authentication, Transparent Data Encryption (TDE), database auditing, and encryption at rest and in transit. You will ensure compliance with security policies, configure access controls, monitor security events, and maintain robust security posture for Azure SQL environments.

Documentation and Reporting – You will prepare comprehensive assessment reports, document migration readiness, conduct risk analysis, create migration runbooks, develop technical documentation, prepare capacity reports, document architecture decisions, and provide management with detailed insights on migration projects and database operations.

Collaboration and Support – You will work remotely with cross-functional teams including application developers, infrastructure teams, and project managers. You will provide technical guidance, support migration activities, coordinate with stakeholders, resolve technical challenges, and ensure successful delivery of Azure SQL migration initiatives.

Mandatory Technical Skills:

✓ Strong expertise in SQL Server (2012+), database internals, and performance tuning

✓ Experience assessing SQL Server workloads for Azure PaaS compatibility

✓ Hands-on experience with Azure SQL Database and Azure SQL Managed Instance

✓ Strong knowledge of Azure migration tools – DMA & DMS

✓ Experience collecting and analyzing workload metrics (CPU, IO, memory, execution plans)

✓ Strong skills in T-SQL and query optimization

✓ Hands-on scripting using PowerShell, T-SQL, and Azure CLI

✓ Experience with HA/DR solutions (AlwaysOn, log shipping, Geo-replication, Auto-failover groups)

✓ Knowledge of Azure security features – AAD, TDE, auditing, encryption

Requirements – 6+ years of experience in database engineering and SQL Server administration. Proven expertise in Azure SQL migration projects and cloud database management. Strong analytical and problem-solving abilities. Excellent communication skills for remote collaboration. Self-motivated with ability to work independently in offshore remote setup.

How to Apply:

Send your updated resume to rokesh.ramesh@prophecytechs.com with the subject line "Senior Database Engineer – Azure Application - [Your Name]". Mention your total years of experience, highlight your Azure SQL migration projects, describe your expertise with migration tools and performance optimization, list any relevant Microsoft certifications, and confirm your availability for offshore remote work from India.

About Prophecy Technologies:

Prophecy Technologies is a technology solutions provider specializing in cloud migration, database modernization, and digital transformation initiatives. We work with clients globally to deliver innovative Azure cloud solutions and support organizations in their cloud journey through expert technical resources and proven methodologies.