Job Description

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.Provide MSSQL database administration service.xc2xb7 Following standard team processes and defines new ones with corrections.xc2xb7 The individuals will be expected to be fully-functional DBA's who can perform traditional DBA activities independentlyand guide team members too.xc2xb7 Able to provide escalation support whenever required.xc2xb7 From an operational perspective, responsibilities include troubleshooting problems, working maintenance windowsand providing 24x7 on-call supports on a rotational basis.xc2xb7 Pre-installation Tasksxc2xb7 Installing Oracle Server and Patch Mgmtxc2xb7 Installing & Maintaining DB Toolsxc2xb7 Uninstallationxc2xb7 Database Upgradexc2xb7 Database Migrationxc2xb7 Database Patch Installationxc2xb7 Physical Database Design and Implementationxc2xb7 Database Setupxc2xb7 Database Clean up / Removalxc2xb7 DB Cloningxc2xb7 Start up and shutdown of Database instancesxc2xb7 Maintaining Database replication / standby / clustersxc2xb7 Job schedulingxc2xb7 Verify all Instances are runningxc2xb7 Look for any new alert log entriesxc2xb7 Verify that SNMP is runningxc2xb7 Look for Trace filesxc2xb7 Session Monitoringxc2xb7 Query or Transaction monitoringxc2xb7 Lock and Latch monitoringxc2xb7 Job monitoring and Purging Job historyxc2xb7 Replication / Stand by monitoringxc2xb7 Object Monitoringxc2xb7 Verify rollback segmentsxc2xb7 Reorganization of DB to remove fragmentationxc2xb7 Rebuild of indexesxc2xb7 Analyze of objectsxc2xb7 Purging of DB logs and trace filesxc2xb7 SSIS and SSRSxc2xb7 Verify that Server has enough resources for acceptable performancexcdx8fPeriodic Report Generation on Database Health xc2xb7 Identify bad growth projections xc2xb7 Identify space-bound objects xc2xb7 Review contention for CPU, memory, network, and disk resources xc2xb7 Generating statistics xc2xb7 Look for objects that break rules. xc2xb7 Ensure that all indexes use an index table space xc2xb7 Ensure that all tables have unique primary keys. xc2xb7 Look for harmful growth rates xc2xb7 Examine tuning opportunities. xc2xb7 Look for I/O Contention xc2xb7 Review fragmentation by investigating row chaining and other areas of fragmentation xc2xb7 Database Objects Creation / Review xc2xb7 Check for unusable indexes xc2xb7 User / Schema Creation xc2xb7 User Management xc2xb7 Roles and Privileges Management xc2xb7 Look for security policy violations xc2xb7 Privileges & Access controls on Database xc2xb7 Verify that the database archiving to tape was successful. xc2xb7 Verify that the database backup was successful xc2xb7 Backup execution and monitoring xc2xb7 Conduct Backup , restoration drills for backup verification xc2xb7 Database Connectivity issues xc2xb7 Slow response xc2xb7 Operations timed out xc2xb7 Database incident and error resolution xc2xb7 Database incident and error resolution xc2xb7 Vendor Management xc2xb7 System Performance Monitoring xc2xb7 Maintaining Environment details xc2xb7 Shell Scripting for DB related work xc2xb7 Adherence to Change Management Process xc2xb7 Presales knowledge / experience are added advantage. xc2xb7 Implement ITIL processes & Create Transition Management xc2xb7 Root Cause Analysis for DB problems/ Recurring problems and initiate Request for Changexcdx8fQualification :xc2xb7 As per the Project RequirementExpected Skills / Experience (L1 / L2 / L3) : L2xc2xb7 xc2xb7 At least SQL DBA experience, 4+ years required xc2xb7 xc2xb7 Thorough Knowledge of Windows Operating System xc2xb7 . Knowledge of creating and maintaining standby / replication setup xc2xb7 . Strong in SQL fundamentals xc2xb7 . Knowledge of using Enterprise Manager and Query Analyzed for basic administration xc2xb7 . Knowledge of configuring and setting up maintenance activities for DB xc2xb7 . Knowledge of SQL statements tuning and DB Tuning xc2xb7 . Knowledge on DB structures (file groups, Indexes - clustered /non clustered/fillfactor) xc2xb7 . Knowledge on Memory structures (configurable parameters) xc2xb7 xc2xb7 Knowledge of complete /differential / transactional backups and their recovery scenarios xc2xb7 . Knowledge on High Availability configuration like replication and log shipping xc2xb7 xc2xb7 Excellent communication Skills xc2xb7 xc2xb7 Prior experience in a 24x7 environment desired xc2xb7 xc2xb7 Strong analytical and troubleshooting skills. xc2xb7 xc2xb7 Provide on-call support as and when required xc2xb7 xc2xb7 Team player who has a customer focus and brings expertise to the teamAdditional Qualification / Skills :xc2xb7 MCSE MSSQL Certification is mandatoryxc2xb7 Technically sound knowledge on Clustering, Log Shipping, Mirroring, Always onxc2xb7 In depth Knowledge on SQL server 2000, 2005, 2008, 2012, 2014, 2017, 2019 Versions.xc2xb7 Cloud, Azure, AWSxcdx8fxcdx8fMandatory 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 . 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 .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.

Wipro