Harika S. Email & Phone Number

Noida, Uttar Pradesh, India

ThinkSys Inc (Acquired Anyonehome - InhabitIQ)Database AdministratorAWS Cloud Infrastructure:Part of database migrations from Heroku Postgres to AWS Aurora Postgres.Installed and maintained AWS Aurora Postgres Clusters.PostgreSQL Management:Installed, configured, managed, monitored, troubleshot, upgraded, and migrated PostgreSQL versions from 9.1 to 16.Performed SQL tuning using explain plans and hints, along with performance tuning for optimized database performance.Tuned applications, instances, and disk usage for improved performance.Materialized Views:Created and managed materialized views to refresh data at regular intervals.Security Administration:Enforced security measures, system monitoring, user management, quota configuration, auditing, and security problem analysis.Database Administration:Administered large and complex databases, focusing on database design, normalization, and replication.Worked with SQL, PL/SQL, procedures, functions, and triggers.Managed database sizes ranging from 500GB to 5TB.Backup and Recovery:Implemented and managed backup and recovery processes.Daily Monitoring:Managed database servers using CloudWatch, monitored databases, agents, and log files.Development and Production Environment:Configured, integrated, and maintained all development, staging, UAT, and production database clusters using Docker.User Management:Managed user creation and access control.

Pune, Maharashtra, India

Senior Database Architect | Anyone Home Inc (Acquired by InhabitIQ)Key Responsibilities:AWS Cloud Infrastructure:Led database migrations from Heroku Postgres to AWS Aurora Postgres.Installed and maintained AWS Aurora Postgres Clusters.PostgreSQL Management:Installed, configured, managed, monitored, troubleshot, upgraded, and migrated PostgreSQL versions from 9.1 to 16.Performed SQL tuning using explain plans and hints, and conducted performance tuning for optimal database efficiency.Tuned applications, instances, and disk usage for improved performance.Materialized Views:Created and managed materialized views to refresh data at regular intervals.Security Administration:Enforced security measures, conducted system monitoring, managed user access, configured quotas, audited, and analyzed security issues.Database Administration:Administered large and complex databases, focusing on design, normalization, and replication.Worked with SQL, PL/SQL, procedures, functions, and triggers.Managed databases ranging in size from 500GB to 8TB.Backup and Recovery:Implemented and managed robust backup and recovery processes.Daily Monitoring:Monitored database servers using CloudWatch, managed databases, agents, and log files.Development and Production Environment:Configured, integrated, and maintained development, staging, UAT, and production database clusters using Docker.User Management:Managed user creation and access control.

Hyderabad, Telangana, India

Management, maintenance, and optimization of PostgreSQL databases hosted on Amazon Aurora and on-premises environments. Ensured database reliability, performance, and scalability while adhering to best practices and security standards.Key Responsibilities:Database Deployment and Configuration:Collaborated with DevOps and infrastructure teams to deploy and configure Aurora PostgreSQL instances.Optimized database parameters, such as buffer sizes, connection limits, and caching settings.Performance Tuning:Conducted regular performance monitoring and tuning activities.Identified and addressed bottlenecks, slow queries, and other performance-related issues.Implemented indexing strategies for optimal query performance.Backup and Recovery:Designed and implemented robust backup and recovery strategies.Tested and validated backup procedures regularly to ensure data integrity and availability.Security and Compliance:Implemented and maintained database security measures, including access controls and encryption.Ensured compliance with industry and organizational security standards.High Availability and Disaster Recovery:Configured and managed Aurora's automatic failover and replication features for high availability.Developed and tested disaster recovery plans to minimize downtime.Monitoring and Alerting:Set up monitoring tools to track database health, resource usage, and performance metrics.Implemented alerting systems for proactive issue identification and resolution.Scaling and Capacity Planning:Monitored database growth and planned for scaling resources as needed.Collaborated with the infrastructure team to ensure adequate resources were provisioned.Documentation:Maintained comprehensive documentation of the database architecture, configurations, and procedures.Provided training and documentation for development and operations teams.

Chennai, Tamil Nadu, India

PostgreSQL Developer/DBA for Telecom Inventory Management Product - NIMSKey Responsibilities:Database Design and Maintenance:Created PostgreSQL DB instances, tables, stored procedures, indexes, triggers, and functions.Managed database maintenance in both Linux and Windows environments.Spatial Database Setup:Set up spatial databases using PostGIS.Job Scheduling:Scheduled jobs using PgAgent.Geoserver Setup:Set up Geoserver using Tomcat.Created workspaces, stores, layers, layer groups, and styles.Metadata Editor:Designed and created a metadata editor to enable configuration changes on the fly without redeployment.Technology Implementation:Designed and implemented technologies such as ME, FTTx, IP, VLAN, etc.Technical Solutions Development:Developed solutions for complex business problems including:Location-based device management of racks/shelf/card/port.Assigning IP addresses to ports.Allocating services to customers.Network management for Layer 1/2/3 networks.Managing Outside Plant (OSP) entities and hierarchies for manholes, cables, splicing points, circuits, cabinets, etc.Data Configurations and UI Flow:Created data configurations and functions defining application behavior and UI flow.Customized UI buttons, wizards, IP generation, life cycle, and allocation based on configurations for each entity.Replication and Upgrades:Set up replication and performed PostgreSQL upgrades (data and server).Data Migration:Loaded data from MSSQL to PostgreSQL and between different environments (dev/test/prod) using shell scripts.