Database Engineer (PostgreSQL/MSSQL)

Auctane; Wrocław; Hybrid; PLN 180,000 - 280,000; Full time

Benefits offered by this job

Hybrid work model

Training budget

Private medical insurance

Life insurance

Multisport card

Volunteer day

Vacation days

NGO donation matching

Employee Assistance Program

Annual salary review

Referral bonus

Nice office in Wroclaw and Zielona Gf

Job summary

Auctane in Wroclaw is looking for a Database Engineer to design, implement, maintain and optimize relational databases (Postgres and SQL Server) hosted in AWS. You will ensure the integrity, availability and high performance of critical data to support operations across the business.

You will develop schemas, implement security, backups, and monitoring, collaborating with developers to align data structures with product needs.

Qualifications

• Bachelor's degree in CS/IT or related field.
• Strong knowledge of PL/pgSQL and T-SQL.
• Experience with AWS RDS and database design principles.
• Knowledge of security, backup and disaster recovery practices.

Responsibilities

• Develop database schemas, tables and indexes for performance and integrity.
• Implement and maintain database security, including authentication and encryption.
• Analyze and interpret performance metrics to identify improvements.
• Monitor and troubleshoot slow queries, locks and resource contention.
• Tune indexes, queries and configurations to improve scalability.
• Write and optimize SQL queries and stored procedures.
• Configure replication, clustering or failover for resilience.
• Review code for database best practices and performance guidelines.
• Collaborate with developers to align schemas with requirements.
• Assist in backups, recovery and disaster planning.
• Stay updated on new database technologies and best practices.

Skills

PL/pgSQL

T-SQL

PostgreSQL

SQL Server

AWS RDS

Database security

Performance tuning

Data modeling

English communication

Education

Bachelor's degree in Computer Science/Information Technology or related field

Tools

AWS RDS

SQL Server

PostgreSQL

Job description

At Auctane, we are united by a passion to help businesses deliver — whatever their size, wherever they are, and however they operate. We make it possible for businesses to meet the ever-changing requirements of their industry and customer expectations. Auctane products enable hundreds of thousands of businesses to annually mail and ship billions of items — over $200 billion worth — to recipients around the globe.

The Auctane family of mailing and shipping software products includes ShipStation, Stamps.com, ShipStation API, Metapack, GlobalPost, and Packlink. Our partners include Amazon, UPS, USPS, eBay, BigCommerce, Shopify, WooCommerce, and Walmart.

Our values

Win as One. Delight Customers. Deliver Great Outcomes.

About the role

As DBE, you will be responsible for the design, implementation, maintenance, and optimization of the organization's relational database systems. This role will ensure the integrity, availability, and performance of critical data to support business operations and decision-making processes. The DBE will work closely with IT teams, developers, and business stakeholders to deliver efficient and scalable database solutions that meet the organization's current and future needs. The ideal candidate will have strong technical skills in Postgres and SQL Server database management systems hosted in AWS, excellent problem-solving abilities, and the capacity to translate business requirements into effective relational database solutions. This role will be critical in maintaining the organization's data infrastructure, enabling data-driven decision-making, and ensuring the optimal performance of mission-critical applications across the enterprise.

What will you be doing?

• Develop database schemas, tables, and indexes to optimize performance and ensure data integrity.
• Implement and maintain database security measures, including user authentication, access controls, and data encryption.
• Analyze and interpret database performance metrics to proactively identify areas for improvement
• Monitor database performance and troubleshoot issues such as slow queries, database locks, and resource contention.
• Identify and address performance bottlenecks through query optimization, index tuning, and database configuration adjustments.
• Optimize database indexes, query execution plans, and caching strategies to improve application responsiveness and scalability.
• Write and optimize SQL queries and stored procedures to efficiently retrieve and manipulate data.
• Configure and maintain database replication, clustering, or failover mechanisms to provide resilience against hardware failures, network outages, or natural disasters.
• Participate in code reviews to ensure adherence to database best practices, performance guidelines, and data access patterns.
• Collaborate with software developers to design database schemas that align with application requirements and development workflows.
• Work closely with application developers to optimize SQL queries, data access patterns, and database interactions for maximum efficiency.
• Perform regular backups and disaster recovery procedures to ensure data availability and integrity.
• Stay abreast of emerging database technologies, trends, and best practices through self-study, training, and participation in industry forums and conferences.

What are we looking for?

• Bachelor's degree in Computer Science, Information Technology, or a related fieldIn-depth knowledge and proficiency in PL\pgSQL and T-SQL
• Strong understanding of database design principles, including normalization, indexing, and data modeling
• Knowledge of database security best practices and experience in implementing security measures such as user authentication, access controls, encryption, and auditing are important
• Knowledge of the AWS RDS solution
• Strong troubleshooting and problem-solving skills
• Effective communication and collaboration skills
• Communicative level of English
• Oracle
• Amazon Web Services
• C# .Net

Hybrid Framework - The best of both worlds! Work from home when you need focus and flexibility, and spend 2 days a week in the office for face-to-face collaboration, sharing ideas and catching up with the team. Because some things are simply better together!

Personal Training Budget. Up to 7.000 year training budget (certifications, conferences attendance, etc.) to invest in your professional development. We want to help you improve your technical skills, feel involved in the product community, and develop your soft skills to lead teams and manage other stakeholders.

Internal and external training, free access to online training platforms such as Linkedin Learning

Languages classes every week. Thirsty for knowledge? Learn a new language by joining our free English/Spanish/German classes. You can connect and enjoy taking up a new language or improving your current skills with one of our great instructors.

Lunch card. Enjoy a subsidized lunch card and grab a meal with your teammates — because the best conversations often happen over lunch!

Free private medical insurance. Take care of your health with private medical care fully covered by us

Attractive life insurance. Extra peace of mind for you and your loved ones.

Co-financed Multisport card - We support an active lifestyle because staying healthy and feeling good matters.

Volunteer day. You can take 16 hours per year in order to participate in volunteering activities! We will love to see some pictures in our slack!

Up to 30 days of vacation per year (additional days are granted along with seniority at AUCTANE).

Up to 1000 PLN/year PLN/year to match your NGO donations!

We have an Employee Assistance Program with psychological assistance free of charge for you and your loved ones.

Annual Salary Review: We are reviewing the salaries of all our teams annually in order to evaluate an increase according to individual performance and the business results.

Referral Fee We need your support in hiring top-class talent! We offer a referral bonus of 4k-20k PLN, depending on the complexity of the role and the hiring process.

An inclusive and upbeat work environment Leave your suit behind... we’re a t-shirt and converse 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 20 nationalities that speak 10 languages. Our company language is English and all internal communication and company-wide meetings are in English.

Company events We do our best every day, even at our regular team-building events.

Nice Office in Zielona Gora and Wroclaw (free drinks, snacks…)

Interested in building your career at Auctane ? Get future opportunities sent straight to your email.