SQL Server Administrator (Full-Time)

As the SQL Service Administrator, you will play a key role in optimizing the organization's SQL Server environment. Your responsibilities will encompass database administration, performance tuning, and troubleshooting to ensure seamless operations and maintain data integrity. This is an opportunity to apply your technical expertise to enhance database performance and contribute to strategic data initiatives.

What You'll Do

Database Administration:

• Install, configure, and maintain SQL Server instances.
• Perform database backups and recovery operations.
• Manage user accounts and permissions.
• Monitor database performance and proactively address any issues.
• Implement and maintain database security measures.
  
  

Data Warehousing:

• Design, develop, and maintain data warehouses and data marts.
• Extract, transform, and load (ETL) data from various sources.
• Optimize data warehouse performance for efficient querying and reporting.
  
  

Integration Services:

• Develop and maintain SQL Server Integration Services (SSIS) packages for data extraction, transformation, and loading.
• Troubleshoot and resolve SSIS package errors.
  
  

Ad Hoc Reporting:

• Assist in the development of ad hoc reports and queries.
• Provide technical support to business users on reporting issues.
• Analyze data and provide insights to support business decisions.
  
  

Troubleshooting and Other Duties:

• Diagnose and resolve database performance issues.
• Troubleshoot and resolve SQL Server errors and exceptions.
• Investigate and resolve data integrity issues.
• Complete other duties as assigned.
  
  

What You'll Need

• Bachelor's degree in Computer Science, Management of Information Systems, or similar field. Experience may be substituted for formal education.
• One year of experience as an SQL Server Administrator.
• One year of experience working with data warehousing concepts and methodologies, SQL Server Integration Services (SSIS), and systems performance tuning and troubleshooting.
• Microsoft Certified SQL Server Database Administrator preferred.
• Ability to understand and communicate effectively and professionally in reading, writing, and speaking the English language.
• Ability to work on-site in our Johnston, Iowa location.
• Work visa sponsorship is not offered for this position.
  
  

Why ChildServe?

ChildServe has earned the title of Top Workplace every year since 2014. Here’s why employees love working here:

• Our work matters. We partner with families to help children with special healthcare needs live a great life.
• We’re not your average non-profit. We serve more than 5,800 children each year through over 30 specialty pediatric services in the Ames, Des Moines, Iowa City, and Cedar Rapids areas. Many of our programs are one-of-a-kind.
• Our team rocks. Our teams are filled with people who care about their coworkers, and who believe that collaboration is key to providing exceptional care to children.
• Our learning never stops. As a non-profit dedicated to innovation, we’re proud to help team members gain new certifications, continue their education, take their expertise to the next level, and find new opportunities to advance their career right here at ChildServe.
• We believe our differences make us great. We are on a continuous journey to create an environment where different perspectives are valued, and all feel safe and welcome.
• We’re moving forward together. Experts across multiple disciplines work together to help kids get the best care possible.
  
  

ChildServe is an Equal Opportunity Employer.