Job Description :
Peraton has an opening for a SQL Server Database Administrator (DBA). The selected candidate's tasks will include but are not limited to definition and design of enhancement to existing databases, daily performance monitoring of data base activity, weekly review and tuning of database indexes, troubleshooting of reported problems, and patching as required.
Primary Responsibilities:
Provide database administration services in support of web and client server applications. Must be able to provide both production and development DBA support tasks.
Creating and maintaining database documentation, such as data dictionaries, entity relationship diagrams, data models, and stored procedures.
Install, configure, upgrade and maintain databases on Windows (preferred) or other platforms.
Administer database users, manage database objects, and configure client network.
Perform logical and physical database design.
Implement and enforce security for all the databases.
Perform database monitoring and tuning using DMVs, Perfmon, profiler and other tools.
Perform database refreshes of Development and QA databases.
Work with the application development team on production release deployments.
Provide support and consultation to the application development team in all database related areas including table and index design and creation and SQL tuning.
Install and configure DBA management tools.
Troubleshoot and correct database issues in an efficient and timely manner.
Perform backup and recovery of databases.
Support all nightly database maintenance and administration jobs.
Maintain all production job scripts assigned to the database team.
Proactively monitor databases and identify potential problems.
Enforce all database architecture and relevant procedures according to established policies.
Create, troubleshoot and deploy SSIS/SSRS solutions for data exports/imports and reporting needs.
Must have worked in Microsoft clustering of SQL databases, Always ON high availability solutions.
Position will report to the Senior Database Administrator.
The selected candidate must be able to manage database related services from the planning phase through the implementation and management phases. He or she will interface with other team members, management, and end-users on a regular basis. After hours, availability is required in order to respond to emergencies, production releases, and to perform database maintenance that cannot be completed during normal business hours.
Qualifications/ Skills:
5+ years Database Administration experience; should have experience in test, development and production instances.
In-depth knowledge of SQL server versions 2012/2016 and above, with SSIS/SSRS
Experience with databases migrations of SQL Servers from older to newer versions
Experience in configuring and maintaining SQL Always ON is required.
Ability to execute performance monitoring and necessary adjustments.
Excellent knowledge of backup and recovery scenarios and backup tools.
Highly self-motivated individual who has the ability to work independently as well as in a team environment.
Excellent verbal and written communication skills; ability to think strategically with technical vision; proven project management and leadership skills; attention to detail and strong organizational skills.
Oracle experience a plus.
Comments for Suppliers:This position will be part of the team that provides ellection support and time off wis restricted for the dates elow.
State Primary Election 9/6/2022 (last day to register 8/17/2022)
Time off requests will be limited and attendance for the team will be mandatory between the dates of 8/15 to 9/9.
State Election 11/8/2022 (last day to register 10/19/2022)
Time off requests will be limited and attendance for the team will be mandatory between the dates of 10/17 to 11/10.

Required Skills : 5+ years Database Administration experience; should have experience in test, development and production instances. In-depth knowledge of SQL server versions 2012/2016 and above, with SSIS/SSRS Experience with databases migrations of SQL Servers from older to newer versions Experience in configuring and maintaining SQL Always ON is required. Ability to execute performance monitoring and necessary adjustments. Excellent knowledge of backup and recovery scenarios and backup tools.
Basic Qualification :
Additional Skills : Hybrid 2 weeks onsite, one week remote.
Background Check :Yes
Drug Screen :Yes
Notes :Comments for Suppliers: This position will be part of the team that provides election support and time off will be restricted for the dates below. US Persons required due to govt services requirements. State Primary Election 9/6/2022 (last day to register 8/17/2022) Time off requests will be limited and attendance for the team will be mandatory between the dates of 8/15 to 9/9. State Election 11/8/2022 (last day to register 10/19/2022) Time off requests will be limited and attendance for the team will be mandatory between the dates of 10/17 to 11/10.
Selling points for candidate :Hybrid 2 weeks onsite, one week remote.
Project Verification Info :
Candidate must be your W2 Employee :Yes
Exclusive to Apex :No
Face to face interview required :No
Candidate must be local :No
Candidate must be authorized to work without sponsorship :Yes
Interview times set : :No
Type of project :Development/Engineering
Master Job Title :DBA: SQL Server
Branch Code :San Diego
             

Similar Jobs you may be interested in ..