Automation Tester (Python)

Designation SQL Database Administrator

LocationMohali, Chandigarh,

Job Description & Responsibilities

• Provide database monitoring and support of multiple 24/7 enterprise SQL Server always on availability groups.
• Troubleshoot issues as they occur, working with the Operations team during incidents, and resolving problems quickly and to a high standard.
• Maintain database performance by identifying and resolving production and application development problems, calculating optimum parameter values, evaluating
• new release code, answering developer questions and advising on code changes.
• Develop and configure database solutions, configuration of new systems, defining database structure, improving security, ensuring back-ups and restores meet audit requirements.
• Ensure all database systems meet RPO & RTO policies.
• Work with the Engineering Team to design and optimize SQL solutions.
• Work with the Operations Team to manage, install and configure servers in multiple data centres around the world.
• Update job knowledge by participating in educational opportunities, reading professional publications, maintaining personal networks, and participating in professional organizations.
• Ability to work closely with developers to resolve issues and improve systems.
• High level knowledge of Windows and Windows security and how they affect SQL Server.
• Knowledge of PowerShell scripting.
• Excellent analytical and problem-solving skills.
• Excellent written and verbal communication skills.

Education

• BE, B. Tech, M. Tech in Computer Science or equivalent.

Certifications

• Knowledge of Clustering.
• Knowledge of Database Migration.
• Knowledge of Database Mirroring.
• Knowledge of Log Shipping.
• Knowledge of Mirroring.
• Knowledge of Replication.
• Knowledge of SQL DBA.

Work Experience

• 05 to 08 years of experience as a SQL Database Administrator.
• Experience in Airlines or travel domain is a plus.

Skills

• Responsible for installation and configuration of SQL Server 2016/2017/2019.
• Scheduling jobs and job monitoring.
• Performing SQL Server upgrades, applying patches, and monitoring status.
• Manage user and role level security.
• Understanding and modifying existing stored procedures.
• Configured always On, log shipping and replication.
• Creating databases and logins with permissions in SQL Servers as developer's request.
• Implemented database standards and naming conventions for the database objects.
• Monitoring the databases as per the daily schedule tasks to check the health of databases using DBCC commands.
• Monitoring jobs like backup and restore check the error log for daily running batch jobs.
• Performance tuning high-level understanding.
• Troubleshooting issues high-level understanding.

We are pleased to inform you that we have multiple job openings available exclusively for local candidates from Morbi or nearby areas.

If you or anyone in your network residing in Morbi is actively seeking a job opportunity, we encourage you to apply or share this information further.

Location: Morbi

The End User Support (EUS) / IT Service Desk Team Leader role is like project manager of this entire project. He/She will be responsible for managing and supervising the entire end-user support operations, ensuring high-quality service delivery in accordance with the agreed Scope of Work (SoW) and defined SLAs.

1. Team Management & Supervision

o   Manage the daily operations of the End User Support Engineers, Helpdesk Coordinator, and Network Technician.

o   Allocate tasks, monitor performance, and ensure coverage across all shifts or locations (as applicable).

o   Review ticket queues, ensure timely response/resolution, and minimize escalations.

2. Service Delivery Oversight

o   Ensure all support services (incident, request, configuration) are delivered as per agreed Service Level Agreements (SLA).

o   Monitor open tickets and proactively address delays or recurring issues.

o   Take necessary action on recurring & repeat issue to fix the permanently.

o   Conduct regular service quality reviews and corrective action planning.

3. Technical Assistance & Escalation Support

o   Provide Level 2/3 technical support to the support team on hardware, software, AD, antivirus, networking, and IT asset management.

o   Guide the team in resolving complex issues and ensure user satisfaction.

o   Coordinate with internal IT teams and vendors for issue resolution, patching, installations, or upgrades.

4. IT Asset Management Control

o   Ensure all IT assets supported by the team (laptops, desktops, printers, attendance systems, conference devices, network items, CCTV) are:

o Properly tagged, recorded, and updated in the IT Asset Management Tool.

o Compliant with asset tracking and audit policies.

5. Process Implementation & Improvement

o   Implement and maintain Incident Management, Request Fulfillment, and Change Management processes in ManageEngine (ServiceDesk Plus) in coordination with IT and vendor teams.

o   Define workflows, categories, escalation paths, SLAs, and approval hierarchies as per ITIL best practices.

6. Software Licensing & Compliance

o   Ensure awareness of software licensing policies and usage.

o   Support the team in maintaining compliance with licensing limits and software audit readiness.

7. Team Motivation & Skill Development

o   Motivate the team and maintain high morale and work discipline.

o   Identify skill gaps and coordinate internal/external training to upskill the support team.

o   Promote a culture of continuous improvement, accountability, and customer satisfaction.

8. Reporting & Communication

o   Prepare and share daily, weekly & monthly reports on ticket trends, SLA compliance, asset updates, and team performance.

o   Conduct regular review meetings with internal IT stakeholders and vendor managers.

o   Act as the first point of contact for escalations from business users and management.

Job Summary: We are looking for a skilled SQL Developer to join our team. The ideal candidate will have a strong understanding of database management systems, experience in writing complex SQL queries, and a solid understanding of data structures and algorithms. The SQL Developer will be responsible for designing, developing, and maintaining SQL databases, ensuring their performance, availability, and security.

Key Responsibilities:

• Design, develop, and optimize SQL databases, tables, views, stored procedures, and triggers.
• Develop efficient and complex SQL queries for data extraction, transformation, and loading (ETL).
• Create and maintain database schema designs, data models, and ER diagrams.
• Analyze and optimize complex SQL queries for better performance.
• Implement indexing strategies, query optimization techniques, and other performance tuning practices.
• Ensure data integrity and security by designing and implementing database constraints, data validation rules, and security policies.
• Work with software developers, data analysts, and system administrators to integrate SQL databases with other applications and systems.
• Collaborate with business stakeholders to understand data requirements and provide solutions.
• Document database designs, stored procedures, and other database-related activities.
• Maintain accurate records of database changes, optimizations, and configurations.

Eligibility Criteria:

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• 3 to 5 years of experience as an SQL Developer or in a similar role.
• Proven experience in database design, development, and management.
• Experience with SQL Server, MySQL, PostgreSQL, or other relational database management systems.
• Proficiency in writing complex SQL queries, stored procedures, functions, and triggers.
• Strong understanding of indexing, query optimization, and performance tuning.
• Familiarity with database security best practices.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration abilities.
• Attention to detail and commitment to quality.
• Ability to work independently and in a team environment.
• Experience with cloud-based databases (e.g., AWS RDS, Azure SQL Database).
• Experience with NoSQL databases.

What We Offer:

·        Competitive salary and performance based incentives.

·        Comprehensive benefits package, including health

·        Opportunities for professional growth and career advancement.

·        A collaborative and innovative work environment.

Hi All,

Greetings from LMV Group

We are hiring  Female Telecallers

Education - Any graduate fresher is eligible

Age limit - 18 TO 28 years

Experience required - Fresher 0 to 6 months is required

Languages known - Telugu, English

candidate must have good communication skills.

• Strong experience of Angular 2+ and above along with other technologies like HTML5, CSS, jQuery, AJAX with good knowledge of ECMA Scripts.
• Strong knowledge of JS Fundamentals.
• Design & development of Angular applications as per desired specifications, along with experience in frameworks/libraries like jQuery, Bootstrap, Typescript etc.
• Architecture design, development, testing and maintenance of Web Apps, Implementation based on Angular Application MVC Patterns.
• Own end to end product modules/features (from the requirement to going live)- Design & code review, troubleshoot & help team members on issues.
• Gather requirements by interacting directly with the end-users.
• Research on open source framework/technology required for developing the feature/application.

Primary Duties

• Build a broad knowledge across various systems and processes via knowledge transfer and capture any missing information on the wiki

• Gather software requirements by talking to various stakeholders and document them

• Implement software solutions after discussing the requirements and taking direction from the Technical lead and talking to other colleagues within and outside the team

• Provide necessary effort and time estimates for tasks to aid scheduling and prioritization

• Provide necessary 3rd line support to the Operations teams including software fixes as needed

• Work on any BAU development activity including on-boarding new data sets and delivering new markets into the system

• Work with external vendors from time to time to gather necessary requirements for new data or changes to existing data specifications

• Maintain pro-active communication with relevant stakeholders and keep them updated on progress

General

• Any other duties commensurate with the post holder’s position and seniority; and
• All employees should understand that it is their personal responsibility to comply with all organisational, statutory and regulatory policies and procedures.

Experience, Knowledge & Skills

Essential

• 4+ years’ experience of programming in Java.
• 4+ years’ experience working with SQL including complex queries, stored procedures, views, database design and solid understanding of database concepts (preferably SQL Server)
• Experience of both Linux and Windows environments, scripting and tools
• Willing to carry out operational data tasks alongside developing new solutions
• Well organised with the ability to prioritise and manage multiple streams of work
• Excellent communication skills

Beneficial

• Experience working with Cloud environments (preferably AWS)
• Experience in handling financial data sets and familiarity with financial instruments (equities, futures, FX)
• Experience working with data pipelines and building ETL solutions
• Experience working with tools like Flink, Kafka and Tableau

Educational & Professional Qualifications

• Educated to degree (or equivalent) level or higher.
• A degree with mathematical and computing content (e.g. Computer Science, Maths, Physics)

• Meet prospective clients, execute effective product demonstrations, emphasizing product features  and benefits with focus on the value of the solution 
• Consult with hospitals to understand product needs and expectations 
• Prospect, educate, qualify, and generate interest or Sales Opportunities in key account areas (SML hospitals) 
• Develop and accomplish a lead generation plan including Outbound and Inbound prospect 
  management 
• Follow up with prospective clients and be an expert in closing deals 
• Attending sales group meetings concerning sales targets, forecasts, and reporting on maret situation and competition 
• Participating in conferences, representing the company for brand awareness 
• Ensure proper reporting of sales/CRM numbers to GM sales to effectively drives sales and output 
• Maintaining and expanding the database of prospects for the organization 
• Providing suggestions to improvise on sales and marketing strategies