Resume Sr database administrator in India Pune

Hi, my name is Vikas. I have around 14 years of experience in database administration, with 10 years primarily focused on PostgreSQL. Throughout my career, I’ve worked extensively on PostgreSQL running on AWS RDS and Azure, managing production environments ranging from OLTP systems to multi-tenant SaaS platforms. My expertise includes PostgreSQL performance tuning, query optimization, autovacuum tuning, replication, high availability, disaster recovery, backup and recovery, monitoring, security, and database migrations. I’ve also worked with Citus, ClickHouse, Databricks, Oracle, SQL Server, and MySQL. In my current role, I support critical production databases, troubleshoot performance issues, automate operational tasks using Python and Bash, and work closely with development teams to improve application performance. I’ve also optimized large databases by implementing proper indexing strategies, partitioning where appropriate, reducing storage usage, and resolving production incidents under strict SLAs. I’m looking for an opportunity where I can solve challenging database problems, work on large-scale PostgreSQL deployments, and continue growing in database architecture and cloud technologies.

Bachelor of engineering

PRIMARY DATABASES • PostgreSQL (10+ years) • Oracle • Microsoft SQL Server • MySQL • Citus (Distributed PostgreSQL) • ClickHouse • Cassandra • CrateDB • Databricks (1 year) POSTGRESQL ADMINISTRATION • Installation, Configuration & Upgrades • Performance Tuning • Query Optimization • Execution Plan Analysis (EXPLAIN, EXPLAIN ANALYZE) • Index Optimization • Autovacuum Tuning • Vacuum & Analyze • WAL Internals • Checkpoints • Background Writer • Shared Buffers • Work_mem & Maintenance_work_mem • Effective Cache Size • WAL Buffers • Effective IO Concurrency • Checkpoint Completion Target • PostgreSQL Memory Tuning • Connection Pooling • Parameter Tuning HIGH AVAILABILITY & DISASTER RECOVERY • Streaming Replication • Synchronous Replication • Asynchronous Replication • Cascading Replication • Hot Standby • Failover • PITR (Point-in-Time Recovery) • Base Backups • pg_basebackup • Replication Slots • WAL Archiving • Recovery Configuration • Patroni • HAProxy • etcd BACKUP & RECOVERY • pg_dump • pg_restore • Physical Backups • Logical Backups • PITR • WAL Recovery • Disaster Recovery Planning PERFORMANCE & TROUBLESHOOTING • Slow Query Analysis • pg_stat_statements • pg_stat_activity • pg_locks • pg_blocking_pids() • Wait Events • Lock Monitoring • Deadlock Analysis • Blocking Session Analysis • Table Bloat Analysis • Index Bloat Analysis • Disk Space Analysis • Temporary File Analysis • Storage Optimization • Query Rewriting • Capacity Planning POSTGRESQL EXTENSIONS • pg_partman • pg_repack • pg_squeeze • pg_stat_statements • pg_trgm • fuzzystrmatch • pg_vector • pgcrypto PARTITIONING & DATA MANAGEMENT • Native Partitioning • Range Partitioning • Partition Maintenance • Partition Pruning • Partition Cleanup • Materialized Views • TimescaleDB Continuous Aggregates SEARCH & VECTOR DATABASES • PostgreSQL Full Text Search • pg_trgm • pg_vector • Milvus • Qdrant • Elasticsearch CLOUD PLATFORMS • AWS RDS PostgreSQL • Amazon EC2 • Amazon CloudWatch • AWS KMS • AWS VPC • Azure Database for PostgreSQL Flexible Server • Azure Blob Storage OPERATING SYSTEMS • Linux • Ubuntu • Red Hat Linux • Windows Server SCRIPTING & AUTOMATION • Python • Bash Shell Scripting • SQL • PL/pgSQL MONITORING • Grafana • Prometheus • Zabbix • CloudWatch DEVOPS & CONTAINERS • Docker • Kubernetes BUSINESS INTELLIGENCE • Power BI • Tableau APPLICATIONS • Django • Django ORM DATA WAREHOUSING • ClickHouse • Databricks SECURITY • Database Encryption • pgcrypto • SSL Configuration • Role Management • User Management • Access Control • AWS KMS Integration DATABASE MIGRATION • Cross-Version PostgreSQL Upgrades • Cross-Platform Migrations • Oracle to PostgreSQL • SQL Server to PostgreSQL • Database Consolidation • Data Migration PRODUCTION OPERATIONS • Incident Management • Root Cause Analysis (RCA) • Production Support • Performance Optimization • Capacity Planning • SLA Management • Change Management • Release Support • On-call Support TOOLS • pgAdmin • DBeaver • psql • Git SOFT SKILLS • Production Troubleshooting • Root Cause Analysis • Stakeholder Communication • Cross-team Collaboration • Mentoring • Documentation • Automation Mindset • Problem Solving

English Hindi

Na