Spectraforce Technologies - Columbia, SC

posted 2 months ago

Full-time - Mid Level
Remote - Columbia, SC
Administrative and Support Services

About the position

As a SQL Server Database Administrator/Engineer at SPECTRAFORCE, you will play a critical role in managing and optimizing our database systems to ensure high performance, security, and availability. Your expertise in database management and optimization will be essential as you design and implement database solutions that meet the needs of our diverse client base. You will be responsible for performance tuning, utilizing tools like SQL Server Management Studio (SSMS), and ensuring that our databases are running efficiently and effectively. In addition to database management, you will oversee backup and recovery processes, ensuring that automated backups are set up correctly and that data can be restored quickly in the event of a failure. Your strong understanding of database security will be crucial as you manage user permissions, encryption, and auditing processes to safeguard sensitive data. You will also be tasked with configuring and managing high availability solutions, such as Always On Availability Groups and clustering, to ensure continuous database availability for our clients. The role requires a proactive approach to problem-solving and the ability to adapt to changing requirements in a fast-paced environment. You will work closely with a small IT team that values thorough planning and precise execution, ensuring that all projects are completed on time and within scope. Your communication skills will be vital as you convey technical information to both technical and non-technical stakeholders, fostering collaboration and teamwork within the organization. SPECTRAFORCE is committed to providing a supportive work environment that encourages professional growth and development. As part of our team, you will have the opportunity to work on diverse projects across various industries, contributing to our mission of delivering exceptional service to our clients.

Responsibilities

  • Manage and optimize SQL Server databases to ensure high performance and reliability.
  • Set up automated backups and perform data recovery to protect against data loss.
  • Implement and manage database security measures, including user permissions and encryption.
  • Configure and maintain high availability solutions like Always On Availability Groups and clustering.
  • Collaborate with IT team members to ensure project timelines and processes are adhered to.
  • Communicate technical information effectively to both technical and non-technical stakeholders.

Requirements

  • Expertise in database design and performance tuning using SQL Server Management Studio (SSMS).
  • Proficiency in setting up automated backups and performing data restores.
  • Strong understanding of database security, including user permissions and encryption.
  • Experience with high availability and disaster recovery solutions.

Nice-to-haves

  • Proficient in managing Windows Server OS, including installation and configuration.
  • Strong understanding of networking concepts and VPN setup.
  • Knowledge of security best practices and regulatory compliance.
  • Expertise in automating tasks with Ansible/PowerShell scripting.

Benefits

  • ACA compliant health benefits
  • Dental insurance
  • Vision insurance
  • Accident insurance
  • Critical illness insurance
  • Voluntary life insurance
  • Hospital indemnity insurance
  • Commuter benefits
  • 401K plan with matching
  • Referral bonus program
  • Paid sick leave when required by law
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service