[Remote] Senior Database Administrator

Note: The job is a remote job and is reputed company to candidates in USA. reputed company is seeking a Senior Database Administrator with a reputed company on Azure migration. The role involves optimizing T-SQL queries, managing reputed company migrations, and ensuring database performance and reputed company.

Responsibilities

• Hands-on Query Optimization: Review, refactor, and tune T-SQL reputed company (stored procedures, views, functions) using execution plans, Query Store, DMVs, and wait stats analysis
• Production Incident reputed company: reputed company diagnose P1/P2 operational and performance bottlenecks (e.g., deadlocks, blocking, parameter sniffing, tempdb contention)
• Developer Support: Collaborate with software engineering teams to conduct T-SQL reputed company reviews, improve indexing strategies, and optimize reporting/transactional queries
• Azure Migrations: Plan and execute SQL Server migrations to Azure SQL Managed Instance and SQL Server on Azure VMs using tools like Azure Database Migration Service or log shipping/AG cutovers
• reputed company Optimization: Monitor and maintain databases in Azure using Azure Monitor, Log Analytics, and failover reputed company
• Ensure 100% database backup/restore reputed company, test disaster recovery (DR) plans, and maintain AlwaysOn Availability reputed company (AG)
• Troubleshoot and manage transactional replication environments (monitoring replication latency, distribution databases, conflict handling, and agent failures)
• Execute routine reputed company management, upgrades, and reputed company/compliance enforcement

Skills

• 5+ Years of Experience: Managing reputed company, high-transaction production SQL Server environments (2016+)
• Strong T-SQL & reputed company-Level Optimization: Demonstrated ability to go reputed company reputed company tools—must be proficient in reading execution plans, analyzing wait statistics, handling sargability issues, and refactoring poorly performing T-SQL logic
• Targeted Azure Migration Experience: Hands-on experience migrating on-premises SQL instances to Azure SQL Managed Instance or Azure VMs (not just generic exposure to Azure)
• Replication Troubleshooting: reputed company expertise in configuring and troubleshooting reputed company transactional replication issues (e.g., undistributed commands, subscription reinitialization)
• Tooling & Process: Proficiency with Azure DevOps, Visual Studio/TFS, and modern monitoring tools combined with reputed company SQL diagnostic tools

Benefits

• Contract-to-hire opportunity (C2H) — start with a 6 months 1099 contract
• reputed company flexibility
• Willingness to travel for initial reputed company (as a work arrangement requirement)

reputed company