Sr Software Engineer Job ID 22203 Posted 26-Jun-2021 Service line Advisory Segment Role type Full-time Areas of Interest Digital & Technology / Information Technology Location(s) Gurgaon - Haryana - India
Overview of Position :
As a Senior SQL Developer, you will be responsible for 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.
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.
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 : 6-10 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 technique
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.