Senior Software Engineer

CIVICA India is seeking a creative and self-motivated Software Engineer (SE) with considerable proficiency in SQL Development & who is keen to join a multi-cultural software company. The successful candidate will be responsible for application development, Support and maintenance. This role will be measured by the following criteria: 85% of working hours to be billable; delivery of high quality product in accordance with our ISO +001 Quality Management System.

Key Responsibilities and Duties:
• 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
• Analyse existing SQL queries for performance improvements
• Suggest new queries
• Develop procedures and scripts for data migration
• Provide timely scheduled management reporting
• Investigate exceptions regarding asset movements
• Perform unit testing of work to ensure maximum code coverage.
• Write documentation and comment code as per guidelines.
• Ensure code is properly version-controlled.
• Comply with corporate test processes and ISO +001 Quality Management System.
• Work independently with Business user for support tickets and new requirementsGeneral

Users are responsible for:
• Ensuring that operations carried out using data are for a proper purpose, and for safeguarding the confidentiality and security of that data.
• Ensuring personal data is processed in a way that complies with national legal and statutory regulations and with CIVICA policy.
• Ensuring that they are authorised to supply any information requested, that it is given to only to those authorised to receive it, and that any such requests for information are for a proper purpose.
• Implementing and acting in accordance with their statutory and legal obligations, CIVICA policies, standards, procedures, guidelines and controls
• Protecting CIVICA assets within their control from unauthorised access, disclosure, modification, destruction or interference
• Reporting security events or potential events or other security risks to CIVICA
• Performing their job with security best practice in mind and conforming to any best practice frameworks which are used within CIVICA
• Employees must not be in the course of their work for CIVICA, writing/accepting malicious code or anything intended to cause undesired effects, security breaches or damage to a system.
• Please note anyone found writing malicious code may be subject to disciplinary procedures as per company policy.
• Line Managers must ensure that anyone reporting them receive the appropriate level of training and guidance to ensure that employees have the knowledge to comply with legislation, policy and procedure.

Requirements

Essential Competencies
• Developer in Data Migration projects to migrate data from the customer legacy system to the Civica applications
• Performed data migration into customer non-production and production environments when required
• Development of high-quality database solutions Develop, implement and optimize procedures and functions using Microsoft Azure Data Factory
• Understand and/or consider the impact the data migration has on the functionality of the Civica applications.
• Review and interpret ongoing business report requirements
• Research required data
• Analyse existing SQL and Azure Data Factory queries for performance improvements and suggest new queries
• Attend meeting with the customer as required
• Produce technical design documentation where appropriate for modules being developed.
• Ensure technical designs are reviewed by peers before commencing with development.
• Understand enterprise development approaches and design methodologies.
• Ensure coding development meets quality standards of business requirements within project time frames