Home » » jobs in MPOnline Ltd

jobs in MPOnline Ltd

Written By Ajit Kumar on Friday, March 3, 2017 | 7:05 AM

The culture of MPOnline Limited is built around providing excellence in our respective domains, contributing to the growth and success of our employees, a keen sense of integrity, a great sense of humour and a strong sense of social responsibility with us. We continually strive to ensure that MPOnline Limited employees experience job Enrichment and satisfaction.

Position for which you can Apply

  • Software Developer
  • Business Analyst
  • Database Administrator (DBA)

Eligibility Criteria

  • Full Time Graduation or Post Graduation
  • Not more than 2 years break in career (education or between jobs)
  • Consistent academic records Class X onwards (Minimum 50%)
  • Candidate should not have attended the MPOnline Selection Process in the last 6 months

Software Developer
  • BE/ B.Tech/ MCA/ M.Sc (CS, IT)
  • Minimum 1-3 Years
Skills Required
  • MS SQL Server, ASP.Net, C#.Net, .Net Framework, Visual Studio, MVC, Angular JS
  • Strong experience in T-SQL & must have worked on Procedures, functions, views, triggers, Cursors, query writing, Database Tuning, query optimization, normalization and strong logic and analytical ability.
  • Diagnose and resolve database access and performance issues
  • Ensure all database systems meet business and performance requirements
  • Participate in discussions, involving the application creation and understand the requirements and provide the back-end functionality to produced desired output
  • Determine the impact of proposed functionality on current system
  • Document unit test plans and completes unit testing successfully
  • Be aware of potential blocking, deadlocking and write code to avoid those situations
  • Plan and coordinate data migrations between systems
  • Creation and maintenance of technical documentation
  • Create functions and stored procedures to provide custom functionality as per the requirements
  • Create Entity Relationship (ER) Diagrams to the proposed database
  • Develop reports in SQL Server Reporting Services
  • Design, Develop and Deploy SSIS Packages.
  • Identify and write best possible code in case of new deployments or when rewriting code when migrating to newer version of SQL Server

 Business Analyst

    BE/B.Tech/MCA/M.Sc preferably MBA(IT)


    1-3 Years Experience with enterprise software solutions and large, complex organizations Candidate having experience with government departments will be preferred

Skills Required

    Experience in Business Process Consulting, problem definition, Design /Detailing of Processes
    Should be able to actively participate in daily and weekly project planning/reporting activities
    Excellent verbal and written English communication skills
    Should have worked on response to RFPs
    Understanding of systems engineering concepts


    Responsible for interaction with the clients and other stakeholders
    Define the action items or processes that will solve business requirements
    Successfully shape and draft the business request, which will even include changing requests
    The ability to conduct cost/benefit analysis
    Business case development
    Modeling techniques and methods
    Gather, interpret, and translate customer needs into functional and nonfunctional requirements – translate business problems into requirements that facilitate application development
    Understand system behavior, inputs, and outputs as they relate to business functions
    Ability to manage multiple activities in a deadline-oriented environment; highly organized and flexible
Database Administrator (DBA)

    BE/B.Tech/MCA/M.Sc (Comp. Science)
    MCDBA / MCT certification


    Minimum 5 Years in SQL Server Environment

Skills Required

    Has 5+ years of experience in database development and management, support in MS SQL Server environments.
    Strong experience in Database Administration in SQL Server ( 2005/2008/2012)
    Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
    Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
    Ability to detect and troubleshoot SQL Server related CPU,memory,I/O, disk space and other resource contention.
    Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
    Expert experience in implementing operational automation.
    Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
    Knowledge of SQL Server tools ( Profiler, DTA, SSMS, PerfMon, DMVs, system sprocs)
    SQL Development – ability to write and troubleshoot SQL Code and design ( stored procs, functions, tables, views, triggers, indexes, constraints )


    Technical documentation skills
    MSSQL/Oracle DBA certified Mandatory.
    SSIS ETL Tool, Configuration and Development
    SSRS Configuration and Development
    Migration Strategy
    Configuration SQL component
    Managing SQL server agent
    Configuration and Managiung Databases
    Configuration and managing instances
    implementing clustered instance
    Resolving concurrency
    Audit of sql server
    Importing and Exporting data
    Managing Logins and Server Roles
    Managing User and database roles
Share this article :



Support us : APTF257 || మాష్టారు || Ajit Kumar ||
Copyright © 2013. Big Jobs - All Rights Reserved
Designed by The Masters Mind || Published by Divine Spirit || Tech Gnan ||
Proudly powered by Ajit Kumar || On Facebook || On Twitter ||