Database Administrator, SQL Server Job Listing at SIG SAUER in Portsmouth, NH (Job ID 07e53ee4-8990-49ba-a23f-938aa951bf62)

Description

Database Administrator, SQL Server

SIG SAUER, Inc. is a leading provider and manufacturer of firearms, electro-optics, ammunition, air guns, suppressors, remote controlled weapons stations, and training. For over 250 years SIG SAUER, Inc. has evolved, and thrived, by blending American ingenuity, German engineering, and Swiss precision. Today, SIG SAUER is synonymous with industry-leading quality and innovation which has made it the brand of choice amongst the U.S. Military, the global defense community, law enforcement, competitive shooters, hunters, and responsible citizens. Additionally, SIG SAUER is the premier provider of elite firearms instruction and tactical training at the SIG SAUER Academy. Headquartered in Newington, New Hampshire, SIG SAUER has over 3,200 employees across twelve locations in three states and is a certified Great Place to Work™. For more information about the company and product line visit: sigsauer.com.

Position Summary:

Serves as a Microsoft SQL Server Database Administrator in the Information Technology Department – Applications team.  Configures, monitors, troubleshoots, performance tunes, patches, and upgrades SQL Server and related software for effective business operations and administration. 

Reports to the Director, Applications. The Director assigns ongoing functional responsibilities and makes special assignment within a framework of established database objectives, programs and priorities and results desired.  The incumbent plans and carries out work independently within this framework, keeps the Director informed, and brings highly complex or highly sensitive matters to the immediate attention of the Director; however, the incumbent is expected to take a thorough and thoughtful approach to problem solving and present complexities/sensitivities with options for action. Work is expected to be complete, thorough, accurate, and adequate for the purposes of improving database structure and is subject to review in process and upon completion, in terms of quality, quantity, timeliness, customer service, teamwork, adherence to requirements, and other factors, including attainment of specified performance management goals and objectives.

FLSA: Exempt

Job Duties:

• Monitors multiple SQL Server instances to ensure system health and performance.
• Manages or assists in backup, restoration, archiving of data and other scheduled maintenance tasks.
• Assists developers in query tuning, schema development and deployment.
• Assists in real-time troubleshooting of database related issues for both commercial and in-house software.
• Works with groups such as Quality and Business Intelligence to ensure efficient data retrieval and analysis.
• Reviews, develops, recommends, enforces, and adheres to database policies and standards for SIG SAUER Inc.; these policies and standards include policies and procedures on high availability, replication, change data capture (CDC), access and security.
• Communicates and interacts effectively with internal and external business contacts including, but not limited to, other members of the unit/team, other SIG SAUER Inc. (such as managers, supervisors, and support staff), contractors, and vendors.
• Uses a computer and (a) modern office suite software for various applications such as, but not limited to, planning/scheduling, communicating (email), word processing, data manipulation (databases and spreadsheets), charts/graphics and presentations; (b) enterprise systems/software (such as ERP) to collect, store, manage and interpret data from business activities; and (c) specialty systems/software used in the Office for database administration.
• Performs other duties as assigned.

Education/Experience & Skills:

• A bachelor's degree in information technology, Computer Science or a field that provides a strong foundation for successful performance of the DUTIES in this job description, or an equivalent combination of education, experience and training that totals four years.
• 5 + years of Experience. Responsible experience in Microsoft SQL Server Database administration including experience working with: SQL Server Management Studio, SQL Configuration Manager, SQL Profiler, and other SQL tools and related applications.

Knowledge, Skills, Abilities and Other Factors (KSAOs)

• Comprehensive expert level knowledge of Microsoft SQL Server installation and configuration.
• Expert level knowledge of SQL clustering, high availability, and disaster recovery options.
• Expert level knowledge of stored procedures, views, schemas, permissions, and other objects.
• Expert level knowledge in query development, including understanding execution plans and query optimization.
• Experience with Windows Server and Active Directory.
• Knowledge and ability to configure and manage SQL Agent, database mail, linked servers, and other features.
• Software development experience a plus.
• Skill in problem solving to select, organize and logically process relevant information (verbal, numerical or abstract) to solve a problem.  This includes the ability to recognize subtle aspects of problems and identify relevant information.
• Skill in written communication to understand written information (facts, descriptions, ideas, concepts, conflicting assertions, and arguments), draw inferences, form hypotheses and develop logical arguments, and to express such information in writing so that others will understand, and concerning some issues, be convinced or persuaded. Examples include reviewing and editing established database policies and procedures and developing new SOPs for database software installation and configuration.
• Skill in oral communication to understand verbal information (including instructions, descriptions, and ideas) and to express such information verbally so that others will understand. This includes the ability to encourage oral communication by others. Examples include exchanging routine and non-routine operational and procedural information and technical information to co-workers and Office management.
• Skill in using a computer and (a) modern office suite software (such as MS Office) to plan, schedule, communicate, word process, process mapping, prepare and develop reports, and perform research (Internet use, as in searching for performance information and keeping up with technology); (b) enterprise systems/software (such as ERP) for collecting, storing, managing, and interpreting data from business activities; and (c) specialty systems/software used in the Office for database administration.
• Experience with Ansible automation platform is preferred but not required.

Working Conditions:

• Prolonged periods of sitting at a desk and working at a computer using a keyboard and mouse performing repetitive tasks.
• Ability to open file cabinets, reach with hands and arms, bend, and twist, lift and move files.
• Must wear required Personal Protective Equipment (PPE) where required.
• Must comply with all work exposure EH&S training requirements and adhere to SIG SAUER Inc. Security Mandates.

SIG SAUER, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.