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 SQL Database SQL Server 2016 and SQL Server 2019 technology
PHYSICAL DEMANDS:
None
WORKING ENVIRONMENT:
Tele-Working environment, must have dedicated space in your home
North Wind offers a competitive pay and benefits package to include health, life, and disability insurance benefits, 401(k) with company match, generous paid leave and tuition reimbursement for eligible employees. As a company, we are committed to employee wellness, professional development, and work-life balance. We value safety, reliability, and commitment to our people! For more information about our benefits or hiring philosophy, visit the North Wind Career Opportunities Page.
Reasonable accommodations may be made to enable qualified individuals with disabilities to perform the essential functions. The nature of those accommodations will be determined on a case-by-case basis. If you are an individual with a disability and require a reasonable accommodation to complete any part of the application process, or are limited in the ability or unable to access or use this online application process and need an alternative method for applying, you may contact our Helpline +1.208.528.8718 or use the Request for Reasonable Accommodation form to get assistance.
North Wind is an Equal Employment Opportunity (EEO) employer and welcomes all qualified applicants. Applicants will receive fair and impartial consideration without regard to race, sex, color, religion, national origin, age, disability, veteran status, genetic data, religion, or other legally protected status. All qualified applicants will receive consideration for employment without regard to their protected veteran status and will not be discriminated against on the basis of disability.
Proof of citizenship will be required as a condition of employment.