CBRE South Asia Pvt Ltd

SQL Developer

  • Job Type: Full Time
  • Industry Type: IT Sector
  • Industry Location: Hyderabad
  • Experience: 7-12yrs
  • No. of Positions: 2
  • Salary Range: 8-14.4 lac
  • Primary Skills: Agile Methodology SQL Development SQL Server
  • Secondary Skills: SQL
  • Job Location: Hyderabad
  • Posted Date: 13 days ago
Job Description

Roles and Responsibilities


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 flavors 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.


Desired Candidate Profile


  • 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 analyze 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 team.


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, 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 Db Up and Fluent Migration.
  • Exposure to Continuous Integration and Continuous Delivery (CI/CD) application deployment cycle.
  • Understanding of Enterprise Frameworks, Release procedures, understanding of development environments.
  • Time Management Skills.
  • Excellent troubleshooting and communication skills.
  • Other duties as required.
Relevant Job Openings
Devops Engineer
JAVA Full Stack Developer JAVA Tech Lead
Laravel Developer Urgent Walk In
PHP LARAVEL Developer Bangalore
Senior Software Developer
PHP Developer