1. Database Development and Management:
a. Design, develop, and maintain MySQL databases to support business operations and data needs.
b. Optimize database performance through query tuning, indexing, and schema design.
c. Implement data security measures and ensure compliance with relevant data protection regulations.
d. Perform regular database backups and recovery procedures.
2. Data Analysis and Reporting:
a. Analyze complex datasets to extract actionable insights and trends.
b. Develop and maintain advanced Excel reports, dashboards, and data visualizations.
c. Create and manage automated reports using MySQL queries and Excel macros.
d. Collaborate with stakeholders to understand their data needs and deliver tailored analytical solutions.
3. Data Integration and ETL Processes:
a. Design and implement ETL processes to integrate data from various sources into MySQL databases.
b. Develop and maintain scripts and procedures for data extraction, transformation, and loading.
4. Technical Support and Troubleshooting:
a. Provide technical support for database-related issues and resolve any data discrepancies or errors.
b. Collaborate with IT and development teams to ensure database and reporting systems are functioning efficiently.
5. Documentation and Training:
a. Document database structures, processes, and data workflows.
b. Train team members and end-users on database systems, reporting tools, and best practices.
GlobalSpace is an ICT company founded in 2010, providing cutting-edge enterprise mobility solutions and Digital Consulting primarily focusing on the field force enhancement. The management team of GlobalSpace consists of pioneers from both Pharma and IT industry thus providing world-class field force enhancement solutions and becoming the leading choice for Indian pharma.
GlobalSpace is a young and passionate organization with a mission to solve compound problems with simple solutions. We specialize in mobility with our in-house solutions, seamlessly running on our tablet PCs. In the words of its Founding Director Krishna, "GlobalSpace was conceptualized to empower every foot on the street to do their job better by leveraging technology". GlobalSpace builds SAAS applications and hardware product platforms that aim to provide best-in-class enterprise-wide technology-based solutions.