SQL Database Administrator
PEAK6 was brought to life by the idea that success is driven by a strong collaborative process. The passion for that idea powers our firm still, 20 years later. As a SQL Database Administrator at PEAK6, you’ll be integral to maintaining and improving the firm’s processes and procedures by collaborating with technology to advance the firm’s position as an innovative leader in the industry.
You’ll be responsible for:
- Ongoing support and administration of existing production, staging, QA and development multi-terabyte database environments
- Configure and Support Availability Group Mirroring
- Provide database support to ensure high availability and best sustainable performance
- Review SQL code and implement all changes to the development and production databases
- Work with development teams to optimize queries and stored procedures used in custom applications
- Implement and support SSRS for both report creation and administration
You’ll gain loads of experience in this role but before you do, you should have:
- Advanced understanding of relational database/schema design, SQL query and stored procedure development and enhancement
- Must have good understanding of SQL Transaction Replication
- Knowledge of disk subsystems and performance tuning/monitoring in a SAN environment
- Experience working with Idera SQL Diagnostic Monitor is a plus
- Ability to manage multiple, simultaneous issues
- Excellent communication and interpersonal skills
- Solid problem solving skills
- Strong scripting skills required - Bash/Python
All of our team members have these traits. You should, too.
Collaboration Grit
Adaptability Ownership
Life at PEAK6
We want you to like coming to work so we work really hard to make your job fun and different from any other.
As a SQL Database Administrator, you can enjoy:
- Generous medical, vision and dental plans
- Matching 401(k) programs
- Adoption assistance & family leave
- Sabbatical program
- Speakers Series
- Massage days
- Poker tournament with a grand prize of a World Series of Poker buy in
- Sports leagues
- Cornhole tournaments
- Annual PEAK6 Party
- Yoga classes
- Tuition reimbursement
- Lasik eye discount
- Philanthropy events
- Annual wellness screens and flu shots
- Bagel Fridays/expiration lunches
- Birthday gifts
- Charitable matching gift program