Database Administrator
for section headings. Use - for any list of duties/requirements/benefits, and
for prose.
We need to preserve all substantive info, not invent.
We need to remove boilerplate: cookie/navigation/legal/EEO/equal-opportunity/scam-warning boilerplate, duplicated lines, application instructions. So we should remove the disclaimer, equal opportunity, etc.
We need to include sections only when posting has real specific content.
Let's parse the posting:
First paragraph: Ameris Bank is a purpose-driven company... This is about company culture. Could be "About the role"? Actually "About the role" maybe includes description of role and company. The posting includes: "This position is the primary support position for Microsoft SQL Server databases. This position works with the Systems Engineering Manager to develop and maintain database and technology systems." That's role description.
We could have "About the role" section with prose summarizing role and company.
Then "Responsibilities": list of duties.
Then "Requirements": maybe required knowledge, skills and competencies.
Then "Qualifications": maybe education and experience.
Then "Skills": maybe specific skills.
But we need to avoid duplication. The posting includes "Required Knowledge, Skills And Competencies" which is a list. Also "Industry And Work Experience" includes education/experience. Also "Benefits Available To Employees". Also "Banking Advantages For Employees" (extra benefits). Also "Employee Resource Groups" etc.
We need to decide sections.
Simplify: Use sections: About the role (prose), Responsibilities (ul), Requirements (ul) maybe combine knowledge/skills and experience, Benefits (ul). Possibly also "Qualifications" separate.
But we must not create thin sections. Let's see content.
About the role: Could combine first paragraphs about company and role description.
Responsibilities: The list under "Essential Functions, Duties, And Responsibilities" and also the earlier paragraph describing responsibilities.
Requirements: Could be "Required Knowledge, Skills And Competencies" plus "Industry And Work Experience".
Qualifications: maybe education requirement (Bachelor's degree or 7-10 years related experience; or equivalent combination; Certification: MCDBA preferred; Academic Bachelor’s degree required). That's overlapping.
Skills: maybe specific technical skills list (SQL Server admin, Windows Server, etc.) but that's already in Required Knowledge.
We could combine Requirements and Qualifications into one section "Requirements". But instructions: use headings for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). We can choose to include only those with real content. We could include About the role, Responsibilities, Requirements, Benefits. Possibly also Qualifications if distinct.
But we must not create sections with filler like "not specified". We have content for each.
Let's extract:
About the role: Ameris Bank is a purpose-driven company... (first paragraph). Also "This position is the primary support position for Microsoft SQL Server databases. This position works with the Systems Engineering Manager to develop and maintain database and technology systems." That's role description.
We'll put that in
.
Responsibilities: list items from "Essential Functions, Duties, And Responsibilities" and also earlier bullet-like sentences: "Identifies, researches, and resolves technical problems. Responds to requests for technical support. Provides support to end users on a variety of issues. Provides support to Support Operations Center and serves as a point of escalation. Documents, tracks, and monitors problems to ensure a timely resolution. Maintains current knowledge of the concepts, practices, and procedures related to branch infrastructure technology and operations. Implements policies and procedures related to software, use, support, security, and backup. Communicates standards for use and operations of branch systems and operations. Communicates with other departments to report and resolve infrastructure issues. Installs and tests software and hardware upgrades. Collects and analyzes data utilization information to provide improvements and efficiencies gains. Performs installation, configuration, migration, and maintenance of assigned technology. Determines migration and upgrade impacts and diagnose/resolve complex technology/application errors Coordinate patch schedule with other teams such as patch team, infrastructure management, security operations, governance & risk. Communicate project and operational metrics. Automates IT processes utilizing modern scripting languages and other automation tools. Under direction of the engineering teams, monitor relevant IT facilities, services, and systems as needed to maintain 24x7 service operation uptime. Performs afterhours activities as needed for the environment and technologies Responsible for all production databases in 24x7 supports for large scale, maintenance, upgrade, security and database instance and server level performance, and space usage monitoring. Responsible migration\upgrade to SQL Server to a version supported by Microsoft. Configure with SQL AlwaysOn HA environment and build disaster recovery strategy plan for critical database servers. Build up performance baseline and automation monitoring process. Configure best practices for production databases supports in 24x7 including configure database automation monitor, alert, pre-action, health report, database instance performance tuning, table partition automation sliding window, database backup, as well as space, CPU, and disk IO monitor in clustered and SAN storage environment."
We need to split into list items. Each sentence could be a
- . We'll need to ensure we don't duplicate.
We'll create
with each responsibility as - .
Requirements: combine "Required Knowledge, Skills And Competencies" and "Industry And Work Experience". Let's extract list items:
- Ability to identify and resolve problems in a timely manner; Gathers and analyzes information skillfully; Develops alternative solutions.
- Extensive experience in administration of databases in a large enterprise organization including database backup, restore, recovery models, clustering, database mirroring, and replication.
- Possess extensive experience with the following database administration functions: database definition, storage allocation, security administration, database reorganization, performance tuning, backup and recovery.
- Thorough understanding of best practices in the areas of SQL Server support and production deployment.
- Possess extensive experience with Windows Servers as it relates to database administration.
- Strong ability to detect and troubleshoot database server related CPU, memory, I/O, disk space and other resource contention.
- Possess knowledge of and experience with index management, integrity checks, configuration, software maintenance.
- Possess knowledge of how runtime statistics work, how indexes are stored, how they can be created and managed effectively.
- Extensive hands-on experience in developing diagnostics and disaster recovery plans to safeguard the integrity of the database.
- Experience in design and implementation of monitoring and scheduling processes SQL Server jobs.
- Ability to serve as a mentor for existing and new team members.
- Ability to work well in a fast-paced environment and meet deadlines.
- Is a self-motivated individual, capable of managing his/her time well, and work efficiently and effectively without close supervision.
- Is a team player with excellent written and verbal communication and interpersonal skills.
- Possess strong customer service orientation (internal/external).
- Strong ability and experience documenting and creating technical procedures regarding database systems.
- Bachelor’s degree or 7-10 years related experience; or equivalent combination of education and experience.
- Certification: MCDBA (Microsoft Certified Database Administrator) certification preferred
- Academic Bachelor’s degree required.
We could separate education/experience as qualifications but okay.
We'll put these in
under Requirements.
Benefits: list from "Benefits Available To Employees" and also "Banking Advantages For Employees". We'll combine.
List items:
- Medical, Dental and Vision Insurance (Ameris Bank absorbs a major portion of the cost of healthcare. You become eligible for coverage on the first of the month following 30 days of employment)
- Life Insurance provided at no additional cost to employees
- Accidental Death & Dismemberment Coverage
- Long-Term Disability Coverage
- Paid Sick and Vacation Leave
- 11 Holidays
- Volunteer/Service Day
- Employee Stock Purchase Plan
- 401(k) Retirement Plan (Ameris Bank matches 50% of your first 8% of contributions to the plan)
- Flexible Spending Accounts
- Health Savings Account
- Health Reimbursement Arrangement
- Supplemental Life & Other Insurance Plans
- Identity Theft Protection
- Pet Insurance
- Legal Insurance
- Employee Assistance Program
- Employee Advocacy Program
- Tickets at Work (Entertainment discounts for Ameris Bank Employees)
- AT&T Employee Discount
- Wellness Discounts for Medical Premiums and Other Rewards
- Employee Referral Incentive
- Education Assistance
- Employee Resource Groups
- Banking Advantages For Employees: Free Interest Checking, Free Safe Deposit Box, Free Money Orders, Travelers’ Checks and Cashier Checks, Discount on Mortgage Origination Fee, Free Online Banking and Free Unlimited Online Bill Payment, Employee Banking Perks
We'll make each as - .
We should not include Pay or Schedule sections.
Now ensure we don't include boilerplate: The disclaimer, equal opportunity, etc. Remove.
Now produce HTML fragment:
About the role
...
Responsibilities
- ...
...
Requirements
...
Benefits
...
Make sure no extra whitespace issues.
Let's craft the About the role paragraph: Combine first paragraph and role description.
"Ameris Bank is a purpose-driven company, dedicated to bringing financial peace of mind to communities, one person at a time. Whether a customer wants to grow their business, buy a home, or feel confident in their retirement plan, they have a partner in Ameris Bank. We serve customers in our locations across the Southeast, Mid-Atlantic and nationwide through our extensive digital offerings and mobile app. Delivering financial peace of mind starts with a team that values integrity and rewards ingenuity. At Ameris, you’ll find teammates who are inclusive, collaborative problem-solvers who go the extra mile to support one another and to meet every customer’s needs. When teammates are empowered and bring their diverse perspectives to the table, we create the best possible outcomes for our customers. At Ameris, we know that a growth mindset is key for high performance and fosters an environment that prioritizes continuous improvement. Teammates have access to Employee Resource Groups that serve as advocates and purpose and how you can bring it to life as an Ameris Bank teammate. This position is the primary support position for Microsoft SQL Server databases. This position works with the Systems Engineering Manager to develop and maintain database and technology systems."
That seems fine.
Now responsibilities list: We'll break into sensible items.
I'll create list items each sentence.
Let's draft:
- Identifies, researches, and resolves technical problems.
- Responds to requests for technical support.
- Provides support to end users on a variety of issues.
- Provides support to Support Operations Center and serves as a point of escalation.
- Documents, tracks, and monitors problems to ensure a timely resolution.
- Maintains current knowledge of the concepts, practices, and procedures related to branch infrastructure technology and operations.
- Implements policies and procedures related to software, use, support, security, and backup.
- Communicates standards for use and operations of branch systems and operations.
- Communicates with other departments to report and resolve infrastructure issues.
- Installs and tests software and hardware upgrades.
- Collects and analyzes data utilization information to provide improvements and efficiency gains.
- Performs installation, configuration, migration, and maintenance of assigned technology.
- Determines migration and upgrade impacts and diagnoses/resolves complex technology/application errors.
- Coordinates patch schedule with other teams such as patch team, infrastructure management, security operations, governance & risk.
- Communicates project and operational metrics.
- Automates IT processes utilizing modern scripting languages and other automation tools.
- Under direction of the engineering teams, monitors relevant IT facilities
for prose. We need to preserve all substantive info, not invent. We need to remove boilerplate: cookie/navigation/legal/EEO/equal-opportunity/scam-warning boilerplate, duplicated lines, application instructions. So we should remove the disclaimer, equal opportunity, etc. We need to include sections only when posting has real specific content. Let's parse the posting: First paragraph: Ameris Bank is a purpose-driven company... This is about company culture. Could be "About the role"? Actually "About the role" maybe includes description of role and company. The posting includes: "This position is the primary support position for Microsoft SQL Server databases. This position works with the Systems Engineering Manager to develop and maintain database and technology systems." That's role description. We could have "About the role" section with prose summarizing role and company. Then "Responsibilities": list of duties. Then "Requirements": maybe required knowledge, skills and competencies. Then "Qualifications": maybe education and experience. Then "Skills": maybe specific skills. But we need to avoid duplication. The posting includes "Required Knowledge, Skills And Competencies" which is a list. Also "Industry And Work Experience" includes education/experience. Also "Benefits Available To Employees". Also "Banking Advantages For Employees" (extra benefits). Also "Employee Resource Groups" etc. We need to decide sections. Simplify: Use sections: About the role (prose), Responsibilities (ul), Requirements (ul) maybe combine knowledge/skills and experience, Benefits (ul). Possibly also "Qualifications" separate. But we must not create thin sections. Let's see content. About the role: Could combine first paragraphs about company and role description. Responsibilities: The list under "Essential Functions, Duties, And Responsibilities" and also the earlier paragraph describing responsibilities. Requirements: Could be "Required Knowledge, Skills And Competencies" plus "Industry And Work Experience". Qualifications: maybe education requirement (Bachelor's degree or 7-10 years related experience; or equivalent combination; Certification: MCDBA preferred; Academic Bachelor’s degree required). That's overlapping. Skills: maybe specific technical skills list (SQL Server admin, Windows Server, etc.) but that's already in Required Knowledge. We could combine Requirements and Qualifications into one section "Requirements". But instructions: use headings for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). We can choose to include only those with real content. We could include About the role, Responsibilities, Requirements, Benefits. Possibly also Qualifications if distinct. But we must not create sections with filler like "not specified". We have content for each. Let's extract: About the role: Ameris Bank is a purpose-driven company... (first paragraph). Also "This position is the primary support position for Microsoft SQL Server databases. This position works with the Systems Engineering Manager to develop and maintain database and technology systems." That's role description. We'll put that in
. Responsibilities: list items from "Essential Functions, Duties, And Responsibilities" and also earlier bullet-like sentences: "Identifies, researches, and resolves technical problems. Responds to requests for technical support. Provides support to end users on a variety of issues. Provides support to Support Operations Center and serves as a point of escalation. Documents, tracks, and monitors problems to ensure a timely resolution. Maintains current knowledge of the concepts, practices, and procedures related to branch infrastructure technology and operations. Implements policies and procedures related to software, use, support, security, and backup. Communicates standards for use and operations of branch systems and operations. Communicates with other departments to report and resolve infrastructure issues. Installs and tests software and hardware upgrades. Collects and analyzes data utilization information to provide improvements and efficiencies gains. Performs installation, configuration, migration, and maintenance of assigned technology. Determines migration and upgrade impacts and diagnose/resolve complex technology/application errors Coordinate patch schedule with other teams such as patch team, infrastructure management, security operations, governance & risk. Communicate project and operational metrics. Automates IT processes utilizing modern scripting languages and other automation tools. Under direction of the engineering teams, monitor relevant IT facilities, services, and systems as needed to maintain 24x7 service operation uptime. Performs afterhours activities as needed for the environment and technologies Responsible for all production databases in 24x7 supports for large scale, maintenance, upgrade, security and database instance and server level performance, and space usage monitoring. Responsible migration\upgrade to SQL Server to a version supported by Microsoft. Configure with SQL AlwaysOn HA environment and build disaster recovery strategy plan for critical database servers. Build up performance baseline and automation monitoring process. Configure best practices for production databases supports in 24x7 including configure database automation monitor, alert, pre-action, health report, database instance performance tuning, table partition automation sliding window, database backup, as well as space, CPU, and disk IO monitor in clustered and SAN storage environment." We need to split into list items. Each sentence could be a
- with each responsibility as
- .
Requirements: combine "Required Knowledge, Skills And Competencies" and "Industry And Work Experience". Let's extract list items:
- Ability to identify and resolve problems in a timely manner; Gathers and analyzes information skillfully; Develops alternative solutions.
- Extensive experience in administration of databases in a large enterprise organization including database backup, restore, recovery models, clustering, database mirroring, and replication.
- Possess extensive experience with the following database administration functions: database definition, storage allocation, security administration, database reorganization, performance tuning, backup and recovery.
- Thorough understanding of best practices in the areas of SQL Server support and production deployment.
- Possess extensive experience with Windows Servers as it relates to database administration.
- Strong ability to detect and troubleshoot database server related CPU, memory, I/O, disk space and other resource contention.
- Possess knowledge of and experience with index management, integrity checks, configuration, software maintenance.
- Possess knowledge of how runtime statistics work, how indexes are stored, how they can be created and managed effectively.
- Extensive hands-on experience in developing diagnostics and disaster recovery plans to safeguard the integrity of the database.
- Experience in design and implementation of monitoring and scheduling processes SQL Server jobs.
- Ability to serve as a mentor for existing and new team members.
- Ability to work well in a fast-paced environment and meet deadlines.
- Is a self-motivated individual, capable of managing his/her time well, and work efficiently and effectively without close supervision.
- Is a team player with excellent written and verbal communication and interpersonal skills.
- Possess strong customer service orientation (internal/external).
- Strong ability and experience documenting and creating technical procedures regarding database systems.
- Bachelor’s degree or 7-10 years related experience; or equivalent combination of education and experience.
- Certification: MCDBA (Microsoft Certified Database Administrator) certification preferred
- Academic Bachelor’s degree required.
We could separate education/experience as qualifications but okay.
We'll put these in
- under Requirements.
Benefits: list from "Benefits Available To Employees" and also "Banking Advantages For Employees". We'll combine.
List items:
- Medical, Dental and Vision Insurance (Ameris Bank absorbs a major portion of the cost of healthcare. You become eligible for coverage on the first of the month following 30 days of employment)
- Life Insurance provided at no additional cost to employees
- Accidental Death & Dismemberment Coverage
- Long-Term Disability Coverage
- Paid Sick and Vacation Leave
- 11 Holidays
- Volunteer/Service Day
- Employee Stock Purchase Plan
- 401(k) Retirement Plan (Ameris Bank matches 50% of your first 8% of contributions to the plan)
- Flexible Spending Accounts
- Health Savings Account
- Health Reimbursement Arrangement
- Supplemental Life & Other Insurance Plans
- Identity Theft Protection
- Pet Insurance
- Legal Insurance
- Employee Assistance Program
- Employee Advocacy Program
- Tickets at Work (Entertainment discounts for Ameris Bank Employees)
- AT&T Employee Discount
- Wellness Discounts for Medical Premiums and Other Rewards
- Employee Referral Incentive
- Education Assistance
- Employee Resource Groups
- Banking Advantages For Employees: Free Interest Checking, Free Safe Deposit Box, Free Money Orders, Travelers’ Checks and Cashier Checks, Discount on Mortgage Origination Fee, Free Online Banking and Free Unlimited Online Bill Payment, Employee Banking Perks
We'll make each as
- .
We should not include Pay or Schedule sections.
Now ensure we don't include boilerplate: The disclaimer, equal opportunity, etc. Remove.
Now produce HTML fragment:
About the role
...
Responsibilities
- ... ...
Requirements
-
...
Benefits
-
...
- .
We should not include Pay or Schedule sections.
Now ensure we don't include boilerplate: The disclaimer, equal opportunity, etc. Remove.
Now produce HTML fragment: