Raju D.

Database Development : ****************************************** Oracle Sql, Plsql, Data Export from Oracle DB to excel MSSQL PostgreSQL AWS Redshift, Glue, S3 GCP BigQuery Snowflake Oracle Forms(D2k) Expertise in Entities like : ------------------------------- Tables, Views, Sql Queries, All Types of JOINS, Cursor, Procedure, Function, Packages, Triggers, Collection, Bulk Collect, Analytical/Window Function, Dynamic Sqls, Pipelined Functions, Sql Loader, External Table, Hints, Bug Fixing , Debugging, Impact Analysis etc. DBA ************** * Having 10+years of experience as an Oracle, MICROSOFT SQL server and Golden Gate administrations in Banking, finance, Healthcare, Multimedia and currently working in Telecom domain. Working in 24x7 environments and providing support. * 6 +Month experience on AWS RDS and EC2 instances. Experience in RAC Implementation, maintenance of Clustered Databases, CRS upgrade, ASM implementation and maintenance. * Hands on knowledge of Golden gate replication and online Migrations tool. * Migration from 11g and 2c to 19c using DBUA Experience in installation & configuration oracle 10g, 11g, 12c and 19c RAC. * Implementation MICROSOFT SQL server 2008, 2012, 2014 and 2016 in development, test, and production environment. Always on replication. * Monitoring MSSLQL Server clustering, Log shipping, mirroring * Having dept knowledge about Oracle and MICROSOFT SQL server patching. * Tested and Implemented different physical and logical backup and recovery methods like point in time, Media recovery, RMAN and EXPDP and IMPDP utility. * Experience in designing Data guard solution and implementation and in managing physical standby. * Experience in monitoring and optimizing the Database performances through tuning using stats pack, AWR, ADDM, explain plan, Backup timings of databases. Having hands-on knowledge Oracle Table Partitions and Materialized Views. * Upgraded/ Migrated MICROSOFT SQL server Instances/Databases from older version MICROSOFT SQL server to new version of SQL Server. Apply SP (Service Pack)/ hot fixes on MSSQL server Instances to address security and upgraded related issues. * Performance Tuning and schedule jobs to automate different database related activities including backup, monitoring database health, disk space, and backup verification. * Extensive knowledge of oracle architecture SGA, PGA, Listener, tns names. * Developed Different Maintenance Plans for database monitoring. Setup Jobs, Maintenance plans for backups. Rebuilding indexes, check server health, alert, notifications Manual, on demand and setup jobs for Database Backup, and design backup strategy. * Experience in Mirroring and Log shipping and managing Standby Databases. * Creating File groups & managing File groups. Creating users and providing proper privileges for Database access. * Memory monitoring and optimizing the Database Performances through Tuning Explain Plan. Experience in Oracle RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery. * Experience in, Maintenance plans for backups, Rebuilding indexes, check server health, alert, notifications Manual, on Demand and setup jobs for Database Backup, and design backup strategy. * Hands-on experience in configuring MSSQL server and Windows system event log entries for warnings. Language : ********************* Python (Pandas, Numpy, Matplotlib, AI/ML, PySpark) Java (Java, Spring MVC, Spring boot, Microservices, Rest-api, React, Angular old version Javascript) ETL: Informatica,ODI **************** 1. Proficient in data integration and ETL processes using Informatica PowerCenter. 2. Extensive experience in designing, developing, and implementing ETL solutions with a focus on Informatica PowerCenter. 3. Demonstrated expertise in creating complex mappings, workflows, and transformations in Informatica PowerCenter to optimize data flow. 4.Proven track record of troubleshooting Informatica PowerCenter workflows. 5. In-depth knowledge of working with various databases and sources like oracle , terafata, flat files to extract, transform, and load data using Informatica PowerCenter. 6. Implemented and maintained data warehouses utilizing Informatica PowerCenter as a key component of the ETL architecture. 7. Proficient in utilizing Informatica PowerCenter for handling large volumes of data. Excel : ************* Advanced Excel Formula, Macro Data Visualization : ************************** Power BI, As a Trainer to Train in SQL Help Students in their SQL Assignments ####################################### Having over 14 Years of experience mainly as a Database Development Expert. Also having hands on experience in above mentioned skill set. Just give a faith for your development activities, I assure you will not be disappointed. Note : Pay after only the satisfaction of work only. Thanks DK Raju