Database Optimization & BI Lead
Tharsol
Total years of experience :5 years, 11 Months
Designing and implementing database optimization strategies to improve database performance, scalability, and efficiency.
Performing database maintenance tasks, such as backups, restores, and upgrades, to ensure data integrity and availability.
Tuning database performance using techniques such as indexing, partitioning, and query optimization.
Designing and implementing business intelligence (BI) solutions to provide data insights and support data-driven decision-making.
Developing and maintaining ETL processes to extract, transform, and load data from various sources into data warehouses or other target systems.
Collaborating with cross-functional teams, including developers, data scientists, and business analysts, to understand business needs and translate them into database and BI requirements.
Performing data analysis and profiling to identify data quality issues and make recommendations for data cleansing and enrichment.
Creating and maintaining technical documentation, including database schema, ETL workflows, and BI reports and dashboards.
Managing database and BI projects, including project planning, scope definition, and resource allocation.
Staying up-to-date with industry trends and emerging technologies related to database optimization and BI.
Providing technical support to customers who use Teradata's ETL applications, including troubleshooting issues and resolving problems.
Collaborating with cross-functional teams, including developers and database administrators, to ensure smooth functioning of ETL applications.
Analyzing customer data to identify patterns and trends, and making recommendations for improvements.
Designing and implementing ETL processes to extract data from various sources, transform it, and load it into data warehouses or other target systems.
Developing and maintaining technical documentation, including standard operating procedures and user manuals.
Monitoring and optimizing ETL performance to ensure timely delivery of data to downstream applications.
Managing ETL application upgrades and migrations, including testing and validation.
Mentoring and training junior team members to improve their technical skills and knowledge.
Participating in customer meetings and providing updates on project status, issue resolution, and future plans.
Staying up-to-date with industry trends and emerging technologies related to ETL and data integration.
Performing business and data analysis.
Transformation, modeling, and data validation.
Designing, building, and deploying BI solutions.
Create visualizations and reports.
Report optimization.
Data quality management.
Evaluating and improving existing BI systems.
Writing data collection and processing procedures.
Performs the database administration tasks such as DBMS installations and upgrades, migrating databases, changing server configuration parameters, transferring system databases, and managing users and logins.
Assist in data administration, modeling, and integration activities in data warehouse systems.
Implement business intelligence solutions to achieve data reporting and analysis goals.
Monitored database performance, tracked and stored procedures and queries’ execution times, and implemented improvements in efficiency.
Designing and developing database applications using Oracle technologies, such as SQL, PL/SQL, and Oracle Forms.
Creating and maintaining database objects, such as tables, views, stored procedures, and functions.
Writing complex SQL queries and scripts to retrieve and manipulate data from Oracle databases.
Carrying out design, construction, review, and defect analysis activities.
Defining and generating screen formats and report designs.
Providing suitably tested fixes to defects within the sanctioned delivery process.
Producing and updating relevant documentation.
Meeting clients face-to-face and on-site to as certain requirements.
Develop software in accordance with the agreed design with consideration for usability, software quality, and future maintenance.
Successfully Passed Defence.
Got 2nd Position.
URL removed due to policy violation. Please contact support for further information.