Pradip Kumar

About Pradip Kumar

PostgreSQL DBA having 17 years of proficient experience in #PostgreSQL,#MongoDB,#Informix, Oracle PL/SQL, DB Administration, DB Migration, Automation, Performance tuning and Google Cloud technologies (GCP, Cloud SQL, DataStream, Dataflow, Looker).

Experience

1. Principal Database Engineer

   UKG

   Aug 2024 — Present · IN

   Role and Responsibilities:Database Management & Strategy Manage and oversee large-scale, enterprise-level database systems supporting critical business and technology areas. Lead database server configuration, capacity planning, lifecycle management, and performance monitoring. Implement best practices for backups, data purging, replication, health checks, and routine automation to ensure system reliability. Drive database schema design efforts and provide technical guidance and consultation to application development teams to optimize data structures and access.Performance & Optimization Execute advanced performance tuning on database servers, focusing on Query Optimization to improve application response times. Implement best-practice optimization techniques, including appropriate indexing, statistics updates, ANALYZE, and VACUUM operations. Monitor and analyze system metrics to proactively address bottlenecks and maintain peak performance.Database Migration & Development Spearhead complex, cross-platform Database Migration projects (e.g, Oracle to PostgreSQL, Informix to PostgreSQL, and Informix to Oracle). Manage the deployment of database changes and patches across production environments, ensuring stability and zero downtime.Security & Compliance Ensure database security and access control by effectively managing user roles, necessary privileges, and access controls. Identify, report, and manage database security vulnerabilities, audit trails, and forensics.Cloud Data Engineering & Analytics (Google Focus) Engineered, configured, and managed high-availability Google Cloud SQL for PostgreSQL instances, optimizing for performance and scalability. Architect and implement Google Fan-In Replication solutions utilizing DataStream, Storage Buckets, and Dataflow jobs for centralized data ingestion and processing. Design a strategic framework for a comprehensive Looker dashboard suite to visualize core business KPIs,

Education

• Uttar Pradesh Technical University

  Master of Computer Applications - MCA, Computer Applications