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.

Technical Project/Product Lead

We are seeking a Technical Project/Product Lead with 8-10 years of experience in Microservice.Net Technologies with at least 2-4 years of experience in technical project lead. As a Project Lead, you will be responsible for leading business and technology outcomes for assigned programs or projects.

Educational Qualification:

The ideal candidate should possess educational background in Engineering along with a proven track record of delivering successful projects.

Technology/Skills:

• Expertise in Microsoft.NET Technologies and MVC Architecture.

• Strong design experience including experience in architecture and design patterns.

• DevOps/ Cloud experience is an added advantage.

• Strong experience in integration architecture including API Gateway, Service Catalogs etc.

• Strong experience in integration design for secured and scalable API’s and Webservices.

• Excellent communication and interpersonal skills, with the ability to build strong relationships with stakeholders at all levels.

• Proven ability to lead cross-functional teams and deliver projects on time, within budget, and to the required quality standards.

Roles & Responsibilities:

• Lead and manage end-to-end technical project, ensuring successful planning, execution, and delivery within scope, budget, and timeline.

• Collaborate with cross-functional teams, including software developers, architects, quality assurance, and stakeholders to define project requirements, objectives, and deliverables.

• Provide technical guidance and expertise in Microsoft .NET, MS SQL, ASP.NET Core, and Azure to the project team, assisting with problem-solving, troubleshooting, and decision-making.

• Ensure adherence to software development best practices, coding standards, and quality assurance processes throughout the project lifecycle.

• Act as a liaison between technical and non-technical stakeholders, effectively communicating project updates, progress, and risks.

• Conduct regular project status meetings, providing comprehensive reports and updates to project sponsors and stakeholders.

• Stay up to date with industry trends, emerging technologies, and best practices in Microsoft .NET, MS SQL, ASP.NET Core, and Azure, and apply this knowledge to project execution.

• 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

Requirements:

• Retrieve Data from Databases

SSRS developers optimize SQL server queries to retrieve data efficiently and quickly. As

teams submit requests for different ways of doing things, SSRS developers work with them to find solutions that meet their needs.

• Design Data Solutions

To create and design best-practice data warehouse solutions that support business reporting tasks. This is achieved using different programs and software, such as Microsoft Excel, MS SQL Server, and Tableau.

• Create and Maintain Reporting Processes

To maintain a record of the different reporting processes in place. Evolve ways & means for a more effective data management.

• Resolve IT and Data Issues
• Provide Delivery Plans and Estimates for Projects

• 5+ years of object-oriented software development of web applications
• 5+ years of C# in a .NET environment
• Preferable Experience in Cloud Technologies (AWS, AZURE)
• Experience with MS SQL stored procedures, database design and optimization
• Experience developing and utilizing web services
• Experience with high volume consumer oriented web sites
• Experience working in an Agile Scrum environment
• Experience with formal test procedures, release management
• Preferable Travel industry experience preferred, especially programming associated with GDS’s - SABRE, Farelogix, and Travelport
• Ability to distill complex business needs into functional requirements
• Excellent follow-up, verbal and written communication skills
• Excellent problem solving skills and an ability to make good decisions
• Team player with a professional attitude
• Ability to manage multiple tasks and maintain tight schedules
• Ability to work effectively with a geographically dispersed team in India

Strategic and Development Responsibilities

• Ability to "think outside the box"
• Ability to provide accurate and timely project estimates.

Pluses:

• Experience with Angular JS frameworks and Mobile Development.
• Experience with developing machine learning algorithms.
• Experience on projects that required localization/globalization
• Experience with MS SQL Reporting Services
• Knowledge of web farm configuration and best practices

Software Tools/Languages

Required:        MS Visual Studio, MS SQL Server Management Studio, IIS, AWS

C#, Web Services, MS SQL (stored procedures), Jenkins, DevOps Tools.

Education

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