Development Lead (Microsoft SQL Server, and NoSQL databases, Cosmos DB)-

Trigyn Technologies Limited.; NTR; On-site; INR 2,500,000 - 4,500,000; Full time

Job summary

Trigyn Technologies Limited. seeks a Senior Database Lead to guide the design, development, and maintenance of enterprise database solutions across MS SQL Server and NoSQL platforms.

You will develop complex stored procedures, optimize performance, and integrate databases with internal and external APIs while mentoring a team of database developers. Strong leadership and 8+ years of IT experience required.

Qualifications

• Educational qualification includes B.Tech/M.Tech in CS or MCA or equivalent.
• Minimum 8+ years of IT industry experience with leadership abilities.
• Experience in maintaining enterprise databases and security practices.
• Hands-on SQL/PL-SQL development and performance tuning.

Responsibilities

• Lead the design, development, and maintenance of enterprise database solutions.
• Design and develop stored procedures, functions, packages, triggers, and views.
• Build and optimize large business logic within database objects for performance and scale.
• Perform SQL query tuning, indexing, and performance optimization.
• Integrate databases with REST APIs and external systems.
• Support payment gateway integrations and transaction management.
• Design and maintain ETL processes, data migration, and synchronization.
• Perform database code reviews and enforce coding standards.
• Troubleshoot database performance issues and production incidents.
• Mentor database developers and provide technical guidance.

Skills

Database design

SQL optimization

Performance tuning

Data migration

REST API integration

Mentoring

Team leadership

Stored procedures

PL/SQL

Education

B.Tech/M.Tech in Computer Science or others/MCA

Tools

MongoDB

Cassandra

Cosmos DB

Azure SQL Database

SQL Profiler

ETL tools

Job description

Required Educational Qualification

• B.Tech/M.Tech in Computer Science or others/MCA.

Required Experience

• He/She must have 8+ years of experience in IT Industry
• Proven experience leading development teams and
• Maintenance of enterprise databases.

Required Skills & Competencies

• Lead the design, development, and maintenance of enterprise database solutions using MS SQL Server, and NoSQL databases.
• Design and develop complex stored procedures, functions, packages, triggers, and views to support business-critical applications.
• Build and optimize large, complex business logic within database objects while ensuring performance and scalability.
• Perform SQL query tuning, execution plan analysis, indexing, and database performance optimization.
• Integrate databases with internal and external APIs and third-party systems.
• Support secure payment gateway integrations by managing transaction processing and database interactions.
• Design and maintain ETL processes, data migration, and data synchronization activities.
• Perform database code reviews and ensure adherence to coding standards and best practices.
• Troubleshoot database performance issues and production incidents.
• Mentor database developers and provide technical guidance.

• Required Technical Skills

Required Technical Skills

• Strong expertise in S?L PL/SQL, including:
• Stored Procedures
• Functions
• Packages
• Triggers
• Cursors
• Collections
• Dynamic SQL
• Exception Handling

• Experience with NoSQL databases such as MongoDB, Cassandra, or Cosmos DB.
• Expertise in SQL query optimization and database performance tuning.
• Experience handling high-volume transactional databases.
• Experience integrating databases with REST APIs and external systems.
• Experience supporting payment gateway integrations and transaction management.
• Strong understanding of relational database design, normalization, and indexing strategies.
• Knowledge of database security, backup, recovery, and auditing.

Preferred Skills

• Experience with SQL Performance Tuning tools (SQL Profiler , Execution Plan).
• Exposure to Azure SQL Database.
• ETL tools and data migration experiences
• Experience with version control and deployment processes for database objects.