YASH Technologies

Technical Lead

Module Lead(Data Analyst)
•	Understanding Business requirement and creating Data warehouse and designed Blueprint (Bus Matrix)
•	Developed pipeline using Azure Data factory to extract data from different data sources which includes QuickBooks (on premises), Fishbowl (on premises), MSSQL server (on premises), MYSQL (legacy system), Sybase Central (on premises).
•	Designed and Modeled several Fact and Dimension tables as part of EDW (Enterprise Data warehouse).
•	Configured linked services on premises data sources and created dynamic data set as part of Dynamic ADF pipeline.
•	Created complex Stored procedure to handle incremental load, creating calculated table based on business requirements.
•	Created complex views as a part of Enterprise Data Warehouse to be consumed as reporting in Power BI and SSRS.
•	Created Enterprise Data Warehouse using multiple different system connected with common Dimension and Fact table.
•	Created technical designed and mapping documentation.
•	Performance tuning in EDW process.
•	Validation data after Migration with business scripts.
Module Lead(Oracle DBA)
•	Working with development Team and Maintenance Team. 
•	Migrate data from legacy systems to oracle database.
•	Performance tuning as per client requirement.
•	Take RMAN backup, (COLD & HOT backup).
•	Export and Import using oracle 10g/11g/12C DATAPUMP (Refresh Schema, Refresh Database)
•	Responsible for restore / recovery/Cloning of databases using RMAN.
•	Set up oracle data guard with one primary and multiple standby databases.

Module Lead

•	Perform data import export activity as per client requirements.
•	Responsible for restore / recovery/ Cloning of databases using RMAN.
•	Working on Plsql trigger, Procedure to maintain history in database.
•	Collecting statistics of database object for performance & Generating AWR report.
•	Maintain of the Physical Standby database and Troubleshooting when required.
•	Maintaining the DR in sync with Primary and resolving the GAP whenever required.

senior technical service specialist

Bharat Electronics limited

PROFESSIONAL SUMMARY:

•	Having total 4 years experience in IT industry.
•	Having 3.5 years experience in ORACLE DBA activities like database creation, Tablespace management, user management.
•	Knowledge of Oracle architecture.
•	Perform the recovery of the database (complete, point in time, SCN based recovery).
•	Basic knowledge of set up oracle data guard with one primary and multiple standby databases. 
•	Storage management (Physical storage management- Resizing of data files, relocation of data files, log files, control files. Logical storage management- creation of Tablespace, segments and maintenance of Tablespaces ).
•	Perform backups (physical- Cold backup, Logical-Export/Import).
•	Perform RMAN backup and restore.
•	Basic knowledge of performance tuning. 
•	Experience in Refresh Schema, Refresh Database.
•	Experience in installation, upgrading and migrating various version of database (10g/11g) on UNIX platform. 
•	Rman cloning exercises of databases.
•	Implementation and maintaining database security.
•	Experienced in database Patching.
•	Performance monitors of the Databases and viewing Alert log files & Trace files.
•	Experience in preparing the Technical documents on relevant topics.

Experienced Technical Services Specialist with a demonstrated history of working in the information technology and services industry. Skilled in Oracle Database, Oracle Database Administration, Databases, Data Pump, and Data Recovery. Strong information technology professional with a Bachelor of Engineering (B.E.) focused in Computer Science engineering from patel college of science and technology,indore. 

Taplio

Gajendra Mourya's Linkedin Analytics

Want to drive more opportunities from LinkedIn?

Taplio

.css-1jgreyo{background-image:linear-gradient(284deg, rgba(39,43,72,1) 0%, rgba(33,47,183,1) 100%);color:transparent;-webkit-background-clip:text;background-clip:text;}Gajendra Mourya's Linkedin Analytics

Want to drive more opportunities from LinkedIn?

Gajendra Mourya's Linkedin Analytics