04 Aug
MS SQL Server Database Administrator
Vacancy expired!
Description Job Description: Leidos is seeking an MS SQL Server Database Administrator to join our database team with the corporate CIO Services organization. In this role, you will be perform day-to-day database administrative task that includes design, database schema definition, database access privilege management, database query optimization, documentation, database instance patching and upgrades, long-range requirements, data encryption and database protection. Primary Responsibilities:
- Review data within the database to ensure user data integrity, maintain database support tools, database tables and dictionaries, recovery and backup procedures, and make recommendations regarding enhancements and improvements.
- Install, configure, and manage multiple SQL server environments with clustering and disaster recovery, to include Monitoring, Analysis and Reporting solutions.
- Extensive documentation of DBA procedures and work progress with respect to SAFe DevOps culture.
- Understand, write, and execute custom and third party SQL scripts.
- Execute, manage, and validate database server backups leveraging forward thinking concepts, processes, and technology that meet the organizations Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO).
- Responsible for operational management and implementation of upgrades and enhancements of the database environment supporting SCCM, SCOM and SharePoint databases.
- Troubleshoot techniques and analysis with SQL Server service outages and performance issues as they occur in real time.
- Responsible for the lifecycle of SQL performing routine SQL patch updates, applicable service packs, and new major versions as they are released.
- Be available and flexible for part of on-call support rotation.
- Understand Windows clustering technology to support various SQL clusters and SQL Always On Availability Groups.
- Experience using SRSS to provide reporting capability to meet customer needs
- The candidate must be experienced in interfacing with both application managers and system users.
- Bachelor's degree and minimum 4 years of database administration experience. Additional years of relevant experience may be considered in lieu of Bachelor's degree.
- Deep knowledge of Microsoft SQL Server 2016 thru SQL 2019 to include installation, configuration, upgrades, and maintenance of Microsoft database technologies.
- Experience with MS SQL Server, data backups, data recovery, SSIS package and SQL stored procedure development and security fixes.
- Domain level technical knowledge to maintain databases, ensure recovery and provide patches on SQL databases.
- Strong T-SQL and SSIS development skills
- Experience working independently on technical database administration activities in support of a client on SQL databases.
- Experience with Microsoft Structured Query Language (SQL)
- Experience implementing a broad range of assignments requiring originality and innovation in determining how to accomplish tasks.
- In-depth experience in performance tuning using instance and database level configuration, index and statistics maintenance, and fragmentation management
- Experience interfacing with senior management and clients on requirements and solutions.
- US citizenship is required and able to obtain federal security clearance
- Experience with Oracle DB and cloud services (AWS, Microsoft Azure) a plus.
- Demonstrated Working knowledge of Linux, Oracle, AWS, Azure, VMware vSphere (Virtualization Management), EMC Data Domain (Storage Management)
- Migration between instances and between on-prem to AWS and Azure environments
- Familiarity with Scaled Agile Framework (SAFe) DevOps.
- Automation using Microsoft PowerShell, VBScript, or batch files.
- Adaptable to changing circumstances and operational needs.
- Experience working in VmWare ESXi environments.
Vacancy expired!