MySQL Database Administrator

Company: IDFC

About the company:  IDFC Limited was set up in 1997 to finance infrastructure projects in India. With time, the company diversified into asset management, institutional broking and investment banking. In 2014, the Reserve Bank of India granted in-principal approval to IDFC Limited to set up a new bank in the private sector

Job Description - The role entails the responsibility of providing production support to bank's software applications. It includes administering and resolving day to day production applications issues, providing updates and perform root cause analysis

Position:  Production Support

Location: Mumbai

Minimum Qualification:  Bachelor of Technology (B.Tech) / Bachelor of Science (B.Sc) / Master of Science (M.Sc) /Master of Technology (M.Tech) / Bachelor of Computer Applications (BCA) / Master of Computer Applications (MCA)

Experience:  2 to 5 years of experience in production support and 1 year of relevant experience in CMS/BXP application

CTC:  12 LPA

Employment Type:  Full Time

Key Responsibilities:

• Hands on Experience Banking Production Support. Good to have knowledge of Intellect Payment, Collection, BXP, Integrator, Liquidity etc.
• System understanding and hands on experience on Application Support
• Perform all tests on production applications
• Design production support procedures, policies and documentation.
• Prepare recovery procedures for all applications and provide upgrade to same.
• Identify and resolve technical issues.
• Establish the root causes of production errors and escalate serious concerns
• Coordinate with IT groups and external vendors and ensure effective production application services to ensure reliability
• Manage code migration across environments to ensure continued and synchronized functionality
• Gather information independently, carry out necessary research and provide an in-depth analysis to resolve production issues
• Supervise all alerts related to production application and system procedures and provide services proactively 
• Prepare and coordinate communications to senior management. 
• Deliver regular and customized training to teams within the business. 
• Develop test scripts for new/changed production application capabilities. 
• Capture and share best- practice knowledge amongst the team
• Stay abreast with global market trends and competitor strategies in key markets
• Leverage in-house synergies through collaboration with internal stakeholders
• Checking the BMC tool to check the tickets and update the status of the tickets accordingly
• Maintaining the SLA, do the critical analysis of application. 

Skills and qualification:

• Technical Skill Set: Java, Spring boot, API/Microservice
• Basic Understanding of React, Angular, any UI framework , SQL
•  knowledge of database , Log tracing application like Grafana, Jaeger, Kibana, etc ,
• Deployment pipeline like Jenkins, GoCD, GitLab, etc ,
• Good to have Docker, Kubernetes, Git  
• Fair Knowledge on Oracle Database, SQL, PL/SQL, Java, Web Server, App Server, Linux, Windows Server  

● 5+ years of experience as a Data engineer or related role.

● 5+ years of experience in application development using Python

● Strong experience with SQL and good to have NoSQL.

● Experience with Agile engineering practices.

● Preferred experience in writing queries for RDBMS, cloud-based data warehousing solutions like

Snowflake.

● Ability to work independently or as part of a team.

● Experience with cloud platforms, preferably AWS, is good to have

● Experience with ETL/LT tools and methodologies.

● Experience working on real-time Data Streaming and Data Streaming platforms

·      Identifying opportunities in target markets for your organization’s products and services

·      Generating leads through cold calling prospective clients or networking at trade shows

·      Developing and nurturing relationships with key customer accounts

·      Keeping up with the latest industry developments, including market positioning of corporate competitors

·      Assessing client needs and the company’s ability to meet those needs

·      Following up with new leads and referrals generated from the sales team

Requirements:

• Bachelor’s degree in business, marketing or related field.
• Experience in sales, marketing or related field.
• Strong communication skills and IT fluency.
• Ability to manage complex projects and multi-task.
• Excellent organizational skills.
• Ability to flourish with minimal guidance, be proactive, and handle uncertainty.

Jain Software is a leading software development company that specializes in creating innovative and cutting-edge software solutions for businesses. We are currently seeking a highly skilled and experienced Software Project Manager to join our team. As a Software Project Manager, you will be responsible for overseeing the planning, execution, and delivery of software projects, ensuring they are completed on time, within budget, and to the highest quality standards.

Responsibilities:

1. Project Planning and Scope Definition:

• Collaborate with stakeholders to define project objectives, requirements, and deliverables.
• Create and maintain project plans, including timelines, milestones, and resource allocation.
• Conduct feasibility studies and risk assessments to identify potential project constraints and develop contingency plans.
• Define project scope and ensure alignment with customer expectations.

1. Team Management and Leadership:

• Lead a team of software developers, designers, and testers, fostering a collaborative and productive work environment.
• Assign tasks, set priorities, and provide guidance to team members to ensure timely project execution.
• Conduct regular team meetings to track progress, address issues, and ensure effective communication.
• Mentor and coach team members to enhance their technical skills and professional growth.

1. Project Execution and Monitoring:

• Monitor project progress, identify deviations from the plan, and implement corrective actions as needed.
• Coordinate with cross-functional teams to ensure seamless integration of software components.
• Conduct quality assurance checks and ensure adherence to coding standards and best practices.
• Track and manage project risks, issues, and dependencies to minimize disruptions and maximize project success.

1. Stakeholder Communication:

• Act as the primary point of contact for project stakeholders, including clients, senior management, and internal teams.
• Provide regular project status updates, including progress reports, risk assessments, and budget summaries.
• Manage customer expectations by ensuring clear and timely communication regarding project scope, timelines, and deliverables.
• Proactively address stakeholder concerns, resolving conflicts, and facilitating effective decision-making.

1. Continuous Improvement and Best Practices:

• Identify areas for process improvement and implement best practices to enhance project management methodologies.
• Foster a culture of continuous learning and innovation within the project team.
• Stay updated with the latest industry trends, technologies, and tools to drive efficiency and effectiveness.

Requirements:

• Bachelor's degree in Computer Science, Software Engineering, or a related field.
• Proven experience (X+ years) as a Software Project Manager or in a similar role.
• Strong understanding of software development methodologies, processes, and best practices.
• Proficiency in project management tools and software, such as JIRA, Trello, or Microsoft Project.
• Excellent leadership and team management skills, with the ability to motivate and inspire team members.
• Strong problem-solving and decision-making abilities, with a proactive and results-oriented approach.
• Excellent communication and interpersonal skills, with the ability to effectively collaborate with stakeholders at all levels.
• Strong organizational and time management skills, with the ability to handle multiple projects simultaneously.
• PMP or PRINCE2 certification is a plus.

Joining Jain Software as a Software Project Manager provides an exciting opportunity to work on challenging projects, lead a talented team, and contribute to the success of our software solutions. If you are passionate about software development, have a track record of delivering successful projects, and thrive in a dynamic and collaborative environment, we would love to hear from you.

• Thoroughly understanding the data processing pipeline and troubleshooting/problem-solving the technical team
• Acting as SPOC for client communications across the portfolio of projects undertaken by the organization
• Contributing to different aspects of organizational growth– team building, process building, strategy and business development

Desired Candidate Profile

• Post-graduate degree in relevant subjects such as Economics/ Engineering/ Quantitative Social Sciences/ Management etc
• At least 5 years of relevant work experience
• Vast experience in managing multiple client projects
• Strong data/quantitative analysis skills are a must
• Prior experience working in data analytics teams
• Credible experience of data platforms & languages in the past    

Designation: Angular Developer

Experience: 1 to 5 years

Skill Set: Angular 2+ Versions, HTML, CSS

Requirements:

• Must have experience on Angular 2+ versions
• Design, develop, test, deploy, maintain and improve software in the area of Web Development.
• Ensure the technical feasibility of UIUX designs.
• Manage individual project priorities, deadlines and deliverable.
• Making complex technical and design decisions for Angular projects.
• Adapting interface for modern internet applications using the latest front-end technologies.

Skills:

• Experienced in C# MVC ASP.Net, Net
• Should have good knowledge in JavaScript, SQL, RDBMS Concepts and Microsoft .NET
• Framework, practical implementation of Object Oriented Concepts, N-Tier Architecture
• Development and understanding of JSON, XML, SOAP.
• Good hands-on coding skills in Java Script, Ajax, C#, ASP.Net, ADO.Net, jQuery.
• Knowledge of working Android iOS mobile development would be added advantage
• Good communication and analytical skills are must.
• Candidates with experience will be preferred.

Primary Roles and Responsibilities:

• Participate in requirements analysis.
• Collaborate with internal teams to develop software design and architecture.
• Candidate should be able to write clean, scalable code using C#.
• Revise, update, refactor and debug code.
• Test and deploy applications.
• Resourcefulness and troubleshooting.
• Good analytical and problem solving skills.

• 5 to 8 years of hands on experience in automating MS Office applications like Excel, Word, PPT and Outlook using VBA 
• 5 plus years of experience in the design, development, and implementation of programming code
• Experience in database development
• VBA - Should have good experience in developing efficient logic/algorithms using VBA
• Solid understanding of SDLC concepts 
• Solid experience in MS Excel (2003, 2007, 2010, 2013,2016)
• Must be good at all excel features and excel formulas 
• Well versed with complete MS Office package (Excel, Word, Outlook, PPT)
• Work both independently and as part of a team 
• Experience in requirements gathering, effort estimate, designing and implementation and creating mock-up screens 
• Experience in databases like MS SQL Server (2005 to 2012,2014), MySQL and MS Access 
• Must have strong database concepts and DB designing skills 
• SQL - must be good at writing efficient, fine-tuned queries using joins and aggregates 
• Experience in writing Stored procedures, Triggers and T-SQL
• Nice to have programming knowledge in C# 

• VBA, SQL 

• Strong analytical and problem-solving skills 
• Excellent interpersonal and communication skills 
• Should be able to take complete ownership of the project from requirements gathering to delivery and maintenance 
• Should be able to work independently 
• Must be Proactive and Self-motivated
• Must have the ability to prioritize the work, execute tasks and meet the deadline without fail 
• Effective time management skills 
• Customer Focus, Willing to learn and self- teach any new technology 
• Strong business and collaboration skills, and responsive to service needs and operational demands.