Sapphire Ventures
Partnering with expansion-stage, enterprise software companies that we believe can become category leaders.
Sapphire Partners
Limited partner investing in exceptional early-stage venture fund managers.
Sapphire Sport
Partnering with early-stage companies at the nexus of technology and culture.
Menu close
Sapphire
hero

Portfolio Jobs

Looking for your next role? Take a look at these exciting jobs at Sapphire Ventures’ portfolio companies. Our Talent team is passionate about connecting you to your dream job!

Database Administrator

Simpplr

Simpplr

Software Engineering, IT
Gurugram, Haryana, India
Posted on Thursday, June 13, 2024

Who We Are

Simpplr delivers exceptional AI-powered employee experiences at scale. It is the only platform that unifies employee engagement, enablement, and self-service to provide every employee with a seamless and personalized experience so they can do their best work from anywhere. Organizations use our forward-looking, adaptable products to deliver personalized experiences that inspire and engage their employees. Wherever people work, Simpplr enables them to flourish.

Trusted by more than 700+ leading brands, including Penske, Snowflake, Moderna, Eurostar, and AAA, our customers are achieving measurable improvements in employee engagement, productivity, and accelerated business performance.

Simpplr is headquartered in Silicon Valley, CA with offices in the UK, Canada, and India, and is backed by Sapphire Ventures, Norwest Venture Partners, Salesforce Ventures, and Tola Capital. Learn more at simpplr.com.

DBA

Job Description

Simpplr is seeking a highly skilled and experienced Database Administrator (DBA) to join our team. The ideal candidate will have a strong background in managing and optimizing ElasticSearch and Postgres databases, as well as extensive experience with AWS managed databases including RDS, Aurora and MySQL. This role requires a deep understanding of database failover and recovery, backups, and proficiency in optimizing query, index and overall database performance . The successful candidate will be passionate about ensuring database performance, availability, security, and best practices to keep the database up and running smoothly 24/7.

Responsibilities

Database Management:

  • Administer, maintain, and implement policies and procedures for ensuring the security and integrity of databases and regular testing.
  • Build and design database systems of high availability and quality depending on product needs.
  • Minimize database downtime and manage parameters to provide fast query responses
  • Provide proactive and reactive data management support and training to users

Performance Tuning:

  • Monitor database performance, implement changes and apply new patches and versions when required, to ensure optimal performance.

Failover and Recovery:

  • Design and execute database backup and recovery strategies, including failover planning and testing
  • Perform tests and evaluations regularly to ensure data failover, restore, recovery are within RPO and RTO.
  • Use high-speed transaction recovery techniques and backup data

Security and Compliance:

  • Ensure database security measures are in place, including access controls and audit logging.
  • Comply with all applicable data privacy laws and regulations.

Monitoring:

  • Utilize AWS CloudWatch and other monitoring tools to ensure database health, performance, and to automate scaling and notifications.

Troubleshooting and Support:

  • Provide high-level support for complex database issues, including troubleshooting.
  • Resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, slow query logs, etc.
  • Determine, enforce and document, database policies, procedures and standards
  • Required a deep understanding PostgreSQL roles and permissions
  • Manage the PostgreSQL autovacuum tasks on Amazon RDS for PostgreSQL
  • Use pgBadger for log analysis with PostgreSQL
  • Work with parameters on your RDS for PostgreSQL DB instance
  • Must have excellent problem solving skills and the ability to think algorithmically

Requirements and skills

Communication Skills:

  • Excellent verbal and written communication skills

Database Expertise: AWS Managed Databases and ElasticSearch

  • Proven experience as a DBA with expertise in ElasticSearch and AWS managed RDS (PostgreSQL and MySQL) with multi region setup
  • Hands-on experience with database standards, user management, security restrictions and best practices.
  • Familiarity with database design, documentation and coding, specially for multi tenant architecture.

Failover and Recovery:

  • Solid experience in database backup, failover, recovery procedures, and disaster recovery planning, security, integrity and SQL.

Others:

  • Good to have a basic understanding of Mongo, Redis and Snowflake.
  • Open to learn new technologies and skills.

Desired Skills and Experience:

Certifications: AWS or relevant database certifications (e.g., Oracle Certified Professional, PostgreSQL Professional).
Scripting Skills: Experience with scripting languages (e.g., Python, Bash) for automation of database tasks.
Monitoring Tools: Deep familiarity with database monitoring tools, especially AWS CloudWatch, for performance monitoring and alerting

See what our employees say about working at Simpplr: Glassdoor Reviews

Simpplr’s Hub-Hybrid-Remote Model:

At Simpplr we believe that when work is good, life is better and that belief guides all we do. Including how we approach our flexible work model. Simpplr operates with a Hub-Hybrid-Remote model. This model is role-based with exceptions and provides employees with the flexibility that many have told us they want.

  • Hub - 100% work from Simpplr office. Role requires Simpplifier to be in the office full-time.
  • Hybrid - Hybrid work from home and office. Role dictates the ability to work from home, plus benefit from in-person collaboration on a regular basis.
  • Remote - 100% remote. Role can be done anywhere within your country of hire, as long as the requirements of the role are met.