Lead Consultant - Ms Sql Server Dba)
- Genpact India
- 3 to 5 Yrs
- Hyderabad
- 4 years ago
- Email to a friend
- Report this job
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 you
Bachelors 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.
- 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
Employement Category:
Employement Type: Full timeIndustry: IT - SoftwareRole Category: General / Other SoftwareFunctional Area: Not ApplicableRole/Responsibilies: Lead Consultant - Ms Sql Server Dba)Contact Details:
Company: Genpact IndiaLocation(s): Hyderabad+ View Contact
Fraud Alert to job seekers!
₹ Not Specified
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