Job type full-time
Full job description
At jackson hewitt, we are working hard for the hardest working and we are on a mission to completely change the way our customers engage with their personal financesJackson hewitt combines the fun, fast-paced culture of a startup with the scale and reputation of one of the nation’s largest retailers (over 6,000 locations).
We have a passion for our employees and our customersWe recognize and appreciate that our team members are our single greatest competitive advantageBeing an industry leader requires a consistent focus on quality, innovation, performance and results.
This can be a hybrid/office or a fully remote role*
The senior sql server database administrator is responsible for administering microsoft sql servers, which includes implementation, performance tuning, ongoing maintenance, backup/recovery, security, auditing, production support, migration, providing on-call support and architecting adequate technical solutions that best suits jackson hewitt’s requirements and needs.
What you`ll do here:
Assume the subject matter expert role for established and new database technologies within the jackson hewitt technical infrastructure.
Architects, designs and deploys new, or modifications to, databases sql databases.
Create new database clusters and be responsible for ha/dr solutions using alwayson, replication, log shipping etcFor business continuity and data growth.
Supports sql server databases and ensures their performance, availability and security.
Develops the logical data model and the conversion of the logical model into the relational database model.
Provides leadership in the development, management, documentation and execution of business recovery strategies.
Leads and manages all data integrity and database tuning.
Responsible for data purging, archiving and retrieval as it relates to data stored in sql server.
Accountable for the uptime, performance and overall health of all sql servers and supporting systems and infrastructure.
Plans and implements upgrades, ensuring system integrity and monitoring and establishing security protocols.
Ensures availability and performance of the databases.
Participates in the creation of both the logical and physical data models.
Proactively monitors the database systems to ensure secure services with minimum downtime.
Manages sql server security.
Troubleshoots and problem solves sql development and sql server production issues.
Troubleshoot performance issues and suggest/implement optimizations.
Creates setup and monitors all sql server jobs.
Operationalize complex technical implementations by developing documentation, scripts, runbooks and conducting regular knowledge transfer sessions with operational support staff.
Other duties as assigned.
Skills you’ll bring for success:
Senior level preferred with at least 8+ years experience as a dba with ms sql server
8+ years experience tuning sql in ms sql platforms
Identify and champion strategic improvements to our database and processes
Knowledge of indexes, index management, statistics and related performance impacts.
Experience managing high volume, high concurrency environments and multi-tb oltp databases.
Experience designing and deploying automated alerts when errors occur, or performance moves below tolerable thresholds.
Experience in performance tuning and optimization (pto)
Experience with backups, restores and recovery models (native tools and quest litespeed)
Experience working in an amazon web services (aws) environment
Knowledge of high availability (ha) and disaster recovery (dr) options for mssql server, including always-on and clustering techniques / configurations.
Experience working with windows server including active directory security objects and storage configurations.
Excellent communication and documentation skills.
Knowledge of data warehouse design using dimension/fact-based models preferred.
Experience with ssas, ssrs, and ssis.
Experience with sql server monitoring toolsSentryone a plus.
Experience with windows powershell a plus.
Experience with splunk a plus.
Certification is a plus; mcts, mcitp.
What you will get if you join us:
Competitive salary + bonus
Unlimited paid time off + 11 paid holidays
401k + match
Medical, dental, and vision
Company celebrations and appreciation events
Fast-paced, innovative culture with an open and collaborative environment
Ample opportunity to develop core and new skillsets and have a stake in your own success
Freedom to create your best work and make a visible impact on the organization
Opportunities for advancement within the organization
We appreciate your interest in jackson hewitt tax serviceJackson hewitt tax service is an equal employment opportunity employerThe company’s policy is not to discriminate against any applicant or employee based on race, color, sex, religion, national origin, age (40 and over), disability, gender identity, sexual orientation or any other basis protected by applicable federal, state, or local lawsJackson hewitt tax service also prohibits harassment of applicants or employees based on any of these protected categoriesIt is also jackson hewitt tax service’s policy to comply with all applicable state and federal laws respecting consideration of unemployment status in making hiring decisions.