Asish Kumar Email & Phone Number

Wellington, New Zealand

Wellington, Wellington Region, New Zealand

• Responsible for day-to-day activities regarding the upkeep and availability of all on-premises database servers, Cloud Databases including Microsoft Azure and AWS.• Lead MS SQL migrations to Azure and AWS Cloud.• AWS Cloud Support and Implementation: AWS RDS, SQL on EC2• AZURE Cloud Support and Implementation: Azure SQL, Managed Instance, SQL Server on Virtual Machines • Serve as SME (subject matter expert) to project teams for Microsoft SQL Server on VM and Cloud (Azure/AWS)• Responsible for database backup and restore functions including scheduled tests of DR availability, including knowledge of MS SQL restoration and availability technologies such as Clustering, Replication and especially Always-On.• MS SQL production database level performance tunning and optimaisation.• MS SQL production database level monitoring and alerting.• Review and implementation of Database level changes.• Carry out Database Platform technical analysis and design for current and future projects.• Document processes and procedures of DBA tasks for Cloud Platforms including data security, integrity and backup and recovery.• Review and provide feedback for Architecture documents for Database platforms including project scope and implementations.• Provide initial consolation for projects including time and resource scoping.• Database Management System cloud platform setup and configuration.• Provide 24x7 support for critical production DB systems• Perform scheduled maintenance and support release deployment activities after hours

Wellington & Wairarapa, New Zealand

• Projects: Installation/Migration/Upgrade of Databases Servers and instances – SQL 2005 – SQL 2019 version• Projects: Database consolidation• Implementation and documentation of SQL Server 2008-2019 environments• Database disaster recovery including backups and restore• Day to day configuration, maintenance, monitoring, and administration of database systems• Perform regular health checks of database systems• Apply system, security patches to database systems• Database security configuration• Documentation and testing of disaster recovery plans and high availability• Configure High availability solutions: SQL Clustering, Database Mirroring and Log Shipping• Configure SQL Replication: Transactional, Snapshot and Merge• Installation and configuration of SSRS (Reporting Services), SSIS (Integration Services), SSAS (Analysis Services): SQL Server 2008R2 -SQL Server 2019• Developing Integration Services packages for data transfer• Transact-SQL skills including performance tuning• Experience with HR\ Financial and sector facing applications and databases including reporting. • Change, problem and incident management. • Develop and improve processes according to Microsoft best practise and industry standard.• Provide on-call support 24x7 as needed.• Business Continuity plan and documentation• Assist the Senior SQL Server DBA in day-to-day administration and future planning of the SQL Server Database environment.

Wellington & Wairarapa, New Zealand

• Provide support for internal and sector facing national applications including support for databases.Applications included: National Immunisation Register, Before Schools Checks, Unicenter Service Desk, National Health Index, WellChild and other Clinical Applications.• Windows application environment and infrastructure experience including Active Directory• Web based applications including IIS.• Support for HR and Financial applications• Upgrade and development of internal and sector facing applications.• Develop and maintain Application and Database Support standards and procedures and other documentation as required.• Project work as required for application upgrades including requirements analysis, testing and deployment in Test and Production environments.• Provide specialist professional advice and support throughout in relation to the support of all clinical and some non-clinical applications.• Undertake strategic planning in relation to application system upgrades, new releases, and migration to new systems both local and national.• Troubleshooting and improving application reporting capability.

Wellington

Provide technical expertise and advice to ITS and its customers• Provide support for all desktop activities• Maintain availability of desktop computer hardware and desktop applications• Resolve potential faults before impacting on service delivery• Test and install new components, software and hardware• Deploy software• Assist the Service Desk in regard to queries, incidents and problems• Perform Incident, Problem and Change management process for assigned service desk calls• Provide on-call services to deal with system issues to ensure minimum disruption to the business/business units• Assist with the research and development of new standard hardware and software• Conduct software assessment• Evaluate, test and install new components and software• Participate in the development, testing and maintenance of desktop images

Wellinton

• Provide Level 3 Desktop support within Novell (including Novell Zenworks), Windows and Citrix Environment.• Attend to customer enquiries through the various contact channels (phone based as well as face to face)• Escalate work to appropriate System Support team as required• Work with System Support team to identify customer problems and design practical solutions • Assist in completion of IT projects - Desktop upgrades, software updates for labs, installation setup of new computer equipment.• Networking computer labs• Assisting in building software images for labs through installation, imaging, testing and deployment.• Provide support in a Citrix environment including installation and networking of Citrix Terminals.• Support student and staff Database Management Systems.

Suva, Fiji

• Manage and administer all IT related services for the Commission including help desk activities.• Develop strategies for maintaining and updating IT infrastructure for the Commission including computer network and centralised Database for Complaints Management System.• Identification of training needs for staff members and providing appropriate training to up skill staff computer skills.• Provide one on one training for newly appointed staff members for the Commission.• Repairing and upgrading of PC’s as seen appropriate.• Carrying out research on various software applications and making recommendations to the Commission to purchase these software’s. • Analysing manual based procedures followed by the staff members of the Commission and researching on appropriate software’s that could provide IT solutions to these procedures – mainly for registering client complaints, processing of client complaints and storing client information in a centralised database.• Development and updating of the Commission’s website.• Providing IT support for all the conferences and seminars held by the Commission including Audio Visual support.• Maintain and further develop the Complaints Management System database.• Networking new PC’s to the existing computer network.• Implementing secure network against viruses, installation and management of anti-virus software. Managing and updating all PC’s with new anti-virus updates.• Carry out weekly backup for the server.• Providing technical advice to the management on IT related issues and improvements.

Certificate In Network Administration (Level 6), Network And System Administration/Administrator

Bachelor’S Degree, Information Technology

Diploma In Business Computing With Merit, Information Technology, Merit