Venkata Chaitanya Gurram

• Plans and coordinates the administration of PostgreSQL databases to ensure accurate, appropriate, and effective use of data
• Performs quality control audits to ensure accuracy, completeness, such as database dictionaries
• Establish and maintain security and integrity controls
• Prepares and/or reviews activity, progress, and performance reports
• Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases
• Managed schemas, indexing, objects, and partitioning the tables Created automated scripts to backup the database nightly and restore it in case of failure or migration to new hardware
• Studied and stayed current on feature and functionality of PostgreSQL
• Proactive managing standby replication methodologies like Streaming replication and hot standby for disaster recovery
• Proactive in updating the latest security patches to database, which are provided by PostgreSQL open-source community
• Worked with product teams to take applications from ideation to delivery, to support our customers Stayed up to date on evolving technology and communicate with the team on trends, finding new ideas and system improvements Participating in daily meetings to discuss about the new database design, modeling, and creation
• Installing and configuring PostgreSQL from source or packages on Linux machines
• Experience designing database structure, indexes, views, partitioning
• Implement backup and recovery (logical and physical)
• Performance monitoring and optimization Removing the index bloat concurrently to improve the performance
• Schedule maintenance activities to vacuum, analyze to improve the query response time
• Diagnoses, resolves, and implements preventive measures to prevent problems for availability, recoverability, and performance of all supported database environments
• Query optimization and troubleshooting
• Actively participate and contribute to projects monitoring involving Enterprise Failover

• Ability to proactively identify, troubleshoot, and resolve live database systems issues
• Hands-on experience on database administration, backup recovery, and troubleshooting in co-location environments
• Ability to thrive in a fast-paced, deadline-sensitive environment
• Responsible for all backup, recovery, and upgrading of all the PostgreSQL databases
• Monitoring databases to optimize database performance and diagnosing any issues
• Providing response for all system / database issues on 24x7 schedule responding to critical events and situations outside normal work hours
• Remote administration and support of production and development Databases sizing 5TB
• Work with development and operations teams to tune production queries for optimal performance
• Review new database schema changes
• Plans and configures the physical, progress, and performance reports
• Recommends and oversees implementation of database level configuration changes to optimize performance
• Ensures maintenance of physical integrity of all production databases
• Created database security policies that prevented unauthorized access, reducing DBA workload by 80

• Proficient in implementing and managing CORPORATOR workflows to streamline corporate processes and improve operational efficiency.
• Experienced in conducting user training and providing ongoing support for CORPORATOR users to ensure effective utilization of the platform.
• Skilled in integrating CORPORATOR with other business systems and applications to facilitate seamless data exchange and process automation.
• Proficient in using advanced SQL features such as triggers, and views to enhance database functionality and data integrity.
• Experienced in performance tuning and optimization techniques to improve query execution time and overall database performance.

· Executing campaigns using IBM-UNICA.

· Targeting customers and segment them according to the requirement using SQL and Unica.

· Worked on campaign for multiple channels - CAT (coupon at till), Email, Direct Email .

· Collectors and built survey campaigns for business development.

• Proficient in utilizing APRISO for [specific tasks or functions relevant to your experience, such as production planning, quality management, inventory control, etc.].
• Experienced in navigating and customizing APRISO modules to streamline manufacturing processes and enhance productivity.
• Skilled in configuring APRISO workflows and implementing solutions to optimize operational efficiency and resource utilization.
• Proficient in writing complex SQL queries to retrieve, manipulate, and analyze data from relational databases.
• Experienced in database design and management, including schema definition, indexing, and performance tuning.
• Skilled in using SQL for data manipulation, aggregation, and reporting, leveraging functions, joins, and subqueries to extract actionable insights.