Lead Data Platform – Database Engineer

This is a fully remote position, open to applicants in Florida.

📋 Description

• Take complete responsibility for TrustEngine's relational database and overall data environment from start to finish.

• Evaluate the current database setup.

• Prioritize and perform a critical operating system upgrade before the year concludes.

• Establish guidelines and standards to enhance the overall database environment.

• Act as the senior technical expert on data for both engineering teams.

• Manage Microsoft SQL Server, including comprehensive installation and configuration on self-hosted Windows Server environments.

• Conduct Windows Server administration, including operating system upgrades and migrations.

• Oversee SQL Server high-availability solutions, such as Always On Availability Groups and failover clustering.

• Administer MySQL.

• Manage AWS data infrastructure, including EC2, RDS, S3, IAM, and CloudWatch.

• Incorporate AI expertise into daily tasks.

• Enhance and maintain the production database environment to be suitable for clients, auditors, and insurers.

• Develop data standards and evaluate schema and data-access designs across application teams.

⛳️ Requirements

• Extensive and up-to-date experience in Microsoft SQL Server administration.

• Recent hands-on experience with complete SQL Server installation and configuration on a self-managed server — Windows Server on EC2 or on-premises — not utilizing managed services like RDS or Azure SQL.

• OS-level tasks on a live production instance.

• Proficient in Windows Server administration, including OS upgrades and migrations.

• Documentation of the most recent SQL Server upgrade, detailing source and target versions, whether in-place or side-by-side, the year, and the corresponding Windows Server version.

• Experience with SQL Server high availability, including Always On Availability Groups and failover clustering.

• Proficient in MySQL administration.

• Knowledge of AWS services: EC2, RDS, S3, IAM, CloudWatch.

• AI proficiency, such as with Claude, applied to daily tasks.

• Minimum of 7 years of professional experience.

• Previous end-to-end ownership of a production database environment, including evaluating an inherited setup and implementing measurable improvements.

• Experience in establishing data standards and reviewing schema and data-access design across application teams.

• Preferred experience in Snowflake administration and development.

• Familiarity with ETL pipelines and tools, such as Rivery and dbt.

• Experience in designing and developing data warehouses.

• Knowledge of data lakes on S3.

• Proficiency with BI/analytics tools, such as Metabase and QuickSight.

• Understanding of data governance and data quality practices.

• Experience with SQL Server migration to a managed service, such as RDS or equivalent.

🏝️ Benefits

• 100% Remote position, featuring a virtual office.

• Comprehensive Health Care Plan (Medical, Dental & Vision).

• Retirement Plan options (401k, IRA).

• Life Insurance coverage (Basic, Voluntary & AD&D).

• Flexible Paid Time Off (Vacation, Sick & Holidays).

• Family Leave policies (Maternity, Paternity).

• Short Term & Long Term Disability benefits.

• Opportunities for Training & Development.

• Access to Wellness Resources.