Note: The job is a remote job and is open to candidates in USA. PayTrace is a B2B payments expert transforming financial and accounting processes to future-proof businesses. The Senior Database Administrator will manage and maintain PayTrace’s database environment, ensuring performance, availability, and security while also supporting the modernization of the payment processing platform.
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
Benefits
- Pay within this range varies by work location and on job-related knowledge, skills, and experience. We look forward to discussing your salary expectations and our full total rewards offerings throughout the interview process.
Company Overview