Monikaa Patel

• Delivering expert-level DBA services including monitoring their databases, making recommendations to improve performance and durability, fix things when they break, help design new architectures and implement best practices perform upgrades, configure, and monitor backups, assist with recoveries, and other related DBA-level tasks as needed.
• Developed and deployed cloud solutions using AWS, Azure, and Google Cloud Platforms.
• Collaborated with other teams across the organization to develop new features or improve existing ones in order to better meet customer needs.· Working on EDB: Big Animal Managed Postgres Cloud Database
• Optimized costs by consolidating workloads onto fewer instances or moving them into more cost effective regions and zones.
• Assisted in designing disaster recovery plans for critical systems hosted on public clouds.
• Troubleshot complex technical issues related to cloud environments with a focus on root cause analysis.

• Experience in PostgreSQL cascading/multiple replications on PostgreSQL 10/11/12 version .
• Collaborate with development, architecture, and release teams, providing architectural design recommendations, driving standards for effective PostgreSQL transition to production operations. Managing Users/Privileges/Roles/Profiles/Resources and Password security .
• Implemented change management processes to ensure smooth transition between different stages of development life cycle.
• Implemented backup procedures for databases and monitored their success rate.Working with best tuning parameters and comparing with on prem ones .Query optimization and troubleshooting .
• ·Writing stored procedures / functions to update million records in MySQL,Postgresql etc
• Installed new software releases, patches and upgrades on production servers as required.
• Maintained knowledge of advances in information technology systems and applications.
• Wrote scripts and processes for data integration and bug fixes.

Postgresql

• Responsible for monitoring environments using monitoring tool via Nagios .Cloning the Development, test and UAT environments with production data as per customer’s request.
• Created new tablespaces for applications to store their data in the database.
• Experienced in performing PITR .
• Experience supporting a mission-critical database environment with 24x7 On-Call Support including weekends Upgrading, installing, and configuring PostgreSQL servers.
• Ensure night cron jobs for backups, re-Indexing & vacuuming & materialized views executed properly .
• Resolved customer queries related to database issues promptly and accurately.
• Communicated with data architects, programmers and engineers to keep projects on track.

Mysql

• Performed installation, new databases design, configuration, backup, recovery, security, upgrade and schema changes, tuning and data integrity.
• Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware. schema and Percona toolkit to identify redundant and unused indexes .
• Tungsten Replicator.
• Monitoring opsgenie alerts for mysql/aerospike/vertica/PostgreSQL databases. Effectively configured MySQL Replication as part of Confidential.

Vertica /Aerospike

• Monitoring servers & doing basic day to day DML,DDL sequences, primary key, foreign keys and constraints, external tables.
• Upgraded Vertica to higher versions and also upgraded vertica license in resource management, and memory management depending on the priority of resource pools and users.
• Extensive working knowledge in database objects like creating tables, views, indexes ,activities.
• Knowledge about with setting up multi node Vertica Cluster.

• Reviewed and modified unit and integration tests to improve software quality and reliability.
• Tackled development tasks based on system requirements and documented approaches.
• Liaised with QA testers to perform testing meeting various parameters.
• Introduced automation tools to enhance workflow.
• Managing the database (test and development) servers (PostgreSQL clusters). Monitoring for requirement of routine maintenance tasks and performing the same .Configuring the backup jobs on customer system. Server versions ranged from PostgreSQL 8.2 to 9.5.
• Optimize postgresql.conf for performance improvement.
• Conducted thorough debugging and troubleshooting of software issues.
• Performed regular maintenance tasks to optimize existing software systems.