MS SQL Server Database Administrator, DBA
A-TEK, Inc.
AWSAzureCloudETLMS SQL ServerMySQLSQLSSIS
SharePoint Database Administrator
ServBeyond Solutions LLC
contract
Posted on:
Origin: • 🇺🇸 United States
Visit company websiteSalary
💰 $85 per hour
Job Level
Mid-LevelSenior
Tech Stack
AzureSplunkSQL
About the role
- Maintain, back up, and restore SQL SharePoint databases to ensure data integrity and availability.
- Monitor server health and troubleshoot issues at the server and database level.
- Optimize performance, storage, and security of databases, including regular checks and disaster recovery tests.
- Collaborate with application developers and system administrators for integrated operations.
- Utilize tools like Azure Portal, Power BI Report Server, SSMS, Splunk, and TSQL for managing and monitoring databases at a server level.
- Support database security compliance and address findings related to database impacts.
- Monitor disk and server usage, handle failover processes, and manage permissions.
- Support monthly SharePoint database patching activities including database stability checks.
- Perform database backup/restore of SQL SharePoint content databases to align with operations and maintenance processes.
- Provide server level troubleshooting of databases and monitoring of database health including disk usage, server usage, storage.
- Create basic T-SQL scripting to change parameters and tune queries.
- Maintain database schemas, stored procedures, indexes, and triggers; document procedures, incidents, and changes.
- Install and configure database software, tools, and utilities; perform regular database maintenance.
- Work with Product Owners to identify priorities, participate in Feature/Iteration Reviews, Backlog Refinement, and daily stand-up meetings.
- Support the Migration from SharePoint On-Premise to SharePoint Online.
- Must be able to support on-call duties over the weekend and have a flexible working schedule.
Requirements
- Bachelor’s degree in Information Technology , Computer Science, Information Systems, or a related field.
- Minimum of four (4) years of experience providing database administration for a large system.
- Experience in systems database , recovery , and/or systems software and support.
- Experience utilizing SAFe Agile and Scrum Methodologies.
- Excellent customer communication skills.
- Strong troubleshooting and root cause analysis skills.
- Experience with SharePoint On-Premise and support for migrations to SharePoint Online.
- Familiarity with Azure Portal, Power BI Report Server, SQL Server Management Studio (SSMS), Splunk, and T-SQL.
- Experience creating T-SQL scripts; maintaining database schemas, stored procedures, indexes, and triggers.
- Experience performing database backup/restore, disaster recovery tests, and monthly patching activities.
- Maintain database security in compliance with federal standards; experience supporting federal government environments preferred.
- Prior SSMS application and SQL Server experience; experience with ShareGate and Jira preferred.
- Database Microsoft Technology Associate (MTA) certification preferred.
- Must be able to support on-call duties over the weekend and have a flexible working schedule.
- Must be able to multitask and write grammatically correct email responses to customers.
- Must interact with a cross-disciplinary team and navigate between government clients, partner contractors, and internal team.
