[Data Manager] Data Administrator - SQL
[ Back ] [ The Roadtechs Nuclear Job Board ] [ Help ] [Edit ] [Mark Position Closed ]
Database Administrator - SQL
The objective of this scope is to engage a qualified individual to provide SharePoint services and support for the Information Technology (IT) enterprise system requirements of the MSA Information Management (IM), Network and Computing Services (N&CS) organization. Work will be managed by MSA Information Systems.
DESCRIPTION OF WORK SPECIFIC
Specific duties and responsibilities include, but are not limited to:
Support the Hanford Site MS SQL database environment and supporting infrastructure, servers, storage, and databases to ensure enterprise level performance, availability and security. This includes working with IT professionals on various infrastructure components, systems and servers supporting hundreds of Hanford applications and systems.
Provide troubleshooting support, working with the user support team and the operations staff to effectively manage and communicate issues and perform problem analysis to resolution.
Providing recommendations on innovative and/or cost-effective options for delivering and improving enterprise-level MS SQL database services.
Manage the day-to-day technical operations and product management, monitoring database performance, configuration, maintenance and repairs.
Provide Tier-3 troubleshooting support; working with the user support team, operations staff, outside vendors, other Site support personnel and/or organizations to effectively manage and communicate issues and perform problem analysis to resolution.
Installing, configuring, and maintaining MS SQL infrastructure servers, integration with other systems, capacity planning, system-wide operation control, and task automation.
Performing typical MS SQL database administrator functions.
Develop new system implementation plans, custom scripts and testing procedures to ensure operational reliability, high availability and system security.
Work with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures.
Create models for new database development and changes to existing ones.
Respond to and resolve database access and performance issues.
Monitor, optimize, and allocate physical and virtual storage for database systems.
Assess and develop long-term strategic goals for databases.
Design and implement systems, policies, and procedures for disaster recovery and data archiving to ensure effective production and integrity of the MS SQL data assets.
Conduct research and make recommendations on database products, services, protocols, and standards.
Monitoring database performance, performance tuning and query optimization.
Control database access for users and applications and apply security best practices.
Perform database transaction and security audits.
Provide technical support to maintain, operate, upgrade and patch MS SQL databases to ensure maximum performance and availability for the applications and systems.
Installation and management of the host environment and client tools.
Develop procedures and documentation for backup and restoration as well as DR/COOP capabilities.
Advise management of developments in the industry or on the Hanford Site that could affect the MS SQL environment, projects and client relations.
Develop and maintain a positive and effective relationship with peers, staff, and customer base. This includes communicating effectively, oral and written. Exercise sound judgment and discretion as well as working well under pressure on short turnaround assignments.
Communicate and present technical information, products or services clearly and effectively to varying audiences.
Assist in administering and ensuring technical security compliance with the site security plan and cyber security initiatives applicable to the computing services environment maintaining confidential and specialized information, organizational policies, procedures and operations.
Ability to effectively prioritize and execute tasks in a high-pressure environment.
AA/AS degree in Computer Science or related field with 10+ years of relevant experience or combination of education and experience.
Minimum 6 years of experience in MS SQL Database Administration.
Minimum three years of experience with recent MS SQL versions (12, 14, 16, 17, 19).
Minimum two years of experience as an MS SQL database administrator in a government environment.
Minimum two years of experience in managing MS SQL servers in a virtualized environment.
Minimum two years of recent experience performing MS SQL database upgrades.
Experience with Windows and SQL Availability groups, replication and mirroring technologies.
Minimum two years of recent experience simultaneously managing 3,000 or more MS SQL databases.
Prior experience implementing Oracle client software on SQL servers to create linked servers.
Minimum two years experience installing, configuring and supporting SSRS (SQL Server Reporting Services) and SSIS (SQL Server Integration Services).
Experience with Enterprise Service Platform work ticketing system.
Ability to provide support during non-standard business hours and be on call 24 hours a day, 7 days a week as needed or as scheduled.
Prior experience supporting MS SQL in the Hanford Site network environment.
Knowledge and understanding of the DOE Software Quality Assurance requirements and processes
Familiarity with the HLAN enterprise server environment, specifically SQL Server environment.
Experience using PowerShell to create scripts and manage a large SQL environment.
Experience with VMWare server management tools.
Experience with SQL Safe backup tools.
Experience with AltaVault backup tools.
Experience in supporting SharePoint.
Experience in Oracle database administration.
Microsoft or SQL Certifications.
Prior experience in performing enterprise application implementation and support activities on the Hanford Local Area Network.
Work Location / Potential Access Requirements
The primary work location is 2261 Stevens, Richland Washington. This is subject to change. Work, including meetings, may also be conducted on the Hanford site at various locations.
Site Access and Work Hours
Hanford personnel at the Hanford Site work a standard 4/10 schedule. The standard work week consists of ten (10) hours of work between 6:00 a.m. and 4:30 p.m. with one-half hour designated as an unpaid period for lunch, Monday through Thursday.
Work performed outside normal operating hours shall be coordinated and/or approved through the BTR and/or the Contract Specialist prior to performing the work.
Work performed outside the normal operating hours shall be performed at the same hourly rate as standard hours worked.
For persons with disabilities: If you require assistance completing, or are unable to complete the online resume/application process, please contact:
Human Resources @ (803) 644-0070
Mon. - Fri. 9am - 4pm
237 High Gate Loop
Aiken, SC 29803
Value Added Solutions, Inc. is an Equal Opportunity Employer and supports a drug-free work environment.
Thinking about applying for this position?
Please make sure that you meet the minimum requirements indicated for the job before you apply (see user agreement). If you are qualified, then use either the email link (near top of post) or the application link (near bottom of post) to apply, whichever is provided.