This is a remote position, but please be aware that you must reside in one of the following states: PA, NJ, NH, DE, CO, SD, TX, WY, AK, FL or Canada.

This is truly a Senior level position!  Ideally 10+ years of experience is needed for this position!

The Senior Database Administrator is an expert in SQL Server database systems, configuration best practices, and performance optimizations. They are responsible for proactively monitoring production database systems, resolving performance issues, optimizing existing systems and collaborating with the development and operations teams. They coordinate database deployment tasks with project managers and work closely with the development and operations teams on database projects. They serve as an authority on database best practices and inform proper database design, implementation, configuration, security, backup and maintenance.

Responsibilities: 

• Administer database environments to ensure availability, security, integrity and recovery
• Ensure consistent configuration of all database servers and adherence to configuration best practices
• Monitor production database systems and proactively mitigate performance and configuration issues
• Ensure appropriate SQL maintenance plans are implemented, scheduled, optimized and run
• Analyze database performance, identify performance bottlenecks, implement optimization strategies through indexing, query tuning and other techniques
• Proactively plan for and lead projects for database growth, updates, upgrades, security enhancements, performance enhancements, and scalability enhancements
• Support the IT/Operations team on production issues, deployments, server maintenance, Disaster Recovery (DR), backups and other production service requests
• Support development team activities including but not limited to: creating new databases, performing database backups, restores, and deployments, troubleshooting connectivity issues, assigning permissions, and informing system designs
• Develop and implement backup and recovery procedures to ensure data availability in the event of system failure or disaster
• Collaborate with the analytics team to define and implement data warehousing strategies
• Participate in regular sprint planning, retrospectives, daily scrum and other group functions as part of agile development teams
• Serve as a database authority and mentor team members on database best practices to inform proper database design and performant SQL implementations
• Implement database changes and upgrades while minimizing downtime and data disruption
• Position may require off-hour work during releases, outages or other critical initiatives

Requirements:

• Expert managing Microsoft SQL Server implementations in a large scale multi-tenant enterprise environment
• Expert in diagnosing performance and configuration issues
• Expert in Microsoft SQL Server configuration best practices including operating systems, security, disk, memory and processing
• The ideal candidate:
  • Will be able to work independently as well as in a group
  • Will suggest improvements to both the technology and business functionality of the product
  • Will estimate work activity, and deliver high-quality, low-defect engineering work product within established timelines and will ensure effective information flow throughout 
  • Will have excellent communication skills, a strong work ethic, good time management and decision making capabilities

Education and Experience: 

• 10+ years of experience administering Microsoft SQL Server in an enterprise environment
• 10+ years of experience designing and implementing databases in an enterprise environment
• Bachelor’s degree in Computer Science or equivalent in a related field
• Experience working with Azure VM, Azure SQL, Azure Managed instances