Ashwin Sirigi

• Database Administration: Over 7.6 years of comprehensive experience as a Senior Cloud Database Administrator | Developer proficient in managing relational and NoSQL databases including MySQL, MariaDB, PostgreSQL, MSSQL, MongoDB, Dgraph, AWS Aurora, and Redis. Expertise in provisioning instances, both clustered and non-clustered configurations, and performing database installations, configurations, upgrades, and migrations.
• Database Migration: Proficient in migrating databases from on-premise to cloud environments and conducting cross-region migrations in AWS. Expertise in migration cross database (e.g., MySQL to PostgreSQL, MSSQL to PostgreSQL).
• Backup and Disaster Recovery: Automated regular backups and implemented disaster recovery procedures to minimize downtime in case of failures.
• Database Clustering and Replication: Hands-on experience with MySQL/MariaDB Clustering (InnoDB Cluster, Galera Cluster), PostgreSQL Clustering (Patroni, Repmgr), MySQL replication strategies (Multi-Master, Chain, Master-Master, Master-Slave), MongoDB Replica Set & Sharding, and MSSQL (AlwaysON, Replication, Mirroring, Log Shipping).
• Cloud Database Management: Expertise in setting up, managing, and monitoring cloud databases (Aurora Engines), ensuring scalability and performance optimization aligned with business requirements. Expertise in working with multiple cloud services (RDS|DMS|EC2|Route53|Cloud Watch Alarms|SNS).
• Infrastructure and Tools: Proficient in Kubernetes, Docker, and Ansible with experience in YAML scripting. Configured PostgreSQL connection pooling with PgBouncer and implemented load balancing with HAProxy. Managed monitoring tools such as SolarWinds DPM, PgBadger, Grafana, Icinga2, Nagios, and OPS Manager for performance enhancement.
• Backup and Recovery Solutions: Extensive knowledge of various backup strategies (e.g., Full, Differential, Transactional Log, Logical, Physical) across SQL Server, MySQL, MariaDB, PostgreSQL, and MongoDB. Hands-on experience with third-party utilities like Percona XtraBackup, PgBackRest, Barman, and Percona Backup/OPS Manager.
• Performance Optimization: Strong expertise in performance tuning, query optimization, and understanding query execution plans across MySQL, MariaDB, PostgreSQL, SQL Server, and MongoDB. Proven ability to identify and resolve deadlock, locking, and blocking events, collaborating effectively with application teams.
• Security and Compliance: Implemented robust security measures and encryption protocols for sensitive data, including row-level and column-level security implementations. Proficient in creating and managing database logins, users, groups, roles, and profiles, ensuring adherence to security policies and standards.
• Database Deployments: Experienced in making DDL and DML changes on heavy transactional tables without downtime, collaborating proactively with application developers for seamless database deployments. Skilled in enforcing and documenting database policies, procedures, and standards to maintain data integrity and security.
• Capacity Planning and Forecasting: Expertise in assessing current and future capacity needs of databases, analyzing growth trends, resource utilization patterns, and application requirements to ensure optimal performance and scalability.
• Automation: Automated many day-to-day activities (writing scripts in bash, batch, AWS CLI, Ansible) for traditional database activities RDS database Automatic Upgrade/Downgrade | Scheduling Backups |Scheduling Maintenance Plans | Log Archival | Database Status | Database Locking | Replication Failure | Critical Event Failure | Database Performance and Disk/CPU/Memory Usage | Slow Queries on prime and cloud environment.
• Additional Skills: Strong understanding of database design, data modeling, and implementing data management solutions. Dedicated to staying updated with emerging technologies and advancements in database administration.
• Redis Expertise: Skilled in Redis Data Security and Access Controls (ACLs), implementing automated scaling, and failover mechanisms using Redis Cluster for high availability. Developed monitoring dashboards using Prometheus, Grafana, and RedisInsight to track metrics and identify potential issues.
• Database Documentation: Determine, enforce and document database policies, procedures and standards.
• Database Management: High-performing professional with extensive experience managing large-scale, complex databases. Skilled in SQL and multiple databases management systems.
• Ready to help team achieve company goals. Complex problem-solver with analytical and driven mindset. Dedicated to achieving demanding administrative objectives according to tight schedules. Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy. Seeking a position to leverage that offers professional challenges utilizing interpersonal skills, excellent time management and problem-solving skills.

Driven Database Architect with [Number] years of experience in full lifecycle development. Goal-oriented team player succeeds working with various colleagues and clients by maintaining communication. Motivated with keen analytical, problem-solving and task management abilities.

Dubai Technologies - Intelligent Fleet Management System:  An Intelligent Fleet Management System (FMS) integrates GPS, telematics, IoT, and AI to optimize fleet operations. It tracks vehicle locations, routes, and driver behavior in real-time, aiding in route optimization, reducing fuel consumption, and minimizing downtime through predictive maintenance. FMS monitors driver behavior for safety and efficiency, manages fuel consumption, and ensures regulatory compliance. Additionally, it tracks and manages fleet assets beyond vehicles, providing comprehensive insights into fleet performance. By analyzing data and generating reports, FMS helps organizations enhance operational efficiency, reduce costs, improve safety, and deliver better customer service. It's essential for industries like transportation, logistics, construction, and utilities, where efficient fleet management is critical for success.

Next Education - Next Learning Platform: Next Learning Platform(NLP) and Learning Management System (LMS) with virtual classroom features have revolutionized our traditional classrooms' learning environment. Next Learning Platform (NLP) with a feature of live streaming is the singular school management solutions application that seamlessly integrates the academic and administrative functions of a school. No matter what your role in a school is - principal, teacher, parent, student, accountant, vehicle attendant, etc - Next Learning Platform's role-based access allows you to access the information you need based on your designation. All your transactions can now be done anytime and anywhere through an NLP App.

TechUva Solutions - PVH Corp:  PVH(Phillips-Van Heusen) has excelled at growing brands and businesses with rich American heritages, becoming one of the largest global apparel companies which own brands such as Van Heusen, Tommy Hilfiger, Calvin Klein, IZOD, Arrow, Warner's, Olga, True & Co., and Geoffrey Beene.