SQL Database Administrator

Job Responsibilities:
Design and implement fault-tolerant SQL Server solutions using highly availability patterns for scalability and stability in on-premises and Microsoft Azure
Design and deploy Microsoft SQL PaaS solutions in Microsoft Azure Government (MAG)
Monitor and maintain database storage, and database health, performance, sustainability and security
Monitor and maintain SQL server Mirroring, Log shipping, backups, ETL SSIS jobs, and encryption
Provide SQL Server administration in MS SQL Server 2016, 2017 and/or 2019
Plan and implement database backup strategies and perform recovery in case of disaster
Respond to database and user problems, and provide guidance to junior level DBA
Analyze SQL query plans, suggest and implement solutions to support developers in the Software Development Life Cycle (SDLC)
Install, configure and upgrade database management systems and software including clustering environment
Refine and automate security lockdown processes. using T-SQL and PowerShell DSC
Optimize Microsoft for ETL, Data visualization, and Business Intelligence data analysis

Education and Experience:
BS degree in Computer Science or Information Technology; an advanced degree is preferred
A minimum of five (5) years of experience in the management and administration of enterprise level SQL databases in SQL Server 2016 or 2017
Experience designing fault-tolerant MS SQL solutions
A minimum of two (2) years of experience designing and deploying Azure SQL Database on PaaS solutions in MS Azure Government (MAG)
A minimum of three (3) years of experience with SQL Server Integration Services (SSIS).
A minimum of five (5) years of experience with the planning and implementation of MS SQL database disaster recovery for enterprise level application
Knowledge of physical database design, database changes, enforcement of data integrity, and security management
Knowledge of query languages, T-SQL
Ability to troubleshoot and fix issues, and work well across functional teams
Ability to install, configure and patch database management systems and software
Excellent interpersonal skills, initiative, teamwork and problem solving
Strong attention to detail, and good oral and written communication skills

Preferred Skills:
Knowledge of PowerShell DSC
Knowledge of Power BI
Experience on SQL Server 2019 Administration
#J-18808-Ljbffr