Roles and Responsibilities
Salary– Will depend on the role / hierarchy fitment. Salary should not be a constrain for a good resource
Industry – Office Equipment/Automation/ IT Software & Software Services / Electronic / Security and Surveillance
Functional Area – Software Development
Role– SQL Developer
EmploymentType – Permanent Job, Full Time
Work location – Ahmedabad [Prahaladnagar]
Shift –Regular Day Shift
- Experience in SQL server development, Performance tuning, with experience in writing and executing advanced queries against large indexed data sets ( > 100 million records)
- Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints etc.
- Identify columns for Primary Keys in all the tables at the design time and create them.
- Be aware of potential blocking, deadlocking and write code to avoid those situations.
- Code is written keeping in mind with security issues such as SQL Injection
- In-depth understanding of data management (e.g. permissions, recovery, security and monitoring)
- Monitors database servers for resource utilization and pin-point the issue.
Required Key Skills
- B.E. IT/ MCA/ BCA/MSC IT any equivalent
- Minimum 3Years of experience in SQL ServerDevelopment
- Sound knowledge in MS-SQL Queries, SP, Triggers, Data Normalization, Indexes, Backup & Restores.
- Basic knowledge on DBCC Commands, Recovery Models & SSIS.
- Having a knowledge of database design, optimization and and data integrity
Desire Personality Traits
l Ability to work independently & within groups
l Analytical thinking & Customer / User expectations analysis
l Strong work ethics and sense of commitment towards company’s needs and requirements
Salary: Not Disclosed by Recruiter
Employment Type:Full Time, Permanent
UG:BCA in Computers
PG:PG Diploma in Computers,M.Tech in Computers,MCA in Computers
Founded in 1999, Spectra has re-defined identity solution offerings over these years. Backed by a dedicated, experience-rich team we understand industry-specific needs better. With every solution we touch-base with our clients, listen to them with patience, answer their queries, inform them of all nitty-gritty, guide them through the process of building effective systems and provide reliable after sales support.
Spectra boasts of a team of talented and dedicated minds. Lot of team members have been integral part of this growth journey for praiseworthy long tenures and have contributed to the success story of Spectra. Their time is invested in creating value-driven offerings and exceptional customer service for our various client verticals. Together, their passion and undivided attention made Spectra a force to recognize with, in a short span of its existence. From launch of its first to second and now third generation of products and solutions, Spectra has been a consistent player in its field.
With eyes firmly set on the future, Spectra brings to you the most cutting-edge, dynamic and note-worthy products and solutions. At Spectra, we believe each day is a sparkling new opportunity to break barriers and create something new. Our experts strive to bring to your desk ever refined identity solutions, in tune with the buzzing trends. We have thus recorded a strong presence in India and now expanding footprints globally with 500+ channel partners.Today we are backed by a strength of150+ human capital serving 7500+ client base including 120+ top of the league marquee corporate clients.