11+ Database analysis Jobs in Pune | Database analysis Job openings in Pune

Job Description:      

• 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,
• 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 6 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

• 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

About the Organisation:

Our client works in the area of skilling and livelihoods for underserved youth. This is a pioneering program with a strong PPP model, an agency-led approach to livelihoods and a vision of socio-economic transformation. They are run through a public-private partnership that empowers the Government, Corporates, NGOs and Citizens to work together towards changing lives. The provision of location and capital expenditure for the centres is taken care of by the Government. Corporates contribute through CSR funds to provide operational expenses. NGOs come on board to provide various skilling courses to the youth. With penetration in more than 400 of the 500 odd slum communities of Pune, the program has now expanded to other cities viz. PCMC, Dombivali, Aurangabad and also States viz. Delhi, Odisha,Hyderabad and upcoming in Ambivli.

About the role:

The CIO will work closely with the Program teams to fully understand the program landscape and implement technology and data solutions.

Your role to supplement the Organisational goals:

Develop a technology and data roadmap in line with the operational strategy and growth plan of the

organisation and in alignment with the Mission Cell, MEL (Monitoring, Evaluation and Learning)

framework and Programme Operations Team. (Timeline: Sep 2023)

Ensure that all key programs can be mapped onto common parameters and measures.

Create an overall technology and data architecture that outlines and connects key technology components.

Identify the processes/systems that need to be digitised/ created for enabling scale,including appropriate solutions.

Develop tools and processes for data collection, analysis and management within LCF

Monitor changes or advancements in technology to discover ways the company can gain competitive advantage (ongoing basis).

ERP System

Maintain and when required, develop, the existing ERP system. (Timeline: ongoing)

Develop and implement the next version of the organization’s ERP system including reports/

dashboards. (Timeline: Sep 2023 for finalization of BRD and initiation of development)

Support with, and track, adoption across the organization

Partnerships

Identify and engage with technology partner(s) to design and implement the solutions for

effective program and data management. (varying timelines as per solution)

Establish partnerships with IT providers

Infrastructure

Oversee the technological infrastructure (networks and computer systems) in the organization

to ensure optimal performance

Establish a process for and approve, purchases of technological equipment and software

Security

Analyze the costs, value and risks of various aspects of IT implementation to advise

management and suggest actions

Data Management and Analytics

Design automated reporting formats for reporting to key stakeholders such as Government,

donors and board of directors.)

Analyse, synthesize, and produce key insights from the data that can inform the approach and

design improvisations in the program

Data and knowledge management

Lead the overall knowledge management system for the organization and enable data to be available on cloud with clear protocol for sharing and storage, such that security and confidentiality are assured.

Finalization of Data Protection and Management Policy, training of relevant team members, implementation and compliance tracking.

Who we are looking for:

● Education : Masters in Information Technology

● Experience: Minimum 15+ years of experience

● IT skills – familiarity with modern databases and IT systems.

● Analytical skills

● Problem-solving skills

● Partnership management

● Communication skills – must have an excellent verbal and written communication skills.

● High social intelligence : able to engage teams, create relationships of trust with stakeholders.

● Able to reflect, empathetic and a good listener.

● Experience in Need Identification, Project Management, Stakeholder Management

● Ability to manage multiple projects and stay on deadline.

● Proficiency in Microsoft Office programs, including Word, Excel and PowerPoint

Proven work experience as a Database Programmer, Database Developer, or similar role.

Strong proficiency in SQL and hands-on experience with PostgreSQL.

Solid understanding of relational database concepts and principles.

Experience in database design, schema modeling, and optimization.

Familiarity with database administration tasks, such as user management, backup and recovery, and performance tuning.

Ability to write efficient SQL queries, stored procedures, and functions.

Detail-oriented with a focus on data accuracy and integrity.

Familiarity with software development methodologies and programming languages is a plus.

AEM Forms Developer would need to have at least 3 years of experience.

3 plus years of experience in application development.

2 years of experience with AEM Forms 6.4/6.5, Adobe LiveCycle ES 2, 3 or 4 Or Adobe AEM Forms focusing on LiveCycle Designer, LiveCycle Workbench, LiveCycle Admin Console.

Experience and working knowledge of designing forms and rules in AEM Forms Designer.

Experience in projects on Dynamic Assembly of PDFs using DDX, Manipulation of PDF using DDX, calling APIs of Output and Assembler service (using Java SDK) Hands on Application Development experience (Workflow in AEM Forms, Output, Reader Extensions, Process Management etc).

Solid knowledge and expertise in JavaScript, Java, REST API, JSON, XSD, XML,PDF, Database - Strong communications skills to effectively communicate at different levels of management.

Experience on adaptive form designs, interactive communication,creating templates and automated workflows.

Who we are

 Incorporated in 2010, Futran Solutions is a specialized provider of digital technology solutions focused on Data Analytics, Cloud, Automation and New Age App Development.

 We believe in simplicity and agility. Our ‘Make it Ez’ framework and accelerators enable our clients to realize business value faster through rapid development, intelligent automation and cloud adoption.

Futran is headquartered in Edison, New Jersey, and has a global delivery center in Hyderabad, India. With a strong belief in ‘Firgun’ philosophy, Futran is a leading supporter of many community services, especially uplifting young, deserving talent.

Specialties

• Futran specializes in digital with 100% of its revenue from digital solutions.
• With a startup culture and product mindset, Futran has always adopted agile and lean way of working
• Futran has a meritocratic, self-reliant, empowering culture that puts talent ahead of everything else, resulting into greater talent retention and productivity

 For more details visit our website: http://www.futransolutions.com/">www.futransolutions.com  

 Go to linkedin:  https://www.linkedin.com/company/futran/">https://www.linkedin.com/company/futran/  

• Development of custom objects, validation rules, workflows
• Development of Lightning components
• Meeting with project managers to determine CRM needs.
• Developing customized solutions within the Salesforce platform.
• Designing, coding, and implementing Salesforce applications.
• Creating timelines and development goals.
• Good experience in developing components by integrating API from external applications
• Good knowledge in SSO/oAuth integration
• Testing the stability and functionality of the application.
• Troubleshooting and fixing bugs.
• Maintaining the security and integrity of the application software.

8-16 years of overall database administration and support/operations experience, with a successful delivery track record.
# Proficient knowledge in  MySQL, HANA administration.
#Should have knowledge in setting up DR and HA approaches
#Should have strong Knowledge in Backup & Recovery.
# Should have played a L2 role in current position
# Experience of working in large landscape/environment where multiple database flavors are running.
# Knowledge on Database capacity planning/strategy is an added advantage
# Knowledge & Experience on other database as HANA flavors are added advantage
# Hands on experience with expert knowledge of Unix/Linux flavors w.r.t Database.
# Good understanding of operational framework like ITIL/ITSM.
# Should be capable of Owning, Leading and coordinate operational tasks, customer escalations, process improvements.
# Excellent presentation & communication skills are a must.

·       Primarily responsible for working on various service requests related to maintaining database security (roles, privileges, authentication), creating schema and copying data

·       Work on installation, configuration, creation and administration of HP Vertica database clusters and AWS RDS MySQL database.

·       Work with platform, product and other support teams to participate in release and change management processes to implement new features/functions as well support mandatory patches or upgrade activities on weekends.

·       Responsible for database performance tuning, query tuning and database operations including migration and upgrade.

·       Plan and implement periodic upgrades of database schema and perform testing and verification of released database schema upgrades.

·       Configure and manage database backup and restore, participate in Disaster Recovery

·       Create and maintain documentation, procedures and best practice guides for database deployment and maintenance.