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