Senior Database Administrator

About us

At Auctane, we are united by a passion to help sellers — wherever they are, however they operate — fulfill the promises they make to consumers. The Auctane mission is to fuel commerce through exceptional delivery. We make it possible for businesses to meet the ever rising expectations of their customers, and we make the world smaller and more accessible to consumers everywhere. Auctane brands enable hundreds of thousands of merchants to annually deliver billions of products — over $200 billion worth — to customers around the globe. And Auctane is just getting started.

Auctane is a team of shipping and software experts with a passion for helping merchants move their ideas, dreams and innovations around the globe. The Auctane family includes ShipStation, ShipWorks, ShipEngine, ShippingEasy, Stamps, Endicia, Metapack, Shipsi, GlobalPost, and Packlink. Our partners include Amazon, UPS, USPS, eBay, BigCommerce, Shopify, WooCommerce, and Walmart.

Our values

About the role

As a Senior Database Administrator (DBA) and member of the Engineering Operations team, this individual is responsible for the research and planning, development, implementation, utilization, monitoring, and administration of databases, primarily MS SQL Server. They are also responsible for the security, integrity, efficiency, scheduling, and documentation of the databases. They will establish and enforce written guidelines, rules, and standards.

About the Team

The Auctane Engineering Operations team is empowered with providing a world class software production system. This team ensures that our customers experience a fast and reliable system and provides our engineering teams with the tools to deploy, monitor, and maintain our production systems.

What will you be doing?

• Perform day to day and long term monitoring of system health as it relates to database usage and performance.
• Perform research into database performance issues and come up with solutions to address those concerns.
• Respond to requests for data from internal users in a timely fashion.
• Perform database health checks using SQL profiler, performance monitor, performance counters and DBCC commands.

What are we looking for?

• Excellent analytical, Interpersonal and Communication skills, fast learner, hardworking and good team player.
• Expert in database Performance Tuning, using tuning methodology, including enterprise manager, query plans, performance views, trace files and other SQL Server tools.
• Expert in writing T-SQL, including complex stored procedures, functions, views and triggers.
• Good knowledge of configuration management concepts, release management, change management concepts, industry standards and best practices
• Able to create effective Backup and Recovery plans by Transactional Log and Full Database Backups.
• Knowledgeable of high availability and disaster recovery solutions with SQL Server Failover Clustering, Database Snapshot, Log shipping and Database Mirroring.
• Knowledgeable with Data Warehouse concepts and implementation to provide reporting solutions for the organization.
• Knowledgeable in creation of SSIS packages for transferring data from various data sources like Oracle, MS Access, MS Excel and Text files.
• Strong ability to use Excel to create Pivot tables and accessing multidimensional cubes from Excel.

What will make you stand out?

• Bachelor's degree in Computer Science or a related field preferred.
• Five or more (5+) years in Database Design, Development, Administration of MS SQL Server in Production, Development and QA environments.
• Experience in fine tuning indexes for performance improvement.
• Experience implementing data partitioning to improve performance.
• Experience with very large databases (VLDB)
• Experience in security concepts as they relate to SQL Server.

The Tech

• SQL Server
• SQL Sentry, New Relic, and CloudWatch.
• SQL Server Failover Clustering, Database Snapshot, Log shipping, and Database Mirroring
• Data Warehouse platforms such as Redshift and reporting tools such as SSRS and Bime.
• Various data sources like Oracle, MS Access, MS Excel and Text files.

What do we offer?

• Discount on your personal shipment orders via and GlobalPost.
• Charitable donation matching We are happy to support your initiatives by duplicating the amount donated.
• Volunteer day. You can take 1 day off per year in order to participate in volunteering activities We will love to see some pictures in our slack
• Referral Fee We need your support in hiring top-class talent We offer a referral bonus of 500-5K, depending on the complexity of the role and the hiring process.
• Great work-life balance. We offer a flexible work schedule and will do our best to adapt to your situation. Working in a fast-paced environment can be intense, but that doesn't mean you shouldn't enjoy your free time
• An inclusive and upbeat work environment Leave your suit behind... business casual, jeans accepted kind of place More importantly, our company culture promotes diversity and inclusion. The personality and opinions of each of our team members are important and valid, and we aim to offer all employees a safe environment where they can be themselves and thrive.
• A cross-cultural atmosphere We are a truly international team of over 20 nationalities that speak at least 10 languages. Our company language is English and all internal communication and company-wide meetings are in English.
• Company events Work hard, play hard We do our best every day, even at our regular team-building events.
• Internal and external training, free access to online training platforms such as LinkedIn Learning.
• We are a hybrid company. All team members at Auctane in Austin come into the office Tuesday-Wed-Thursday.
• � We offer 10 paid days off for U.S. holidays throughout the year
• Health and Wellness: The well-being of our team is super important to us. Choose from different options that help you focus on your health.
• Take the reins of your time off with our flexible PTO policy – because work-life balance should always be in your hands
• Attractive office space in the heart of central Austin, Texas (free drinks, snacks...)
• Indulge in weekly catered lunches at our office – a delicious perk to fuel your work.
• Free garage parking directly across from the office building.
• Fitness center in the office with Tonal Mirrors, Peletons, free weights, etc.
• We offer a gym discount program to help you stay fit and healthy
• Find your zen right at the heart of our Austin office with weekly onsite yoga sessions – because balance is key to our vibrant workplace culture
• 401k employer matching program – because your future deserves a friendly boost
• We offer education reimbursement to all employees, ensuring that you can pursue your educational goals while excelling in your career with us. Invest in your future and let us support your growth every step of the way.
• We've got your furry friend covered with pet insurance discounts.
• Have a helpful legal sidekick right in your back pocket with our free access to Rocket Lawyer.
• Get ready for hassle-free healthcare from the comfort of your couch – we offer free Telehealth services to keep you feeling your best
• Treat yourself to relaxation on the regular – enjoy a monthly discount at Massage Envy.
• Get ready to rock our brand with style – we've got awesome company swag to offer
• We conduct annual merit reviews to recognize and reward your hard work and achievements.
• BenefitsHub platform to obtain perks and discounts on auto/home insurance, pet insurance, travel, fitness, etc.
• Wellness programs with wellness discounts on medical benefit deduction and offers various company wellness activities/webinars and challenges such as Steps challenges and a Health Fair
• Health savings account employer contribution for HSA medical plan enrollees.

Additional Position Duties: (The following is a list of what all employees, except those with medical accommodation, may be regularly required to do.)

• Sit for prolonged periods of time
• Utilize wrist and hands for a prolonged period of time
• Walk short distances
• Stand for short periods
• Speaking and conversing with others
• Lift up to 25lbs without assistance up to chest height

Equal Opportunity Employer/Veterans/Disabled

If you are based in California, we encourage you to read this important information about the ShipStation Privacy Policy for California residents linked here.