Summary
US company focusing on device product, with global teams to deliver world-class solutions to their client.
Responsibilities
- High Availability Architecture: Design, implement, and maintain multi-site Microsoft SQL Server Always On Availability Groups and disaster recovery (DR) solutions.
- Incident & Request Management: Own, track, and resolve database-related incidents and service requests within established SLAs.
- Database Maintenance & Automation: Plan and execute automated and attended maintenance operations during scheduled and emergency windows.
- Monitoring, Security & Compliance: Implement and optimize database monitoring, auditing, backup, and recovery strategies while maintaining strict security and compliance standards.
- Technical Leadership & Advisory: Serve as the company’s in-house SQL Server evangelist and expert advisor, providing best-practice guidance to engineering teams on application deployment and database design.
Requirements
- Education: B.A., B.S., or higher degree in Computer Science, Software Engineering, or a related technical discipline.
- Experience: 10+ years of professional experience in database administration, implementation, and support of Microsoft SQL Server within high-availability, highly transactional (OLTP), and OLAP environments.
- Core Expertise: Mastery of Microsoft SQL Server Always On and comprehensive high-availability (HA/DR) features.
- Version Expertise: Hands-on administration experience with modern SQL Server versions (including SQL Server 2022 and newer).
- Troubleshooting Mastery: Proven ability to diagnose and resolve complex database issues, including database integrity failures, migration blockers, deadlocks, performance bottlenecks, replication lags, log-shipping issues, and connectivity anomalies.
- Performance Tuning: Advanced query optimization skills using Performance Monitor, Extended Events, SQL Profiler, and industry-standard diagnostic tools.
- Resource Optimization: Strong capability to detect and troubleshoot SQL Server-related CPU, memory, I/O, storage, and resource contention.
- Deep Architectural Knowledge: Thorough understanding of backup/restore models, Dynamic Management Views (DMVs), clustering, database mirroring, auditing, replication, and encryption.
- Automation & Scripting: Expert experience in implementing operational automation and writing efficient T-SQL (stored procedures, functions, views, triggers, indexes, and constraints).
- Index & Statistics Mechanics: Deep knowledge of index structures, maintenance strategies, integrity checks, and how statistics impact query execution.
- Documentation & Communication: Excellent documentation skills for creating SOPs, architecture blueprints, and providing operational support to technical users.
- Operational Readiness: Availability for on-call rotation.
Post Time｜2026/10/12
Click here to add your own text
