Database Administrator

Location open to all major service locations in Montana and South Dakota will be considered (Billings, Bozeman, Butte, Great Falls, Helena, Missoula) QUALIFICATIONS INCLUDE: Bachelor's Degree from four-year accredited college in associated discipline such as Computer Science, Business and Information Technology, or other relevant degree; an equivalent combination of education and related experience may also be considered Three years DBA experience Ability to work in a team environment and adapt to changing responsibilities and priorities Working knowledge of Microsoft SQL Server and/or Oracle databases for on-premise and cloud based deployments Demonstrated knowledge of database concepts, such as schema design, triggers, queries, transaction logs, stored procedures and performance tuning Experience with SQL Server Reporting and Integration Services development and support Ability to work with data architects and other IT specialists to setup, maintain and monitor data networks Knowledge of database structure languages such as SQL or SQL/PSM Experience with database installation, patches and upgrades Experience with database maintenance, database backup and recovery Familiarity with database management best practices Knowledge of IT security best practices Strong sense of responsibility and ownership; driving a project from inception to completion Affinity for solving problems and diving deep into the details Excellent attention to detail Strong written/oral communication and documentation skills Ability to do some travel, including day trips and overnight will be required, depending on work location and experience Ability to work extended hours as necessary Ability to participate in an on-call rotation schedule Ability to pass a drug test and a background check Experience managing high availability Oracle environments like Data Guard or Real Application Clusters a plus Experience with UNIX or Linux a plus Experience with CI/CD and Infrastructure as Code (IaC) a plus Understanding of a virtual architecture, including virtual delivery of applications and desktops is preferred DUTIES INCLUDE: Perform database migrations and deployments Manage deployment pipeline for schema deployments across landscapes Monitor, maintain and configure database servers for high-availability redundant and non-high-availability systems Configure servers and database to support applications Develop and implement databases processes for optimizing security and performance Ensure updates to all hardware and software as required Monitor the performance of hardware and software Preserve data integrity Effectively and efficiently organize, plan, execute and coordinate multiple work assignments to meet project milestones or established completion dates Maintain and ensure the integrity and confidentiality of sensitive information Adhere to company safety and security standards and the Code of Business Conduct & Ethics Ensure all actions are consistent with NorthWestern Energy's values, mission, and strategic business objectives Full-time position. $62,900 - $121,800 annually, depending on experience. Benefits include: 401K with company match up to 4% and non-elective contribution up to 7%; healthcare and wellbeing programs, including dental and vision; Health Savings Account (HSA); healthcare and dependent care flexible spending account (FSA); Employee Assistance Programs; Life Insurance; paid time off starting on your first day, plus 11 paid holidays. Closes June 20, 2024.