SQL Developer

Job brief 

We are looking for a qualified Database developer to design stable and reliable databases, according to our company’s needs. You will be responsible for developing, testing, improving and maintaining new and existing databases to help users retrieve data effectively.

As part of our IT team, you will work closely with developers to ensure system consistency. You will also collaborate with administrators and clients to provide technical support and identify new requirements. Communication and organization skills are keys for this position, along with a problem-solution attitude.

Ultimately, you should be able to ensure our database systems run effectively and securely on a daily basis.

Responsibilities

• Design stable, reliable and effective databases
• Optimize and maintain legacy systems
• Modify databases according to requests and perform tests
• Solve database usage issues and malfunctions
• Liaise with developers to improve applications and establish best practices
• Gather user requirements and identify new features
• Develop technical and training manuals
• Provide data management support to users
• Ensure all database programs meet company and performance requirements
• Research and suggest new database products, services and protocols

Requirements

• Proven work experience as a Database developer (5+ Years)
• In-depth understanding of data management (e.g. permissions, recovery, security and monitoring)
• Knowledge of software development and user interface web applications
• Advanced proficiency and hands on experience with T-SQL, Stored Procedures, Cursors, Triggers, Schedulers etc.
• Familiarity working with MS SQL Server, MySQL, .Net Framework, java
• Excellent analytical and organization skills
• An ability to understand front-end users’ requirements and a problem-solving attitude
• Ability to craft detailed technical manuals.
• Excellent verbal and written communication skills
• BE/MCA/MSc Degree in Computer Science or relevant field.

Skills:

- Very Strong in WCF, WPF, MVVM, Restful WS, and XML

- Very good in Design/Architecture understanding

- Knowledge in DevExpress, Entity Framework, RDBMS and MS SQL Server would be a BIG 

PLUS. 

- Very Strong knowledge in OOPS and Design Patterns

- Working Knowledge in Design, Code reviews/quality, unit testing with NUnit/ XUnit and 

Continuous integration

- Analytical, a problem solver, with good communication skills.

- Ability to understand the requirements, analyze and articulate into design.

- Ability to find out and work with alternatives, check feasibility and propose solutions.

- Experience in Agile methodology and following best practices

- R&D mindset and thirst for exploring/learning new skills 

Qualifications 

Qualifications - BE/BTech/MCA

Experience: 6+ years 

• BE/MTech/MCA/MSc
• 3+yrs Hands on Experience in TSQL / PL SQL / PG SQL or NOSQL
• Immediate joiners preferred*
• Candidates will be selected based on logical/technical and scenario-based testing

Note: Candidates who have attended the interview process with TnS in the last 6 months will not be eligible.

1. Technical Skills Desired:
   1. Experience in MS SQL Server and one of these Relational DB’s, PostgreSQL / AWS Aurora DB / MySQL / Oracle / NOSQL DBs (MongoDB / DynamoDB / DocumentDB) in an application development environment and eagerness to switch
   2. Design database tables, views, indexes
   3. Write functions and procedures for Middle Tier Development Team
   4. Work with any front-end developers in completing the database modules end to end (hands-on experience in parsing of JSON & XML in Stored Procedures would be an added advantage).
   5. Query Optimization for performance improvement
   6. Design & develop SSIS Packages or any other Transformation tools for ETL

1. Functional Skills Desired:
   1. Banking / Insurance / Retail domain would be a
   2. Interaction with a client a

1. Knowledge in a Cloud Platform (AWS / Azure)
2. Knowledge on version control system (SVN / Git)
3. Exposure to Quality and Process Management
4. Knowledge in Agile Methodology

1. Soft skills: (additional)
   1. Team building (attitude to train, work along, mentor juniors)
   2. Communication skills (all kinds)
   3. Quality consciousness
   4. Analytical acumen to all business requirements

Position : Database Programmer:

Job Description / Required Skills

• Strong experience in Database design for complex web and mobile application, including writing complex store procedures, function, triggers and ad-hoc queries.
• Hands-on development experience with T-SQL.
• Strong experience on Database designing, normalization, optimization and performance tuning.
• Experience in advanced SQL programming, problem-solving and analytical skills.
• Experience in security, troubleshooting and optimizing the performance of databases and stored procedures.
• Experience in Refactoring/troubleshooting existing databases as needed.
• Deep understanding of referential integrity and indexing.
• Assisting with production database issues and helping to troubleshoot and isolate the root cause of issues and provide issue resolution by interacting with Developers.
• Ability to estimate development tasks accurately and meet agreed upon deadlines.
• Understanding of code promotion, version control and QA procedures.
• Good Communication skills.

Technical Skills:

• MySql, MS-SQL, SQL Server Management Studio and SQL Server Profiler.
• PostgreSQL
• DCL, DDL, DML Scripts.
• T-SQL, SSRS and SSIS
• OS Environments: Windows XP/Windows 7, Windows Server 2003/2008

Experience         :               3 to 4 years

Qualification       :               B. Tech/BE/MCA/MSC Computers

Location               :               Mumbai

Job Description

Responsibilities: -

• To understand the specifications and programmed it.
• To articulate unit test case and unit test the programmer
• Producing clean, efficient code based on specifications.
• Verify and deploy programs and systems.
• Gather and evaluate user feedback.
• Recommend and execute improvements.

Job Requirement: -

• Experience in Microsoft ASP, C#, SQL server, and github.
• Experience with software design and development in a test-driven environment.
• Experience with databases.
• Ability to learn new languages and technologies.
• Good communication skills.

Who can Apply: -

Education: -No bar

Experience: -Good to have:- BFSI domain and professional certification