SL - 美商 | SaaS Product | Cloud SQL Server DBA

【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.