Network Infrastructure Engineer
for sections like About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. We must only include sections that have real specific content. The posting includes: Onsite Description (maybe about role), Responsibilities, Requirements, Highly Desired Skills (could be Skills), About Diversified Systems (maybe About the role? Actually about company). There's no explicit Benefits, Pay, Schedule. So we should not create those sections. Also we should not repeat job title as heading. We need to preserve all substantive info, remove boilerplate (EEO, etc). The posting includes a lot of EEO and diversity statements at end; we should remove those. Also remove navigation/cookie etc (none). Also remove duplicated lines.
We need to decide sections: maybe "About the role" from the Onsite Description paragraph. Could also have "About Diversified Systems" as separate section maybe "About the company". But allowed headings list includes About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. Qualifications maybe same as Requirements? But we can use Requirements for the list of required years etc. Skills for Highly Desired Skills. About the role for the initial description. Possibly also "About Diversified Systems" could be considered "About the role"? Not exactly. But we could include a section "About the company" but not in allowed list; better to stick to allowed headings. Could we put company info under About the role? Might be okay but it's not exactly role. However we could treat the Onsite Description as about the role; the company description could be considered extra but maybe we can include as a paragraph under About the role or as a separate section not in list? The instruction: "use for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule)." It says e.g., meaning those are examples, not exclusive? It says "Use for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule)." Likely they expect only those headings. So we should map content to those headings where appropriate. If we have content that doesn't fit, we could still use a heading not in list? Might be risky. Better to fit: About the role: combine Onsite Description and maybe company overview? Could include both. Responsibilities: list. Requirements: list of required years. Skills: Highly Desired Skills. Qualifications maybe not needed if we already have Requirements; but we could omit Qualifications section if no distinct content. Benefits, Pay, Schedule: omit as not present.
Thus output:
About the role
for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule)." Likely they expect only those headings. So we should map content to those headings where appropriate. If we have content that doesn't fit, we could still use a heading not in list? Might be risky. Better to fit: About the role: combine Onsite Description and maybe company overview? Could include both. Responsibilities: list. Requirements: list of required years. Skills: Highly Desired Skills. Qualifications maybe not needed if we already have Requirements; but we could omit Qualifications section if no distinct content. Benefits, Pay, Schedule: omit as not present.
Thus output:
About the role
Onsite Description: Diversified Systems is searching for a Network Infrastructure Engineer to provide advanced technical support across all phases of database administration, database development, database operations, data migration, and enterprise database management activities. This position is responsible for supporting critical production systems and ensuring the availability, performance, security, and reliability of database environments, including Azure SQL and SQL Server platforms. Founded in 1990, Diversified Systems is an award-winning Technology Services corporation providing all levels of IT project consulting services nationwide. DSI is headquartered in Columbus, Ohio with regional offices in the American Midwest and East Coast.
But we need to preserve all substantive info: The Onsite Description paragraph includes the role description. The company description is separate; we could include it in same paragraph. Responsibilities: list each bullet from responsibilities section. Need to convert to- . Ensure we keep all responsibilities lines.
Requirements: list each requirement line.
Skills: list highly desired skills.
We must remove boilerplate: EEO, diversity statements, etc. Also remove "We offer our consultants a number of flexible and competitive compensation benefit packages." That's a benefit statement but vague; it's not specific benefits; we should not create Benefits section because it's vague. But we could include that sentence in About the role? It's about compensation benefits but vague; maybe we can keep as part of About the role? It's not boilerplate but it's a benefit statement. However we are not making Benefits section; we could embed it in About the role paragraph. But the instruction: "never create Pay/Schedule/Benefits sections unless the posting actually states them." It does state "We offer our consultants a number of flexible and competitive compensation benefit packages." That's a benefit statement but vague. It's still a statement about benefits. Should we include it? Probably we can include it in About the role paragraph as it's substantive. But we must not create a Benefits section. So we can include that sentence in About the role.
Also remove "Diversified Systems is committed to the principles of equal employment..." etc. That's EEO boilerplate; remove.
Also remove the Diversity, Equity and Inclusion section; remove.
Now craft HTML.
Let's extract responsibilities list exactly:
From text:
"Provide operations support for SQL Database and Database Server administration for critical production systems.
Ensure overall health, availability, and quality of database services.
Perform health checks to review database performance and provide recommendations for performance improvements.
Perform migration and upgrades of SQL databases from legacy servers and SQL versions to new server and SQL versions.
Perform data migration activities by designing programs to extract, cleanse, transform, load, and validate data between source and target systems.
Deploy SQL database solutions within Azure environments.
Secure Azure SQL resources and data.
Provide database design support.
Define, develop, and create databases by assessing business and technical requirements.
Meet with developers and vendors to gather requirements and provide consulting support for database configurations.
Deploy and maintain database schema changes across test and production environments.
Provide technical support for Data Warehouse, Data Mart, and Power BI environments.
Deploy, configure, secure, back up, and maintain Azure SQL database solutions.
Integrate Azure SQL resources with other Azure services to support enterprise applications and data solutions.
Monitor, troubleshoot, and optimize Azure SQL and SQL Server database performance and availability.
Support migration of on-premises SQL Server databases to Azure SQL.
Design, develop, and maintain logical and physical database models based on business and technical requirements.
Review and validate data models and data dictionaries to ensure compliance with organizational standards.
Develop and maintain database structures, including tables, relationships, and normalization, to ensure data integrity, efficiency, and minimal redundancy.
Collaborate with developers, business stakeholders, and vendors to gather requirements and recommend appropriate database architectures and configurations.
Coordinate database backup and restore requests with backup administration teams.
Participate in ongoing process improvement initiatives.
Apply data analysis and database management techniques to support enterprise solutions.
Work independently with minimal supervision.
Determine time estimates and schedules for assigned work.
Identify and track issues, risks, and action items.
Coordinate with vendors and service providers to resolve technical support issues.
Assist in coordinating software releases.
Manage and provide status updates on assigned work activities.
Follow established database standards and procedures.
Work effectively within a team environment.
Complete assigned tasks and project deliverables."
That's many items.
Requirements list:
"7 years of SQL Server Database Administration experience required.
4 years of experience performing database administration on production servers required.
3 years of Data Analytics experience required.
1 year of Azure Database Administration experience required.
1 year of Data Warehouse experience required.
Excellent communication skills required.
Ability to provide high-quality and professional customer service required."
Highly Desired Skills:
"Power BI Administration experience highly desired.
Business systems analysis and design experience highly desired.
Microsoft SQL High Availability (HA) and Always On experience highly desired."
Now About the role paragraph: combine Onsite Description and company overview and benefit statement.
Onsite Description: "Onsite Description: Diversified Systems is searching for a Network Infrastructure Engineer to provide advanced technical support across all phases of database administration, database development, database operations, data migration, and enterprise database management activities. This position is responsible for supporting critical production systems and ensuring the availability, performance, security, and reliability of database environments, including Azure SQL and SQL Server platforms."
Company overview: "Founded in 1990, Diversified Systems is an award-winning Technology Services corporation providing all levels of IT project consulting services nationwide. DSI is headquartered in Columbus, Ohio with regional offices in the American Midwest and East Coast. We offer our consultants a number of flexible and competitive compensation benefit packages."
We could combine into one paragraph.
Now produce HTML:
About the role
Diversified Systems is searching for a Network Infrastructure Engineer to provide advanced technical support across all phases of database administration, database development, database operations, data migration, and enterprise database management activities. This position is responsible for supporting critical production systems and ensuring the availability, performance, security, and reliability of database environments, including Azure SQL and SQL Server platforms. Founded in 1990, Diversified Systems is an award-winning Technology Services corporation providing all levels of IT project consulting services nationwide. DSI is headquartered in Columbus, Ohio with regional offices in the American Midwest and East Coast. We offer our consultants a number of flexible and competitive compensation benefit packages.
Responsibilities
- Provide operations support for SQL Database and Database Server administration for critical production systems.
- Ensure overall health, availability, and quality of database services.
- Perform health checks to review database performance and provide recommendations for performance improvements.
- Perform migration and upgrades of SQL databases from legacy servers and SQL versions to new server and SQL versions.
- Perform data migration activities by designing programs to extract, cleanse, transform, load, and validate data between source and target systems.
- Deploy SQL database solutions within Azure environments.
- Secure Azure SQL resources and data.
- Provide database design support.
- Define, develop, and create databases by assessing business and technical requirements.
- Meet with developers and vendors to gather requirements and provide consulting support for database configurations.
- Deploy and maintain database schema changes across test and production environments.
- Provide technical support for Data Warehouse, Data Mart, and Power BI environments.
- Deploy, configure, secure, back up, and maintain Azure SQL database solutions.
- Integrate Azure SQL resources with other Azure services to support enterprise applications and data solutions.
- Monitor, troubleshoot, and optimize Azure SQL and SQL Server database performance and availability.
- Support migration of on-premises SQL Server databases to Azure SQL.
- Design, develop, and maintain logical and physical database models based on business and technical requirements.
- Review and validate data models and data dictionaries to ensure compliance with organizational standards.
- Develop and maintain database structures, including tables, relationships, and normalization, to ensure data integrity, efficiency, and minimal redundancy.
- Collaborate with developers, business stakeholders, and vendors to gather requirements and recommend appropriate database architectures and configurations.
- Coordinate database backup and restore requests with backup administration teams.
- Participate in ongoing process improvement initiatives.
- Apply data analysis and database management techniques to support enterprise solutions.
- Work independently with minimal supervision.
- Determine time estimates and schedules for assigned work.
- Identify and track issues, risks, and action items.
- Coordinate with vendors and service providers to resolve technical support issues.
- Assist in coordinating software releases.
- Manage and provide status updates on assigned work activities.
- Follow established database standards and procedures.
- Work effectively within a team environment.
- Complete assigned tasks and project deliverables.
Requirements
- 7 years of SQL Server Database Administration experience required.
- 4 years of experience performing database administration on production servers required.
- 3 years of Data Analytics experience required.
- 1 year of Azure Database Administration experience required.
- 1 year of Data Warehouse experience required.
- Excellent communication skills required.
- Ability to provide high-quality and professional customer service required.