Skip to main content

Wipro Limited is hiring Administrator – L3

Company Name: Wipro Limited

Job Description: Administrator – L3

Work Experience: 3 – 5 Years

Work Location: Bangalore

Education: UG -Any Graduate, Graduation Not Required, PG - Post Graduation Not Required
Doctorate - Any Doctorate - Any Specialization, Doctorate Not Required

Job Description
Roles and Responsibilities: MS SQL Admin, MS SQL Admin, Database Admin, Database Admin, Database High Availability, Database Performance Tuning, Database Backup and Recovery, Infra Storage Administration Skill & Job Requirements: - - >Database Admin( L1) - Entry level position.

Works under close supervision to perform low- level database management tasks such as adding users, managing space etc

Participates in testing back- ups, ensuring maximum up- time and maximum performance of database

Familiarity with basic administrative commands is expected at this level
Front- line interaction with users to assist with low level trouble- shooting requirements - - >Database Admin( L2) - A fully contributing team member who performs database management tasks such as meeting user access requirements and resolving their problems.

Responsible for ensuring that storage, archiving, backup and recovery procedures are functioning correctly. Writes database documentation, including data standards, procedures and definitions for the data dictionary with some general supervision.

Front- line interaction with users to assist with escalated trouble- shooting requirements. - - >Database High Availability ( L3) - Knowledge of HA ( High Availability - RAC / Cluster / Replication / Data guard/ Standby / Database Failover strategy ?Database DR strategy / Flashback) How is it setup and configured What happens during a fail- over What happens during fail- back? When is it typically done? What are the steps a DBA should perform in the event of a fail- over and fail- ba - - >Database Performance Tuning( L3) - Good Knowledge in Performance Tuning ( Understanding SQL Server profiler and performance monitor. Understand Performance counters. Understanding Query execution plans. Handling fragmentation, statistics and index related issues.

Logical and Physical DB Design) - Planning for Performance in Database Design. Configurations parameter tuning. - - >Infra Storage Administration( L1) - Basic knowledge of Storage devices, RAID, Storage device connectivity, Networked Storage topologies, Storage protocols, Storage management, File Systems, Data Management, Data backup and Data protection - - >Database Backup and Recovery( L3) - Design, Plan and Implement Backup and Recovery Methods? Developing a backup and recovery strategy? DB2 UDB Advanced Recovery for Multiple Partition Databases Identify type of Frequency of Data changes, how quickly the recovery needs to be done, identify which backup solution to use, storage needs.

( RMAN / Native Tools) - - >MS SQL Admin( L2) - Understand New Features in SQL Server 2005 Data transfer and connectivity command list BCP, OSQL, ISQL, DTS Security - - Creation of logins / users. Grant/ deny permissions. Advanced Database Maintenance work - - moving data bases between servers, planning and sizing databases. Configuration Management: Good knowledge of SP configure, clear understanding of configuration parameters of SQL Server at server level as well as database level. Understanding Query execution plan Understanding of SQL Profiler & other Windows performance monitoring tools , Performance counters , analyzing profiler outputs Remote Access - - Advanced - - Linked Server, Querying linked server data TSQL - - Advanced - - Writing complex queries / SP. Resolving performance issues in SP / Queries. Log Shipping - - Setup / Initialization / Failover Replication - - Setup/ Initialization Connectivity Issues - resolving any connection issue to SQL Server like SSPI context error / SSL error. Handling Fragmentation / Statistics/ Index related issues related to slow performance.

Logical & Physical Database Design, normalization, Codd's Rule Access Violation - - monitoring and troubleshooting any AV's in SQL Server. SQL Cluster Management Low Free Memory Basic Log Shipping Troubleshooting Basic Replication Troubleshooting Installation of SQL Server instance on Cluster server. Cluster Administration - - Understanding of Cluster Administration tool, Start/ Stop SQL resources, Online/ Offline Cluster Resources, getting SQL Cluster status using query

Candidate Desired Profile
Administrator responsible for resolving escalated troubleshooting requirements. Responsible for guiding junior administrator in trouble shooting non- routine and complex troubleshooting requirements. As a senior member responsible for ensuring SLA is met and there are no complaint from customer. Technically sound, Contributes to KM and practice building. Prepares the Change management plan and gets sign- off. Conducts planned regular and random Technical audits. Suggest improvement plans Implement and share best practices. Implement automation of regular admin activities. Capture and report metrics like Devices/ FTE , incidents/ FTE, incidents/ devices , SA metrics. Perform trend analysis on the data captured.

Corporate Office Address: Wipro Limited, Doddakannelli Sarjapur Road Bangalore - 560 035 India


Telephone: +91 (080) 2844 0011


About Wipro: They are the first PCMM Level 5 and SEI CMM Level 5 certified IT Services Company globally. We provide comprehensive IT solutions and services, including systems integration, information systems outsourcing, package implementation, software application development and maintenance, and research and development services to corporations globally. In the Indian market, we are a leader in providing IT solutions and services for the corporate segment in India offering system integration, network integration, software solutions and IT services. In the Asia Pacific and Middle East markets, we provide IT solutions and services for global corporations. We also have a profitable presence in the niche market segments of consumer products and lighting. Our ADSs are listed on the New York Stock Exchange, and our equity shares are listed in India on the Bombay Stock Exchange, and the National Stock Exchange. For more information, please visit our websites at www.wipro.com and www.wipro.co.in Wipro Technologies is a global provider of consulting, IT Services, and outsourced R&D, infrastructure outsourcing and business process services. We deliver technology-driven business solutions that meet the strategic objectives of Global 2000 customers. With over 25 years in the Information Technology business, Wipro is the largest outsourced R & D Services provider and one of the pioneers in the remote delivery of services. We deliver unmatched business value to customers through a combination of process excellence, quality frameworks and service delivery innovation. Wipro is the Woorld"s first PCMM, CMM and CMMi Level 5 certified software Services Company and the first outside USA to receive the IEEE Software Process Award. We are the first services company to embrace Six Sigma, lean manufacturing and factory model concepts to software engineering. We have a wide geographical diversity of operations with over 40 development centers and 10 near shore centers spread across India, Japan, China, Eastern Europe, France, Austria, Sweden, Germany, UK and USA. Wipro Technologies is the global technology services division of Wipro Limited. (NYSE:WIT). For the last two decades, we have successfully served the technology needs of more than 200 customers from diverse industries and locations.We believe our people ? talented, enthusiastic and driven, best define us. Today, we have a team of over 9,500 committed people from different managerial and engineering backgrounds.Working in 20 offices around the world, they use powerful technologies to provide services for business transformation and product realization as well as complete solutions for the service provider market.At Wipro, we apply technology with innovation and responsibility to achieve two broad objectives:- Effectively address the business issues our customers face today- Generate new opportunities that will help them stay ahead in the future


Popular posts from this blog

Ready to Make an Impact? Join Accenture's Team as a Quality Engineer (Tester)

  Entity Name: Accenture India Private Limited Role in the Project: Quality Engineer (Tester) Work Location: Bengaluru – Full time Project Position Overview: Facilitates the development of comprehensive solutions through collaborative team efforts and seamless integration of diverse disciplines, aimed at expediting project delivery and ensuring high standards across the application lifecycle. Implements rigorous testing protocols encompassing security, API functionality, and regression testing. Designs and executes automation strategies, develops automated scripts, and assists in configuring data and environments. Engages in code evaluations, monitors performance, and identifies defects to foster continuous enhancement of the end-to-end testing process. Required Skills: Proficiency in Salesforce Testing Preferred Skills: Familiarity with Salesforce Lightning Web Components, and Salesforce Development Minimum Experience: At least 3 years of relevant experience Educational

Business intelligence Analyst (Tableau, PLSQL) Job at Thomson Reuters

  Entity Name: Thomson Reuters Job Name: Sr. BI Systems Analyst Work Location: Hybrid – Full time Qualification: A bachelor's degree in computer science, statistics, business, or a related discipline, or equivalent professional experience. Job ID: JREQ174000 Role Overview: At Thomson Reuters, your work will influence and lead the global knowledge economy. Our technology powers global markets and supports professionals worldwide in making critical decisions. You'll collaborate with top industry minds on diverse projects, developing innovative solutions that yield impactful results. As a premier provider of intelligent information, we value your unique insights to help drive our business forward and advance your career. In the role of Sr. BI Systems Analyst, you will be pivotal in defining, managing, and overseeing the workflow, lineage, and quality of our data across multiple platforms and for various users and applications. This position demands strong technical

Propel Your Career as a Staff Engineer in Camera IP Design Verification with Qualcomm

  Company Name: QualComm India Private Limited Job Name: Camera IP Design Verification - Staff Engineer Job ID: 3053403 Work Location: Bengaluru Qualification and Experience: A Bachelor's degree in Computer Science, Electrical/Electronics Engineering, Engineering, or a related discipline, along with at least 4 years of experience in Hardware Engineering or a relevant field.  An advanced degree, such as a Master's, in Computer Science, Electrical/Electronics Engineering, Engineering, or a related area, coupled with a minimum of 3 years of experience in Hardware Engineering or a related domain. A Doctorate (PhD) in Computer Science, Electrical/Electronics Engineering, Engineering, or a related field, complemented by a minimum of 2 years of experience in Hardware Engineering or a related professional sphere. Job Description As a pioneering force in technology, Qualcomm consistently challenges the limits of what's achievable to facilitate forthcoming experiences and spearheads