DBA

· Extensive experience in Appian BPM application development
· 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

Bachelor's degree in computer science, information systems, or related field preferred

Five or more years of experience with technical product configuration, design, and/or integration using the following tech stack:

In-depth knowledge of .Net Framework.

Should have experience in C#.Net, LINQ and .Net Parallels.

Hands-on experience in MVC 3.0 or webforms or winforms.

Must have experience in working WCF (Windows Communication Foundation).

Experience in WPF, Windows forms, Silverlight and Enterprise Libraries is preferred.

Should possess strong architectural and design skills; implemented various design patterns and frameworks.

Hands-on experience in SSRS and Reports development and support

Experience in SQL Server 2008\2012 is mandatory. Should be able to write complex stored procedures and functions. Optimize long running queries using tuning advisor and Execution plan.

We are looking for Young, Energetic and Experienced Professionals who can join our Team as Senior Database Developer.
• Experience in Database Development and Support in MS SQL Server environments.
• Hands-on End to End Database Development encompassing Database Design and Development
working with cross-functional teams.
• Hands-on experience of Transact SQL(T-SQL) utilizing SQL Server 2016 and above.
• Excellent understanding of T-SQL programming
• Hands-on experience in SQL - writing hands on experience in complex stored procedure, function,
triggers
• Sound knowledge of SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS)
• Develop, implement and optimize stored procedures and functions using T-SQL
Review and interpret ongoing business report requirements
• Analyze existing SQL queries for performance improvements.
• Develop procedures and scripts for data migration Provide timely scheduled manage

1) designing and implementing applications
2) developing and testing software and resolving technical issues that arise
3) Prepare and maintain all applications utilizing standard development tools
4) Utilize backend data services and contribute to increasing existing data services API
5) Lead the entire development life cycle right from concept stage to delivery and post-launch support
6) Convey effectively with all task progress, evaluations, suggestions, schedules along with technical and process issues
7) Document the development process, architecture, and standard components
8) Coordinate with co-developers and keeps project manager well informed of the status of development effort and serves as a liaison between development staff and project manager
9) Keep abreast of new trends and best practices in web development
10) Fixing bugs

Job Description:

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)

Primary Role

• As an SSRS Report Engineer, the primary job role is to develop a transactional data report using Microsoft SQL Service Reporting Service 2016 or above.
• This includes developing high performing Stored Procedures, Functions, and corresponding reporting formats.
• Required to design the required logics for the queries and collaboratively coordinate with the rest of the team.

 

Main Duties / Responsibilities

• Design & implement high performing T-SQL queries as per the functional specification.
• Create Technical Specification.
• Effective troubleshooting of technical issues and bugs.
• Package deployment and release management.
• Provides technical support to customers.
• Participate in Requirements discussions.
• Must be able to manage timelines and task priorities.
• Attention to detail and maintaining high-quality standards is a must.

 

TECHNICAL KNOWLEDGE

• Experience in Microsoft SQL Server 2016 (or above) and Microsoft SQL Service Reporting Service 2016 (or above).
• Knowledge of T-SQL including complex SQL queries, stored procedures, views and functions.
• Experience with usage of indexes and T-SQL performance tuning techniques.

 

QUALIFICATIONS

• Bachelor’s Degree or an equivalent qualification

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.

About Increasingly:Increasingly is an award-winning, fast-growing retail technology company focused specifically on the automation of cross-selling for online retailers. Our clients include large global corporations like Samsung & Canon to several small to medium size retailers across the globe. Our AI-based algorithms help a customer buying a TV on Samsung to find the matching soundbar & purchase both together. Increasingly is headquartered in London with offices in Lisbon & Bangalore. We work with clients in over 30 countries & 20 languages.We are looking to rapidly expand our technology & product development operations in India. And we need smart, ambitious people like you who enjoy a fun yet challenging work environment. We believe strongly that diversity & inclusion are the foundations for a lasting, incredible culture. We also believe that it's important to get the balance right between work & life.The job and its impact:- Be solely responsible for designing databases and ensuring their stability, reliability, and performance. Ensure that the database system is efficient and error-free. - Optimize your queries when a website is too slow due to database performance, write queries for heavy traffic databases, and design tables and indexes for the best database architecture and performance.- Lead a team of developers and successfully solve issues and make improvements to databases, while ensuring all work meets the necessary requirements.- Learn new technology. There's a ton of stuff in there that falls outside the classical SQL model, and learning how to use it will improve your craft.- Find a problem to solve and don- t be afraid to fail. Learn by making mistakes.- Be fluent in the current technology and able to learn how to correctly utilize new technology, often on the fly. As a result, you are must be the most versatile member of any team.- Everything changes so fast the fundamentals you learned five or 5 years ago may no longer be applicable. Architect skills. Developers must be architects these days. Understand the big picture of mapping. Try to find the next set of standards.What essential skills you need:- Schema design, data modeling, data upgrades, develop distributed and highly scalable applications with a focus on scalability performance availability reliability security and maintainability of the applications or technologies.- Code review, SQL query tuning, SQL patches, ownership, attention to detail ad-hoc queries & automation in support of internal and external customers data exchange and integration needs.- Research, troubleshoot, and resolve data issues impacting extract delivery, application design enhancements, development, debugging, and optimization with respect to data concerns and new product features.- Cloud-managed database engines such as Amazon RDS. NoSQL solutions such as Redis, Cassandra, MongoDB, make regular recommendations for system improvements.- Extensive experience with backups monitoring performance tuning and troubleshooting tools & techniques. Ability to identify bad SQL statements & optimize them.- Support QA & development team in project queries, test plans and test cases to improve the database with an ability to communicate effectively within a team.- Self-starter collects data, analyzes the collected information, designs algorithms, draws flowcharts and then implements code for the logic developed through algorithms and flowcharts.What are the benefits:- You'll get to work in one of the hottest & fastest growing retail technologies in Europe right now. - You'll get paid a competitive salary & be working directly with a super experienced team of people. - You'll get a great place to come to work every day. Varied, complex, challenging & with a great culture that you can shape & change.

Duration of contract: 12 Months Total Yrs. of Experience: 7years Relevant Yrs. of experience: 7years Detailed JD *(Roles and Responsibilities): · 7 yrs experience with technology. · Proven experience with heavy usage of SSIS and SQL database tool and related infrastructure like development, deployment, administration and investigation of issues with quick turnaround (functional as well as performance). · Demonstrated development/deployment/administration/support with SSAS Tabular project using advanced concepts like percentile, partitioning, row level security implementation is a must · Good understanding of reporting UIX and demonstrated development of reports using "Online Microsoft Power BI" features and visuals for 5K+ users. · Demonstrated effective and proactive communication with clients · In general, the candidate would be working in fast paced agile environment having around 8-10 team members to work with and direct daily client interaction (in second shift 2pm to 11pm) in GDM model. The daily activities would be as below but not limited to o identify data needs and analyze available data o comprehend business and technical requirements o analysis of code and understanding existing system o and preparing high level design document, low level design o contributions to schedule and effort estimation o Build, Unit testing, Understanding of configuration management · SQS Server 2016 experience is plus · Azure experience related to Microsoft business intelligence stack is a plus · SSRS experience is good to have

We conceptualize, architect, build and run scalable and complex, modern day full stack technology platforms