SQL Server DBA

APN Consulting, Inc. is a progressive IT staffing and services company offering innovative business solutions to improve client business outcomes. We focus on high impact technology solutions in ServiceNow, Fullstack, Cloud & Data, and AI / ML. Due to our globally expanding service offerings we are seeking top-talent to join our teams and grow with us.

Role: SQL Server DBA
Location: Remote (Occasional travel to NYC)
Duration: 6-12 months Contract

Job Description:
The SQL Database Resource will be responsible for independently managing SQL Server databases, including new installations and migrations from existing systems. The role requires supporting ongoing database activities, troubleshooting and resolving issues as they arise, and performing routine maintenance and administrative tasks. The candidate will monitor database activity and resource usage to ensure optimal performance and reliability. Success in this position demands strong technical expertise, solid organizational skills, and the ability to deliver high-quality work within a customer-focused, schedule-driven environment, in line with company and client objectives.

Schedule & Work Location:
M-F 9-5 or as needed for escalations
Location: mostly remote; quarterly onsite visits to NYC office may be required

Role Responsibilities

• Independently manage SQL Server database environments, including new setups and migrations from existing databases.
• Assist in database support activities and perform ad-hoc SQL Server troubleshooting and remediation.
• Conduct standard database maintenance and administration tasks, such as monitoring database activity, resource usage, and optimizing performance.
• Plan for and forecast resources needed to support database growth and capacity.
• Perform capacity planning to create and maintain databases, collaborating with system administration teams as needed.
• Maintain disk and database capacity reports.
• Perform routine configuration, installation, and reconfiguration of databases and related products.
• Manage database configurations, including installing, upgrading software, and maintaining relevant documentation.
• Handle SQL Server patching and assist with Always On Availability Group failovers during Windows Server (OS) patching processes.
• Manage SSL certificate deployment and renewal.
• Proactively monitor database systems to ensure secure services and minimal downtime, employing MS SQL Server best practices.
• Establish and enforce policies and procedures for database security, integrity, compliance, and auditability.
• Develop and maintain procedures and documentation for databases.
• Contribute to setting and enforcing standards for the definition, security, and integrity of database objects.
• Ensure conformance to established database standards and practices.

Requirements & Experience

• 15+ years of experience as a SQL Server Database Administrator, with strong expertise in new setup and migrations.
• 7+ years working with On-Premise SQL Server database applications and the Azure platform, including SaaS SQL Database and SQL on VM.
• Proven ability to work independently and be a quick-starter, adapting to the pressures of large migration projects.
• Experience supporting large, complex database systems both on-premises and in Azure, including SQL Server versions 2014, 2016, 2019, and 2022.
• Expertise in index and statistics maintenance for very large database environments.
• Experience supporting databases over 10TB, including troubleshooting issues related to maintenance, backup/restores, and database corruption.
• In-depth knowledge of SQL Server setup, installation, administration, and management, as well as SSRS (Reporting Services) and SSIS (Integration Services).
• Working knowledge of backup and recovery strategies, data masking, encryption, and SQL certificate deployment.
• Skilled in SQL Server queries, PowerShell scripting, and automation with PowerShell and Excel.
• Prior experience in production support operations, delivering high availability services within team environments.
• Hands-on experience with SSIS, SSRS, clustering, Always-On Availability Groups (AOAG), and HA/DR troubleshooting.
• Comprehension of AOAG configurations, including read-only routing and monitoring of AOAG systems.
• Ability to perform business analysis and write effective documentation and specifications.
• Experience writing T-SQL stored procedures, triggers, and functions, as well as knowledge of database table partitioning.
• Demonstrated ability to work well under pressure and meet tight deadlines.
• Resourcefulness in finding information to address technical issues.

We are committed to fostering a diverse, inclusive, and equitable workplace where individuals from all backgrounds feel valued and empowered to contribute their unique perspectives. We strongly encourage applications from candidates of all genders, races, ethnicities, abilities, and experiences to join our team and help us build a culture of belonging.