About Collective Intelligence
With over 25 years of excellence in Central Pennsylvania, Collective Intelligence transforms businesses through innovative IT solutions and expert guidance. We specialize in data services—including advanced analytics and modern data estate management—while offering comprehensive IT expertise across enterprise architecture, infrastructure modernization, AI/ML, and DevSecOps. Our diverse team of IT professionals serves education, healthcare, insurance, manufacturing, government, finance, and retail sectors, delivering customized solutions that create lasting competitive advantage. Join our talented team and help shape the future of data-driven technology solutions that make a difference.
Job Description
As a SQL Server Database Administrator (DBA), you will be responsible for the installation, configuration, maintenance, and performance of critical SQL Server systems. You will ensure the availability and consistent performance of corporate applications. This is a “hands-on” position requiring solid technical skills, as well as excellent interpersonal and communication skills. Your role will involve monitoring system health, optimizing database performance, and ensuring data security and integrity.
Position Requirements
- Education: Bachelor’s degree in Computer Science, Information Technology, or a related field. Alternatively, an associate’s degree combined with 5 years of relevant experience.
- Experience: Minimum of 4 years of experience in SQL Server database administration.
- Technical Proficiency: Strong proficiency in SQL Server, including installation, configuration, and maintenance. Experience with performance tuning, backup and recovery, and high availability solutions.
- Analytical Skills: Ability to analyze and resolve complex database issues.
- Communication: Excellent verbal and written communication skills to effectively collaborate with stakeholders and executives, and provide user support.
- Problem-Solving: Strong problem-solving skills and attention to detail.
Required Skills
- SQL Server: Advanced knowledge of SQL Server, including versions 2016 and later.
- Performance Tuning: Expertise in performance tuning and optimization (PTO), using native monitoring and troubleshooting tools.
- Backup and Recovery: Proficiency in backup, restore, and recovery models.
- High Availability: Experience with SQL Server high availability (HA) and disaster recovery (DR) options, including Always On Availability Groups.
- Security: Understanding of SQL Server security, including roles, permissions, and encryption.
- T-SQL: Strong T-SQL skills for writing and optimizing queries.
- Automation: Experience with automation of database tasks using PowerShell or other scripting languages.
- Documentation: Proficiency in creating and maintaining comprehensive documentation for database configurations, processes, and procedures.
- Collaboration: Ability to work collaboratively in a team environment and manage multiple projects simultaneously.
Preferred Certificates
- Microsoft Certified: Azure Database Administrator Associate
- Microsoft Certified: Data Management and Analytics
- Microsoft Certified: SQL Server Database Administrator
- Certified Information Systems Security Professional (CISSP)
Equal Opportunity Statement
We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status. We are committed to creating an inclusive environment for all employees.