Senior/Lead Database Administrator (PostgreSQL)
About the Company:
NRS is seeking a Senior/Lead Database Administrator to join their NRS Team. The NRS point-of-sale (POS) solution comprises devices deployed at customer locations that interact with cloud-based services. With over 30,000 customers across the US, NRS requires a dedicated resource focused on the design, configuration, scalability, and performance tuning of the Postgres RDS instances that are core to their cloud infrastructure.
Role and Responsibilities:
- Design, implement, and maintain PostgreSQL databases (self-hosted and RDS).
- Support multiple environments and teams.
- Monitor database performance and proactively identify and resolve issues.
- Optimize queries and database schema for performance and scalability.
- Plan and execute upgrades.
- Manage database schema changes, database splits, migrations, and improvements.
- Collaborate with developers, QA, DevOps, data teams, and others.
- Provide reporting and analytics support.
- Handle data archiving, migrations, import, export, and other related tasks.
- Develop and maintain disaster recovery plans, including backups, replication, and failover strategies.
- Manage database security, including access controls and compliance.
- Perform capacity planning and cost management.
Requirements:
- Experience with PostgreSQL administration.
- Experience with AWS RDS for PostgreSQL, including parameter groups, snapshots, and monitoring.
- Advanced knowledge of SQL for querying, optimization, and troubleshooting.
- Proficiency in performance tuning, vacuuming strategies, indexing, and partitioning.
- Experience with high availability, read replicas, and failover strategies.
- Scripting experience for automation.
- Experience with backup and disaster recovery strategies.
- Experience with monitoring tools.
- Familiarity with other database technologies.
- Experience migrating from self-hosted to RDS or vice versa.
- Strong communication and documentation skills.
- Analytical mindset and attention to detail.
- Ability to work independently and collaboratively.
- Comfortable in a fast-paced, iterative environment.
What We Offer:
- An exciting and challenging job with talented people.
- Competitive salary and growth opportunities.
- High-quality hardware.
- Remote work opportunity or hybrid work in Minsk.
- Reimbursement for sports activities.
- Medical insurance.
- 26 vacation days and 5 fully covered sick days per year without requiring sick leave.
- Excellent corporate English lessons.
