Senior SQL Database Administrator
Job Description
SofterWare is on the “Philly.com Top Workplaces” list for the seventh time! We have enjoyed over 35 years of continuous growth because our employees and customers are happy. Our employees are offered a challenging and rewarding career along with a generous benefits program. SofterWare is a fun place to work and we support a work-life balance.
We offer benefits such as time off to volunteer, meditation classes, and a casual dress environment. In addition, we enjoy company events like a family Halloween open house and an annual holiday party. Our open office is state of the art and provides you with access to a gym, cafeteria, and walking trails, which will keep you energized.
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
Reasonable accommodations may be made to enable individuals with disabilities to perform these essential functions.
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 Amazon AWS/EC2 or RDS virtualized environment a plus
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.
"Life at SofterWare is rewarding in many ways. The flexible work schedules allow for a great balance outside of the office. In daily activity, I love working with knowledgeable members from all departments when troubleshooting issues as well as gaining insights for improvements to the current products and future enhancements. I have found that my coworkers have great knowledge of the fundraising industry and they enjoy sharing that experience to make our products the best they can be. "
Matt Krout
Product Developer