Job Summary We are seeking a highly experienced and motivated Senior SQL Server Database Administrator (DBA) to join our dynamic IT team. The ideal candidate possesses deep technical expertise in managing complex SQL Server environments, with a proven track record in database migration projects and advanced performance tuning. You will be responsible for the health, performance, security, and availability of our critical database systems. Experience supporting databases for Microsoft Dynamics AX 2012 environments is a significant advantage and highly desirable for this role.
This position will report to the SHI Leadership team and will be based in the Somerset, NJ office on a hybrid schedule .
About Us Since 1989, SHI International Corp. has helped organizations change the world through technology. We've grown every year since, and today we're proud to be a $14 billion global provider of IT solutions and services.
Over 17,000 organizations worldwide rely on SHI's concierge approach to help them solve what's next.
But the heartbeat of SHI is our employees - all 6,000 of them. If you join our team, you'll enjoy:
- Our commitment to diversity, as the largest minority- and woman-owned enterprise in the U.S.
- Continuous professional growth and leadership opportunities.
- Health, wellness, and financial benefits to offer peace of mind to you and your family.
- World-class facilities and the technology you need to thrive - in our offices or yours.
Responsibilities
Include but not limited to: - Database Migration: Plan, execute, and validate complex database migrations, including version upgrades, on-premises to cloud, and consolidation projects. Ensure minimal downtime and data integrity throughout the migration process.
- Capacity Planning: Monitor database growth trends and forecast future capacity requirements for storage, CPU, and memory.
- Collaboration: Provide transparency to the database configuration and workflow. Work closely with development teams, system administrators, business analysts, and application owners to support database requirements for various applications, namely exporting data on a schedule for business analysts.
- Automation: Develop and maintain scripts (T-SQL, PowerShell) to automate routine administrative tasks, monitoring, and deployments.
- Database Management: Install, configure, manage, monitor, and maintain SQL Server instances (specifically 2012 and newer and Azure SQL) across development, testing, and production environments.
- Performance Tuning & Optimization: Proactively monitor database performance, identify bottlenecks (CPU, Memory, I/O), and implement tuning solutions. Optimize complex T-SQL queries, indexing strategies, and server configurations for maximum efficiency and speed.
- High Availability & Disaster Recovery (HA/DR): Design, implement, and manage robust HA/DR solutions, including Always On Availability Groups, Failover Clustering, Log Shipping, Replication, and backup/recovery strategies. Regularly test disaster recovery plans.
- Security: Implement and enforce database security policies, manage user access and permissions, conduct regular security audits, and address vulnerabilities.
- Troubleshooting: Provide expert-level troubleshooting for database-related issues, perform root cause analysis, and swiftly implement corrective actions.
- Documentation: Maintain comprehensive documentation of database configurations, processes, and procedures
Qualifications
- Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent practical experience.
- 7+ years of hands-on experience as a SQL Server Database Administrator in enterprise environments.
- Expert-level proficiency in SQL Server administration (specifically 2012 and newer).
Required Skills
- Experience in successfully planning and executing complex SQL Server database migrations (e.g., large databases, cross-platform, version upgrades).
- Expertise in advanced SQL Server performance tuning, query optimization, and troubleshooting. In-depth understanding of execution plans, indexing, statistics, and wait stats analysis.
- Clearly communicates performance tradeoffs for coding and hardware.
- Strong experience implementing and managing SQL Server High Availability (HA) and Disaster Recovery (DR) technologies (Always On AGs, FCI, Log Shipping, Replication).
- Proficiency in T-SQL scripting and PowerShell for automation and administration.
- Excellent analytical and problem-solving skills.
- Strong communication and interpersonal skills, with the ability to explain complex technical concepts clearly.
- Ability to work independently and as part of a collaborative team in a fast-paced environment.
Preferred Skills: - Significant experience managing and supporting SQL Server databases specifically for Microsoft Dynamics AX 2012. Understanding AX database structures and performance considerations is highly desirable.
- Relevant Microsoft certifications (e.g., Azure Database Administrator Associate, older MCSE: Data Management and Analytics).
- Experience with database monitoring tools (e.g., SolarWinds DPA, Redgate SQL Monitor, SentryOne).
Additional Information
- The estimated annual pay range for this position is $70,000 - $125,000 which includes a base salary. The compensation for this position is dependent on job-related knowledge, skills, experience, and market location and, therefore, will vary from individual to individual. Benefits may include, but are not limited to, medical, vision, dental, 401K, and flexible spending.
- Equal Employment Opportunity - M/F/Disability/Protected Veteran Status