Job Description
Company: PayTrace
Location: United States (Remote)
Workplace Type: Remote
Employment Type: Full-time
Pay / Compensation: $110,000 – $175,000
About the Role
PayTrace by North is seeking a Senior Database Administrator to serve as an essential member of the Technology team, taking ownership of PayTrace’s entire database environment. This role involves managing and maintaining production and development databases across multiple platforms, driving infrastructure modernization by migrating from legacy systems to AWS RDS, and ensuring high availability and robust data security for business-critical payment processing systems.
What You’ll Do / Key Responsibilities
- Database Management & Operations: Create and maintain databases and hosts for Production, Development, and Test environments, ensuring availability and recoverability meet established SLAs.
- Performance & Monitoring: Continuously monitor and tune database performance, review logs, verify backups, and perform periodic capacity planning and reporting.
- Architecture & Migration: Design and architect innovative database solutions, including modernizing the database infrastructure by migrating from MS SQL Server to AWS RDS.
- Automation & Security: Automate system administration for resource efficiency and scale, and implement robust database security based on best practices and regulatory compliance.
- Development & Disaster Recovery Support: Assist developers with designing and tuning database queries and procedures, support the Disaster Recovery (DR) strategy with a multi-region active-active setup, and support data pipeline automation to Snowflake.
- Production Support: Address critical production issues which may require evening, overnight, weekend, and holiday work.
Requirements & Qualifications
- Bachelor’s degree in Information Technology, Computer Science, or an engineering field.
- Minimum of 5 years of experience supporting databases in an enterprise environment.
- At least half of that time working primarily in a PostgreSQL environment.
- Solid knowledge of PostgreSQL version 15.x and experience supporting RDBMS in both Linux and Windows environments.
- Proven experience with Amazon Web Services (AWS) technologies, including Postgres RDS, Aurora RDS, and EC2.
- Experience with Database High Availability / Replication technologies (e.g., Postgres HA, AlwaysOn).
- Demonstrated scripting and automation experience.
- Exceptional problem-solving, decision-making, and communication skills in high-pressure situations.
Preferred / Bonus Qualifications (if applicable)
- Experience with Microsoft / Linux administration.
- AWS Certification is a plus.
- Microsoft MCDBA certification is a plus.
Benefits & Perks (profile notes)
- Comprehensive total rewards and salary packages.
Please note: North is a US-based company and this role is not eligible for current or future visa sponsorship.