Senior Technical Advisor (Remote) - DP Professionals

DPP is seeking a Senior Technical Advisor for an opportunity with our client in Columbia, SC.
 
Work arrangement:

• Remote
• W2 position; 12 months

Summary:

• 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.

Top skills:

• 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.

Minimum required work experience:

• 12 Years IT experience including 7 years progressive responsibility within area of expertise.

Job/class description:

• Provide senior level technical expertise on decisions and priorities regarding the enterprise’s overall systems architecture, and instrumental in analysis and recommendation of infrastructure, architecture, application and performance enhancements. Provides complex and vital knowledge critical to the setting of vision and strategies within the IT organization.
• Serve as a technical expert resource within IT in planning, strategizing and developing resource requirements and direction for applications, architecture and/or infrastructure. Review and design system software and hardware builds analyzing system options, risks, cost vs. benefit, and impact on the enterprise business process and goals. Develop and document the framework for integration and implementation for changes to technical standards.
• Provide expert technical guidance to project team areas as appropriate. Evaluate vendor-supplied software packages and make recommendations to IT management. In coordination with Project Leads, provide input on all proposals that could potentially impact systems. May perform sizing on proposed new services and systems through simulations of system configurations and capacity modeling for multiple platforms to establish capacity requirements.
• Review customer requests, security patches, and audit requirements for additions or changes to systems, and evaluate feasibility to determine if/how to handle the request while maintaining an adequate/appropriate overall systems infrastructure. To determine if requested changes are possible, review system capabilities, workflow, and scheduling limitations. Ensure data integrity and space requirements are met across a variety of platforms. Provide data needed to ensure reliability and availability of platforms to meet business objectives.
• Facilitate the establishment and implementation of standards and guidelines that guide the design of technology solutions, including architecting and implementing solutions requiring integration of multiple platforms, operating systems, and applications across the enterprise.

Required knowledge, skills, and abilities:

• MS SQL Server
• 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.
• Strong analytical and logical thinking skills.
• Thorough understanding of operating systems and foundation architecture.
• Expert knowledge of the following as applicable: systems programming, graphical user interfaces, control languages, development, quality assurance, integration methodologies, and the use of currently utilized programming productivity tools.
• Expert knowledge in the analysis of system software, tools, technologies, and/or products and making recommendations for performance enhancements.
• Thorough understanding of the implications of multiple systems software products.
• Standard office equipment.

Desired KSAs:

• 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.

Work environment:

• 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.
• Fast paced, multi-platformed environment which may require action and response 24X7 to support the technical business needs of the customer.

Required education/equivalencies:

• Bachelor’s degree in Computer Science, Information Technology, or other job-related degree;
• OR, Associate’s degree in CS, IT, or other job-related degree plus 2 years of work-related experience;
• OR, 4 years job-related work experience (total 16 years without a degree)

Interested? Learn more:
Click the apply button or contact our recruiter Daniel at Daniel.Free@dppit.com to learn more about this position (#24-00602).
 
DPP offers a range of compensation and benefits packages to our employees and their eligible dependents. Call today to learn more about working with DPP.
 
Authorized US Worker - US Citizens and those authorized to work in the US are encouraged to apply. We are unable to sponsor at this time. EOE/AA/V/D