Database Administrator

locationsBangalore, Indiatime typeFull timeposted onPosted 30+ Days Agojob requisition idR-10946At Gensler, we design for people. We leverage our global perspective and local presence to innovate at every scale. We’re not just designers. We’re tinkerers, craftspeople, visionaries, innovators and thought leaders. Fueled by passion and entrepreneurial spirit, our people bring new ideas to solve challenging problems. Whether you’re into sketching new ideas, hacking a building or growing client relationship in global markets, there’s something here for everyone.Our depth of expertise spans disciplines—from aviation and transportation to education, hospitality, retail, technology and more. At our core we embody an entrepreneurial spirit, always looking ahead for new ways to innovate and add to our clients' success. We share the belief that design has the power to transform organizations and change lives; whether we’re refreshing a retailer’s brand, planning a new urban district or designing a super tall building.Our work reflects an enduring commitment to sustainability, and we believe that a diversity of voices and cultures is one of the most powerful strategic tools for securing lasting competitive advantage.As the world’s largest design firm, Gensler has a unique obligation and opportunity to focus on sustainability in the built environment. We deepened our commitment to combat the impact on climate change in the built environment when we launched Gensler Cities Climate Challenge (GC3) in 2019. This is our pledge to meet an ambitious goal: the elimination of all greenhouse gases from our work by 2030.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 BIWhat 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 TrackingExperience 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 401k, profit sharing, employee stock ownership, and twice annual bonus opportunities. Our annual base salary range has been established based on local markets.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.