Team Lead

16 hours ago


Ghaziabad, Uttar Pradesh, India .Kreate Full time ₹ 20,00,000 - ₹ 25,00,000 per year

Job Title/Designation: Team Lead- Database

Core SQL Skills:

(Ms Sql) 5+ year :(Must have skills)

Advanced querying (complex joins, subqueries, CTEs, window functions).

Stored procedure, function, and trigger development.

Error handling and transaction management.

Dynamic SQL.

Working with various data types (including XML, JSON, and spatial data).

Data Manipulation Language (DML):

Efficient INSERT, UPDATE, DELETE, and MERGE statements.

Understanding of data integrity constraints.

Data Definition Language (DDL):

Creating and modifying tables, views, indexes, and other database objects.

Understanding of database schemas and normalization.

Database Design and Architecture:

Relational Database Design:

Normalization and denormalization principles.

Entity-relationship modeling (ERD).

Data warehousing and OLAP concepts (if applicable).

Database Object Design:

Designing efficient and maintainable stored procedures, functions, and triggers.

Understanding of indexing strategies.

Implementing database security.

Database Architecture:

Understanding of the different SQL server editions and their capabilities.

Understanding of high availability and disaster recovery concepts.

Performance Optimization:

Query Optimization:

Analyzing query execution plans.

Identifying and resolving performance bottlenecks.

Index tuning and management.

Understanding of statistics and their impact on query performance.

Database Performance Tuning:

Monitoring and optimizing database server performance.

Understanding of SQL Server Profiler and Extended Events.

Understanding of resource management.

SQL Server Agent's Role:

Automation:

SQL Server Agent is the job scheduling and alerting service in SQL Server. It enables developers to automate routine database tasks, reducing manual effort and ensuring consistency.

Key Functions:

Scheduling jobs (e.g., backups, index maintenance, data imports).

Monitoring database events and sending alerts.

Executing T-SQL scripts, operating system commands, and other tasks.

Skills Related to SQL Server Agent:

Job Creation and Management:

Ability to create and configure SQL Server Agent jobs.

Defining job steps, schedules, and notifications.

Understanding of different job step types (T-SQL, operating system command, PowerShell).

Scheduling:

Proficiency in creating flexible job schedules (e.g., daily, weekly, monthly, recurring).

Alerting and Notifications:

Setting up alerts to notify administrators of database events (e.g., errors, performance issues).

Configuring notifications (e.g., email, pager) for job status and alerts.

Troubleshooting:

Analyzing job history and logs to troubleshoot job failures.

Identifying and resolving issues related to job scheduling and execution.

Soft Skills:

Problem-solving: Ability to analyze and resolve complex database issues.

Communication: Clear and effective communication with developers, analysts, and other stakeholders.

Teamwork: Ability to work effectively in a team environment.

Attention to detail: Meticulous attention to detail in database design and development.

Continuous learning: Staying up-to-date with the latest SQL Server features and technologies.

When considering SQL Server Agent in the context of a SQL Server database developer's skills, it's crucial to understand how it's used for automating database tasks. Here's how it fits into the skillset:

Good to have skills - PostgreSQL,MySQL ,NoSQL ,SSIS ETL Tool


  • Team Lead

    3 days ago


    Ghaziabad, Uttar Pradesh, India Royal bee Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Lead, mentor, and manage a telesales team to achieve monthly and quarterly sales targets.Develop sales scripts and ensure team members effectively communicate product benefits, features, and offers.

  • Team Lead

    2 weeks ago


    Ghaziabad, Uttar Pradesh, India Paytm Full time ₹ 10,00,000 - ₹ 15,00,000 per year

    About us: Paytm is India's leading mobile payments and financial services distribution company. Pioneer of the mobile QR payments revolution in India, Paytm builds technologies that help small businesses with payments and commerce. Paytms mission is to serve half a billion Indians and bring them to the mainstream economy with the help of technology. ...

  • Kronos Team Lead

    3 weeks ago


    Ghaziabad, Uttar Pradesh, India ADP Full time

    Team Lead – UKG Migration (Workforce Central to Dimensions) role, with a strong focus on technical system setup, client deliverables, and initiative-driven leadership:Role Overview:We are seeking a proactive and technically skilled Team Lead to drive end-to-end UKG migrations from Workforce Central to Dimensions. This role demands hands-on expertise in...

  • Sales Team Lead

    4 days ago


    Ghaziabad, Uttar Pradesh, India Trivoid Electronics Full time ₹ 4,00,000 - ₹ 12,00,000 per year

    Responsibilities:* Manage sales pipeline & forecasting* Collaborate with marketing on campaigns & strategies* Lead B2B sales team in industrial & institutional markets

  • Executive/team Lead

    4 weeks ago


    Ghaziabad, Uttar Pradesh, India Tekpillar Full time

    We seek a Sales Development Manager with banking experience who is focused on results to spearhead sales strategies drive customer acquisition and increase revenue Responsibilities include recognizing new market prospects overseeing a sales team and marketing banking products to corporate and retail customers Responsibilities Duties - Devise and carry...

  • Team Lead

    3 days ago


    Ghaziabad, Uttar Pradesh, India oceansunited24 exports and imports pvt ltd Full time ₹ 6,50,000 - ₹ 7,00,000 per year

    The eligibility criteria for all the profiles are mentioned below:-Minimum 1 year of International BPO Experience.· It would help if you had the designation TL on paper. (Minimum 12 months on paper is mandatory)· The span of control is Min Associates).· Operational knowledge - Healthcare (this experience is not mandatory but can be preferable) + Internal...

  • YouTube Uploader

    1 week ago


    Ghaziabad, Uttar Pradesh, India The Lead Vision Full time ₹ 4,00,000 - ₹ 6,00,000 per year

    About Us: The Lead Vision is a dynamic and fast-growing company focused on delivering engaging video content to a wide audience. We are looking for a detail-oriented and reliable YouTube Uploader to join our Operations team and help manage our video content upload process efficiently.Job Description: As a YouTube Uploader, you will be responsible for...


  • Ghaziabad, Uttar Pradesh, India The Lead Vision Full time ₹ 1,20,000 - ₹ 1,80,000 per year

    About Us:At The Lead Vision, we believe that people are our greatest asset. We're a dynamic and growing organisation committed to building a supportive, inclusive, and high-performance work culture. As we expand, we're looking for a proactive and dedicated HR Executive to join our Human Resources team and play a key role in driving our HR initiatives...

  • Project Engineer

    24 hours ago


    Ghaziabad, Uttar Pradesh, India Team Search LLP Full time ₹ 1,80,000 - ₹ 2,20,000 per year

    Job Title:- Project EngineerJob Location:- New DelhiQualification:- Degree in Electrical Engineering or ITI Electricals OR EEE Preferably from Commercial Kitchen & Laundry equipmentExperience:- Minimum 4 to 6 YearsIndustry:- Commercial Kitchen & Laundry equipmentRoles & Responsibility:-Hands-on experience in the installation, commissioning, andmaintenance...

  • Team Leader

    4 days ago


    Ghaziabad, Uttar Pradesh, India ITIO Innovex Pvt. Ltd. Full time ₹ 5,00,000 - ₹ 15,00,000 per year

    Job Title:Team Leader – B2B Sales (IT / Fintech)Experience:3–5 YearsLocation:Kaushambi, GhaziabadCompany:ITIO Innovex Pvt. Ltd.About UsITIO INNOVEX PVT. LTD. is a fast-growing Custom Web and Mobile App Development Company. Our diverse team of domestic and international developers brings extensive expertise across a wide range of technologies and...