Apply now »


Work with us

Title:  MSSQL Admin

Requisition ID:  61757
City:  Pune
Country/Region:  IN
Wipro Limited (NYSE: WIT, BSE: 507685, NSE: WIPRO) is a leading technology services and consulting company focused on building innovative solutions that address clients’ most complex digital transformation needs. Leveraging our holistic portfolio of capabilities in consulting, design, engineering, and operations, we help clients realize their boldest ambitions and build future-ready, sustainable businesses. With over 230,000 employees and business partners across 65 countries, we deliver on the promise of helping our customers, colleagues, and communities thrive in an ever-changing world. For additional information, visit us at www.wipro.com.

Job Description

Provide MSSQL database administration service.

· Following standard team processes and defines new ones with corrections.

· The individuals will be expected to be fully-functional DBA’s who can perform traditional DBA activities independently

and guide team members too.

· Able to provide escalation support whenever required.

· From an operational perspective, responsibilities include troubleshooting problems, working maintenance windows

and providing 24x7 on-call supports on a rotational basis.

· Pre-installation Tasks

· Installing Oracle Server and Patch Mgmt

· Installing & Maintaining DB Tools

· Uninstallation

· Database Upgrade

· Database Migration

· Database Patch Installation

· Physical Database Design and Implementation

· Database Setup

· Database Clean up / Removal

· DB Cloning

· Start up and shutdown of Database instances

· Maintaining Database replication / standby / clusters

· Job scheduling

· Verify all Instances are running

· Look for any new alert log entries

· Verify that SNMP is running

· Look for Trace files

· Session Monitoring

· Query or Transaction monitoring

· Lock and Latch monitoring

· Job monitoring and Purging Job history

· Replication / Stand by monitoring

· Object Monitoring

· Verify rollback segments

· Reorganization of DB to remove fragmentation

· Rebuild of indexes

· Analyze of objects

· Purging of DB logs and trace files

· SSIS and SSRS

· Verify that Server has enough resources for acceptable performance
 

͏

Periodic Report Generation on Database Health · Identify bad growth projections · Identify space-bound objects · Review contention for CPU, memory, network, and disk resources · Generating statistics · Look for objects that break rules. · Ensure that all indexes use an index table space · Ensure that all tables have unique primary keys. · Look for harmful growth rates · Examine tuning opportunities. · Look for I/O Contention · Review fragmentation by investigating row chaining and other areas of fragmentation · Database Objects Creation / Review · Check for unusable indexes · User / Schema Creation · User Management · Roles and Privileges Management · Look for security policy violations · Privileges & Access controls on Database · Verify that the database archiving to tape was successful. · Verify that the database backup was successful · Backup execution and monitoring · Conduct Backup , restoration drills for backup verification · Database Connectivity issues · Slow response · Operations timed out · Database incident and error resolution · Database incident and error resolution · Vendor Management · System Performance Monitoring · Maintaining Environment details · Shell Scripting for DB related work · Adherence to Change Management Process · Presales knowledge / experience are added advantage. · Implement ITIL processes & Create Transition Management · Root Cause Analysis for DB problems/ Recurring problems and initiate Request for Change

͏

Qualification :


· As per the Project Requirement


Expected Skills / Experience (L1 / L2 / L3) : L2


· · At least SQL DBA experience, 4+ years required · · Thorough Knowledge of Windows Operating System · . Knowledge of creating and maintaining standby / replication setup · . Strong in SQL fundamentals · . Knowledge of using Enterprise Manager and Query Analyzed for basic administration · . Knowledge of configuring and setting up maintenance activities for DB · . Knowledge of SQL statements tuning and DB Tuning · . Knowledge on DB structures (file groups, Indexes - clustered /non clustered/fillfactor) · . Knowledge on Memory structures (configurable parameters) · · Knowledge of complete /differential / transactional backups and their recovery scenarios · . Knowledge on High Availability configuration like replication and log shipping · · Excellent communication Skills · · Prior experience in a 24x7 environment desired · · Strong analytical and troubleshooting skills. · · Provide on-call support as and when required · · Team player who has a customer focus and brings expertise to the team

Additional Qualification / Skills :

· MCSE MSSQL Certification is mandatory

· Technically sound knowledge on Clustering, Log Shipping, Mirroring, Always on

· In depth Knowledge on SQL server 2000, 2005, 2008, 2012, 2014, 2017, 2019 Versions.

· Cloud, Azure, AWS

 

͏

͏

Mandatory Skills: MSSQL Database Admin .

 

Experience: 3-5 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. Come to Wipro. Realize your ambitions. Applications from people with disabilities are explicitly welcome.

If you encounter any suspicious mail, advertisements, or persons who offer jobs at Wipro, please email us at helpdesk.recruitment@wipro.com. Do not email your resume to this ID as it is not monitored for resumes and career applications.

Any complaints or concerns regarding unethical/unfair hiring practices should be directed to our Ombuds Group at ombuds.person@wipro.com.

We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, caste, creed, religion, gender, marital status, age, ethnic and national origin, gender identity, gender expression, sexual orientation, political orientation, disability status, protected veteran status, or any other characteristic protected by law.

Wipro is committed to creating an accessible, supportive, and inclusive workplace. Reasonable accommodation will be provided to all applicants including persons with disabilities, throughout the recruitment and selection process. Accommodations must be communicated in advance of the application, where possible, and will be reviewed on an individual basis. Wipro provides equal opportunities to all and values diversity.

Apply now »