We are focused on the health and safety of our workforce, clients, and greater community. Our team is working hard (remotely) to support your staffing and job search needs. Please call us at 1-503-299-6811 and use the name directory, or email opportunities@vanderhouwen.com (monitored Mon-Fri 8 am-5 pm).
VanderHouwen is an Equal Opportunity Employer and stands with our fellow citizens and countrymen in the battle against all forms of racism and social injustice.
Read more about our commitment to diversity here.

Be well and stay safe!

Description

Job ID: 47382

Database Administrator 
This Database Administrator position will support the Software Infrastructure and Support Services organization (TTST). This position will work with a team that is responsible for overall development, enhancement, operations, and maintenance of enterprise databases.  This position will provide database administration support and assistance for all systems operating on the Control Center Network (CCN) and the CCN DMZ, (referred to as the CCN environment) and will act as part of a team that supports CCN Database Management System (DBMS) and Business Intelligence systems utilizing SQL Server Suit tools, and Application Integration.  The DBA function will also perform patch discovery and application per North American Electric Reliability Corporation critical infrastructure protection (NERC CIP)-007 regulations.

Up to 5% travel to attend meetings/training, a valid U.S. Driver’s License is required. Up to 5% overtime is anticipated.

Database Administrator Responsibilities 
With oversight and approval by the Manager:
Mine data from various database instances to support Transmission Operations and provide the results in the form of custom reports to various customers within Transmission Operations.
Some of the required reporting will include routine processes that are able to be reused by various customers and other situations that are a one-off and require a quick report to be created to address a specific need (i.e. response to on-site auditors).

Provide assistance with and/or perform administration and support of:
Enterprise level SQL Server 2008 and later; 
Windows Server 2008 and later. 

Recommend and produce automation of various routine manual processes using PowerShell, WMI, SMO and .Net.
Conduct remote server monitoring.

Reporting:
Collaborate and participate in requirements gathering.
Recommend, create and customize a wide variety of reports.

Assist with the development and documentation of processes and procedures.
Assist with validating compliance with all applicable regulations, which includes Federal Information Security Management Act (FISMA) and NERC CIP related activities associated with database security and management. 

With oversight and approval by the Manager:
Perform and/or assist with database administration tasks within Microsoft SQL environments, including:
Database Management Systems (DBMS) installation, 
DBMS patching, 
Backup and recovery, 
Monitoring,
Performance Tuning,
Security,
Replication,
Perform command line database management using: 
Microsoft SQL – ISQL, OSQL, SQLCMD, BCP, etc. 

Perform Windows Server administration:
Software installation, 
Network configuration (DNS, WINS, Routing, etc.), 
Backup and recovery, 
Monitor server for problems and availability Stay current on available server patches and apply them as needed, 
Active Directory, 
Clustering, 
Automation of administrative tasks, such as backups and monitoring, using PowerShell.

Analyze Windows Server and/or DBMS and CCN environments for processing and performance tuning. Recommend needed system modifications; develop and provide implementation plans for management approved modifications. 
Provide developer and end-user support for databases including maintaining existing views and procedures, performance tuning, and troubleshooting database problems as requested or needed.
Provide Windows Server support for users including maintaining privileges, installing applications, performance tuning, and troubleshooting problems as requested or needed. 
Develop and recommend more effective consolidation strategies; assist with implementation of management approved recommendations.
Participate in project and/or technical meetings, as requested, to provide technical recommendations from a DBA perspective on the risks, impacts and strategies related to process and project decisions. Keep manager or team lead informed of project or technical decisions with a potential impact on CCN environments or processes.
Communicate with a wide variety of technical and business experts in both individual and group settings using email, self-generated documentation and presentations.

Database Administrator Qualifications
Bachelor’s Degree in Information Technology or a directly-related technical field is preferred.
5 years previous directly-related experience in Computer/Information Technology is required.
4 years’ experience with SQL Server of My SQL:
DBMS installation and patching,
Backup and recovery,
Monitoring,
Patching,
Performance Tuning, 
Security, 
Mirroring,
Reporting – SQL Server:
Reporting Services,
Report Builder,
Business Intelligence Design Studio,
Integration Services.

SQL Server and Database Administration:
Certified Microsoft SQL Server 2008 or later,
Microsoft SQL – sqlcmd, bcp, etc.),
OLTP and OLAP data modeling, 
Assist in designing and implementing changes to a complex database environment as requested,
Database consolidation strategies.

SQL Server remote management.

Preferred Skills & Experience 
CCN Database Management Systems include Microsoft SQL 2008 R2 / 2012 / 2014.
General programming skills (scripting / PowerShell / .NET / SMO).
Electrical utility experience.
Experience with Graphical User Interface (GUI) database management tools, to include:
Microsoft SQL – SQL Server Management Studio and SQL Profiler, 
SQL Server Failover Clustering,
SQL Development, Database Administration).

Experience with Windows:
Windows Server administration or Software installation, 
Active Directory, 
Windows 2008 or later certification,
Uses remote management tools. Such as NetOp and Microsoft Remote Desktop,
Microsoft Office Suite including Word, Outlook , Excel, Visio. 

Utilize Microsoft Office tools to document processes and procedures.

Benefits
Benefits are available to eligible VanderHouwen contractors and include coverage for medical, dental, vision, life insurance, short and long term disability, and matching 401k.

About VanderHouwen 
VanderHouwen is an award-winning, Women-Owned, WBENC certified professional staffing firm. Founded in 1987, VanderHouwen has been successfully placing experienced professionals throughout the Pacific Northwest and nationwide.  Our recruitment teams are highly specialized in either Technology and IT, Engineering, or Accounting and Finance career markets. Our recruiters value building meaningful, professional relationships with each candidate as well as developing honed knowledge of companies' staffing needs and workplaces. Partner with us to land your next exciting career.

VanderHouwen is an Equal Opportunity Employer and participates in E-Verify. VanderHouwen does not discriminate on the basis of race, color, religion, sex, national origin, age, disability, or any other characteristic protected by applicable local, state or federal civil rights laws.

SIMILAR JOBS

Apply Now

Thank you for your interest in applying for this position! Please fill out the fields below. Your profile will be reviewed with the rest of the applicants.







Upload Your Resume (Required)

Not Ready to Apply?