Senior SQL Database Developer

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.Team/Department Description:

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.

Strategic Imperative:

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

Primary Objectives:

1. Design database schemas, tune poorly performing queries, improve data access patterns from applications.
2. Responsible for the research and planning, development, implementation, utilization, monitoring, and administration of databases, primarily MS SQL Server.
3. Responsible for the integrity, efficiency, and documentation of the databases.
4. Establish and enforce written guidelines, rules, and standards.
5. Mentor to other members of the team. 

Qualifications - To perform this job successfully, an individual must be able to perform each essential job duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Essential Position Duties (typical monthly, weekly, daily tasks which support the primary objectives):

• 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 propose solutions to address those concerns.
• Respond to requests for data from internal users in a timely fashion.
• Perform regular database health checks. 
• Be in an on-call rotation to ensure 24-hour uptime and address after hours issues.

Required Education and/or Experience:                  

• Bachelor's degree in Computer Science or a related field or equivalent years’ experience. 
• Five or more (5+) years in Database Design, Development, Transact SQL 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) in a 24-hour OLTP environment.
• Experience with Amazon Web Services.

Skills and Knowledge:

• Excellent analytical, Interpersonal and Communication skills, fast learner, hardworking and good team player.
• Expert in database Performance Tuning and Query Optimization. 
• Expert in writing T-SQL, including complex stored procedures, functions, and views.
• Knowledgeable of high availability and disaster recovery solutions with SQL Server Availability Groups and Database Mirroring.
• Good knowledge of configuration management concepts, release management, change management concepts, industry standards and best practices.
• Proficiency in writing documentation for processes and procedures.

Computer/Software/Application Proficiency:              

• Proficiency in security concepts as they relate to SQL Server.
• Proficiency in day to day monitoring of system performance using tools such as SentryOne, Database Performance Analyzer, New Relic, and CloudWatch.
• Proficiency with Data Warehouse concepts and implementation to provide reporting solutions for the organization. Experience with Data Warehouse platforms such as Redshift and reporting tools such as SSRS and Looker.
• Proficiency in creation of SSIS packages for transferring data from various data sources such as PostgreSQL, SQL Server, Redshift, and text files.
• Proficiency in using Excel to create Pivot tables.

Travel Requirements: 

• None

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