Talent.com
Database Lead

Database Lead

BridgesoftDindigul, IN
5 hours ago
Job description

Job Description :

Technical Deep Dive Opportunities :

  • SSIS Project Modernization :    The role presents an opportunity to migrate or modernize existing SSIS packages. This could involve refactoring legacy packages for improved performance, error handling, and maintainability. Investigating newer SSIS features available in SQL Server 2022+ (e.g., improved control flow tasks, enhanced logging) would be a key component. Further, the encryption / archiving requirement suggests a need for expertise in security best practices within SSIS, potentially involving sensitive data handling procedures and compliance regulations.
  • SQL Server Performance Tuning Focus :  The role emphasizes database tuning and performance, suggesting a need for in-depth SQL Server internals knowledge. This includes query plan analysis, index optimization, statistics management, and understanding resource utilization. The senior developer could implement strategies such as :
  • Query Store analysis :  Using Query Store to identify and fix regression issues after code changes or server upgrades.
  • Extended Events :  Leveraging Extended Events to capture detailed performance data for troubleshooting bottlenecks.
  • In-Memory OLTP : Exploring the potential of In-Memory OLTP for performance-critical workloads.
  • Advanced T-SQL Development :    Beyond basic stored procedure writing, the role requires proficiency in advanced T-SQL concepts. This includes utilizing indexed views, user-defined functions (UDFs), triggers, cursors (though their use should be minimized in favor of set-based operations), XML handling, and distributed transactions. Understanding transaction isolation levels and concurrency control mechanisms in SQL Server is crucial. Specifically, the description calls for SQL Server 2017 or higher, meaning utilizing newer features of T-SQL.

Operational and Support Responsibilities :

  • Root Cause Analysis and Problem Prevention :  The job description emphasizes identifying root causes and proposing solutions to prevent recurring problems. This requires a strong analytical skillset and a systematic approach to troubleshooting. Implementing monitoring and alerting systems to proactively detect potential issues is essential. Developing a knowledge base of common problems and their solutions would also be beneficial.
  • Database Topology and Documentation :  Documenting database topology, architecture, processes, and procedures is a critical responsibility. This documentation should be comprehensive, up-to-date, and easily accessible to other team members. This also includes maintaining data dictionaries and data lineage documentation. The documentation should be kept in a centralized repository, following a consistent format.
  • Operational Support and Problem Resolution :  Providing operational support and resolving recurring problems requires strong communication and collaboration skills. This includes working with other members of the data team to understand their needs and providing timely and effective solutions. The ability to prioritize tasks and manage multiple competing demands is also essential.
  • Capacity Planning and Resource Management :  Assisting with capacity planning and resource expansion requires an understanding of database performance metrics and resource utilization. This involves analysing data to identify trends and predicting future resource needs. The senior developer may also be responsible for recommending hardware upgrades or software optimizations.
  • Collaboration and Communication :

  • Working with Project Managers :  Collaborating with project managers to understand business needs and opportunities for process improvement is crucial. This requires the ability to translate business requirements into technical specifications and to communicate technical concepts to non-technical audiences.
  • Teamwork and Knowledge Sharing :    Establishing and maintaining effective working relationships within the team is essential. This includes sharing knowledge and expertise with other team members, mentoring junior developers, and participating in code reviews.
  • Years of Exp :
  • 05-09 Years
  • Create a job alert for this search

    Lead Database • Dindigul, IN

    Related jobs
    • Promoted
    Oracle Cloud Technical Lead

    Oracle Cloud Technical Lead

    de Novo SolutionsDindigul, IN
    We are looking for a highly skilled and motivated.Managed Services team in India.This role is pivotal to establishing and growing our offshore capability, working closely with our UK-based counterp...Show moreLast updated: 30+ days ago
    • Promoted
    SAP Basis Cloud architect Advisory

    SAP Basis Cloud architect Advisory

    HCLTechDindigul, IN
    CAA (Cloud Architect Advisory).This is SAP Cloud Architect position which is elevated role as per career progression / path for SAP Basis consultant. Architect’s primary role / responsibility is to pl...Show moreLast updated: 30+ days ago
    • Promoted
    Senior SAP Cutover Lead

    Senior SAP Cutover Lead

    MaitsysDindigul, IN
    SAP transformation programs, including.S / 4HANA, RISE, and cloud-based migrations.The ideal candidate will be responsible for orchestrating all phases of the technical and business cutover, coordina...Show moreLast updated: 8 days ago
    • Promoted
    Database Developer - Virtual Drive - 15th Sep

    Database Developer - Virtual Drive - 15th Sep

    PwCdindigul, tamil nadu, in
    Experienced with MySQL Enterprise Versions Products and should have performed MySQL Upgrades & applied patched.Hands-on experience on migration from MySQL to Maria and vice-versa.Configuring & trou...Show moreLast updated: 30+ days ago
    • Promoted
    Team Lead

    Team Lead

    Programmers.iodindigul, tamil nadu, in
    Job Title : Team Lead- Power BI.Should be able to work until 10 : 30 PM IST.Location : PAN INDIA Remote, Work from Home.Experience Required : 7 - 15 Years. Note- Please ensure the Power BI Desktop App is ...Show moreLast updated: 8 days ago
    • Promoted
    Delivery Lead

    Delivery Lead

    RapidBrainsMadurai, IN
    Job Title : Portfolio Lead (Digital Delivery & Strategic Client Transformation).Remote / Hybird / Onsite as permanent employee. Company : Our Premium Client - German Based.We're seeking an experienced an...Show moreLast updated: 6 days ago
    • Promoted
    Cloud Data Delivery & Modernization Lead

    Cloud Data Delivery & Modernization Lead

    Pacific Data IntegratorsDindigul, IN
    Core Technical & Domain Skills.Extensive hands-on experience with cloud modernization of ETL pipelines.Strong data debugging skills and deep understanding of enterprise analytics stack.Proven track...Show moreLast updated: 18 days ago
    • Promoted
    PostgreSQL Database Administrator

    PostgreSQL Database Administrator

    DigitalRecruiter APPdindigul, tamil nadu, in
    PostgreSQL Database Administrators (DBAs).The role involves providing BAU support, performance tuning, and maintenance for PostgreSQL environments while ensuring database availability, security, an...Show moreLast updated: 7 days ago
    • Promoted
    Sr. Data Architect - Data Architect - Snowflake & SAP BW / ECC(Urgent Hire)

    Sr. Data Architect - Data Architect - Snowflake & SAP BW / ECC(Urgent Hire)

    Reflections Info Systemsdindigul, tamil nadu, in
    We are looking for 10+ years experienced Sr.A minimum of 10 years of experience in data engineering, encompassing the development and scaling of data warehouse and data lake platforms.The candidate...Show moreLast updated: 8 days ago
    • Promoted
    Technical Lead

    Technical Lead

    HCLTechmadurai, tamil nadu, in
    Informatica EDC CAI / CDI Developer.Informatica CAI (Cloud Application Integration) - Integration Platform.API Development (REST / SOAP, Swagger / WSDL) - Web Services & APIs. Workflow Orchestration (Even...Show moreLast updated: 30+ days ago
    • Promoted
    NonStop Database Admin

    NonStop Database Admin

    Coffeee.iomadurai, tamil nadu, in
    Job Title : -NonStop Database Admin.Perform NonStop Database Admin tasks that may include, but not limited to support activities such. Database Product Installation, Maintenance, Planning, Monitoring,...Show moreLast updated: 5 days ago
    • Promoted
    Senior Data Modeler

    Senior Data Modeler

    Neutrino Advisory, an Inc 5000 CompanyDindigul, IN
    The role involves designing and optimizing data models across transactional, analytical, and cloud environments using platforms such as SQL Server, Oracle, Snowflake, and Azure Synapse.The ideal ca...Show moreLast updated: 7 days ago
    • Promoted
    Database Expert TimescaleDB

    Database Expert TimescaleDB

    Block LiquidityMadurai, IN
    We are a fast-growing company building advanced analytics platforms and dashboards for traders, builders, analysts, quants and researchers. Our mission is to make complex data accessible through cle...Show moreLast updated: 3 days ago
    • Promoted
    Database Administrator

    Database Administrator

    BizTech StaffingDindigul, IN
    We are seeking an experienced Database Administrator (DBA) with expertise in managing and migrating data across multiple database platforms, including Amazon Redshift, MongoDB, SQL Server, and Orac...Show moreLast updated: 8 days ago
    • Promoted
    IDMC Lead

    IDMC Lead

    LumenDataMadurai, IN
    LumenData is a recognized leader in modern data architecture and cloud data management.We specialize in implementing cutting-edge solutions using Informatica’s Cloud Data Management suite, deliveri...Show moreLast updated: 8 days ago
    • Promoted
    Senior Database Administrator

    Senior Database Administrator

    CitNOW GroupMadurai, IN
    Founded in 2008, CitNOW is an innovative, enterprise-level software product suite that allows automotive dealerships globally to sell more vehicles and parts more profitably.CitNOW’s app-based plat...Show moreLast updated: 30+ days ago
    • Promoted
    MERN Stack Lead

    MERN Stack Lead

    QubryxDindigul, IN
    Qubryx, a US based Product Consulting and Development company, is looking for an.Full-stack lead developers to work on.What you'll need to be considered (Required) : . Overall 10+ years total work exp...Show moreLast updated: 8 days ago
    • Promoted
    snowflake Cloud Database Administrator

    snowflake Cloud Database Administrator

    Leading automobile GCCmadurai, tamil nadu, in
    Cloud Platform Expertise : Familiarity with leading cloud platforms such as Amazon Web Services (AWS), Microsoft Azure, and Snowflake is essential. Understanding their database offerings, such as AWS...Show moreLast updated: 30+ days ago