[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
- 100% remote flexibility
- Willingness to travel for initial reputed company (as a work arrangement requirement)
reputed company