SQL Server Database Specialist

Knowesis is currently seeking an exceptional SQL Server Database Specialist to join our team and provide invaluable support to the Department of Defense Office of Inspector General (DoD OIG) Information Technology Support Services (ITSS) Bridge contract.

To be eligible for this position candidates must have or have the ability to obtain a Secret security clearance and possess United States Citizenship without the need for sponsorship both now and in the future. Applicants without proof of United States Citizenship will not be considered due to the positions security clearance requirements.

The Job Duties and Responsibilities include but are not limited to the following:

• Provide database management design troubleshooting and configuration of Microsoft Structured Query Language (SQL) Server database systems for the Department of Defense Office of Inspector General (DoD OIG)
• Plan coordinate and implement security measures to safeguard information in computer files against accidental or unauthorized damage modification or disclosure
• Modify existing databases and database management systems in accordance with policy and procedures created to optimize and secure data
• Test programs and databases correct errors and make necessary modifications
• Develop methods for integrating different products so they work properly together such as customizing commercial databases to fit specific needs
• Design install and support Microsoft High Availability solutions and Windows Load Balancing for database systems
• Design install and support MySQL Fabric and MySQL replication to support data redundancy
• Perform database installation configuration and upgrades for Microsoft SQL Server instances
• Develop and maintain database schemas tables views stored procedures functions and triggers
• Optimize database performance through query tuning index optimization and database configuration adjustments
• Monitor database performance capacity and availability and proactively address issues
• Implement and manage database backup and recovery strategies and procedures
• Perform database restoration and recovery operations when needed
• Implement and maintain database security including user access controls permissions and role-based security
• Develop and maintain database documentation including data dictionaries entity-relationship diagrams and backup/recovery procedures
• Support application development teams with database design query optimization and troubleshooting
• Create and maintain database reports and provide data analysis support
• Implement and manage database replication clustering and high availability solutions
• Perform data migration and integration activities between database systems
• Apply patches updates and security fixes to SQL Server instances following established change management procedures
• Ensure all database solutions are in compliance with Defense Information Systems Agency (DISA) Security Technical Implementation Guides (STIGs) Department of Defense (DoD) and OIG policies and standards
• Follow all OIG Change Management and Engineering Review processes and ensure changes are completed according to the project and release manager schedule
• Work with the OIG Project Management Office (PMO) to establish and meet project milestones to ensure all solutions meet documented customer requirements and are within project scope
• Maintain existing and as required develop new documentation that includes Standard Operating Procedures (SOPs) database design documentation and technical specifications adhering to organizational templates policies and standards
• Troubleshoot and resolve database connectivity performance and functionality issues
• Monitor database growth and capacity planning for future resource requirements
• Implement and maintain database auditing and compliance reporting
• Support the OIG PMO and Enterprise Architect (EA) during requirement analysis to develop technical solution options for database systems
• Provide technical support and guidance to application developers and users for database-related issues
• Participate in disaster recovery planning and testing for database systems
• Meet OIG established service level metrics and performance standards
• Travel within the Continental United States (CONUS) and the National Capital Region (NCR) may be required to attend meetings conferences and training

Required Qualifications:

• Bachelors degree from an accredited university in computer science information systems information technology or a related technical field
• Minimum of 5 years of experience in database administration database development or related technical roles
• Strong experience with Microsoft SQL Server (SQL Serveror later)
• Experience with database design including schema design normalization and entity-relationship modeling
• Experience with Transact-SQL (T-SQL) programming including stored procedures functions triggers and views
• Experience with database performance tuning and optimization
• Experience with database backup and recovery strategies and procedures
• Experience with database security implementation including user access controls and permissions
• Experience with high availability solutions such as Always On Availability Groups database mirroring or failover clustering
• Experience with database monitoring and capacity planning
• Knowledge of Department of Defense Security Technical Implementation Guides (STIGs) and compliance requirements for database systems
• Strong documentation skills and ability to create technical specifications and database documentation
• Experience working in a government or DoD environment
• Strong analytical and problem-solving skills
• Excellent communication skills and ability to work effectively with technical and non-technical stakeholders

Preferred Qualifications:

• Information Assurance Technician (IAT) Level I certification in accordance with DoD 8570.01-M guidance (Security Plus GIAC Security Essentials Certification (GSEC) Certified Ethical Hacker (CEH) or similar)
• Microsoft Certified: Azure Database Administrator Associate
• Microsoft Certified Solutions Associate (MCSA): SQL Server or Microsoft Certified Database Administrator (MCDBA)
• Microsoft Certified Solutions Expert (MCSE): Data Management and Analytics
• Information Technology Infrastructure Library (ITIL) v3 or later certification
• Experience with MySQL database administration and MySQL replication
• Experience with Microsoft Azure SQL Database and cloud-based database solutions
• Experience with SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)
• Experience with SQL Server Analysis Services (SSAS)
• Experience with PowerShell scripting for database administration automation
• Experience with database version control and deployment automation
• Experience with Entity Framework or other Object-Relational Mapping (ORM) tools
• Experience with database migration tools and strategies
• Experience with data warehouse design and implementation
• Experience with database encryption technologies (Transparent Data Encryption Always Encrypted)
• Experience with Microsoft Dynamics CRM database architecture
• Experience with SharePoint database administration
• Experience supporting both unclassified and classified networks (NIPRNet SIPRNet)
• Experience with Assured Compliance Assessment Solution (ACAS) vulnerability scanning for database systems
• Experience with disaster recovery planning and implementation for database systems
• Experience with virtualized database environments (VMware Hyper-V)
• Masters degree in computer science information systems information technology or related technical field
• Current Secret or Top Secret security clearance
• Multiple Microsoft database certifications

Benefits:

• Health (Preferred Provider Organization (PPO) & High Deductible Health Plan (HDHP) Insurance
• Dental
• Vision
• Short-Term Disability (STD) & Long-Term Disability (LTD)
• Basic Life Insurance
• 401k Company Match & Voluntary Products

Knowesis is committed to providing equal employment opportunities to all individuals based on merit and qualifications. We prohibit discrimination in all aspects of employment as required by Title VII of the Civil Rights Act and other applicable federal laws. Our company values all applicants and employees and fosters a work environment where everyone is treated with respect and dignity.

Required Experience:

IC