Job Category Information TechnologyMinimum Clearance Secret Job Description What Yoursquoll Get to Do We are seeking a senior-level SQL Server Database Administrator with extensive knowledge and experience in SQL Server administration in Microsoft Azure and on-premises environments in support of mission at Department of State. The candidate will manage all aspects of database administration in a single and clustering environment including but not limited to planning, installation, configuration, security configuration, backup and restore, optimization, and monitoring of SQL Server databases. The candidate should also possess T-SQL development skill to maintain and optimize SSIS ETL processes, and SQL scripts for enhancing and automating security lockdown process. The candidate should understand IT and software development life cycle processes to provide support in the Microsoft Azure Government. Key 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 andor 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 Yoursquoll Bring These Qualifications 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 These Qualifications Would be Nice to Have Knowledge of PowerShell DSC is preferred Knowledge of Power BI is preferred Experience on SQL Server 2019 Administration is preferred What We Can Offer You - Wersquove been named a Best Place to Work by the Washington Post. - Our employees value the flexibility at CACI that allows them to balance quality work and their personal lives. - We offer competitive benefits and learning and development opportunities. - We are mission-oriented and ever vigilant in aligning our solutions with the nationrsquos highest priorities. - For over 55 years, the principles of CACIrsquos unique, character-based culture have been the driving force behind our success. Job Location US-Arlington-VA-VIRGINIA SUBURBAN CACI employs a diverse range of talent to create an environment that fuels innovation and fosters continuous improvement and success. At CACI, you will have the opportunity to make an immediate impact by providing information solutions and services in support of national security missions and government transformation for Intelligence, Defense, and Federal Civilian customers. CACI is proud to provide dynamic careers for employees worldwide. CACI is an Equal Opportunity Employer - FemalesMinoritiesProtected VeteransIndividuals with Disabilities.