Job Board | ACS Group

Database Administrator
10/12/2021
Technology
Vancouver
Washington
JO-2110-10004

Overview:
ACS Professional Staffing is looking for an employee to work on-site with our client. The Database Administrator 2 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 responsible for supporting 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. This full-time position is located in Vancouver, WA.

Responsibilities:
  • 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
  • Aid 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.
  • 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.
  • 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
  • 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.
  • Communicate with a wide variety of technical and business experts in both individual and group settings using email, self-generated documentation, and presentations.

Requirements:
  • 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
  • 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.
  • Valid U.S. Driver’s License is required.
  • Work sponsorship not available at this time. No third-party candidates considered for this position.
Because we are a federal government contractor, we have special restrictions placed on us for hiring foreign nationals into certain key positions within the company. This particular position requires U.S. citizenship.

ACS Professional Staffing will provide equal employment opportunities to all applicants without regard to applicant’s race, color, religion, sex, gender, genetic information, national origin, age, veteran status, disability status, or any other status protected by federal or state law.  The company will provide reasonable accommodations to allow an applicant to participate in the hiring process if so requested.

If you have any questions about the job posting, please contact recruiting@acsprostaffing.com

If you have any questions about our Reasonable Accommodation Policy, please feel free to email hr@acsprostaffing.com
​​​​​​​

 

Would you like to apply to this job?

Apply for the Database Administrator position



© ACS Group. All Rights Reserved.


Previous MonthNext Month
SunMonTueWedThuFriSat