SQL DBA - Remote / Telecommute

Job Description: • The Senior SQL Server Database Administrator will be responsible for the design, implementation, optimization, and ongoing management of SQL Server database solutions across on-premises, hybrid, and cloud environments. • This role requires advanced expertise in SQL Server administration, performance tuning, HA/DR architecture, automation, and security. • The successful candidate will collaborate closely with project teams, developers, and IT stakeholders to ensure highly available, secure, and scalable database environments that support business-critical applications. Key Responsibilities: • Design, plan, and implement SQL Server database solutions in on-premises and cloud environments. • Manage and maintain multiple SQL Server versions, including cross-server connectivity. • Configure, monitor, and troubleshoot SQL Server instances in physical, virtual, and Azure VM environments. • Install, configure, and support high availability and disaster recovery architectures (e.g., AlwaysOn Availability Groups). • Oversee SQL encryption processes and ensure data security compliance. • Plan and execute migrations from legacy SQL Server versions to modern systems and cloud platforms. • Perform database tuning and optimization using industry-standard tools and methodologies. • Resolve issues related to database integrity, performance, blocking, deadlocking, log shipping, connectivity, and security. • utomate database administration tasks through scripting. • Conduct backups, restores, and manage recovery models to ensure recoverability. • Propose and implement improvements for monitoring, administration, and security. • Document all database changes in alignment with Change Management protocols. • Monitor and analyze activity to proactively prevent incidents and recommend enhancements. • Participate in incident response and ensure timely resolution of database issues. • Test and evaluate new SQL Server and DBMS software releases for impact. • Maintain the integrity of all database objects including structures, statistics, and indexes. • Identify and remediate security violations promptly. • Utilize SQL Trace, System Monitor, Activity Monitor, and Database Engine Tuning Advisor for diagnostics and tuning. • pply Microsoft Service Pack patching procedures. • ssess emerging database technologies to improve administration and operational efficiency. Skill Requirements: • Minimum 10 years of experience in SQL Server database administration and design. • dvanced expertise in T-SQL performance tuning. • Strong proficiency in Windows scripting for automation. • Excellent problem-solving, analytical, and decision-making skills. • Strong organizational, time management, and interpersonal abilities. • bility to work independently and handle high-pressure, on-call situations. • Bachelor's degree in Computer Science, IT, or equivalent professional experience. Preferred Qualifications (Optional): • Experience managing multiple SQL Server versions in parallel and configuring cross-server connectivity. • Hands-on experience with SQL Server on Azure VMs and hybrid environments. • Knowledge of Microsoft Distributed Transaction Coordinator (MSDTC) configuration and troubleshooting. • Experience migrating SQL Server data from on-premises to Azure. • Effective communication skills for working with developers, testers, and configuration managers. Apply tot his job Apply tot his job