We are seeking an experienced Microsoft SQL Database Administrator (DBA) to manage daily operational workloads, ensuring database performance, security, and high availability. The ideal candidate will have deep expertise in SQL Server administration, backup and restore strategies, high availability (HA), disaster recovery (DR), and performance tuning to maintain a resilient and efficient database environment.
Key Responsibilities:
• Database Administration: Manage and maintain Microsoft SQL Server databases, ensuring optimal performance and reliability.
• Backup & Restore Management: Implement and monitor database backup and recovery strategies, ensuring business continuity and data protection.
• High Availability & Disaster Recovery (HA/DR): Configure and manage Always On Availability Groups, Failover Clustering, Log Shipping, and Replication for critical systems.
• Performance Monitoring & Tuning: Analyze and optimize query performance, indexing strategies, execution plans, and resource utilization.
• Security & Compliance: Implement and enforce database security policies, user access control (RBAC), encryption, and auditing to safeguard sensitive data.
• Automation & Scripting: Develop and maintain SQL scripts, PowerShell automation, and database jobs for operational efficiency.
• Monitoring & Incident Response: Use tools like SQL Server Profiler, Performance Monitor, and third-party monitoring tools to proactively identify and resolve performance issues.
• Upgrades & Patch Management: Plan and execute SQL Server upgrades, patching, and migrations while minimizing downtime.
• Collaboration & Documentation: Work with developers, DevOps, and infrastructure teams to ensure database best practices and maintain comprehensive documentation.
Requirements
• Technical Proficiency:
o Expertise in SQL Server versions (2016, 2019, 2022) and Azure SQL Database.
o Strong knowledge of HA/DR solutions such as Always On, Log Shipping, and Mirroring.
o Experience with backup and restore strategies, including point-in-time recovery.
o Proficiency in T-SQL, stored procedures, triggers, and indexing.
o Hands-on experience with PowerShell, SSIS, and automation scripting.
o Familiarity with cloud-based database solutions (Azure SQL, AWS RDS, GCP Cloud SQL).
o Strong understanding of database security principles, compliance (GDPR, SOC2, HIPAA), and encryption.
o Experience with database monitoring tools like Redgate, SolarWinds, and SQL Sentry.
o Education: Bachelor’s degree in Computer Science, Network Security, Information Technology, or equivalent experience.
o Experience: 8+ years in network security operations, with at least 3+ years managing GCP network and security workloads.
o Certifications: GCP Professional Cloud Network Engineer or Cloud Security Engineer is highly preferred.
Moonlight Adventures Travel Agency
airSlate
betstamp
Data Theorem, Inc.
Touch Support