Lead Consultant - SQL Server Database Admin L2
- Genpact India
- 3 to 6 Yrs
- Hyderabad
- 5 years ago
- Email to a friend
- Report this job
Job Description
Lead Consultant SQL Server Database Admin L2
- Installations, configurations, upgrades, patching, performance tuning, reorganization, backup and recovery of SQL Server databases.
- Installing, configuring and security settings for Oracle Database
- Should have worked in High Availability Features like Clustering, Always On, Log Shipping, DB Mirroring and Replication.
- Upgrading/Consolidating/Migrating of Database.
- Cross-Functional Migration from One Technology to Another or On-Prem to Cloud.
- Responsible for ensuring availability and performance of the databases that support the system.
- Performing daily maintenance task for critical databases.
- Establish and maintain sound backup and recovery policies and procedures.
- Setup and maintain documentation and standards.
- Create, maintain and administer monitoring and ongoing maintenance & administration of System Center Operations Manager
- ITIL Skill set requirement (Problem Management/Incident Management/Chain Management etc.)
- Documenting major changes to Database Activities
- Identify, research, and resolve technical problems like Database tuning and performance monitoring, Physical Server Level, Database level (Database settings and options) and query tuning.
- Proactively monitor the database systems to ensure secure services with minimum downtime.
- Automation of regular and repetitive tasks.
- Driving permanent fixes and issue resolution.
- Handling the task of managing database structure, storage allocation, database access, roles, users and privileges.
- Should be involved in troubleshooting, resolving data integrity and monitoring performance issues.
- Should have proven communication skills and experience in handling bridge call. Available for after-hours critical escalations and provide 7 24 supports when required.
Qualifications we seek in you
Minimum qualifications:
- Strong Knowledge on handling On-Prem Databases and on Cloud (AWS/Azure).
- SQL Server Database Admin and business/industry work experience
- Knowledge of Idera/SCOM and other monitoring tools.
Bachelors Degree required. Preferably in Computer Science, Information Systems, or related field
Preferred qualificationsVery 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
- Scripting and DevOps Tool Knowledge.
- Experience on cloud agnostic tools like Jenkins, Maven, Terraform etc
- Experience on automation languages like python, shell scripts, pearl/ruby
- Should be effective in communication skills and client communication
- Should proactively look into all support servers with 24 x 7 support whenever the issue arises.
- Solid process skills with an understanding of change control processes and managing critical production environments.
- Strong inter-personal, analytical thinking, presentation and communication skills essential.
Employement Category:
Employement Type: Full timeIndustry: IT - SoftwareRole Category: Network / System AdministrationFunctional Area: Not ApplicableRole/Responsibilies: Lead Consultant - SQL Server Database Admin L2Contact Details:
Company: Genpact IndiaLocation(s): Hyderabad
Similar positions
Genpact India
Genpact (NYSE: G) is a global professional services firm focused on delivering digital transformation for our clients, putting digital and data to work to create competitive advantage. We do this by integrating lean principles, design thinking, analytics and digital technologies with our domain and ...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in