Gopinath Narayanan

Technology Lead

Triyam Information Technology Pvt Ltd

Chennai

05.2018 - Current

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.
Implemented ETL processes using SQL and additional tools to migrate data across different systems.
Optimized existing queries for better performance using SQL query tuning techniques.
Provided technical assistance in the form of SQL coding advice to other team members.
Analyzed and resolved complex database and data integrity issues to maintain high availability and reliability.
Analyzed business requirements and translated them into logical data models.
Collaborated with cross-functional teams to gather requirements and translate business needs into technical specifications.
Documented SQL development processes, creating a knowledge base for best practices and troubleshooting.
Performed backup and recovery of databases on a regular basis.
Designed and developed complex SQL queries for data analysis and extraction to support business decisions.
Developed technical specifications and plans, documenting details into user manuals for future reference.
Maintained security by creating user accounts and granting appropriate privileges.
Resolved customer service requests related to database errors or performance issues quickly and efficiently.
Developed stored procedures, functions and triggers to support application requirements.
Monitored database performance metrics and made adjustments to configurations and hardware to meet scalability demands.
Created database objects like tables, views, indexes and synonyms in Oracle 11g and 12c databases.
Implemented data security measures, including access controls and encryption, to protect sensitive information.
Created and maintained database objects including tables, views, indexes, and triggers to ensure data integrity and performance efficiency.
Conducted database tuning and performance monitoring to ensure optimal system functionality.
Integrated multiple data sources into one unified view using views or joins in SQL queries.
Developed strategies for problem solving and conflict resolution among team members.
Set specific goals for projects to measure progress and evaluate end results.
Resolved customer complaints in an effective manner while maintaining a high level of customer service.
Monitored team workload to prevent burnout and ensure equitable task distribution.
Maintained a positive work environment that promoted collaboration between team members.
Implemented strategies to take advantage of new opportunities.
Coordinated daily operations, ensuring team adherence to company policies and procedures.
Facilitated training sessions for new employees on company policies and procedures.
Mentored newly hired employees on machine operations and implemented training on safety procedures to prevent injuries.
Maintained open lines of communication with senior management, reporting team progress and challenges.
Completed daily quality assurance duties to provide feedback for improvements.
Collaborated with other departments to ensure alignment of goals across teams.