Gurgaon,

Staff Software Engineer

Job ID

22195

Posted

28-Jun-2021

Service line

Advisory Segment

Role type

Full-time

Areas of Interest

Digital & Technology / Information Technology

Location(s)

Gurgaon - Haryana - India

EMPLOYEE JOB DESCRIPTION

Title: Senior SQL Developer

Business Line: Information Technology.

Based in: Gurgaon

Start Date: As soon as possible.

Overview of Position:

As a SQL Admin, you will be responsible for managing the SQL server end to end for automatic backup, replication, partitioning, mirroring, azure configuration, DB deployment along with designing tables, writing queries, and ensure that these queries perform at an optimal speed. Expertise in managing database development. There are different flavours of SQL depending on the platform you use, but they all perform the same basic functions-retrieve, add, edit, and delete database data. And as a SQL developer you will be well-versed in all of these functions.

You will play a key role in SQL development and support of the company's key applications used throughout Asia Pacific. This senior role also requires the candidate to have a sound understanding of enterprise application development standards and methodologies and demonstrated experience working with custom enterprise frameworks.

As a member of our geographically distributed development team your communication and analytical skills are essential to the role.

Key Responsibilities:

• Designing databases and ensuring their stability, reliability, and performance.

• Responsibility of regular automatic backup, replication, partitioning, mirroring, azure configuration, DB deployment

• Design, create, and implement database systems based on the end user's requirements.

• Improve application's performances.

• Prepare documentations for database applications.

• Memory management for database systems.

• Develop database schemas, tables and dictionaries.

• Ensure the data quality and integrity in databases.

• Fix any issues related to database performance and provide corrective measures.

• Create complex functions, scripts, stored procedures and triggers to support application development.

• Take regular database backup.

• Test databases and perform bug fixes.

• Provide authentication and authorizations for Database

• Develop best practices for database design and development activities.

• Ability to quickly analyse existing T-SQL code and make improvements to enhance performance, take advantage of new SQL features, close security gaps, and increase robustness and maintainability of the code.

• Take on technical leadership responsibilities of database projects across various scrum teams

Required Knowledge & Skills:

Experience: 8-12 years would be preferable. Knowledge details are:
  • Solid understanding of normalization and denormalization of data, database exception handling, transactions, profiling queries, performance counters, and debugging techniques
  • Understanding of index design and performance-tuning techniques
  • Reviewing query performance and optimizing code
  • Writing queries used for front-end applications (websites, desktop applications, or cloud apps)
  • Familiarity with SQL security techniques such as data encryption at the column level, Transparent Data Encryption (TDE), signed stored procedures, and assignment of user permissions
  • DB replication; availability groups; mirroring, table partitioning; Azure configuration (disks, etc.) in a VM environment
  • Designing and coding database tables to store the application's data
  • Data modeling to visualize database structure
  • Working with application developers to create optimized queries

  • Creating database triggers for automation, e.g., automatic email notifications
  • Creating table indexes to improve database performance
  • Programming views, stored procedures, and functions
  • Adhere to standards for all database e.g. Data Models, Data Architecture and Naming Conventions
• Exposure to Source control like TFS, GIT

  • Understanding of Agile methodologies
• Competence in SQL Server (2014 experience preferred). Advance PL/SQL, Stored Procedures etc. Good understanding of SSRS reports would be added advantage.

• Experience in SQL Database Project and other database deployment automation tool such as DbUp and FluentMigration.

• Exposure to Continuous Integration and Continuous Delivery (CI/CD) application deployment cycle.

• Experience with Real Estate IT systems would be advantage.

• Understanding of Enterprise Frameworks, Release procedures, understanding of development environments.

• Time Management Skills.

• Excellent troubleshooting and communication skills.

• Other duties as required.

Personal Attributes:

  • Very good communication skills.
  • Ability to easily fit into a distributed development team.
  • Customer service oriented.
  • Enthusiastic/High initiative.
  • Ability to manage timelines of multiple initiatives.
  • Very good attention to detail and the ability to always follow up.

Gurgaon,

CBRE Group, Inc. (NYSE:CBRE), a Fortune 500 and S&P 500 company headquartered in Los Angeles, is the world’s largest commercial real estate services and investment firm (based on 2019 revenue). The company has more than 100,000 employees (excluding affiliates) and serves real estate investors and occupiers through more than 530 offices (excluding affiliates) worldwide. CBRE offers a broad range of integrated services, including facilities, transaction and project management; property management; investment management; appraisal and valuation; property leasing; strategic consulting; property sales; mortgage services and development services. Please visit our website at www.cbre.com .

We are in particular need of Building Maintenance Technicians and Maintenance Managers.  Folks that have current hands on experience with HVAC, refrigeration, plumbing, electrical, PLC’s, robotics, conveyor systems, carpentry, automation, controls and/or general maintenance.  And we need Managers that can direct these employees.  

We have job openings in many locations here in the US.  We offer a competitive salary and benefits including some matching 401K, vacation, etc.  All our jobs are full-time and permanent.  

Similar jobs