Post Date: 01/09/2020
Close Date: 01/26/2020
Database Administrator 2 or 3
BI/DBA; Portland, Oregon (US-OR)
Posting # 142
Responsible for daily maintenance, MSSQL and Oracle tuning, configuration, and performance on the SQL platform.
Day to Day:
Provides primary SQL DBA support including index tuning, schema changes, security and data replication.
Performs database administrative tasks such as maintaining database jobs (i.e. database backups, database indexing), setting up database security (i.e. users and roles), and monitors disk space for database growth. (i.e. using tools such as DB Artisan, TOAD, SQL Enterprise Manager, Oracle Enterprise Manager, Oracle RMAN).
Optimizes queries, reports and application code response time (i.e. using tools such as SQL Profiler).
Develops documents and maintains procedures for database servers such as backups, restores, performance tuning, and configurations and performs daily and monthly backups of production systems and other backups as required.
Supports 3rd party tools for replication, encryption, backups, change management and interfaces.
Performs database object promotions.
Provides SOX and audit reporting information as required to management, internal and external auditors
Works with IT team leads to ensure consistency in architecture, schema and change control for SQL and Oracle database environments.
Effectively communicates design considerations and recommendations to team members and business.
Responds to developer requests for changes.
Participates in on call rotation.
Supports Company’s commitment to a culture of safe work practices.
Come on your first day with:
Bachelor’s degree in Computer Science or an equivalent combination of education and experience.
Minimum 1 year MSSQLDBA experience for Level 2 position. Additional years of experience required for Level 3.
Knowledge of TSQL coding for database support.
Knowledge of data integration concepts, approaches, ETL tools and the role of data architecture in successful implementation of data integration strategies.
Knowledge of physical database design and tuning using major RDBM’s such as SQL Server, Oracle etc.
Knowledge of with system architecture changes, database schema changes, database performance optimizations. Experience designing and implementing required for Level 3.
Experience developing Spatial data queries a plus.
Working knowledge of data modeling tools and reporting tools.
Demonstrated ability to work effectively with staff at all levels and across departments and customer units.
Proven ability to function in a highly cohesive team environment to complete department goals.
Experience working with vendor packages (i.e. replication, encryption, change management).
Knowledge of and experience with logical and physical data modeling and database design, database security and integrity and indexing strategy and management.
Demonstrated willingness to acquire new skills and learn new tools.
Excellent oral and written communication skills including the ability to work effectively with employees at all levels and across departments.
Skilled at defining issues, analyzing and evaluating information, presenting recommendations and identifying alternative solutions.
Highly self-motivated and directed combined with extensive experience working in a collaborative, team-oriented environment.
Oracle and Postgres SQL experience required
Cloud experience (i.e. Azure) a plus
What we offer:
Arguably the most competitive healthcare and wellness benefits in the Pacific Northwest
Meaningful Annual Incentive Bonus Opportunity in addition to base salary
401(k) with generous match and additional 5% employer contribution
Company provided Trimet or C-Tran passes/Bike storage for cyclists
Green Team / Diversity, Equity & Inclusion Council / Safety Team / Women’s Network
Numerous volunteer and community engagement opportunities
Employee Stock Purchase Plan with a 15% discount
20% Employee discount on Natural Gas
7 Paid Holidays and up to 3 floating holidays to add an extra paid day off to Holidays Observed by NW Natural
Flexible work schedule opportunities
Base salary range:
Level 2 - $83,250.00 - $115,250.00 per year
Level 3 - $95,900.00 to $132,700.00 per year
Depending on qualifications
Application Process: To be considered for this position, submit a complete electronic application including cover letter and resume via our website.
Deadline: January 26, 2019
All applications must be submitted through NW Natural’s Electronic Application System. Resumes submitted via email, fax or mail will not be accepted in lieu of an electronic application.
We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, sexual orientation, gender identity, veteran status, disability or any federal, state or locally protected class.
We are a drug free workplace and we comply with Federal Drug Free Workplace Act and Department of Transportation regulations. Pre-employment drug tests are part of the hiring process and apply to all positions.
NW Natural does not accept unsolicited submissions or assistance from search firms for posted positions. Resumes submitted by search firms working under a valid and current written contract with NW Natural valid written Statement of Work in place for this position from NW Natural HR/Employment will be deemed the sole property of NW Natural. No fee will be paid in the event the candidate is hired by NW Natural as a result of the referral or through other means.