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