Srinivas Chintha

About Srinivas Chintha

Experienced Database Administrator with over 12 years of expertise across Netezza, PostgreSQL, and Oracle environments. Proven track record in managing database design, administration, performance tuning, and security compliance. Skilled in backup and recovery strategies, replication setups, and optimization for high availability and scalability. Hands-on experience with database migrations, upgrades, RAC setups, Data Guard, and Netezza system management. Strong background in incident management, customer engagement, and project consulting. Adept at troubleshooting complex issues, streamlining maintenance activities, and ensuring seamless database operations across large enterprise systems. Certified in EDB-PostgreSQL v16, IBM PureData Systems, Oracle 10g OCA, and Microsoft Azure Administration.

Experience

1. Data Engineer

   IBM

   Sep 2024 — Present

   Prepared effort estimations, gathered requirements, and developed technical documentation for PostgreSQL to DB2, Teradata to DB2, and PostgreSQL Server migration projects.Performed PTS replication and NRS configurations on IBM Netezza servers.Worked on NPS version upgrade activities, ensuring minimal downtime and system stability.Migrated Netezza databases from Mako architecture to IPS infrastructure.Managed end-to-end Netezza-related activities, including user management, performance tuning, and system maintenance across all Netezza server models (Mako and NPS).Conducted Netezza installations, upgrades, and patches, ensuring smooth transitions and system stability.Proactively identified and addressed potential Netezza hardware issues, performing repairs or replacements to prevent system failures and minimize downtime.Scheduled and executed routine PostgreSQL maintenance tasks such as VACUUM, ANALYZE, and REINDEX to minimize table bloat and enhance performance.Maintained and managed staging environments for testing schema changes, database migrations, and patch rollouts using pg_dump and pg_restore.Designed and modified database structures—including schemas, tables, indexes, views, and constraints—using DDL scripts while adhering to best practices in normalization and performance optimization.Automated recurring tasks like backups, log rotations, and system health checks using cron, pg_cron, and pgAgent.Tuned critical PostgreSQL configuration parameters such as work_mem, shared_buffers, and max_parallel_workers to improve memory utilization and query parallelism.

Education

• Jawaharlal Nehru Technological University

  Master of Computer Applications - MCA