Lead Consultant, SQL Database Administrator

🔥 0 minutes ago

🇺🇸 United States – Remote

💵 $140k - $160k / year

⏰ Full Time

🟠 Senior

📀 Database Administrator

🦅 H1B Visa Sponsor

This company has sponsored H1B visas in the past.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Allstate

WebsiteLinkedInAll Job Openings

10,000+ employees

Founded 1931

💼 Consulting

📦 Logistics

🛡️ Insurance

💰 Post-IPO Equity on 2014-01

Consulting • Logistics • Insurance

Allstate is an industry leader in providing insurance solutions, focusing on home, auto, device, and identity protection. With a commitment to customer well-being, Allstate aims to instill peace of mind and financial security for its customers. The company also emphasizes community impact and sustainability through various initiatives, showcasing their dedication to social responsibility and positive change.

📋 Description

• Administer and support enterprise database platforms, including SQL Server, MongoDB, MySQL/MariaDB, and PostgreSQL. • Monitor, tune, and optimize database performance, availability, and reliability. • Manage database installations, upgrades, patching, lifecycle management, and capacity planning. • Support high-availability and disaster recovery solutions, including clustering, replication, backup, and recovery strategies. • Partner with development teams to review implementations, solve application performance issues, and improve database design. • Strengthen database security, access controls, monitoring, and operational processes. • Contribute to platform modernization and automation initiatives that improve scalability and operational efficiency. • Participate in an on-call rotation supporting critical production systems.

🎯 Requirements

• High School Diploma/GED • 8+ years of progressive experience in Microsoft SQL Server database administration • Strong expertise in SQL Server performance tuning, security, backup/recovery, and Always On Availability Groups (AOAG) • Experience supporting databases in virtualized environments. • Proven ability to troubleshoot complex database, application connectivity, and data integration issues. • Strong analytical, problem-solving, communication, and stakeholder partnership skills. • Familiarity with Nutanix or other enterprise virtualization platforms (Preferred) • Experience with PostgreSQL administration and support (Preferred) • Experience with SQL Server High Availability (HA) and Disaster Recovery (DR) architectures (Preferred) • PowerShell scripting and database automation experience (Preferred) • Experience with MongoDB replica sets, production upgrades, and monitoring tools (Preferred) • Experience with MySQL/MariaDB replication and enterprise platform support (Preferred).

🏖️ Benefits

• Eligible for annual bonus up to 20% of base salary • Comprehensive technology setup including laptop, monitors, headset, keyboard, and mouse • Monthly connectivity reimbursement to help offset internet costs • Flexible work arrangements • Equal employment opportunities and accommodations for qualified individuals with disabilities.