Komhar Infotech

1 Job openings at Komhar Infotech
Senior Sql Developer hyderabad 6 - 10 years INR 5.0 - 15.0 Lacs P.A. Hybrid Full Time

Summary Highly experienced and results-driven Senior SQL Developer with 8+ years of expertise in designing, developing, and optimizing complex database solutions. Proficient in a variety of SQL dialects, including T-SQL, Oracle SQL, and GCP BigQuery . Proven ability to deliver high-performance queries, manage data warehousing projects, and collaborate with cross-functional teams. Possesses a solid understanding of the software development lifecycle, including JIRA and QA processes , and has hands-on experience with Python and Shell scripting for automation and data manipulation. Technical Skills Database: SQL Server, Oracle, Google Cloud Platform (BigQuery) Languages: SQL, T-SQL, PL/SQL, Python, Shell Scripting Tools & Platforms: JIRA, Git, Google Cloud Platform Concepts: Data Warehousing, ETL, Data Modeling, Query Performance Tuning, QA Testing Professional Experience Senior SQL Developer | Designed, developed, and maintained complex SQL queries, stored procedures, functions, and views to support business intelligence and reporting needs. Optimized database performance by tuning slow-running queries, resulting in a 40% reduction in average query execution time. Led the migration of on-premise data warehouses to GCP BigQuery , implementing best practices for data partitioning and clustering to improve query efficiency and reduce costs. Collaborated with a cross-functional team of developers, data analysts, and QA engineers using JIRA to manage project tasks and track progress. Developed Python scripts to automate daily data extraction and loading (ETL) processes, reducing manual effort by over 60%. Participated in the QA process by reviewing test plans and providing feedback on data validation and integrity. SQL Developer Developed and optimized Oracle SQL and T-SQL queries to build and maintain data marts for financial reporting. Wrote Shell scripts to schedule and monitor database backup and maintenance jobs. Assisted in data modeling and schema design for new database projects. Provided support to business users and resolved database-related issues in a timely manner. Education Bachelor of Science in Computer Science