Staff Software Engineer
CBRE
Gurgaon, Haryana, IND
2d ago

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 functionsretrieve, 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 companys 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 applications data
  • Data modeling to visualize database structure
  • Working with application developers to create optimized queries
  • Creating database triggers for automation, , automatic email notifications
  • Creating table indexes to improve database performance
  • Programming views, stored procedures, and functions
  • Adhere to standards for all database , 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.
  • Report this job
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form