Database Administrator 2

CorSource; Vancouver; On-site; CAD 80,000 - 110,000; Full time

Job summary

A technical staffing and recruiting firm is seeking a Database Administrator to support their Software Infrastructure and assist with SQL Server and MySQL database management. The ideal candidate will have experience in database administration, performance tuning, and working within compliance frameworks. This role is based in Vancouver and requires U.S. citizenship.

Qualifications

• 5 years of experience in Database Administration with a Bachelor's Degree.
• 4 years of experience with SQL Server or MySQL.
• Experience with database security management.

Responsibilities

• Create complex stored procedures from user requirements.
• Provide performance tuning for SQL stored procedures.
• Mine data from various databases for reporting.

Skills

SQL Server

MySQL

Performance Tuning

Data Analysis

Windows Server Administration

Automation

Education

Bachelor’s Degree in Information Technology

Tools

Microsoft SQL Server Management Studio

MySQL Workbench

PowerShell

Job description

We are CorSource Technology Group, a locally owned technical staffing and recruiting firm in Portland, Oregon.

We encourage you to submit your resume to the job posting link, or directly contact : [e-mail], 503-726-4545

19567

Database Administrator 2 (N-IT)

12 months

Vancouver

This position closes to submittals on October 15th

Position requires US citizenship and the ability to clear a government background screen.

Overview Description

This contract Database Administrator position will support the agency’s Software Infrastructure and Support Services organization (JDT).

This position will work with a team responsible for overall development, enhancement, operations and maintenance of enterprise databases.

This position will provide database administration support 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 Systems (DBMS), Business Intelligence systems utilizing SQL Server Suit tools, and Application Integration.

Organization

• The team is collaborative and transparent in how they work.
• They follow a compliance calendar that has a standard cadence but have to be agile for emergency work as well.
• This position will gain knowledge and insight of strict regulatory requirements related to Federal Critical Assets.
• The best in this position remain agile to change.

The position is predominantly sedentary.

Position Responsibilities

Note : All official drafts, documents and recommendations, as listed below, must be reviewed, finalized and approved / accepted by appropriate BPA manager or other federal personnel with the authority to do so.

• Create complex stored procedures from user requirements
• Provide performance tuning for SQL stored procedures
• Mine the data from various databases used to support BPA Transmission Operations and provide the results in the form of custom reports to various customers within Transmission Operations.
• Required reporting includes 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 Federal Information Security Management Act (FISMA) and North American Electric Reliability Corporation critical infrastructure protection (NERC CIP) related activities associated with database security and management, per established processes, including:
  • Administration and support of:
  • Enterprise level SQL Server 2019 and later
  • MySQL 5.x and later
  • Windows Server 2016 and later
  • Data Analysis and Design
  • Automation using PowerShell, WMI, SMO and .Net
  • Remote server monitoring
• Reporting:
  • Requirements gathering
  • Report creation and customization
  • Develop and document approved processes and procedures
  • Compliance with all applicable regulations (FISMA, NERC-CIP, NIST, BPA, etc.)
• Analyze the Windows Server and / or DBMS and CCN environment for processing and performance tuning. Recommend required system modifications, develop and provide implementation plans.
• Provide developer and end-user support for databases including maintaining existing views and procedures, performance tuning, and troubleshooting database problems as needed.
• Provide Windows Server support for users including maintaining privileges, installing applications, performance tuning, and troubleshooting problems as needed.
• Recommend effective consolidation strategies.
• 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.

Maintain Filing System and Records

Maintain filing system(s), files, emails and records in accordance with compliance requirements. File and disperse documents / letters only to appropriate personnel. Maintain all official records in accordance with the Information Governance &Lifecycle Management (IGLM) and Information Security (INFOSEC) standards and procedures. Validate official records are accurately maintained for auditing purposes.

Requirements

• Education & Corresponding Experience (required on matrix) Bachelor’s Degree in Information Technology or a directly-related technical field is preferred. Level 2 : 5 years of experience is required with an Applicable Bachelor’s Degree in applicable fields. 7 years of experience is required with an Applicable Associate’s Degree in applicable fields. 9 years of experience is required without a degree.
• Experience must include direct work experience in Computer / Information technology performing Database Administration.
• Required Technical Skills & Experience (required on matrix) 4 years of experience with SQL Server or My SQL : DBMS installation and patching Backup and recovery Monitoring Patching Performance Tuning Security Mirroring / Always On / Cluster Management Reporting – SQL Server Reporting Services Report Builder Business Intelligence Design Studio Integration Services
• Crystal Reports Preferred Skills & Experience (optional on matrix) SQL Server and Database Administration Certified Microsoft SQL Server 2008 or later and / or MySQL 5.x or equivalent DBA experience desired Microsoft SQL – sqlcmd, bcp, etc. MySQL – MySQL, MySQLAdmin, MySQLDump is considered a strong plus, 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
• Windows
• Windows Server administration or Software installation
• Active Directory
• Windows 2016 or later certification
• Uses remote management tools such as, NetOp and Microsoft Remote Desktop.
• Utilize Microsoft Office tools to document processes and procedures.
• Experience with Graphical User Interface (GUI) database management tools, to include:
  • Microsoft SQL – SQL Server Management Studio and SQL Profiler
  • SQL Server Failover Clustering
  • MySQL Workbench (including Database Design & Modeling, SQL Development, Database Administration)

All qualified applicants at CorSource Technology Group will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.