Database Administrator

Our platform is used and trusted by thousands of brands worldwide to maximise their revenue. Our unified ecommerce platform empowers thousands of B2B and multi-channel ecommerce businesses, big and small, to achieve more. From online stores, POS terminals and marketplace connections, to inventory, order management and shipping, our all-in-one platform connects it all.

We’re on a mission to build the most technically advanced marketing & ecommerce platform in the world coupled with unsurpassed customer service and support.

Location: Mohali, Punjab

Work Model: Hybrid

**About the position**:
As a **Database Administrator (DBA)**, you will play a crucial role in managing and maintaining the organization's databases, ensuring their availability, security, and optimal performance. Your role will require a balance of technical expertise, collaboration, and proactive problem-solving to ensure the availability and integrity of critical business data.

**Key Responsibilities**:
**Database Design and Implementation**:
**Performance Tuning and Optimization**:

- Monitor database performance, identifying and addressing bottlenecks and performance issues.
- Optimize queries and database configurations for improved response times and resource utilization.
- Implement and manage database caching and indexing strategies.

**Data Security and Privacy**:

- Enforce data security and privacy policies, ensuring compliance with industry standards and regulations (e.g., GDPR, HIPAA).
- Set up and manage user access controls, roles, and permissions to safeguard sensitive data.
- Perform regular security audits and vulnerability assessments.

**Backup and Recovery**:

- Develop and maintain robust backup and recovery strategies to prevent data loss and ensure data integrity.
- Implement disaster recovery plans to minimize downtime in case of system failures.

**Database Maintenance and Monitoring**:

- Install, configure, and upgrade database software and tools.
- Monitor database systems for performance, availability, and potential issues.
- Carry out routine maintenance tasks, such as data backups, patching, and system updates.

**Capacity Planning and Scaling**:

- Analyze database usage patterns and trends to forecast resource requirements.
- Plan and execute database scaling strategies to accommodate growing data volumes and user loads.

**Documentation and Reporting**:

- Maintain comprehensive documentation of database configurations, procedures, and best practices.
- Generate reports on database performance, usage, and incidents for management and stakeholders.

**Collaboration and Support**:

- Collaborate with cross-functional teams, including developers, system administrators, and network engineers, to resolve database-related issues.
- Provide technical support and guidance to end-users and other teams as needed.

**Must have Qualifications & Skills**:

- Bachelor's degree in Computer Science, Information Technology, or a related field.
- 2+ years of proven experience as a Database Administrator or similar role.
- Proficiency in few database management systems such as o MySQL ,PostgreSQL ,Oracle, Microsoft SQL Server

**Proficiency in few NoSQL databases such as** Cassandra, Elastic Search, Redis
- Strong SQL querying, tuning, and optimization skills.
- Knowledge of database security principles and practices.
- Familiarity with backup and recovery solutions.
- Excellent problem-solving and troubleshooting abilities.
- Effective communication, interpersonal and strong organizational skills.

**Good to have Qualifications & Skills**:

- Certification in relevant database technologies.
- Experience with cloud-based database platforms (e.g., AWS RDS, Azure SQL Database).
- Knowledge of scripting languages (e.g., Ruby, Python, PowerShell)
- Basic understanding of DevOps principles and tools.

**Equal Employment Opportunist**: