Lead Associate - MS SQL Server
- Genpact India
- 3 to 4 Yrs
- Hyderabad
- 4 years ago
- Email to a friend
- Report this job
Job Description
With a startup spirit and 90,000+ curious and courageous minds, we have the expertise to go deep with the world s biggest brands and we have fun doing it. Now, we re calling all you rule-breakers and risk-takers who see the world differently, and are bold enough to reinvent it. Come, transform with us.
Are you the one that we are looking for
Inviting applications for the role of Lead Associate:Database Engineer (SQL Server)
Responsibilities:
- 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 and 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:
- Bachelor s degree or equivalent work experience
- 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 SentryOne 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
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. For more information, visit www.genpact.com. Follow us on Twitter, Facebook, LinkedIn, and YouTube.
,Employement Category:
Employement Type: Full timeIndustry: IT - SoftwareRole Category: General / Other SoftwareFunctional Area: Not ApplicableRole/Responsibilies: Lead Associate - MS SQL ServerContact 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