
About TogetherSolutions
About
Company social profiles
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
Job Profile
Purpose of Role: To support and maintain the existing and future applications managed by ABD (Agile Business Development) Team.
Main Responsibilities:
- To work on existing and future applications as required
- Work with ABD India Application Support and Business Support team to address production issues and/or to do development work
- Work with US ABD team to coordinate the on-going support and monthly release of C-Hub (Customer-Hub) application and other ABD Applications
- Report status to management on project progress
- Identify and escalate related issues and risks
- Coordinate with others in Development and Business Support team to implement new features of SQL Server/ MS Web based technologies
- Assess current modules and offer performance improvements techniques
- Make sure Database Design Standards/coding standards established by ABD are followed
- Constant communication with ABD leadership team in US.
- Problem Solving ability with “Can-do” attitude
- IT experience in Banking industry is preferred
Candidate Profile:
- Minimum 10 years of experience at least 3-5 years of experience in Corporate & Investment Banking area and Bachelor's degree in Engineering, Accounting, Finance, or equivalent
- Expertise with MS SQL Server development including SSIS and SSRS, Proficient in development of Stored procedure, Views, Functions etc in MS SQL Server
- Experienced with DBA kind tasks such as replication, linked server, query analyzer, DBCC commands, data transfer from one DB server to other DB Server etc
- Experienced in MS Excel VBA and macro scripting
- Knowledge of data Encryption in database
Criteria:
- 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.
Job Description:
- Technical Skills Desired:
- 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
- Design database tables, views, indexes
- Write functions and procedures for Middle Tier Development Team
- 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).
- Query Optimization for performance improvement
- Design & develop SSIS Packages or any other Transformation tools for ETL
- Functional Skills Desired:
- Banking / Insurance / Retail domain would be a
- Interaction with a client a
3. Good to Have Skills:
- Knowledge in a Cloud Platform (AWS / Azure)
- Knowledge on version control system (SVN / Git)
- Exposure to Quality and Process Management
- Knowledge in Agile Methodology
- Soft skills: (additional)
- Team building (attitude to train, work along, mentor juniors)
- Communication skills (all kinds)
- Quality consciousness
- Analytical acumen to all business requirements
Think out-of-box for business solution
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)
We are looking for a Senior Microsoft SQL Developer to design, develop, test, plan, implement and maintain conceptual and logical database models.
For this role, you should know how to analyze system requirements and implement migration methods for existing data. Hands-on experience with SQL Server 2012 and above is also required. Ideally, you are familiar with database design, reviewing code, writing stored procedures, creating and modifying SQL agent jobs, making structural changes to tables and views.
Ultimately, you will develop database solutions to ensure project information is stored effectively and securely.
We’re a fast-growing company with clients in the United States, UK, and Australia. You will join a team of talented developers, quality engineers, product managers whose mission is to impact above 100 million people across the world with technological services by the year 2030.
Working as Senior Microsoft SQL Developer at Navtech, you will:
- Design conceptual and logical data models and flowcharts.
- Improve system performance by conducting tests, troubleshooting, and integrating new elements.
- Design and Build database systems of high availability and quality depending on each end user’s specialized role.
- Help write and optimize in-application SQL statements.
- Handle common database procedures such as upgrade, backup, recovery, migration, etc.
- Ensure performance, security, and availability of databases.
- Use high-speed transaction recovery techniques and backup data.
- Provide proactive and reactive data management support and training to users.
- Determine, enforce and document database policies, procedures, and standards.
- Perform tests and evaluations regularly to ensure data security, privacy, and integrity.
- Monitor database performance, implement changes, and apply new patches and versions when required.
- 5+ years of experience in SQL Server Development with at least 1 year of Lead experience.
- Advanced experience in database monitoring, troubleshooting, performance tuning, and high availability strategies for SQL Server 2016, SQL Server in Cloud (AWS RDS preferred).
- Advanced skills in resolving database locking conflicts/blocking and resource utilization.
- Ability to work with other developers and engineers to analyze database performance and identify problems in areas such as execution plans, index coverage, and SQL server statistics.
- A thorough understanding of Performance Monitoring, Tuning, and Optimization, using native and third-party monitoring and troubleshooting tools.
- Advanced knowledge of SQL Server Disaster Recovery (DR) options, Always On availability groups, and experience administering Windows Server, including Active Directory, Failover clustering, database partitioning, security, and encryption (a plus).
- Experience supporting SSIS, SSRS, replication, database mirroring (a plus).
- PowerShell scripting experience with the ability to write automated scripts and strong knowledge of system tables and DMV’s is required. (a plus).
- Administering Microsoft SQL Server databases in a high transaction, 24x7 database environment (a plus).
- Experience in Postgres, No-SQL databases (a plus).
- MCSA SQL Server 2012/2016 , MCSE or MCDBA (a plus).
- Should have excellent logical, analytical, and communication skills with client interaction experience.
Benefits
- Working with industry giants while following your passion for technology.
- Competitive pay package with additional bonus and benefits.
- Performance review and Appraisal Twice a year.
- Family Health Insurance cover for self and family.
- Work with US, UK, and Europe-based industry-renowned clients for exponential technical growth.
- Work with a culturally diverse team from different geographies
Office Location: Goregaon Mumbai
Position description:
4+ years of experience in database development.
Primary Responsibilities:
- Understand requirements from front end applications developers
- Write advanced queries, stored procedures, cursors, functions & triggers
- Conduct code reviews
- Work with high-traffic application servers
- Complete understanding of various DB like Postgresql, Mongo DB, MySQL
- Ability to identify root cause and mitigate issues
- Ability to lead a team of DB developers
Required Skills:
Mandatory: Passionate about sports, Problem solving, Team player, Target & Result oriented, Strong communication skills
Functional: Oracle SQL, PostgreSQL Development - TSQL, Advance Queries, Query Optimization, Stored Procedures, Triggers & Cursors, Database Design, Indexes, Joins, ETL tools like SSAS, SSIS, High Data Volume Processing, DB Backup/Recovery.


