Mstr Admin

1 week ago


Pune, India Teradata Full time

MicroStrategy Administrator

Position Overview

Your primary focus will be on helping clients identify how they can drive more business value from data. This is a project-oriented position in offsite situations having accountability for managing client expectations while delivering the services and solutions associated with the Teradata database. The Consultant provides technical services related to analysis, design, build, performance tuning, testing and integration of all components of the Business Intelligence solution in conjunction with other project team members on a specific client engagement. This position will combine direct client consulting engagement activities, new solution development and analytics positioning responsibilities.

**As a MicroStrategy Developer, you will**:
Work in close coordination with customer MSTR developers.
Act as MicroStrategy expert to advice customers in defining MicroStrategy Roadmap, Security guidelines and MicroStrategy architecture for Complex enterprise systems.
Triage the cause of BI report failure
Escalate to the development team(s) for functional and procedural code/ structures change in the BI Reports and/or BI model
Escalate to Operations team and Customer on data issues
Escalate source system feed non-compliance to client source system owners
Coordinate release/publish of fixed BI Report and/or BI Model mappings as required
Work with users to resolve and troubleshoot report issues

Environment Administration

Application troubleshooting and tuning
Performance Tuning
Proactive Notifications and Alerts
Add, delete, and modify user login information
Maintain Analytic Environment Security Roles
Maintain access rights to Analytic Environment objects
Maintain metadata layer components of the Analytic Environment (Add, delete, and modify objects)
Monitor performance of Analytic Environment components
Report on performance and capacity of the Analytical Environment
Recommend additional performance and capacity planning services when undesirable trends are discovered
Maintain (add, delete, modify) Analytic Environment backup and restore processes
Monitor Analytic Environment backup/restore processes for successful completion
Escalate Analytic Environment backup/restore failures to second level support as required
Restart Analytic Environment backup/restore processes as required
Maintain Analytic Environment settings
Assist with migration and migration testing activities
Manage Analytic Environment system startup, shutdown, restart
Maintain admin. scripts on Analytic Environment servers

Environment Maintenance

Modify existing cube build processes as required
Modify existing SQL based reporting processes as required
Modify batch-oriented analytic processes as required
Site Log / Run book
Maintain site log to record changes and events related to the Analytic Environment
Update runbook to reflect changes made to reports, analytic model, or procedures in this service

Operational Communication

Maintain a service mailbox for capturing Analytic environment incidents
Communicate plans, and incident status to appropriate groups as established in the operations manual
Ensure change requests are appropriately logged and reviewed about affected users, work effort, implementation plan, estimated duration, and backout plan for changes. Assure appropriate resources are available.
Participate in weekly change control meetings
Update the Operations Manual to reflect changes made to reports, processes, or procedures in this service
Alert team members regarding corrective actions required due to performance and/or capacity utilization issues. Alert/escalation process to be documented in Operations Manual.

Service Management

Manage and coordinate activities of offsite resources
Manage day-to-day contractual obligations and changes
Manage resources to ensure service expectations are being met
Update and maintain operations documentation library
Participate in incident post mortem/root cause review
Provide monthly and quarterly input for the scheduled management reviews
Perform project compliance audits on quarterly basis
Present improvement opportunities to client during monthly and quarterly review meetings
Serve as a focal point for management and escalations of high impact problems
Identify opportunities (to improve service, reduce cost, increase availability, maximize ROI.)
Facilitate status calls with customer's management team
Conduct quarterly service reviews
Maintain Risk Register
Maintain Issue Register
Create and Circulate Weekly Project Status Report to Stakeholders
Create and Circulate Monthly Project Status Report to Stakeholders
Distribute list of open/closed Incidents to customer

**Qualifications**:
Bachelors Degree (or higher) preferably in Computer Science, Computer Applications, Information Technology or other related fields.
4+ years of hands-on experience in working with MicroStrategy.
Collect, cleanse, massage, and organize data in both SQL and No-SQL environme