Techno Functional Consultant L1

Location : Bangalore, Pune, Chennai & Hyderabad.

150cbr

:

Hands-on Experience in SQL Server Database/Admin activities on Premise and cloud (Azure and AWS).

Upgrade, Migration and Exporting data from SQL Server 2008/2012/2014/2016/2017/2019/2022 to latest versions On-Premises and Azure Cloud

Migration/Consolidation of SQL DBA database from On-Premises to Cloud.

Experience of configuring linked servers.

SQL server installation experience and configuration of high availability features like Always on.

Decommission of Database and Servers for SQL DBA.

Experience in handling and supporting critical Databases.

Experience with backup, restores and recovery models.

Experience in High Availability (HA) and Disaster Recovery (DR) options for SQL Server.

Experience in Database Replication, Always ON and Log Shipping.

Expert in troubleshooting and debugging Database Performance issues as well as query tuning using various methodologies apart from implementing efficient SQL methodology.

PowerShell and T-SQL experience to automate DBA activities.

Do

1. Bridging the gap between project and support teams through techno-functional expertise

• For a new business implementation project, drive the end to end process from business requirement management to integration & configuration and production deployment
• Check the feasibility of the new change requirements and provide optimal solution to the client with clear timelines
• Provide techno-functional solution support for all the new business implementations while building the entire system from the scratch
• Support the solutioning team from architectural design, coding, testing and implementation
• Understand the functional design as well as technical design and architecture to be implemented on the ERP system
• Customize, extend, modify, localize or integrate to the existing product by virtue of coding, testing & production
• Implement the business processes, requirements and the underlying ERP technology to translate them into ERP solutions
• Write code as per the developmental standards to decide upon the implementation methodology
• Provide product support and maintenance to the clients for a specific ERP solution and resolve the day to day queries/ technical problems which may arise
• Create and deploy automation tools/ solutions to ensure process optimization and increase in efficiency
• Sink between technical and functional requirements of the project and provide solutioning/ advise to the client or internal teams accordingly
• Support on-site manager with the necessary details wrt any change and off-site support

2. Skill upgradation and competency building

• Clear wipro exams and internal certifications from time to time to upgrade the skills
• Attend trainings, seminars to sharpen the knowledge in functional/ technical domain
• Write papers, articles, case studies and publish them on the intranet