hireejobs
Register for Job
Hyderabad Jobs
Banglore Jobs
Chennai Jobs
Delhi Jobs
Ahmedabad Jobs
Mumbai Jobs
Pune Jobs
Vijayawada Jobs
Gurgaon Jobs
Noida Jobs
Oil & Gas Jobs
Banking Jobs
Construction Jobs
Top Management Jobs
IT - Software Jobs
Medical Healthcare Jobs
Purchase / Logistics Jobs
Sales
Ajax Jobs
Designing Jobs
ASP .NET Jobs
Java Jobs
MySQL Jobs
Sap hr Jobs
Software Testing Jobs
Html Jobs
IT Jobs
Logistics Jobs
Customer Service Jobs
Airport Jobs
Banking Jobs
Driver Jobs
Part Time Jobs
Civil Engineering Jobs
Accountant Jobs
Safety Officer Jobs
Nursing Jobs
Civil Engineering Jobs
Hospitality Jobs
Part Time Jobs
Security Jobs
Finance Jobs
Marketing Jobs
Shipping Jobs
Real Estate Jobs
Telecom Jobs

Lead Consultant - MS SQL Server DBA)

3.00 to 5.00 Years   Hyderabad   06 Oct, 2021
Genpact India Pvt Ltd
Job LocationHyderabad
EducationNot Mentioned
SalaryNot Disclosed
IndustryIT - Software
Functional AreaGeneral / Other Software
EmploymentTypeFull-time

Job Description

Lead Consultant: Database Administrator (SQL Server)

  • Analyze existing systems and make recommendations on which technology best suits the business requirement for high availability, disaster recovery or high performance.
  • Design and implement highly available production systems using the following technologies: Database Mirroring, Log Shipping, Windows/SQL clustering, Availability Groups.
  • Work independently or with other CAI teams to design or participate in functional/performance tests.
  • Diagnose and Resolve problems around database performance, capacity, replication, T-SQL, etc.
  • Proactively monitor databases for errors and respond quickly and effectively to troubleshoot and resolve DB on going issues on all CAI environments DEV/QA/PROD.
  • Validate and Install SQL CU/SP updates and instance upgrades.
  • Coordinate and schedule DB downtimes to perform DB maintenance procedures with customers/DB owners. I.e. DB patching, upgrades, etc.
  • Define Backup and Recovery strategies using technologies used at CAI: Netapp Snapshots, SnapManager for SQL, Idera SQLSafe or Native SQL Server Backup/recovery Tools.
  • Perform advanced database administration activities including but not limited to: DB Performance Tuning, T-SQL tuning, backup, recovery, and DB disaster recovery solutions.
  • Communicate effectively with other CAI groups gathering requirements for new instance build outs or supporting existing applications.
  • Create/update CAI s database documentation about standard procedures, DB technology features, or production issue troubleshooting.
  • Stay current with changes in the technical area of expertise.
  • Review scripts submitted by the Development team for performance and standard adherence.
  • Work with development teams to deploy code in production when needed.
  • Participate in on-call rotations (future requirement).
Qualifications we seek in youBachelors Degree required. Preferably in Computer Science, Information Systems, or related field.
  • Experience in Microsoft Windows/ SQL Server Technologies, .Net development.
  • Experience working on 24x7 environments oriented towards a zero downtime target.
  • Working knowledge or previous administration of SQL 2008R2-SQL 2019 and Windows Server 2003+.
  • Experience with ETL, DTS, T-SQL and SSRS, SSIS.
  • Ability to work with minimal direction, in a team environment.
  • Performance tuning for SQL server, queries, stored procedures, views, etc.
  • Hands on experience with configuring and administering Log Shipping and SQL Availability Groups.
  • Experience with SQL in virtual, physical and cloud-based environments.
  • Proven ability to quickly learn and implement new technologies
  • Experience with, or interest in learning, Oracle, MySQL, Netezza, Hadoop database platforms, a significant plus.
  • Experience with Sentry One a plus.
  • Ability to code PowerShell commands a plus.
Preferred qualifications
  • 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
,

Keyskills :
sapenvironmentdeliverycustomer relationssalessql serverbuild outslog shippingwindows servercustomer focusproblem solvingcomputer sciencedisaster recovery

APPLY NOW

Lead Consultant - MS SQL Server DBA) Related Jobs

© 2019 Hireejobs All Rights Reserved