Helen Tekle

● Prepared Documentation for the Disaster Recovery plan, database maintenance procedures, data standards, procedures and definitions for the data dictionary.

● Writing Stored Procedures, Triggers and Functions as per client requirements.

● Creating and Deploying SSIS Package and SSRS Report.

● Data Warehousing, Table Partitioning and Indexing Strategies.

● Analyze long running slow queries and tune them to optimize application and system performance.

● Maintaining data integrity and ensuring database security through access controls and best practices.

● Perform daily checkups on SQL jobs, replication, hardware diagnostics for hard drives, backups, disk-space, SQL and windows error logs as part of proactive maintenance plan.

● Upgrading databases with new releases and patches.

● Performing Data Extraction, Transformation and Loading (ETL) into central repository.

● Managing Production, Stage, QA and Development database environments.

● Run DBCC commands to check the database consistency and shrink the databases.

● Resolving various performance issues and running DBCC commands, SQL Tracer, SQL Profiler.

● Monitored and modified performance using execution plans and index tuning.