PartsBase Inc.

Senior Database Engineer

PartsBase Inc.

full-time

Posted on:

Origin:  • 🇺🇸 United States

Visit company website
✨ AI Apply
Manual Apply

Job Level

Senior

Tech Stack

AWSAzureCassandraCloudDynamoDBETLGoogle Cloud PlatformMongoDBMySQLNoSQLOraclePostgresPythonSQLSSIS

About the role

  • Architect, manage, and optimize multiple Microsoft SQL environments and database instances, ensuring high availability, security, and performance.
  • Design and implement advanced performance tuning strategies, index optimizations, query rewrites, and automated monitoring systems.
  • Create and modify databases, write complex queries, develop stored procedures, and collaborate with other teams to integrate databases with applications.
  • Develop and enforce database security policies, access controls, and auditing measures to maintain compliance with industry standards.
  • Lead large-scale migrations and upgrades of SQL Server databases, ensuring minimal downtime and high data integrity.
  • Develop and maintain high-availability (HA) and disaster recovery (DR) solutions, including Always On Availability Groups, clustering, and failover strategies.
  • Optimize complex queries and stored procedures to enhance database efficiency and scalability.
  • Oversee and enhance SSRS and SSIS development, ensuring robust ETL pipelines and data reporting processes.
  • Collaborate with cloud engineers to design and maintain cloud-based database architectures in AWS, Azure, or Google Cloud.
  • Implement automation for database monitoring, maintenance, backups, and performance tuning.
  • Provide leadership and mentorship to junior DBAs and developers, sharing best practices and fostering database expertise within the team.
  • Stay ahead of industry trends and implement innovative database technologies to improve efficiency and scalability.
  • Document database architectures, processes, and security policies for ongoing maintenance and compliance.

Requirements

  • US Citizenship required due to data export control restrictions.
  • Proficient in Spanish and English.
  • Bachelor’s or Master’s degree in Computer Science, Information Systems, or related field.
  • Proven experience in high-availability (HA) and disaster recovery (DR) strategies, including Always On Availability Groups and cloud-based failover solutions.
  • Expert knowledge of SQL, T-SQL, stored procedures, indexing strategies, and execution plans.
  • 5+ years of experience in database engineering or administration.
  • Proficiency in SQL and experience with relational databases (e.g., PostgreSQL, MySQL, SQL Server, Oracle).
  • Experience with NoSQL databases (e.g., MongoDB, Cassandra, DynamoDB) is a plus.
  • Strong understanding of data modeling, normalization, and indexing strategies.
  • Hands-on experience with cloud platforms (AWS, Azure, or GCP) and database services.
  • Familiarity with CI/CD pipelines, version control (Git), and infrastructure-as-code tools.
  • Excellent problem-solving, communication, and collaboration skills.