Who We Are:

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.

Auctane's Values

The Customer is our mission.

Our company was built in service of our customers. Every time we answer the phone, write a line of code, hire a new team member, form a partnership, or build a new interface it is explicitly because we believe that action will improve the life of our customers.

We work with the best people.

We will only work with people who are enthusiastic about their work, respectful of diverse ideas and backgrounds, and who possess the ability to work both independently and as part of a team.

We only play offense.

We're on a mission to reach and help every mailer, shipper and merchant on the planet. Because of this we move with urgency, take risks, and are determined to ship solutions quickly.

We expect exceptional outcomes.

We are a rapidly growing company with intent. We expect to continue to deliver market transforming solutions for our customers and challenging growth opportunities for our employees.

We are direct and authentic.

We have a genuine empathy for our employees, partners, and customers. We serve that empathy by treating everyone the way we would like to be treated - openly, ethically, and honestly. We set expectations clearly and hold ourselves accountable to what we commit.

About The Team:

The Auctane Engineering Tech and Data team does one thing first - provide our customers with world class production software. 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.

About The Role:

The SQL Server Database Administrator (DBA) position is a unique opportunity for an individual with prior experience seeking new challenges and an opportunity to further develop his/her SQL Server database administration skills. The successful candidate will be responsible for:

• Monitoring, maintaining, and supporting all SQL Server databases
• Maintaining reliability, stability, and data integrity of the databases
• Providing support in the administration, backup, and security of various SQL databases
• Responsible for database tasks from software upgrades and server patching, to troubleshooting and configuration of new servers, and,
• Continually assess, improve, and optimize our current database environment

Primary Objectives:

• Monitor performance of database systems resources and query throughput
• Monitor and maintain database maintenance tasks for backups, indexes, and statistics
• Manage SQL Server Installations, Upgrades, Migrations and Configurations
• Install database software service packs and cumulative updates as necessary
• Maintain database documentation as required
• Maintain and administer database security access
• Troubleshoot and resolve database connectivity and performance issues
• Follow Change Management processes to implement database changes
• Proactively monitor and respond to MSSQL database Alerts.
• On-call requirements to ensure 24 x 7 support of database operations
• Participate in continuous improvement efforts in enhancing database performance and providing increased functionality, including performing maintenance, monitoring activity, and documenting problems, changes, and solutions
• Manage the storage environments of the databases, including optimal sizing, monitoring space, adding additional storage, and providing growth statistics.
• Create tables, views, indexes, views, stored procedures, and other database objects as needed.
• Perform routine backup and recovery testing, including testing and documenting recovery scenarios.
• Work with application/development teams to assist in overall database design, helping developers tune queries, design proper indexes, and aiding developers in the creation of stored procedures.
• Extract data from the database servers and load into the data warehouse

What We Are Looking For:

• 2 years experience as a database administrator in a SQL Server environment
• 2 years experience in Transact SQL, SSIS package development
• 2 years of SQL Server database development
• Experience administering SQL Server 2014, 2017, 2019 databases
• Experience with Monitoring & Diagnostic tools
• Bachelor's Degree (BS/BA) or equivalent combination of education and experience.

What will Make You Stand Out (if applicable):

• Prior experience with Amazon Web Services (AWS)
• Experience working with PostgreSQL databases
• Experience working with Windows server, Active Directory, and disk configurations
• Experience in fine tuning indexes for performance improvement.
• Experience with very large databases (VLDB)
• Experience in security concepts as they relate to SQL Server.

The Tech:

• SQL Server
• SentryOne, New Relic, Solarwinds DPA, and CloudWatch.
• Windows Server Failover Clustering, Availability Groups, and Database Mirroring
• Data Warehouse platforms such as Amazon Redshift and reporting tools such as SSRS and Looker.
• Various data sources such as MS SQL Server, PostgreSQL, Excel, Text Files, and Amazon Redshift.

Travel Requirements (if applicable):

• None

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.

#LI-AK1