Senior Database Administrator (PostgreSQL)

Job Description

Join Our Team at Litera: Where Legal Technology Meets Excellence

Litera has been at the forefront of legal technology innovation for over 25 years, crafting legal software to amplify impact and maximize efficiency. Developed by the best legal minds in the industry, our comprehensive suite of integrated legal tools is both powerful and user-friendly and simplifies the way modern firms manage core legal workflows, secure collaboration, and organize firm knowledge and experience. Every day, we help more than 2.3 million legal professionals focus on their craft. Litera: Less busy work, more of your life’s work.

Overview: As a Senior Database Administrator (DBA), you will work to optimize the performance of Litera’s critical SaaS product databases and participate in making decisions about data flow patterns and database architecture. You will review database code and suggest improvements that align with industry best practices while still satisfying the intended business use case. This position requires a high degree of professional judgment and aptitude in troubleshooting issues, as well as balancing database workload performance with cost considerations

Key Responsibilities:

• Subject matter expert (SME) of PostgreSQL databases (cloud & on-premises)
• Participate in a 24x7 major incident on-call rotation
• Perform root cause analysis for major outages and incidents
• Participate in cross-functional teams to resolve critical production issues
• Perform database tuning and maintenance activities
• Analyze databases to ensure optimal performance and sizing
• Debug database code and resolve complex data problems
• Design new database schemas and data ingest strategies
• Document database design models, configurations, and processes
• Implement advanced security standards (row-level security & data encryption)
• Automate arduous database tasks
• Implement backup and recovery solutions
• Participate in business continuity and disaster recovery preparedness events
• Keep current on the latest database administration trends and practices
• Be a technical leader and respected team member

Qualifications:​

• 5+ years of experience as a Database Administrator
• Minimum 5 years working primarily with PostgreSQL
• Experience writing queries and debugging database code
• Experience working with cloud database solutions
• Competent with backup and recovery solutions
• Understanding of ERDs and ability to build physical schemas from logical designs
• Solid database engine tuning abilities
• Experience or knowledge of database partitioning strategies
• Discernment for potential data loss
• Strong problem-solving skills and reverse engineering discipline
• Ability to simplify and explain complex issues
• Unafraid of ambiguity
• Recognize the importance of urgency
• Able to maintain composure during pressure conditions

Bonus Qualifications:

• Experience with data modeling
• Experience with master data management (MDM)
• Experience developing or using data dictionaries
• Experience working with SaaS product
• Experience working in highly regulated environments (SOX, HIPAA, PCI)
• Experience with software development
• Background in security & privacy compliance

Why Join Litera?

• The company culture: We emphasize helping each other grow, doing the right thing always, and being part of a journey to amplify impact, creating an exciting and fulfilling work environment
• Commitment to Employees: Our people commitment is based on what employees love most about being part of the team, focusing on tools that matter to the difference-makers in the legal world and amplifying their impact
• Global, Dynamic, and Diverse Team: Our is a global company with ambitious goals and unlimited opportunities, offering a dynamic and diverse work environment where employees can grow, listen, empathize, and problem-solve together
• Comprehensive Benefits Package: Experience peace of mind with our health insurance, retirement savings plans, generous paid time off, and a supportive work-life balance. We invest in your well-being and future, ensuring a rewarding career journey.
• Career Growth and Development: We provide career paths and opportunities for professional development, allowing employees to progress through various technical and leadership roles