Home

Manohar Vennamaneni - Postgres AWS DBA

[email protected]

Location: Dayton, Ohio, USA

Relocation:

Visa: H1B

Manohar Vennamaneni Mail id: [email protected] Contact number: 713-357-7351 Results-driven and highly skilled database administrator with over 9+ years of experience in managing, optimizing, and scaling Postgre SQL, Aurora Postgre SQL, and Azure Postgre SQL databases. Proven expertise in database administration, performance tuning, high availability, and security. Adept at collaborating with cross-functional teams to deliver robust and efficient database solutions. Professional Summary: Expertise in Installation, Configuration, Initialization, backup, restore, and High availability solutions. Upgraded PostgreSQL version from 11 to 14. User management(creating users and assigning roles and privileges) Basic level of performance tuning, Query optimization, and performance monitoring using tools such as pgadmin. Installation of pgadmin on Windows. Working knowledge of backup and recovery at Table, Schema, and Database levels. Monitoring daily backups. Major/minor version upgradation of databases. Troubleshooting space issues. Backup/restore using pg_dump, pg_dumpall, and pg_basebackup. Successfully configure and manage database high availability solutions such as physical and logical. PostgreSQL: Administration, management, and monitoring of all PostgreSQL database systems Hands-on experience on database administration, backup recovery troubleshooting. Responsible for configuring, integrating, and maintaining all Development and Production PostgreSQL databases Monitoring databases to optimize database performance and diagnosing issues. Install/Setup and maintain Postgres database software Excellent knowledge of SQL, query troubleshooting and performance improvement Create and maintain accurate documentation of all areas encompassing the database infrastructure Database Security - access, authentication, auditing, vulnerability assessment Perform migration and upgrade tasks while minimizing downtime Perform database backups, restore, and recovery tasks Monitor and maintain Postgresql on Azure for Postgresql Flexible server. Implement backup and recovery processes. Provide system and SQL performance tuning and assist in business integration with various data sources. Fulfils user requests on access control including creating new users and authenticating access to the database. Provide online and on call for production support and administration of SQL and MongoDB Work with front end developers to detine simple yet powerful APIs. Perform specific reports based on business needs. Create and maintain databases, corresponding schemas and tables. Setup replications on Azure Create documentations for business needs. Create foreign data wrappers (FWD) to link different databases together. Process orders and update their statuses. Establish links between various databases and powerbi. Use powerbi to create business reports. Write Postgresql stored procedures and functions. Set up disaster recovery plan including testing, backup and restore AWS Database Administration: Amazon RDS, Amazon Aurora, Amazon Redshift Performance Tuning and Optimization Database Backup and Recovery Strategies Database Security and Access Controls High Availability and Disaster Recovery Database Monitoring and Troubleshooting Database Migrations and Upgrades Scripting and Automation: SQL, Bash, Python Skills: Languages SQL, PL/SQL, Bash, Python, shell Operating Systems LINUX, Windows 2000/2003/2008/2012 Relational Databases PostgreSQL Server 11/12/13 and 14 ETL & Reporting Tools Pentaho DB Utilities PGAdmin III, Dbeaver, Azure Data Studio Tools Nagios, Groundwork, Newrelic and AWS, Zabbix, Logic monitor, Datadog and Elasticsearch Web - Applications HTML Cloud AWS and Azure Professional Experience: Project Details: Medpace INC,Cincinnati Sr AWS Database Administrator Duration: October 2022 Till date Roles & Responsibilities: PostgreSQL: o Installation, setup, and administration of PostgreSQL o Upgraded all the database environments versions from PostgreSQL 11 to 12 and 12 to 13 and 11 to 14 using native logical replication. o Working with Postgres, Timescaledb and PgRouting extensions. o Creating RDS Postgres and Aurora PostgreSQL instances and configuring parameter groups, roles, cloud watch, performance insights and monitoring jobs. o Launching new AWS Linux servers and installing PostgreSQL server and other packages\utilities and configuring HA with Patroni and pg_auto_failover manually or using Ansible playbooks o Establishing process and standards to ensure data integrity and security, performing proactive monitoring, security auditing and capacity management and maintaining and updating Disaster Recovery procedures and processes o Performing regular database maintenance using Vacuum/Analyze/Re-index o Administrating and supporting Azure Database for PostgreSQL servers Environment: - PostgreSQL 11, 12, 13 and 14, AWS RDS, Aurora Postgres, Azure PostgreSQL, Windows, Linux (CentOS/Ubuntu/Redhat), AWS, Azure Project Details: Pinnacle Vision Future Solutions Private Limited AWS Database Administrator Duration: October 2020 to April 2022 Roles & Responsibilities: o Installation, setup, and administration of PostgreSQL. o Database service transition from client. o Preparing Migration Planning, LLD/HLD document, Runbook creation for database Migration. o Responsible for team and client SCRUM call related Project Update. o Cross Migration from SYBASE/MSSQL/ORACLE/DB2 to Aurora/PostgreSQL through AWS SCT and DMS . o High-capacity Database migration planning and implementation on Standalone db , 2 4 Node AOAG. o On-premises or VMServer Database migration on Azure and AWS. o Solutioning for Database Backup, High Availability, DR Planning, and implementation. o Working with SSRS, SSIS as per project requirement basis. o Identified risk that should be captured and then translated into project during the transformation o Responsible for understanding the client's new requirements related to the Database server. o Database servers build and configuration, and handover to BAU support o Database Backup/DR plan and implementation. o Managing and providing high level escalation or p1/p2 ticket support to client. o Environment: PostgreSQL 11, 12, 13 and 14, AWS RDS, Aurora Postgres, Azure PostgreSQL, Windows, Linux (CentOS/Ubuntu/Redhat), AWS, Azure Project Details: Foray Software Private Limited Client/Project Name: PCS TS,PCS AP,PCS Kerala Role: Software Engineer Duration: June 2016 to August 2020 Roles & Responsibilities: o PostgreSQL: o Led the administration of large-scale PostgreSQL, Aurora PostgreSQL, and Azure PostgreSQL databases, ensuring optimal performance, reliability, and security. o Implemented performance tuning and optimization strategies, resulting in a 30% improvement in query response time and increased overall system efficiency. o Designed and implemented high availability and replication solutions, including PostgreSQL streaming replication, logical replication, and Amazon Aurora Multi-Master, ensuring seamless failover and minimal downtime. o Developed and maintained backup and recovery strategies, implementing automated backup schedules and performing regular data restores to validate recovery procedures. o Enforced stringent security measures, including access controls, encryption, and auditing, to meet industry standards and safeguard sensitive data. o Collaborated with development teams to optimize database schema design, stored procedures, and SQL queries, resulting in improved application performance. o Successfully executed database migration projects from on-premises to AWS Aurora PostgreSQL and Azure PostgreSQL, ensuring data integrity and minimal disruption to business operations. o Implemented monitoring and alerting solutions using tools like AWS CloudWatch, Azure Monitor, and native database monitoring features to proactively identify and resolve database issues. o Mentored junior database administrators, providing guidance on best practices, performance optimization techniques, and troubleshooting methodologies. o Prepared and maintained comprehensive documentation, including standard operating procedures, architecture diagrams, and disaster recovery plans. o Environment: Microsoft SQL Server 2012, 2014, 2016, PostgreSQL9.6 to 12, Linux o (CentOS/Ubuntu), AWS, AWS RDS, Windows Project Details: HDB FINANCIAL SERVICES PVT LTD Client/Project Name: HDFC Bank Ltd Role: Software Engineer Duration: July 2014 to May 2016. Roles & Responsibilities: o Proficient in writing and optimizing complex SQL queries for data retrieval, manipulation, and analysis. o Experienced in database design, including table schema creation, indexing, and normalization to ensure efficient data storage and retrieval. o Skilled in database administration tasks such as backup and recovery, performance tuning, and capacity planning. o Demonstrated expertise in managing and maintaining .PostgreSQL database servers, including installation, configuration, and patching/upgrading. o Proficient in monitoring and troubleshooting database issues, identifying bottlenecks, and implementing performance-enhancing solutions. o Familiarity with database security measures and best practices, including user access control, data encryption, and regular vulnerability assessments. o Hands-on experience in database replication and clustering techniques to ensure high availability and fault tolerance. o Proven track record of optimizing database performance by fine-tuning query execution plans, implementing proper indexing strategies, and monitoring resource utilization. o Proficient in writing and automating database maintenance scripts using SQL and shell scripting languages. o Strong understanding of database normalization and denormalization concepts, ensuring data integrity and minimizing redundancy. o Experience in migrating databases between different platforms, including SQL to PostgreSQL. o Proficient in using database management tools and utilities for tasks such as data import/export, performance monitoring, and query profiling. Education: B.Sc computers from Andhra University, Andhra Pradesh, INDIA Masters of Software Engineering from Kingston University,London,UK Certifications: PostgreSQL 12 Professional Certification from Enterprise DB - CERT-DBA-002.12 (Manohar Vennamaneni) Keywords: database procedural language Idaho South Carolina