Magesh Kumar Vijaya Kumar Email & Phone Number

Singapore

Singapore

• Roles and Responsibilities:
• Developing and implementing an overall organizational data strategy that is in line with business processes. The strategy includes data model designs, database development standards, implementation and management of.
• Identifying data sources, both internal and external, and working out a plan for data management that is aligned with organizational data strategy.
• Coordinating and collaborating with cross-functional teams, stakeholders, and vendors for the smooth functioning of the enterprise data system.
• Managing end-to-end data architecture, from selecting the platform, designing the technical architecture, and developing the application to finally testing and implementing the proposed solution.
• Responsible for providing technical expertise to development team (150+ members), technical trainings, coding standards, code reviews for complex objects, High Level design approval (Technical) for new projects.

Singapore

• Roles and Responsibilities:
• Manage and oversee day-to-day activities of Core database team.
• Protect development team from outside distractions, impediments, or team conflicts, and maintain focus on product backlog project timeline.
• Coordinate all scrum ceremonies including sprint planning, daily stand-ups, sprint retrospectives, sprint demos, story grooming, and release planning.
• Identify and resolve database issues related to performance and capacity.
• Provide 24X7 production support with respect to DB performance

Singapore

• Roles and Responsibilities:
• As an application DBA Responsible for providing SQL server problem resolution and 24X7 production support and server outages.
• Built in house SQL server database statistics collection and reporting tool in order to proactively analyze and fix the blocking/locking issues, long running queries, performance issues, Db size growth, etc.
• Responsible for evaluating new features and successfully implemented SQL Server features like data compression (page and row), table partition, filtered and covering indexes, MAXDOP at server and query level, etc.
• Responsible for database physical and logical design, Disaster recovery process, capacity planning, CAPEX, Infrastructure management.
• Responsible for regular monitor of servers, which includes backup job monitoring, Disk space monitoring, Services monitoring, CPU activity, Index fragmentation, Microsoft Windows Clustering and SQL Server Clustering.

Singapore

• Lead 3rd Line Support team which was responsible to look after production issues deliver proper solution in time.
• Re-designed existing application for better performance and closely worked with development and DBA team to tune SQL queries, stored procedures, DTS packages and Adjustment process.
• Created missing indexes and removed unused and redundant indexes
• Written complex stored procedures, views, DTS packages and SSRS reports
• Implemented SQL Server features like table partition, index views, filtered indexes, covering indexes for better performance
• Migrated Data load process from MS Access to SQL Server 2000 using DTS(ETL) Packages and Job

India

India

Bachelor Of Science - Bs, Computer Science

Higher Secondary, Mathematics