Female Tele Sales Executive- E Pharmacy

About the Role

We are seeking a highly organized and detail-oriented HR Operations Specialist to join our team. The

ideal candidate will possess a strong understanding of HR processes and regulations, with proficiency

in various HR tasks including offer letter generation, promotion management, appraisal processing,

and department change documentation. Additionally, the candidate should demonstrate expertise in

Excel, file maintenance, and knowledge of Provident Fund (PF) and Employee State Insurance

Corporation (ESIC) workings.

Responsibilities:

 Generate offer letters, letters of agreement (LOA), promotion letters, appraisal documents,

department change letters, and other HR-related correspondences.

 Proficiently utilize Excel for data analysis and reporting purposes.

 Maintain both digital and hard copy files ensuring accuracy, confidentiality, and compliance

with company policies and legal regulations.

 Utilize HRMS software for various HR operations including employee data management,

leave management, and payroll processing.

 Handle the breakdown of Cost to Company (CTC) and upload CTC breakup accurately.

 Serve as an onboarding expert, ensuring seamless integration of new hires into the

organization.

 Manage vendor relationships for HR-related services, ensuring timely delivery and adherence

to service level agreements.

 Oversee attendance management processes, including monitoring and reporting on

attendance records, leave balances, and attendance policy compliance.

 Maintain knowledge of PF and ESIC workings, ensuring compliance with regulations and

timely submission of required documentation.

Qualifications:

 Bachelor's degree in Human Resources, Business Administration, or related field.

 Proven experience in HR operations, preferably in a fast-paced environment.

 Strong proficiency in Microsoft Excel and other MS Office applications.

 Familiarity with HRMS software and its functionalities.

 Excellent organizational and time management skills.

 Ability to handle sensitive information with confidentiality and discretion.

 Strong communication and interpersonal skills.

 Detail-oriented with a commitment to accuracy.

 Knowledge of labor laws and regulations pertaining to PF, ESIC, and other HR-related matters

is preferred.

Key Responsibilities

Performance Optimization & Query Tuning

  • Tune query performance for PostgreSQL, EdgeDB, MongoDB Atlas, and Snowflake.

  • Analyze execution plans, identify bottlenecks, and implement indexing & caching strategies.

  • Work with engineering teams to optimize schema design for OLTP (Postgres/EdgeDB) and metadata storage (MongoDB).

Database Architecture & Scalability

  • Design multi-tenant scaling strategies for PostgreSQL and MongoDB Atlas (schema, sharding, partitioning).

  • Implement high-availability, replication, and clustering configurations.

  • Optimize Snowflake warehouse configurations for query speed and cost control.

Operational Excellence

  • Plan and execute zero-downtime database upgrades and schema migrations.

  • Set up proactive monitoring, alerting, and anomaly detection across all database systems.

  • Manage capacity planning for storage and compute resources across Postgres, MongoDB Atlas, and Snowflake.

Storage & Cost Optimization

  • Reduce storage costs via archiving, partitioning, compression, and lifecycle policies.

  • Optimize Snowflake compute and storage usage with warehouse tuning and data pruning.

  • Implement tiered storage strategies for cold vs. hot data.

Security, Compliance & Governance

  • Enforce encryption, access controls, and audit logging across all databases.

  • Ensure compliance with GDPR, SOC 2, and other relevant regulations.

Collaboration & Knowledge Sharing

  • Partner with backend, platform, and data engineering teams to ensure efficient database usage.

  • Provide training and documentation on query best practices and schema design.

Qualifications

Required:

  • 7+ years DBA experience, with deep expertise in PostgreSQL and MongoDB Atlas.

  • Strong understanding of multi-tenant architectures in production.

  • Experience with Snowflake query optimization, warehouse tuning, and cost management.

  • Proven success in executing zero-downtime upgrades and large-scale migrations.

  • Strong skills in query optimization, indexing, partitioning, and sharding.

  • Proficiency in scripting (Python, Bash, SQL) for automation.

  • Hands-on experience with monitoring tools (pg_stat_statements, Atlas monitoring, Snowflake Resource Monitors, Prometheus, Grafana).

Nice to Have:

  • Experience with EdgeDB or graph/relational hybrid databases.

  • Familiarity with Kubernetes-based database deployments (StatefulSets, Operators).

  • Background in distributed caching (Redis, Memcached).

1. SAP SD(Sales and Distribution) - HANA Sales of S/4 HANA

2. O2C(Order To Cash ) business process expertise,

3. SAP SD Implementation/Support/Development project expertise.

4. Exposure to SAP SD configurations (O2C processes, Pricing Procedure, Revenue account determination, Credit Management, Rebate Processing, Batch Management, Consignment, Stock transport orders)

5. S/4 Migration/Implementation/AMS experience