Sahana S Gudigar
Bengaluru
Summary
Analytical SQL Developer known for high productivity and efficient task completion. Specialize in database design, query optimization, and data analysis. Excel in problem-solving, communication, and teamwork to enhance project outcomes. Committed to delivering reliable solutions and improving data-driven decision-making processes.
Overview
4
4
years of professional experience
Work History
SQL Developer
Integra Micro system PVT LTD
Bengaluru
12.2020 - Current
- Developed stored procedures, functions and triggers to support application requirements.
- Created database objects like tables, views, indexes and synonyms in Oracle 11g and 12c databases.
- Optimized existing queries for better performance using SQL query tuning techniques.
- Designed complex reports using SQL Server Reporting Services.
- Implemented data migration from legacy systems to new databases.
- Performed backup and recovery of databases on a regular basis.
- Monitored database performance and troubleshooted issues related to slow running queries or deadlocks.
- Maintained security by creating user accounts and granting appropriate privileges as needed.
- Provided technical assistance in the form of SQL coding advice to other team members.
- Analyzed business requirements and translated them into logical data models.
- Resolved customer service requests related to database errors or performance issues quickly and efficiently.
- Used T-SQL scripting language for creating stored procedures, functions, triggers.
- Developed ETL processes using SSIS packages for loading data from various sources into a data warehouse environment.
- Integrated multiple data sources into one unified view using views or joins in SQL queries.
- Collaborated with software developers on designing efficient database structures that meet application requirements.
- Tested databases and performed bug fixes.
- Conducted database tuning and performance monitoring to ensure optimal system functionality.
- Developed database schemas, scripts, and models in collaboration with application developers to meet project requirements.
- Collaborated with IT security to audit database access and implement necessary compliance measures.
Education
Bachelor of Computer Applications -
Maharani's Science College For Women
Mysuru03-2019
Skills
- Data Warehousing
- Data Validation
- Database Administration
- Relational databases
- SQL reporting
- Database Design
- Business Intelligence
- Oracle platform proficiency
- Database Development
- Data Migration
- Transaction Management
- Java
Languages
Kannada
First Language
English
Upper Intermediate (B2)
B2
Hindi
Intermediate (B1)
B1
Timeline
SQL Developer
Integra Micro system PVT LTD
12.2020 - Current
Bachelor of Computer Applications -
Maharani's Science College For Women
Similar Profiles
Kavya HKavya H
SQL Developer at Integra Micro System Private LtdSQL Developer at Integra Micro System Private Ltd
Vikas AwasthiVikas Awasthi
General Manager at Integra Micro Systems Pvt LtdGeneral Manager at Integra Micro Systems Pvt Ltd
KUMAR HAMARIKUMAR HAMARI
Area Business Manager at Integra Micro SystemsArea Business Manager at Integra Micro Systems