Database Administrator - Multiple Cities

Work Location: Major Service locations in Montana and South Dakota will be considered

About this position:

The Database Administrators work in a fast-paced team environment providing top tier database support relative to Northwestern Energy's technology systems. This position requires innovative thinking, database experience, analytical aptitude, and business acumen skills. The successful candidate will work hand-in-hand with other members of the Business Technology Team to ensure optimal solutions, availability, performance and support of database platforms and data integration solutions amongst disparate systems. This role will act as a hands-on subject matter expert within the team. Our work is very rewarding and is a highly valued function within the Northwestern Energy Enterprise.

We offer great benefits:

NorthWestern Energy is a fully regulated electric and natural gas utility serving Montana, South Dakota and Nebraska. We employ 1,500 amazing people and serve 709,000 customers who are our neighbors in our communities. We are a top employer and offer competitive benefits, including:

• 401K with company match up to 4% and non-elective contribution up to 7%
• Healthcare and wellbeing programs, including dental and vision for you, your spouse and dependents, Health Savings Account (HSA), healthcare and dependent care flexible spending account (FSA)
• Employee Assistance Program (Offering up to six free counseling sessions, per person, per issue, per year for employees, spouses and dependents)
• Life Insurance (Company pays basic employee policy; spouse, dependent insurance also available)
• Tuition reimbursement
• Competitive pay (Scheduled performance-based wage increases and annual incentive opportunities.)
• Paid company endorsed volunteer opportunities
• Paid training opportunities
• Paid time off starting on your first day, plus 10 paid holidays

Benefits may vary by position or as negotiated as part of a collective bargaining agreement.

About this job:

• 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
• Understanding of a virtual architecture, including virtual delivery of applications and desktops is preferred
• Maintains and ensures the integrity and confidentiality of sensitive information
• Some travel, including day trips and overnight will be required, depending on work location and experience
• Ability to work extended hours as necessary
• Participation in an on-call rotation schedule required
• All NorthWestern Energy employees are required to 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

Am I right for this job? Here's the success profile:

• 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
• Must be able 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
• 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