CopperPoint has an exciting opportunity for a fully remote Senior Database Administrator (MS SQL Server) to join our team. The ideal candidate will be responsible for the design, implementation, maintenance, and optimization of our Microsoft SQL Server databases. They will ensure database performance, security, and availability, supporting critical business applications and contributing to the overall success of our IT operations.
Job responsibilities:
Database Administration:
- Install, configure, and maintain Microsoft SQL Server instances.
- Design and implement high-availability and disaster recovery solutions (e.g., Replication, Clustering, Log Shipping).
- Monitor database performance, implement performance tuning, and optimize queries.
- Perform capacity planning and ensure efficient resource utilization.
Backup and Recovery:
- Develop, test, and maintain backup and recovery strategies.
- Ensure database resilience through regular testing of disaster recovery plans.
Design and Development:
- Collaborate with developers to design and optimize database schemas, indexes, and stored procedures.
- Provide database expertise during application development and deployment phases.
Monitoring and Troubleshooting:
- Utilize monitoring tools to ensure database health and performance (e.g., SQL Server Profiler, Extended Events, or third-party tools like SolarWinds).
- Diagnose and resolve complex database issues, including performance bottlenecks, replication errors, and deadlocks.
Documentation and Reporting:
- Maintain comprehensive documentation for database configurations, policies, and procedures.
- Generate and analyze database performance reports for stakeholders.
Team Collaboration:
- Act as a mentor and provide technical guidance to junior DBAs.
- Collaborate with cross-functional teams, including developers, system administrators, and business analysts.
Qualifications/Competencies:
- Preferred: 8+ years’ experience in the field or in a related area.
- Requires in-depth knowledge of principles, practices and theories in professional database administration discipline.
- Provides high level database validation approaches based on a specific database
- Defines best practices and standards for back-end validation
- Guides & trains associates on in-depth database concepts and data processing mechanism
- Acts as a mentor for others on SQL coding and related tools
- Has working knowledge of tools and techniques required for area(s) of responsibility
- Has conceptual knowledge of varying Database technologies and the ability to make decisions based on that knowledge
- Experience administering multiple relational databases such as Oracle, MS SQL, MySQL, and PostgreSQL is a Plus
- Strong analytical and troubleshooting skills
Salary Range:
- $102,700 - $143,200 annually
- Compensation may vary depending on skills, experience, education, and geographical location.
- In addition to base salary, compensation may include an annual discretionary bonus.
Benefits:
- Employees and their families are eligible to participate in CopperPoint Insurance Companies benefit plans including medical, dental, vision, short-term disability, long-term disability, life insurance, a health savings account, a flexible spending account, and a 401k plan.
- We provide some benefits at no cost to the employee (Basic Life Insurance and AD&D at two times an employee’s annual salary, Short- and Long-term Disability coverage, and Employee Assistance Plan).
- Employees will accrue 0.0846 hours of Paid Time Off (PTO) per paid hour, which may total 22 days a year. In addition, employees will also receive 10 paid holidays throughout the calendar year.
Founded in 1925, CopperPoint Insurance Companies is a leading provider of workers’ compensation and commercial insurance solutions. With an expanded Line of insurance products and a growing ten-state footprint in the western United States, CopperPoint embodies stability for policyholders in Alaska, Arizona, California, Colorado, Idaho, Nevada, New Mexico, Oregon, Utah, and Washington. CopperPoint Mutual Insurance Holding Company is the corporate parent of Arizona-based CopperPoint Insurance Companies, California-based Pacific Compensation Insurance Company, Alaska National Insurance Company, and other CopperPoint Insurance Entities.
CopperPoint’s culture of compassion extends to the community through employee volunteerism, corporate matching, Board service, program sponsorships and in-kind contributions. We empower employees by providing 12-hours of paid volunteer time annually and matching their personal contribution to the charities of their choice up to $500 per year. In 2020, CopperPoint employees reported 3,500 volunteer hours.
CopperPoint offers a competitive compensation package and comprehensive benefits package including major medical, dental, vision and a wide range of competitive benefits programs, generous matching contributions to your 401(k) plan, generous paid time off, tuition reimbursement and other education benefits and business casual dress. CopperPoint is an equal employment opportunity employer. All qualified applicants will receive consideration without regard to race, color, sex, religion, age, national origin, disability, veteran status, sexual orientation, gender identity or expression, marital status, ancestry or citizenship status, genetic information, pregnancy status or any other characteristic protected by state, federal or local law. CopperPoint maintains a drug-free workplace.
