Description review
SQL Database Administrator
AmeriSave Mortgage Corp. · United States · back to the listing
HR standards
66/100
needs work
Title ↔ description
87/100
strong
Reads as
Database Administrator
100% confident
What this role officially is
database administrator — ESCO, the EU occupation classification
Database administrators test, implement and administer computer databases. They use their expertise in database management systems to plan, coordinate and implement security measures to safeguard computer databases. They also use scripts and configuration files to tailor a database to users' needs.
Also known as: database manager, DBA, database administrators, data manager, data administrator, database configurator
What the listing never says
- 32 bullet points. Long requirement lists deter qualified candidates, who read them as hard gates. Scope clarity
The listing, marked up
Nothing in the wording of this listing tripped a check. The scores above still judge how complete and coherent it is.
About the Role
AmeriSave is a mid-size financial services company running a high-volume Microsoft SQL Server environment, and we are investing heavily in the long-term stability, transparency, performance, and scalability of our data platform. We are hiring a senior, hands-on engineer to lead that effort.
This is a combined reliability-and-performance role for an engineer who is equally comfortable owning the observability and incident-response practice across the estate and getting deep into execution plans and wait statistics to keep the platform fast and resilient underload. You will be the technical center of gravity for the database platform: the person who ensures we see issues early, leads the response when they arise, and engineers durable solutions so they do not recur.
Responsibilities:
• Manage SQL Server databases on Prem and in Azure cloud environments (Iaas/PaaS)
• Recommend short-term and long-term strategic plans to ensure database infrastructure meets existing and future requirements.
• Define and propose policies, procedures, and associated maintenance plans for DBMS resource administration and appropriate use.
• Configure and maintain database servers and processes
• Monitor system's health and performance
• Ensure high levels of performance, availability, sustainability and security
• Analyze, solve, and correct issues in real time
• Provide suggestions for solutions
• Refine and automate regular processes, track issues, and document changes
• Assist developers with query tuning and schema refinement
• Provide 24x7 support for critical production systems
• Perform scheduled maintenance and support release deployment activities after hours
• Off-Hours production support (call rotation) is required for this position.
Requirements:
• 7+ years of experience as a SQL Server DBA
• SSIS, SSAS, and SSRS administration
• Experience with Performance Tuning and Optimization
• Database stored procedure, trigger, and index creation and tuning
• Experience with backups, restores and recovery models
• Experience of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
• Experience supporting a development team in a production environment
• Strong troubleshooting with SQL Server Profiler, Database Engine Tuning Advisor, Performance Monitor, and Query Store
• Database stored procedure, trigger, and index creation and tuning
• Failover Clustering (Always On: FCI & AG) design and configuration
• Sense of ownership and pride in your performance and its impact on company's success
• Critical thinker and problem-solving skills
• Team player
• Good time-management skills
• Great interpersonal and communication skills
• Experience with Azure SQL (preferred)
• Experience with Foglight, Redgate, and other SQL Server 3rd party tools (preferred)
• Certifications are a plus
• High-speed internet required for remote work, Cable or Fiber ONLY with the ability to connect via Ethernet. Minimum speeds: 70/30 Mbps (basic), 200-300/35-70 Mbps (shared), 500-1,000/100+ Mbps (heavy use).
**Please note that the compensation and benefit information that follows is a good faith estimate for this position only and is provided pursuant to applicable state and local laws on pay transparency. It is estimated based on what a successful applicant in the relevant state might be paid. **
Compensation:
The annual compensation for this position generally ranges from between $115,000 - $150,000.
Benefits:
· 401(k)
· Dental insurance
· Disability insurance
· Employee discounts
· Health insurance
· Life insurance
· Paid time off
· 12 paid holidays per year
· Paid training
· Referral program
· Vision insurance
Supplemental pay types:
· Referral bonuses
AmeriSave is an equal opportunity employer. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.
California Consumer Privacy Act Disclosure Acknowledgment
Employment Applicants, New Hires, and Employees Residing in California
AmeriSave Mortgage Corporation’s Privacy Policy Statement (“Policy”) can be reviewed here:www.amerisave.com/privacy-policy
AmeriSave Mortgage Corporation’s California Consumer Privacy Act (“CCPA”) Recruitment Disclosure can be reviewed here:
When AmeriSave’s Human Resources Department makes future requests for personal information, the same Policy is applicable. By applying, you understand this acknowledgment covers current and future personal information requests. You also acknowledge the business purpose of the personal information collected and that future requests may occur while applying for a position at AmeriSave and/or during employment, if applicable.
Originally posted on Himalayas
AmeriSave is a mid-size financial services company running a high-volume Microsoft SQL Server environment, and we are investing heavily in the long-term stability, transparency, performance, and scalability of our data platform. We are hiring a senior, hands-on engineer to lead that effort.
This is a combined reliability-and-performance role for an engineer who is equally comfortable owning the observability and incident-response practice across the estate and getting deep into execution plans and wait statistics to keep the platform fast and resilient underload. You will be the technical center of gravity for the database platform: the person who ensures we see issues early, leads the response when they arise, and engineers durable solutions so they do not recur.
Responsibilities:
• Manage SQL Server databases on Prem and in Azure cloud environments (Iaas/PaaS)
• Recommend short-term and long-term strategic plans to ensure database infrastructure meets existing and future requirements.
• Define and propose policies, procedures, and associated maintenance plans for DBMS resource administration and appropriate use.
• Configure and maintain database servers and processes
• Monitor system's health and performance
• Ensure high levels of performance, availability, sustainability and security
• Analyze, solve, and correct issues in real time
• Provide suggestions for solutions
• Refine and automate regular processes, track issues, and document changes
• Assist developers with query tuning and schema refinement
• Provide 24x7 support for critical production systems
• Perform scheduled maintenance and support release deployment activities after hours
• Off-Hours production support (call rotation) is required for this position.
Requirements:
• 7+ years of experience as a SQL Server DBA
• SSIS, SSAS, and SSRS administration
• Experience with Performance Tuning and Optimization
• Database stored procedure, trigger, and index creation and tuning
• Experience with backups, restores and recovery models
• Experience of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
• Experience supporting a development team in a production environment
• Strong troubleshooting with SQL Server Profiler, Database Engine Tuning Advisor, Performance Monitor, and Query Store
• Database stored procedure, trigger, and index creation and tuning
• Failover Clustering (Always On: FCI & AG) design and configuration
• Sense of ownership and pride in your performance and its impact on company's success
• Critical thinker and problem-solving skills
• Team player
• Good time-management skills
• Great interpersonal and communication skills
• Experience with Azure SQL (preferred)
• Experience with Foglight, Redgate, and other SQL Server 3rd party tools (preferred)
• Certifications are a plus
• High-speed internet required for remote work, Cable or Fiber ONLY with the ability to connect via Ethernet. Minimum speeds: 70/30 Mbps (basic), 200-300/35-70 Mbps (shared), 500-1,000/100+ Mbps (heavy use).
**Please note that the compensation and benefit information that follows is a good faith estimate for this position only and is provided pursuant to applicable state and local laws on pay transparency. It is estimated based on what a successful applicant in the relevant state might be paid. **
Compensation:
The annual compensation for this position generally ranges from between $115,000 - $150,000.
Benefits:
· 401(k)
· Dental insurance
· Disability insurance
· Employee discounts
· Health insurance
· Life insurance
· Paid time off
· 12 paid holidays per year
· Paid training
· Referral program
· Vision insurance
Supplemental pay types:
· Referral bonuses
AmeriSave is an equal opportunity employer. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.
California Consumer Privacy Act Disclosure Acknowledgment
Employment Applicants, New Hires, and Employees Residing in California
AmeriSave Mortgage Corporation’s Privacy Policy Statement (“Policy”) can be reviewed here:www.amerisave.com/privacy-policy
AmeriSave Mortgage Corporation’s California Consumer Privacy Act (“CCPA”) Recruitment Disclosure can be reviewed here:
When AmeriSave’s Human Resources Department makes future requests for personal information, the same Policy is applicable. By applying, you understand this acknowledgment covers current and future personal information requests. You also acknowledge the business purpose of the personal information collected and that future requests may occur while applying for a position at AmeriSave and/or during employment, if applicable.
Originally posted on Himalayas