Candidate need to handle the ticket raised by the team, where they asked to perform the operations on database. Once ticket get’s solved they need to update team for the same.
What would be the key responsibilities expected out of this role
1) Help write and optimize in-application SQL statements
2) Ensure performance, security, and availability of databases
3) Prepare documentations and specifications
4) Handle common database procedures such as upgrade, backup, recovery, migration, etc.
5) Good in DML and DDL
Must Have Skills:
MS-SQL
Good To Have Skills:
SSIS & SSRS Or MSBI
Notice Period:
15 Days - 30 Days (Immediate Joiners Preferred)
Similar jobs
· Knowledge of Appian architecture and its objects best practices
· Participate in analysis, design, and new development of Appian based applications
· Team leadership and provide technical leadership to Scrum teams
· Must be able to multi-task, work in a fast-paced environment and ability to resolve problems faced
by team
· Build applications: interfaces, process flows, expressions, data types, sites, integrations, etc.
· Proficient with SQL queries and with accessing data present in DB tables and views
· Experience in Analysis, Designing process models, Records, Reports, SAIL, forms, gateways, smart
services, integration services and web services
· Experience working with different Appian Object types, query rules, constant rules and expression
rules
Qualifications
· At least 3 years of experience in Implementing BPM solutions using Appian 19.x or higher
· Over 8 years in Implementing IT solutions using BPM or integration technologies
· Certification Mandatory- L1 and L2 a
· Experience in Scrum/Agile methodologies with Enterprise level application development projects
· Good understanding of database concepts and strong working knowledge any one of the major
databases e g Oracle SQL Server MySQL
Additional information
Skills Required
· Appian BPM application development on version 19.x or higher
· Experience of integrations using web services e g XML REST WSDL SOAP API JDBC JMS
· Good leadership skills and the ability to lead a team of software engineers technically
· Experience working in Agile Scrum teams
· Good Communication skills
Company Overview
CareStack is a complete cloud-based dental software solution for scheduling, clinical, billing, patient engagement, and reporting needs of dental offices of any size - whether it's a single location or a large multi-site DSO with hundreds of locations.
The company was founded in 2015 and the commercial launch was done in early 2018. Since then, more than 1000 offices have chosen CareStack as their single source of truth. This is the fastest growth till date in the dental practice management software market, dominated by 100 year old distribution companies.
More about CareStack
● Rated by independent B2B software reviews and research analysts as the most modern, innovative and customer experience focussed company in the space with the fastest growth in the segment.
● Important strategic go to market partnerships with dental industry leaders like Delta Dental, Darby Dental and several others.
● Venture backed with over $60M raised from leading financial and strategic investors.
● HQ'd in Orlando, FL with offices in Minnesota, Bangalore, Trivandrum and Cochin.
Role Overview
CareStack seeks to hire Software Development Engineer - 1 to build its next generation healthcare platform. You will be reporting to a Staff SDE in your business unit , to develop and release services and solutions for our platform, aligning with your business unit’s goals and objectives.
Key responsibilities
● Technical Design
You can be a specialist in technology areas, but capable of creating complete designs to solve a specific problem that accomplishes a definitive product feature or enables a technical advancement.You should work with your lead to review your design and embrace the feedback
● Process Definition/Adherence
You should deliver estimations, review test scenarios/cases created by QAs in your team, participate in sprint grooming and planning meetings. You must learn, practice and evangelize standard techniques for grooming, defining complexity of stories and estimation.
● Code Quality
At Carestack we believe that your code reflects your character. Code for scale, produce maintainable reusable code. You must commit to clean coding, continuous refactoring to ensure a high level of code quality. Continuously learn, practice and evangelize coding patterns/best practices within and outside your team. You should ensure testability of team functional areas, facilitate integration testing, resolve deep rooted technical issues and proactively collaborate with team members in solving complex problems.
● Team Player
You should proactively communicate to resolve dependencies within and outside the team. Understand organizations culture code and streamline conversations and activities that will further instill this code. Mentor and coach new additions to your team.
● Value/Mission Alignment
Be a champion for CareStack within the Engineering team. Help drive workplace and cultural norms within your business unit that align with CareStack company values.
This role may be for you if you…
● Have an insatiable itch to join and the courage to scale an early-stage technology company.
● Have 2-4 years of experience in building modern day web platforms, using Microsoft technologies on the backend.
● Can be a generalist or specialist with deep understanding of building software components that meet defined requirements, with good understanding of .NET Core/ASP.NET.
● Are proficient in data structures and algorithms, and object oriented analysis and design of software systems.
● Are a backend specialist with good understanding of event driven programming, distributed systems, caching/in-memory computing systems, data modeling for transactional systems.
● Solid understanding of relational and non relational databases including warehouses.Preferably MySQL, MSSQL, Vertica and CosmosDB
● Solid understanding of CI/CD patterns and IaC.
● Expertise in building ETLs in both batch and streaming model.
● Expertise in building and testing APIs and micro services
This role may not be for you if you…
● Don’t have the itch to design solutions and write code and you don’t grab every other opportunity to review and write code.
● Don’t have the fire in you to fight for your design suggestions and debate with logical data points
● Don’t have the trait to be transactional in code reviews/design discussions, accept your mistakes and appreciate better ideas from your peers.
● Haven’t developed the habit of doing objective conversations that are data driven.
As one of our Backend Software Engineers, you will be part of the team responsible for the development of all server-side logic, the definition and maintenance of the database, and ensuring high performance and responsiveness to requests from the front-end developers.
What will you be engaged in?
Collaborate with key internal stakeholders to determine how to scalable design backend systems and APIs to meet their needs
Architect, develop and operate services deployed to millions of users
Collaborate with the DevOps team for the necessary infrastructure needed for services to run on the cloud platform
Write backend services and Restful APIs
Be in charge of data migration, transformation, and scripting
Write reusable, testable, and efficient code
Design and implementation of low-latency, high-availability, scalability, and performant applications
Implement security and data protection
Manage web apps that impact millions of users
What do we expect from you?
3 + years of experience building large-scale backend systems
Knowledge of MVC concepts
Knowledge of web applications systems
A good understanding of data pipelines, data lakes, and data ingestion is Plus
Strong understanding of Database management (MSSQL, SQL)
Strong understanding of NoSQL Database (MongoDB)
Strong understanding of RESTful API
Understanding of JavaScript and Typescripts
Understanding of Node.js frameworks and Nest JS Framework
Passion for building high performance, high throughput, low latency frameworks
Problem-solving mindset
Understanding of GIT Source code
Good at JavaScript and passionate about solving challenges using JavaScript.
Good Understanding of Pub/SUB (Kafka, RabbitMQ etc.)
Fintech Industry experience is plus
.NET C# developer provides custom web application development using the .NET Framework, C#, http://VB.NET">VB.NET, http://ASP.NET">ASP.NET, SQL Server and other advanced components of Microsoft technology and provide training to programmer analysts who support the web services manager' responsibilities.
Responsibilities:
The tool development also involves working with SQL queries and web front end
Designing, developing, and testing web applications with .Net HTML, CSS and other technologies
Design and development of software applications (primarily web based) used in various areas of the bank (such as Loans processing, Treasury, Middle Office )
Manages the architecture, design, and coding of software for TFI from concept to finished product, in order to answer the needs of the Strategies, Sales, and Trading departments
Consults with end users within the Strategies, Sales, and Trading departments to identify where technology can automate current processes to enhance revenues and cut cost
Maintains currency in technical skills and all relevant fixed income industry sector factors
May lead the work of others and provide ideas which help to enhance TFI software applications
Software design & development principles such as SOLID, Domain-Driven-Design and Object-Oriented Development
ORM frameworks, particularly the Entity Framework
Managing source code with Git, including Gitlow WorkflowPosition : 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
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
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