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

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

 

 

5+ Yrs in SSIS, SQL
Bangalore
Immediate

• Design, build and deploy effective SSIS packages to validate, synthesize, transform customer data for integrated business planning and analytics
• Understand platform’s data model (table structures, linkages, optimal designs) for designing various planning use cases
• Review and analyse the data provided by customers along with its technical/functional intent and interdependencies
• Participate in the technical design, data requirements gathering and making recommendations on best practices, in case of inaccurate or missing data
• Design and automate the data loading and insights generation process with intelligent checks and balances for sustained value delivery
• Create and execute test plans,document issues and track progress at resolving issues.

Why Think n Solutions Software?
• Exposure to latest Technology
• Opportunity working in different platforms
• Rapid Career Growth
• Friendly Knowledge sharing Environment

Criteria:
• BE/MTech/MCA/MSc
• 3+yrs Hands on Experience in TSQL / PL SQL / PG SQL or NOSQL
• Immediate joiners preferred/ Maximum notice period between 15 to 30days
• 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 either of these Relational DB’s MS SQL Server / PostgreSQL / AWS Aurora DB / MySQL / Oracle / NOSQL DBs (MongoDB / DynamoDB / DocumentDB) in an application development environment and eagerness to switch DB.
• 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 plus.
• Interaction with a client a plus

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 requirement
• Think out-of-box for business solution

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

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:

As a Database developer, you will be responsible for designing, creating database, stored procedure, functions, ETL etc.
and upgrade of database that are leading the way in assuring high quality of data visualization and products. You will be
challenged with systematic database development methodologies in concurrent computing software architecture
environment. The engineer will have the opportunity to work with software developers and the site support engineer ona regular basis.

Job responsibilities:

• Development of high-quality database solutions.
• Develop, implement and optimize stored procedures and functions using T-SQL.
• Review and interpret ongoing business report requirements.
• Research required data.
• Build appropriate and useful reporting deliverables.
• Analyze existing SQL queries for performance improvements.
• Suggest new queries.
• Develop procedures and scripts for data migration.
• Provide timely scheduled management reporting.
• Investigate exceptions about asset movements.

Job requirements:

• Should understand operating system, relational database, concurrent computing, and client/server architecture
and mobile environment.
• Should have excellent problem solving and trouble shooting skills
• Should have ability to excel in cross functional team environment
• Should have experience in Cross-Platforms (Unix/Windows) application testing environment
• Should have excellent written and verbal communication skills in English
• Should have attention to detail, positive attitude under stress
• Design, plan, and develop programs to optimally extract, transform, and load data from data sources to the
target systems. Expert level knowledge of T-SQL, Stored Procedures, Data Modeling, Views, and Functions.
• Maintain source code for database
• Efficient in writing optimized SQL queries.
• Develop SQL scripts, table, views, indexes, and complex queries.
• Design & maintain the existing databases and ensure their stability, reliability, security and performance.
• Coordinate with software developers, review (and modify the queries if required) and approve the SQL queries
written by them for the production deployment.
• Strong knowledge in Database design, develop, test, implement, fine-tune, enhance and maintain new and existing databases.

Professional qualifications:

• 4 – 6 years of relevant experience
• Bachelor's degree in Computer Science, Engineering or a related subject.
• Excellent understanding of Microsoft SQL Server.
• 3-4 years of experience with SQL Server Reporting Services and SQL Server Analysis Services.
• Familiarity with the practical application of NoSQL\NewSQL databases.
• Sense of ownership and pride in your performance and its impact on company’s success.
• Critical thinker and problem-solving skills.
• Team player.
• Good time-management skills.
• Great interpersonal and communication skills

We are urgently looking Azure Data Factory Engineers with 3 to 7 years of overall experience, having good experience on Azure Data Factory and SSIS.

Requirements:

• Qualification: Engineering Graduate.
• Years of Experience: 2+ yrs of relevant experience on Azure Data Factory & SSIS.
• Strong understanding of ETL/ELT concepts.
• Hands on experience on Azure Data Factory.
• Exposure of Cloud technologies, standards, and platforms.
• Sound knowledge of ADF pipeline, configuration, parameters, variables, Integration services runtime (part of Data Factory).
• Strong Experience on SSIS.
• Sound knowledge of implementing slowly changing dimensions and transactional, fact less, snapshot fact tables.
• Azure Data Warehouse.
• Knowledge on Azure components especially file storage and Azure Sql, Blob storage and Data Lake Gen2 storage (just used as a file system on the blob).
• Azure Data Migration tool.
• Well versed with RDBMS systems like Sql server, DDL, DML scripts.
• Sound knowledge of T-SQL and stored procedures.
• Strong Query writing skills, Scheduling tools.
• Ensure quality deliverable and ability to extend work hours if required.
• Azure Certification: Preferred.
• Ability to understand Customer requirements and convert the requirements into technical specifications.
• Ability to understand the overall solution and design components to fit the overall solution.
• Ability to take technical decisions and support the decisions with justifications.
• Ability to work in Agile manner.
• Ability to work independently without much guidance.
• Self-Motivated, team player, results oriented, strong Time Management skills.
• Excellent written and verbal communication skills.
• Willing to travel to outside India (Short term as well as long term)

Who we are? A smart tech company that places more focus on lateral thinking and uses common sense to create innovative models and create an impression at the world stage. From being an absolute no paper usage to being the most desired organisation to work with and create the perfect partners for business and perfect workplace for any professional. We intend to change the way business will be conducted and managed henceforth What is Eazo? An integrated app for logistics - Supply chain needs to evolve. There are many pieces that needs to be brought together to drive an effective model which now Eazo has designed using it’s ecosystem while tapping in to the largest workforce imagined.