Database Administrator

at Simpplr

Gurugram, India

**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.

**DBA**:
**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**:
**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