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 :
Exposure to Source control like TFS, GIT
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 :