Techno Functional Consultant - L1

location - Pan india

Experience

Job Title: SQL Server Database Administrator (DBA

Database Management: Manage SQL Server databases, ensuring their performance, availability, and security.

Configuration and Maintenance: Configure and maintain database servers and processes, including monitoring system health and performance.

Performance Tuning: Perform performance tuning, query optimization, and regular database maintenance tasks.

High Availability and Disaster Recovery: Implement and manage high availability (HA) and disaster recovery (DR) solutions.

Security: Ensure database security by implementing and maintaining security measures.

Backup and Recovery: Manage database backups, restores, and recovery models.

Support and Troubleshooting: Provide 24x7 support for critical production systems and troubleshoot issues in real-time.

Collaboration: Work closely with developers to assist with query tuning and schema refinement.

Documentation: Document database configurations, processes, and changes.

Proficiency in SQL Server administration, including performance tuning and optimization.

Experience with HA and DR options for SQL Server.

Strong knowledge of Windows Server, including Active Directory.

Familiarity with database security, backup, and recovery processes.

Certifications

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