Senior Systems Engineer
Posted on Nov 15, 2018 by Precision System Design, Inc.
*8+ years of experience administering large databases in a high transaction, 24x7 Microsoft SQL Server database environment.
*Advanced skills in resolving database locking conflicts/blocking and resource utilization contention
*Ability to work with database developers and engineers to analyze database performance and identify problems in areas such as: execution plans, index coverage, and SQL server statistics. Demonstrate ability to solve complex database administration problems.
*Advanced experience in database monitoring, troubleshooting, performance tuning, and high availability strategies for SQL Server 2012, SQL Server 2014, SQL Server 2016 and SQL Server in Azure IaaS
*Experience with Performance Tuning and Optimization, using native and third-party monitoring and troubleshooting tools. Working knowledge of Systems Center Operations Manager (SCOM) and IDERA diagnostic Manager is desired.
*Advanced knowledge of SQL Server backup and recovery strategies.
Experience defining hardware requirements and storage capacity planning for development, testing, QA and production for capacity planning and performance.
*Advanced knowledge of SQL Server High Availability (HA) and Disaster Recovery (DR) options for SQL Server.
*Advanced knowledge of SQL Server AlwaysOn availability groups and Failover Cluster Instances.
*Advanced knowledge and experience administrate ring Windows Server, including Active Directory and failover clustering
*Strong skills and working knowledge in database partitioning, security and encryption.
*Production support experience should include support of SSIS, SSRS, replication, database mirroring and SQL Reporting Services. In depth experience with DacPac, BacPac and IsPac concept and deployment and automation of database objects is required.
*Advanced PowerShell Scripting experience. Knowledge of PowerShell for SQL is a plus
*Ability to write automated scripts and strong knowledge of system tables and DMVs is required.
*Require project planning skills and excellent verbal and written communication skills.
*Must be a good team player with a strong team concept and must be self-motivated.
*Ability to organize, plan, work and lead projects independently
*Must be able to work in a team oriented environment and have the ability to communicate effectively within
teams. Share new ideas with the team and be able to think on your feet and recommend solutions.
*Ability to work in a fast-paced environment and rapidly develop proficiency in new skills
*Ability to multi-task switch effectively between different activities and teams
*Capable of handling assignment with aggressive timelines
*Must have strong work ethics and a professional demeanor.
*MCDBA or MCSE: Data Platform Required with MCSA SQL Server 2012/2016
*Pro-actively monitor production databases and optimize systems for better performance. A thorough understanding of database performance monitoring and analysis tools is required.
*Experience working with Microsoft Azure IAAS and PAAS solutions. Working experience with SQL Server on IAAS and Azure SQL DB a plus
*Experience working with data analytics teams and Business Intelligence tools especially PowerBi
*Experience with SQL Server Reporting Services, SQL Server Integration Services and/or SQL Server Analysis Services.
*Advanced working knowledge of Firewall and network security concepts
*Advanced working knowledge of Windows Server management such as disk administration, general performance health counters and overall server configuration
*Good working knowledge of Networking concepts such as subnetting, telnetting, IPV4 routing protocols and overall network connectivity.
*Understanding of current hardware systems, RAID and disk subsystems commonly used in fault tolerant production environments.
*Understanding and experience with SAN hardware and administration.
*Understanding of Virtual Server environments.
*MCTS, MCITP, and/or MVP certifications a plus
*Previous experience working as part of an Agile/Scrum organization Overtime: straight time
Semcon Group LLC
University of Mississippi Medical Center
Wellington Management Company, LLP