13+ years of experience in IT field, 11+ years of experience spesifically in database and data intensive positions.
Extensive hands-on experience with OLTP and OLAP database design, development and maintenance,
Technical and business oriented documentation (ETL data mapping, data dictionary, database diagrams etc.)
Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
Experience with data virtualization & reporting tools like PowerBI, Tableau, SSRS, MS Excel etc.
Working closely with business users to congregate and comprehend requirements.
Hands-on SQL Server database maintenance and administration experience (scheduling jobs, backups, restore)
Experience with complete life cycle of SSIS Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL jobs across different data sources and destinations.
Fluent experience with generating complex Transact SQL (T-SQL) queries, Sub queries, Co-related sub queries, Dynamic SQL queries as needed. (Stored Procedures, views, ad-hoc reports etc.)
Datawarehouse design, implementation, data processing, reporting experience.
Experienced in improving SQL Server performance by using index tuning wizards, performance tuning methods, execution plans and profilers, query analysis and paramaterization, code optimization