Lead Databases & Bi
Current• Support application team in application design and development.• Review junior developers code and also support them.• Review objects created by junior developers.• Design and develop databases, data warehouses and multidimensional databases.• Design and implement measures, measure groups, granularity, calculated measures, and aggregate functions• Implement cubes and implement and configure dimensions in a cube• Develop reports using prescriptive analytics and predictive modeling using regression, classification, and clustering techniques.• Configure authentication and authorization for reporting solution• Implement interactivity in reports and configure report data sources and datasets• Implementation, Management and Maintenance of SQL database server and other storage devices • Performance Monitoring and Tuning of Database Server and other storage devices • Routine Maintenance including Log Management and Monitoring • Optimization of Storage • Establishing standards and schedules for database backups • Recording, developing, and ensuring backups, their schedules and test recovery & restoration procedures for each database • Managing Database Users and Security • Supporting Development Teams • Perform the role of the principal designer responsible for complex systems and their subsystems employing deep knowledge of current technology and tools, as well as relevant systems that already exist.• Monitoring performance and managing parameters to provide fast responses to end users • Maintain documentation and procedures to ensure adherence to database / data storage / data backup policies, procedures, and regulations • Ensure the availability of database backups both onsite and offsite • Controlling access permissions and privileges • ETL, moving data, merging data, etc. • Provide required database management, operations, and support and upgradation capabilities for the IT Department. • Incorporate changes in database structure
