Database Developer

At 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 201+. This is our pledge to meet an ambitious goal: the elimination of all greenhouse gases from our work by 2030. Your Role The data platform studio has a key position available for a SQL Server database developer. In this position, the ideal candidate will have the opportunity to wear many hats and to learn a wide variety of technologies. We are looking for candidates who are ready to roll up their sleeves and solve problems, including the ability to figure out what caused the problem and to make sure that it doesn’t recur. This is an excellent opportunity to explore and master cutting-edge technologies in a highly entrepreneurial environment. What You Will Do Implement and maintain database code in the form of stored procedures, scripts, queries, views, triggers, etc. Perform various day-to-day activities such as ad-hoc data exports, manipulation and analysis of large data sets, reports, bulk data updates, and investigation of data issues Analyze database problems, recommend and develop solution by applying industry best practices of database design, implementation, and deployment Perform query optimization for poorly performing queries Work closely with stakeholders to determine project requirements, perform analysis to create statement of work and provide time estimates Define, develop, and maintain reports/dashboards written in SSRS/Tableau Your Qualifications Bachelor’s degree in Computer Science or related field with 4-5 years of relevant experience in a similar role doing T-SQL programming using MSSQL Server Excellent knowledge of T-SQL, development and debugging of stored procedures, UDFs and triggers Experience in database query/ performance optimization Beginner/ Intermediate level skills in designing reports using SSRS Working knowledge of a version control system (GIT, SVN, TFS or any other) is highly desirable Familiarity with database administration in SQL Server is desirable Familiarity with NoSQL technologies is desirable Knowledge of standards and best practices when it comes to writing database code Willingness to learn recent technologies and innovative ways of approaching projects Effective communication, troubleshooting, and organizational skills and the ability to complete assigned work with minimal supervision Strong behavioral skills including but not limited to problem-solving, work prioritization, communication, self-direction, and time management Life at Gensler Gensler Asia-Pacific and Middle East is committed to Diversity, Equity and Inclusion through our Five Strategies. In partnership with our clients, we strive to create a just and equitable future for our communities and our colleagues. We celebrate our diversity and are focused on creating an inclusive workplace environment for all. As a people-first organization, we are as committed to enjoying life as we are to delivering best-in-class design. From internal design competitions to research grants 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 and wellness programs. We also offer profit sharing 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.