Note: The job is a remote job and is open to candidates in USA. PayTrace by North provides payment and ACH processing, virtual terminals, and payment automation solutions for B2B companies. The Senior Database Administrator will own and support the company’s database environment, including provisioning, maintenance, performance tuning, security, modernization, disaster recovery, and migration to AWS RDS. The role also supports development teams, data pipelines, business intelligence reporting, and business-critical operations.
Responsibilities
- Create and maintain databases and hosts for Production, Development, and various Test environments
- Ensure database availability and recoverability meet established Service Level Agreements (SLAs) and guidelines
- Rapidly and accurately resolve database issues utilizing all available tools
- Continuously monitor and tune database performance. Ensure integrity and availability of all resources, systems, and key processes, including reviewing logs and verifying that scheduled jobs (e.g., backups) are complete
- Perform periodic performance reporting to support capacity planning
- Available to address production issues which may require evening, overnight, weekend, and holiday work
- Automate system administration with a focus on resource efficiency and scalability
- Design, implement and maintain database security based on best practices, company security standards and regulatory compliance
- Provide solutions to development teams when proposed architecture does not support technology strategy
- Assist developers with designing and tuning database queries and procedures
- Understanding of Technology vision, strategy, infrastructure standards, database platforms, programming languages, and observability and monitoring tools
- Migrate legacy database structures to support the modernization of the payment processing platform using microservice architecture
- Support the Disaster Recovery (DR) strategy and a multi-region active-active setup
- Support data pipeline automation to Snowflake
- Create and assist users in creating Business Intelligence (BI) reporting
- Provide technical guidance to data stakeholders
- Regularly update and review contributions to operational, configuration, and other procedural documentation
- Make rapid, well-informed, independent judgments in support of PayTrace’s business-critical systems
- Perform other tasks as assigned by management such as running various reports for the leadership team and data stakeholders
Skills
- + Bachelor's degree in Information Technology/Computer Science or an engineering field
- + Minimum of 5 years of experience supporting databases in an enterprise environment, with at least half of that time primarily in a PostgreSQL environment
- + Solid knowledge of PostgreSQL version 15.x and MS SQL 1219/2022, with the ability to share that knowledge
- + Experience supporting a Relational Database Management System (RDBMS) in both Linux and Windows environments
- + Proven experience with Amazon Web Services (AWS) technologies: Postgres RDS, SQL Server RDS, Aurora RDS and EC2
- + Experience with Database High Availability / Replication technologies (e.g., AlwaysOn, Postgres HA)
- + Scripting and automation experience
- + Experience with troubleshooting problems and formulating resolutions with IT systems and individuals
- + Ability to interact with a variety of clients in a clear, concise, and professional manner
- + Solid understanding and working knowledge of the complete systems development and deployment lifecycle
- + Working knowledge of all facets of systems administration in a large-scale IT operations unit
- + Ability to make effective decisions in high-pressure situations with limited management escalation
- + Exceptional written and verbal communication skills
- • Experience with Microsoft / Linux administration
- • AWS Certification is a plus
- • Microsoft MCDBA is a plus
Company Overview