Your RoleThe Operations Team in our Bangalore office has a key position available for a Database Administrator with Top level SQL Server and T-SQL experience. In this position, you will have the opportunity to wear many hats and to learn a wide variety of technologies. This role is part of the Data Platform Group which owns traditional duties such as managing backups, performance tuning and security. This team also owns and maintains the company’s data warehouse. Cross collaboration with other teams such as IT or Finance will be required. We are looking for candidates who are ready to roll up their sleeves and solve problems. In addition, we are looking for this role to be the one of the firms Power BI Administrators.What You Will DoHave expert knowledge of SQL and T-SQL from troubleshooting to installation, backup and restoringSetup and maintain various SQL Replication and Change Data Tracking channelsGood level of experience with Azure SQL and Azure Synapse AnalyticsBe aware of Microsoft AD security.Provide excellent analytical support for complex or escalated issuesRepresent Gensler’s Data Team, becoming the source of knowledge to train, educate, fix or escalate problems to and answer questions from employees worldwideIdentify areas in need of improvement and collaborate with internal teams across all Gensler to create scalable solutions.Handle the batch/agent job scheduling system for the data team.Possess superior communication skills with the ability to simplify and explain complex problems, listen to and empathize with others.Provide daily monitoring of all data center systems including but not limited to servers, workstations.Report and document all abnormalities and resolutions to the appropriate resources for remediation.Communicate significant events to the Data Team and management team.Maintain and distribute Data Operations Policies and Procedure manual changes as approved by the Data Team.Provide first and second level support to the Gensler Help Desk for the Data Team.Optimize a query using native tools or 3rd party tools.Have an awareness of other database technologies like MongoDB and Postgres.Initiative to propose and create appropriate solutions for changing situationsWillingness to learn new technologies and new ways of approaching projectsYour QualificationsBachelor’s degree in computer’s science or equivalent3-5 years’ experience in a database administrator positionStrong working knowledge of Microsoft SQL Server EngineExperience with SQL replication and Change Data CaptureExperience with Backup, Restore and Recovery processesExperience with SSRS, SSIS and PowerBI administrationConceptual understanding of ERP applicationWorking knowledge of MongoDB administrationEffective problem solver, ability to conceptualize, critical thinking skillsKnowledge of Idera, HVR and SolarWinds will be a huge a plusLife at GenslerAt Gensler, we are as committed to enjoying life as we are to delivering best in-class design. From curated art exhibits to internal design competitions to “Well-being Week,” our offices reflect our people’s diverse interests.We encourage every person at Gensler to lead a healthy and balanced life. Our comprehensive benefits include medical, dental, vision, disability, wellness programs, flex spending, paid holidays, and paid time off. We also offer a profit sharing, employee stock ownership, and twice annual bonus opportunities.As part of the firm’s commitment to licensure and professional development, Gensler offers reimbursement for certain professional licenses and associated renewals and exam fees. In addition, we reimburse tuition for certain eligible programs or classes. We view our professional development programs as strategic investments in our future.
