Genpact (NYSE: G) is a global professional services and solutions firm delivering outcomes that shape the future. Our 125,000+ people across 30+ countries are driven by our innate curiosity, entrepreneurial agility, and desire to create lasting value for clients. Powered by our purpose – the relentless pursuit of a world that works better for people – we serve and transform leading enterprises, including the Fortune Global 500, with our deep business and industry knowledge, digital operations services, and expertise in data, technology, and AI.
Inviting applications for the role of Consultant - MSSQL Administrator!
In this role, Administrator needs the experience in installing attended and unattended mode MS SQL SERVER from 2012 – 2022 updating with hot fix and service packs. Also requires the ability to think at an End-to-End Design, Development and Implementation.
Responsibilities
- Strong Experience on Clustered and Stand-alone Servers.
- Strong understanding of RDBMS concepts as well as Data Modeling Concepts.
- Experience installing attended and unattended mode MS SQL SERVER from 2012 – 2022 updating with hot fix and service packs.
- Extensive experience in implementing Always-On HADR technique in same subnet and multi subnet clusters.
- Extensive experience in implementing different High availability and Disaster Recovery solutions like Replication (Snapshot and Transactional), Log shipping, Clustering and Mirroring on physical and virtual machines.
- Extensively worked on Active-Active and Active-Passive Clustering and multi node clustering.
- Thorough understanding of different RAID levels implementation.
- Experience In in-place and Side by Side upgrade of MS SQL SERVER 2012 – 2022 to newer versions.
- Strong Exp in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, Index rebuild, reorg, horizontal and vertical partitioning.
- Expertise in reading and understanding execution plan and fixing query to execute with low cost using joins like merge, nested loops, hash join etc. depends on scenarios.
- Experience in implementing Policy Based Management, Resource Governor, Data Collector sets and Backup Compression Techniques.
- Extensive experience in Capacity Planning, Performance Tuning, Disaster Recovery, Trouble shooting, Backup and Restore Procedures.
- Expert in extracting from different sources, transforming and loading data using transformation services like data transformation services like Batch processes, Import/Export, SSIS, DTS, BCP and Bulk Insert.
- Experience in configuring and managing Linked Servers.
- Experience in setting up and Implementing SCCM 2012 (Microsoft System Center Configuration Manager).
- Experience in using dynamic management Views (DMV) and functions (DMF) Of Tables, Triggers, Store Procedures for performance monitoring and tuning.
- Experience in writing and debugging Stored Procedures, Triggers, Cursors, Complex queries using T-SQL Scripts and Batch files.
- Experience troubleshooting Deadlock issues using trace flags and Extended Events.
- Experience using BCP, BULK INSERT, Import/Export data from different Data Sources.
- Experience supporting very large databases (VLDB) and Complex Databases.
- Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
- Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, performance monitor, activity monitor, Event viewer, Extended Events for performance analysis.
- Experience in Backups, Restores and Maintenance Plans.
- Expert in analyzing the execution plan and index management for better Query Optimization.
- Configured SMTP Server for Database Mail setup and set up Alerts for the Threshold values.
- Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
- Hands on experience with third party tools like NewRelic, Idera, SCOM & SolarWinds.
- Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
- Experience working in change control process environments.
- Flexible, Enthusiastic and project-oriented team player with good communication and analytical skills to develop creative solution for challenging client needs.
Qualifications we seek in you!
Minimum Qualifications / Skills
- Bachelor’s degree in IS, Computer Science, MIS Management, or related field, or equivalent combination of education and experience required.
- Proven communication skills when working with other technical towers to work out issues.
- Must be well organized, thrive in a sense-of-urgency environment, leverage best practices, and most importantly, innovate through any problem with a can-do attitude.
- Must understand various logging methods and security event terminology.
- Strong leadership skills when troubleshooting across multiple vendor platforms and working out technical issues.
- Proven communication skills when working with other technical towers to work out issues.
Preferred Qualifications/ Skills
- Very good written and presentation / verbal communication skills with experience of customer interfacing role.
- In-depth requirement understanding skills with good analytical and problem-solving ability, interpersonal efficiency, and positive attitude.
- Good ITIL knowledge
- Flexible to work for 24x7 process.
- Excellent Communication and interpersonal Skills
- Ability to prepare Dashboards and Reports
- Experience of working independently & as a team player
- Should have a proactive work approach and ability to think out of the box.
Genpact is an Equal Opportunity Employer and considers applicants for all positions without regard to race, color, religion or belief, sex, age, national origin, citizenship status, marital status, military/veteran status, genetic information, sexual orientation, gender identity, physical or mental disability or any other characteristic protected by applicable laws. Genpact is committed to creating a dynamic work environment that values diversity and inclusion, respect and integrity, customer focus, and innovation. Get to know us at genpact.com and on LinkedIn, X, YouTube, and Facebook.
Furthermore, please do note that Genpact does not charge fees to process job applications and applicants are not required to pay to participate in our hiring process in any other way. Examples of such scams include purchasing a 'starter kit,' paying to apply, or purchasing equipment or training.
Job
Consultant
Primary Location
India-Hyderabad
Schedule
Full-time
Education Level
Bachelor's / Graduation / Equivalent
Job Posting
Oct 10, 2024, 7:31:29 AM
Unposting Date
Nov 9, 2024, 11:59:00 PM
Master Skills List
Consulting
Job Category
Full Time
