Title: Windows-SQL Server Manager
Duration: 12+ Months
Location: Columbia, SC (100 % remote)
Team Name: IaaS Operations
Top 2-4 REQUIRED technologies
- Database Management and Optimization: Expertise in database design, performance tuning, and using tools like SQL Server Management Studio (SSMS).
- Backup and Recovery: Proficiency in setting up automated backups, performing restores, and ensuring data protection using SQL Server’s native features and third-party tools.
- Security Management: Strong understanding of database security, including user permissions, encryption, and auditing to safeguard data.
- High Availability and Disaster Recovery (HADR): Skills in configuring and managing high availability solutions like Always On Availability Groups and clustering to ensure continuous database availability.
- Government contracting experience
Top 2-4 PREFERRED/NICE TO HAVE technologies
- Windows Server Management: Proficient in managing Windows Server OS, including installation, configuration, Active Directory, and system monitoring.
- Networking and Infrastructure: Strong understanding of networking concepts, including configuring network interfaces, IP management, and VPN setup.
- Security and Compliance: Knowledge of security best practices, user access management, firewall configuration, and regulatory compliance.
- Automation and Scripting: Expertise in automating tasks with Ansible/PowerShell scripting to improve efficiency and reduce errors.
Day to Day work:
A typical day starts by checking system and database health, reviewing logs, backups, and performance metrics to ensure everything is functioning smoothly. They then handle user and security management tasks, such as adjusting permissions and troubleshooting access issues reported via servicenow. Routine maintenance follows, involving patching, updates, and database optimization to maintain system efficiency. Throughout the day, they also work on projects like server migrations, setting up new SQL instances, or automating tasks using Ansible/PowerShell. Troubleshooting and resolving any issues that arise, such as server downtime or performance bottlenecks, is a key part of their role. The day ends with a review of activities, updating documentation, and planning for upcoming tasks in JIRA.
Soft skills:
- Communication Skills: Effectively convey technical information to both technical and non-technical stakeholders.
- Adaptability and Flexibility: Quickly adjust to changing requirements and priorities in a dynamic environment.
- Problem-Solving and Critical Thinking: Efficiently identify and resolve issues under tight deadlines and high pressure.
- Time Management: Prioritize tasks and manage time effectively to meet multiple competing deadlines.
- Resilience and Stress Management: Maintain composure and productivity under stress to prevent burnout.
- Attention to Detail: Ensure accuracy and thoroughness, especially in compliance and documentation.
- Teamwork and Collaboration: Work effectively within diverse teams and contribute to collective problem-solving.
Team info:
- A small IT team with a tight deadline that works efficiently within a rigid structure, ensuring each project is completed on time. The success of the team relies heavily on thorough upfront planning, precise execution, and strict adherence to the project timelines and processes.