Job Description
Loaction :- Bengalore
Rate :- 100K/M
EXP :- 5 + years relevant
JD : Lead SQL Server Operations DBA
• Install and configure new Microsoft SQL Server instances, including AlwaysOn availability groups and failover clustering. Preferably on Microsoft SQL Server 2022, 2019, 2016.
• Highly skilled at database design and T-SQL development.
• Responsible for database backup and recovery procedures, security and database integrity, physical data storage design and data storage management.
• Configure and manage SQL Security settings.
• Make system design recommendations according to Microsoft SQL Server best practices.
• Manage database backup, recovery & DR planning.
• Create, modify, and optimize SQL Server Agent jobs and maintenance plans.
• Proactively monitor SQL Server maintenance tasks, troubleshoot failed jobs and resolve issues in a timely manner.
• Troubleshoot application slowness and performance issues.
• Analyzes SQL query plans and refines complex queries for performance tuning.
• Responsible for database migrations and server upgrades.
• SQL Server Integration Services (SSIS) and Data Integration: Develop, maintain, and optimize SSIS packages for ETL (Extract, Transform, Load) processes of large data into and out of Microsoft SQL Server.
• Optimizes data for visualization and Business Intelligence data analysis.
• Perform SQL Server integration with enterprise applications.
Experience Required:
• Experienced in Database Design and Development to perform the following:
◦ Database design utilizing various objects development such as Packages, Procedures, Functions, Triggers for business logic implementation
◦ T-SQL procedures development, compilation and debugging stored Procedures
◦ DB Troubleshooting, performance and tuning
◦ Experience in Logical and Physical Database modelling
• Experienced in Database Performance, Maintenance and Development to perform the following:
◦ Database management including backups, recovery and maintenance
◦ Database management for export, import and mass data loads
◦ Analyzes and generation of all tables and index statistics
◦ Monitoring and resolving data lock issues
◦ Check all statistics related to memory, locks, I/O, database response time, wait events, top sessions and background processes
◦ Create indexes to achieve critical dataset response time for time sensitive reports.
• Solid understanding of database security concepts and best practices for Microsoft SQL Server databases.
• Experience with source control tools (SVN/Git).
• Familiarity with programming and/or scripting languages such as: C#, PowerShell
• Familiarity with NoSQL databases such as MongoDB.
• Exposure to SCOM monitoring tool .
• Hands-On Experience in ITIL
• Good communication Skills interacting with global teams.
͏
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
͏
Deliver
| No. | Performance Parameter | Measure |
| 1. | Contribution to customer projects | Quality, SLA, ETA, no. of tickets resolved, problem solved, # of change requests implemented, zero customer escalation, CSAT |
| 2. | Automation | Process optimization, reduction in process/ steps, reduction in no. of tickets raised |
| 3. | Skill upgradation | # of trainings & certifications completed, # of papers, articles written in a quarter |
͏
Experience: 8-10 Years .
Reinvent your world. We are building a modern Wipro. We are an end-to-end digital transformation partner with the boldest ambitions. To realize them, we need people inspired by reinvention. Of yourself, your career, and your skills. We want to see the constant evolution of our business and our industry. It has always been in our DNA - as the world around us changes, so do we. Join a business powered by purpose and a place that empowers you to design your own reinvention.