Security Engineer - SQL

We need to output HTML fragment with sections: About the role? The posting includes description of company, then responsibilities, then skills/experience/certifications, then education, then pay range. Also maybe Benefits? Not present. Schedule? Not present. So we include sections: About the role (maybe from intro), Responsibilities, Requirements (or Skills/Experience/Certifications), Qualifications? The instruction: use headings for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). We need to include sections only when posting has real specific content. So we can have About the role (company description), Responsibilities (list), Skills (or Requirements) (list of skills/experience/certifications), Pay (pay range). Possibly Education could be part of Requirements/Qualifications. But we can combine Education into Requirements or Qualifications. The instruction: Use headings for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). So we can choose appropriate ones. We have content: company description (Electrosoft Services...). That's About the role. Responsibilities: bullet list of duties. Skills/Experience/Certifications: list of required experience, certifications, etc. Education: Bachelor's degree... Could be part of Requirements/Qualifications. We could have a Qualifications section covering education and certifications. But we already have Skills section for skills/experience/certifications. Maybe we put Education under Qualifications. Let's decide: Use Requirements for mandatory experience/education, Skills for technical skills. But we can also combine. Better: Sections: About the role, Responsibilities, Requirements (includes education, experience, certifications), Skills (technical skills), Pay. But we must not repeat headings with filler. Ensure each section has substantive content. Let's extract content. About the role: The paragraph describing Electrosoft Services, LLC: award-winning company provides comprehensive technology-based solutions and services to federal customers. While cybersecurity is our specialty, we also focus on ICAM, Zero Trust, digital engineering and transformation, and enterprise AI and intelligent automation. We always seek to delight our customers, so we retain highly qualified employees and offer them meaningful work, growth opportunities, and work-life balance. What sets us apart from all other contractors is the sense of teamwork our employees feel – and the knowledge that outstanding effort is recognized and rewarded. The camaraderie we share emanates from Lunch & Learn sessions where we explore new ideas together, fun group activities ranging from escape rooms to miniature golf, and much, much more. If we've described you and your dream workplace, please apply and share in the many benefits and opportunities we offer. We should not include application instructions ("please apply...") as per rule: remove application instructions. So we should cut that sentence. Also remove EEO line at end. So About the role should be up to "much, much more." Possibly we can keep the invitation? It's application instruction, remove. Thus About the role: Electrosoft Services, LLC is an award-winning company that provides comprehensive technology-based solutions and services to federal customers. While cybersecurity is our specialty, we also focus on ICAM, Zero Trust, digital engineering and transformation, and enterprise AI and intelligent automation. We always seek to delight our customers, so we retain highly qualified employees and offer them meaningful work, growth opportunities, and work-life balance. What sets us apart from all other contractors is the sense of teamwork our employees feel – and the knowledge that outstanding effort is recognized and rewarded. The camaraderie we share emanates from Lunch & Learn sessions where we explore new ideas together, fun group activities ranging from escape rooms to miniature golf, and much, much more. Now Responsibilities: list of duties. We need to convert each sentence into

. The responsibilities block starts after "Security Engineer - SQL Responsibilities and Duties:" then "The candidate will be capable of performing the tasks &/or possess the skill sets listed below:" then list. We need to extract each duty: - Maintains database performance by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements; evaluating computer operating systems when/where necessary. - Manage SQL Server environments supporting Dev, Test, UAT, and Production GRC platform and application instances hosted in the HCAP Lab and CSO- managed infrastructure. - Knowledge of information security policies aligns with responsibilities related to maintaining database security and compliance. - Supports Application Administrators in designing, implementing, and testing database changes to support business applications. - Assists Application Administrators code efficient SQL statements, review the SQL statements for performance and make recommendations for indexes. - Candidate is knowledgeable and proficient in dealing with and troubleshooting SQL instances which take advantage of Windows Server Failover Cluster (WSFC) services and capabilities to support Always On availability groups and SQL Server Failover Cluster Instances. - Design and plan upgrade strategies including coordination with system administrators and developer. Upgrade plans must include checklist, milestones, complete checkout, and exercised fallback procedures. - Implement secure access controls, patch management, and vulnerability remediations in line with DISA STIGs and HHS infrastructure policies. - Ensure Archer database configurations align with RSA support standards and meet high availability and disaster recovery (HA/DR) requirements. - Collaborate with HCAP platform teams and OS-managed infrastructure teams to maintain alignment between Archer and shared services. - Use tools like SQL Server Management Studio (SSMS), PowerShell, and ServiceNow to administer, monitor, and track all DBA activities. - Design, implement, maintain, and utilize advanced Data query Language (DQL), Data Definition Language (DDL), Data Control Language (DCL), and/or Data Manipulation Language (DML) to automate tasks, enhance system functionalities, and troubleshoot issues. Must also be comfortable performing Administration and O&M tasks from the command line. - Candidate will hold and maintain a current (or one Microsoft version release previous) Microsoft Database certifications such as Microsoft Certified: Azure Database Administrator Associate or Azure Database Administrator. - Maintain detailed documentation for system designs, configurations, processes, and service records. - Collaborate with cross-functional teams to support IT infrastructure projects, providing expert guidance and technical leadership. - Lead and mentor junior team members in best practices and technical challenges. - Organized, detail-oriented, and excellent problem-solving skills with the ability to work independently or as part of a team. - Capability to troubleshoot and resolve LAN/WAN connections, performance/throughput issues, and other related network problems. - Strong communication and documentation skills, with the ability to explain complex technical concepts to non-technical stakeholders. - Analyzes development and implementation requirements and makes appropriate modifications to existing systems and prepares specifications based on customer requests. That's many items. Now Skills/Experience/Certifications: The block after "Skills/Experience/Certifications:" includes: - Candidate will hold a ComSci/CIS/InfoSec/IT related bachelor's degree (or higher) with ~8+ years of Information Security work experience or an equivalent combination of education, certifications, & IT experience. - Demonstrated knowledge and proficiency with over 5 years Administration, Operations and Maintenance (O&M), and Troubleshooting of Microsoft SQL (2016-2019) and various other databases such as DB2, Oracle, Mongo, MySQL in enterprise environments with more than two years supporting an enterprise GRC platform and application including RSA Archer. - Strong knowledge and proficiency greater than 5 years) in database performance tuning, security, and management suggests a role focused primarily on daily or regularly scheduled administration, maintenance, storage, and optimization of the existing database systems. - Knowledge and proficiency performing the following database administration tasks: Performance tuning (5+ years Preferred), Database administration (5+ years Preferred), and Data Maintenance (5+ years Preferred) - Possess knowledge &/or familiarity with security hardening framework standards and regulations from Center for Internet Security (CIS) Control 4, National Institute of Standards and Technology (NIST) Special Publication 800-53 Revision 5, and Defense Information Systems Agency's (DISA) Security Technical Implementation Guides (STIGs). - Education: Bachelor's degree in computer science, Information Systems, Cybersecurity, or related field (or equivalent combination of education and experience). - Ability to participate in a 24/7/365 on call rotation. Note there is duplication with education earlier. We'll keep education as part of Requirements/Qualifications. We need to decide sections: Maybe Requirements (education, experience, certifications) and Skills (technical skills). But the skills block includes both experience and technical skills. Could split: Requirements: education, experience, certifications, on-call ability. Skills: technical skills like performance tuning, database administration, data maintenance, knowledge of frameworks, etc. But we have overlapping. Let's create: - Requirements: includes education, experience (8+ years InfoSec, 5+ years SQL admin, etc.), certifications (Microsoft DB cert), ability to participate in 24/7 on-call. - Skills: includes performance tuning, database administration, data maintenance, knowledge of CIS, NIST, DISA STIGs, familiarity with security hardening frameworks, etc. But also the bullet about "Strong knowledge and proficiency greater than 5 years) in database performance tuning, security, and management suggests a role focused primarily on daily or regularly scheduled administration, maintenance, storage, and optimization of the existing database systems." That's a skill. Also "Knowledge and proficiency performing the following database administration tasks: Performance tuning (5+ years Preferred), Database administration (5+ years Preferred), and Data Maintenance (5+ years Preferred)" is skill. Thus we can separate. Now Pay: Pay Range $125,000—$145,000 USD. Now we need to output HTML fragment with headings

and lists

• for any list of duties/requirements/benefits, and

  for prose. Thus:

  About the role

  Electrosoft Services, LLC is an award-winning company that provides comprehensive technology-based solutions and services to federal customers. While cybersecurity is our specialty, we also focus on ICAM, Zero Trust, digital engineering and transformation, and enterprise AI and intelligent automation. We always seek to delight our customers, so we retain highly qualified employees and offer them meaningful work, growth opportunities, and work-life balance. What sets us apart from all other contractors is the sense of teamwork our employees feel – and the knowledge that outstanding effort is recognized and rewarded. The camaraderie we share emanates from Lunch & Learn sessions where we explore new ideas together, fun group activities ranging from escape rooms to miniature golf, and much, much more.

  Responsibilities

  • Maintains database performance by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements; evaluating computer operating systems when/where necessary.
  • Manage SQL Server environments supporting Dev, Test, UAT, and Production GRC platform and application instances hosted in the HCAP Lab and CSO- managed infrastructure.
  • Knowledge of information security policies aligns with responsibilities related to maintaining database security and compliance.
  • Supports Application Administrators in designing, implementing, and testing database changes to support business applications.
  • Assists Application Administrators code efficient SQL statements, review the SQL statements for performance and make recommendations for indexes.
  • Candidate is knowledgeable and proficient in dealing with and troubleshooting SQL instances which take advantage of Windows Server Failover Cluster (WSFC) services and capabilities to support Always On availability groups and SQL Server Failover Cluster Instances.
  • Design and plan upgrade strategies including coordination with system administrators and developer. Upgrade plans must include checklist, milestones, complete checkout, and exercised fallback procedures.
  • Implement secure access controls, patch management, and vulnerability remediations in line with DISA STIGs and HHS infrastructure policies.
  • Ensure Archer database configurations align with RSA support standards and meet high availability and disaster recovery (HA/DR) requirements.
  • Collaborate with HCAP platform teams and OS-managed infrastructure teams to maintain alignment between Archer and shared services.
  • Use tools like SQL Server Management Studio (SSMS), PowerShell, and ServiceNow to