Hire the Best Database Caching Developers in Pune, IN

Backup ,Restore,Replication,upgradeing,initialization,Scripting, schema migration, performance tunning, Load balancer,pgbadger, Health check of cluster, vacuum,analyze,reindex, database designI have over all 6 years experience in Database administration working with IT industry clients.. Good knowledge on sharding, Mirroring, security

Oracle : - Having rich experience in Oracle Database Installation, upgrades. - install and setup high availability e.g. RAC , DG , GG - Rich experience in migration from one platform to another .\ - Rich experience in migration from on-prem to AWS/Oracle cloud . - Experience in AWS DMS - Setup the backup and recovery standards. - DB and query tunning. - troubleshoot performance issues - Automation using shell/batch/python scripting - debugging users issues . - Automate repetitive task using python/shell/batch script. - Having fair hands on automation using Ansible for Oracle DBA repetitive task. Migration: =========== - Oracle EE/SE to postgres AWS RDS using AWS SCT & DMS services - Oracle EE/SE to Oracle Cloud using datapump. - Oracle EE/SE to MariaDB using Goldengate. - Migration from one platform to another platform - Migration from oracle to databriks Automation: good in shell scripting , batch , python and ansible. recently completed oracle grid and rdbms installation automation using Ansible . Good experience in upgrades and performance tunning. Experience DBA devops and automation expertise. Postgres : ======= - Installation, upgrade minor and major - AWS Auroa RDA - postgres - troubleshooting - performance analysis Replication: Using golden gate Shareplex Debezium log miner and Openlogreplicator

I’m an EXPERT SQL Server & Cloud Database Performance Engineer with 8.6+ years of experience optimizing production systems across SQL Server, Azure SQL, and AWS RDS. I specialize in identifying performance bottlenecks, fixing slow systems, and improving overall database efficiency — end-to-end. How I Work (Step-by-Step Approach) Phase 1 – Performance Audit Analyze SQL Server / Azure SQL / AWS RDS environments (CPU, IO, memory, DTU/vCore) Identify top resource-consuming queries using Query Store / DMVs Check wait stats, blocking, and deadlocks Review index usage (missing, duplicate, unused) Analyze data growth and large table patterns Evaluate workload, concurrency, and peak usage Phase 2 – Deep Dive Analysis Analyze actual execution plans to find scans, bad joins, and inefficient queries Identify parameter sniffing and cardinality issues Review schema design and data models Assess concurrency issues and workload contention Identify cloud-specific constraints (Azure throttling / RDS limits) Phase 3 – Recommendations Provide clear, prioritized optimization plan: Quick wins (indexing, query fixes) Medium improvements (schema tuning, partitioning) Long-term strategy (scaling, architecture) Define expected performance improvements and impact Phase 4 – Implementation Rewrite and optimize complex SQL queries Design and implement effective indexing strategies Tune stored procedures and database objects Resolve blocking, deadlocks, and concurrency issues Optimize configurations across SQL Server, Azure SQL, and AWS RDS Phase 5 – Validation & Monitoring Benchmark performance before vs after changes Set up monitoring (Query Store, Extended Events, Azure Monitor, alerts) Provide long-term performance management guidance Core Skills : SQL Server (2008–2022), Azure SQL Database, AWS RDS (SQL Server) SQL Server Performance Tuning & Database Optimization Query Optimization & Execution Plan Analysis T-SQL Development (SPs, functions, complex queries) Index Optimization & Statistics Management Blocking, Deadlocks & Concurrency Troubleshooting High-Concurrency & Production System Performance Monitoring (Query Store, DMVs, Extended Events, PerfMon)

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

Database Architect & DB performance engineer at a Crypto & Equities trading platform having 30 million user base with Futures, Options and API trading workloads. • Over 15 years of experience architecting and administering databases for OLTP, OLAP, and HTAP in Postgres, MSSQL, MySQL, Oracle, Redis , Snowflake • Skilled in building and performance tuning for OLTP, OLAP, and HTAP environments. • Expert in database design and architecture for various business workloads specialized in Fintech. • Proficient in designing ETL workloads and analytics on AWS, MS Azure, and on premise systems. • Successfully executed projects optimizing performance and reducing cloud database costs. Technical Skill Sets: Databases : PostgreSQL, Microsoft SQL Server, MySQL, Oracle, MongoDB, Redis, Snowflake, Redshift Cloud : AWS, MS Azure, Mongo Atlas Data Engineering : Attunity / Qlik Replicate, SnowPipe, SSIS, Talend, Python, PowerShell, Azure Data Factory, Synapse, AzureAS, Kafka, Python, Power BI, SSRS, SSAS, Mirth Monitoring : New Relic, Grafana, CloudWatch Scripting : Shell, Python, GO, JS, PowerShell Database Types : SQL, NOSQL, Key Value Pair, Documents, TimeSeries, JSON, Vector, Graph DB / Data Security : GDPR, HIPPA, CCPA, DPDPA, Data Encryption, Masking, Tokenization, TDE, PII, PCI, PHI, Encryption at Rest