Consulant-Client (Chennai)

Consulant-Client (Chennai)

18 Aug
|
IGT solutions
|
Chennai

18 Aug

IGT solutions

Chennai

Job Summary

We are looking for a skilled SQL Developer with strong expertise in designing, developing, optimizing, and maintaining relational databases. The ideal candidate should have hands-on experience in writing complex SQL queries, stored procedures, performance tuning, and database optimization. The candidate will work closely with application developers, business analysts, and stakeholders to deliver high-quality database solutions.

Key Responsibilities

- Design, develop, and maintain SQL database objects including tables, views, stored procedures, functions, and triggers.
- Write, optimize, and troubleshoot complex SQL queries for application development and reporting.
- Perform query optimization, indexing, and execution plan analysis to improve database performance.
- Develop ETL processes and support data migration activities.
- Ensure data integrity, consistency, security, and high availability.
- Analyze business requirements and translate them into efficient database solutions.
- Monitor database performance and resolve production issues.
- Collaborate with application developers and QA teams during development and deployment.
- Maintain database documentation, scripts, and release versions.
- Participate in code reviews and recommend database best practices.

Required Technical Skills

- Robust knowledge of SQL and Relational Database Management Systems.
- Hands-on experience with SQL Server, Oracle, PostgreSQL, or MySQL.
- Expertise in:
- Stored Procedures
- Functions
- Views
- Triggers
- CTEs
- Joins
- Window Functions
- Temporary Tables

- Strong understanding of indexing strategies and query optimization.




- Experience in database performance tuning and execution plans.
- Knowledge of transactions, locking, concurrency, and normalization.
- Experience with ETL processes and data migration.
- Familiarity with Git or other version control systems.
- Exposure to SSIS, SSRS, SSAS (preferred for Microsoft SQL Server environments).
- Basic understanding of cloud databases (Azure SQL, AWS RDS, PostgreSQL) is an advantage.

Preferred Skills

- Experience in Banking, Financial Services, Insurance (BFSI), Retail, Healthcare, Telecom, or Airline domains.
- Knowledge of Power BI, Tableau, or other reporting tools.
- Understanding of Agile/Scrum methodology.
- Strong analytical and problem-solving abilities.
- Excellent verbal and written communication skills.

Educational Qualification

- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
- Relevant database certifications are an added advantage.

Good to Have

- Azure SQL Database
- AWS RDS
- Snowflake
- PostgreSQL Administration
- Data Warehousing concepts
- Database Security
- CI/CD for Database Deployments

Key Competencies

- Strong analytical thinking
- Attention to detail
- Ability to work independently
- Team collaboration
- Time management
- Ownership and accountability

Nice-to-Have Certifications

- Microsoft Azure Database Administrator Associate
- Oracle Database SQL Certified Associate
- PostgreSQL Certification
- AWS Database Specialty (preferred)

Experience Required

- 3–8 years of hands-on SQL Development experience.
- Experience in database design, SQL programming, and performance tuning.
- Production support experience is preferred.

📌 Consulant-Client (Chennai)
🏢 IGT solutions
📍 Chennai

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: consulant-client (chennai) / chennai

Subscribe to this job alert:

Get the latest job offers by email for: consulant-client (chennai) / chennai