Team Lead

14 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

    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. ...

  • IT Team Lead

    1 week ago

    Ghaziabad, Uttar Pradesh, India Muthoot Fincorp Limited Full time ₹ 5,00,000 - ₹ 15,00,000 per year

    TEAM LEAD - ITUsing .NET infrastructure to create software solutions to meet the customer's requirements Collaborating with internal teams to produce software architecture and design Organising meetings with the clients to discuss the project details Writing code aligning with the customer's brief and requirements Preparing and maintaining code...

  • Sales Team Lead

    2 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

  • 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...

  • Human Resource Executive

    6 days ago

    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

    22 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

    3 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...

  • Sales Team Leader

    6 days ago

    Ghaziabad, Uttar Pradesh, India Prefect generator Pvt . Ltd Full time ₹ 3,60,000 - ₹ 4,80,000 per year

    Lead and supervise the Operations team to meet or exceed targets and KPIs.Monitor daily sales performance and implement strategies to improve conversion rates.Conduct regular coaching sessions and performance reviews for team members.Assist in the development and execution of sales campaigns and initiatives.Manage customer escalations and provide quick...

  • Lead Generation

    1 week ago

    Ghaziabad, Uttar Pradesh, India Perfect Generator Technologies (P) Ltd Full time ₹ 2,40,000 - ₹ 3,00,000 per year

    Job DescriptionDesignation: Executive Marketing (Lead Generation)Job location: Muradnagar - GhaziabadExp: 1 Years Qualification: Any Graduate Female Candidates onlyPreferred Industries: Preferred from Recycling Industry however, sharp candidate from other industry will also work.Roles & Responsibilities: Identify and generate new business leads through...