Job Information
North Wind Solutions Microsoft SQL DBA II 03518 NWSOL in Richland, Washington
Location: Richland, Washington Title: Microsoft SQL DBA II Schedule (FT/PT): Regular Full Time Travel Required: No Clearance: Ability to obtain North Wind Solutions is a Government contracting small business with operations at military and civilian installations across the United States. The company's focus is facilities operation and maintenance, waste management and radiological services, security control and force protection, and environmental services. POSITION PURPOSE: Subject Matter Expert for Microsoft SQL database technology involving the application of routine SQL principles with Creation, Performance, Maintenance and overall operability between databases and applications The candidate will be responsible for management of compute resources, operations, support, and maintenance activities as assigned for databases as well as the underlying technology in this role The individual will be part of a team that operates on day to day activities in support of break fix, data calls, audits and general support tickets assigned to the SQL DBA team as well as long range planning along with the application owners for SQL database upgrades ESSENTIAL DUTIES AND RESPONSIBILITIES: Under the supervision of Managers, Leads, Mentors or Peers assists with and work towards becoming proficient in the following responsibilities Implements and maintains operational status and design of databases across multiple platforms and computing environments Provides database backup and recovery Maintains security and integrity controls, and monitors database availability Database creation, cloning and recovery Management of operational procedures Systems environment management and Database health Backup and recovery strategy planning and implementation Assists with individual system environment transition planning Maintain and create Windows and SQL PowerShell scripts for SSIS, SSRS and SSIS, SSRS and PowerBI Occasional Off Hours and Weekend support may be required MINIMUM QUALIFICATIONS: Education and Experience: BA or BS in Information Technology or related field, in lieu of a 4 year degree, Professional SQL Experience will be considered Subject matter expert in database management, technology, multiple operating systems, as well as knowledge of networking components and functions Four years minimum of Microsoft SQL Database Administration experience Skills and Abilities: Communication Skills Excellent attention to detail Must be able to communicate technical information, product plans, and system governance information to all levels of technical staff as well as management, and customers Presentation Skills Written and verbal communication with internal and external peers, customers, and customers management chain Reasoning Ability Ability to define problems, collect data, establish facts and draw valid conclusions Ability to interpret a variety of instructions and deal with abstract and concrete variables Technical Skills Troubleshooting and resolving database integrity, performance, blocking, dead blocking, connectivity and security issues Strong analytical ability when working with peers and IT management Ability to performance tune through query optimization using related monitoring tools Knowledge with current Technical Standards, SQL Concepts, Administrative Database tools, Backup and Recovery, Disaster Recovery Understanding of IT strategies, methodologies and SQL Architecture standards Special Requirements: Must be United States Citizen, Must be able to obtain and maintain Department of Energy Public Trust clearance. PREFERRED QUALIFICATIONS: Experience in larger Enterprise environments Cloud Based experience Technical certification for current MS