Job Description
We are looking for a SQL developer who will be responsible for designing databases and
ensuring their stability, reliability, and performance. You will also work other developers while
optimizing in-application SQL procedures as necessary, and establishing best practices. You
will help solve all database usage issues and come up with ideas and advice that can help avoid
such problems in the future
Responsibilities
Development of high quality database solutions
Develop, implement and optimize stored procedures and functions using T-SQL
Review and interpret ongoing business report requirements
Research required data
Ensure performance, security, and availability of databases
Prepare documentations and specifications
Build appropriate and useful reporting deliverables
Setup monitoring tools and report Database performance statistics periodically and take
necessary actions
Analyze existing SQL queries for performance improvements
Suggest new queries
Develop common database procedures and scripts needed for upgrade, backup,
recovery, migration, etc.
Profile server resource usage, and optimize and tweak as necessary
Provide timely scheduled management reporting
Collaborate with other team members and stakeholders
Investigate exceptions with regard to asset movements
Skills and Qualifications
7-8 years of experience as a SQL Developer or similar role
Strong proficiency with SQL, T-SQL and its variation among popular databases
B.E/B.Tech in Computer Science, Engineering or a related subject
Excellent understanding of Microsoft SQL Server and very strong in Database modelling,
design concepts
Good knowledge of Azure/AWS SQL platform as a service
Good knowledge on MS-SQL Server monitoring tools
2-3 years of experience with Transparent Data Encryption (TDE)
2-3 years of experience with SQL Server Reporting Services and SQL Server Analysis
Services
Familiarity with the practical application of NoSQL\NewSQL databases
Skilled at optimizing large complicated SQL stored procedures
Knowledge of best practices when dealing with relational databases
Capable of configuring popular database engines and orchestrating clusters as
necessary
Ability to plan resource requirements from high level specifications
Capable of troubleshooting common database issues on production
Sense of ownership and pride in your performance and its impact on company’s success
Familiar with tools that can aid with profiling server resource usage and optimizing it
Proficient understanding of code versioning tool GIT
Critical thinker and problem-solving skills
Great team player
Good time-management skills
Great interpersonal and communication skills
# Engineering