BASIL TITUS

• Expertly configured and maintained PostgreSQL high availability (HA) clusters using streaming replication and synchronous standby configurations to ensure minimal downtime and data integrity.
• Enhanced database performance through meticulous tuning of buffer cache settings, query optimization, and strategic indexing, leading to significant improvements in query response times and overall system efficiency.
• Implemented and fine-tuned PgBouncer for efficient connection pooling, reducing server load and improving application responsiveness; configured transaction pooling modes.
• Designed and managed robust data pipelines integrating PostgreSQL, Debezium, Kafka, and Greenplum for real-time Change Data Capture (CDC) and seamless data flow.
• Enhanced Greenplum database performance by implementing Append-Optimized (AO) columnar tables, improving query execution times and reducing storage requirements.
• Conducted routine Greenplum maintenance tasks, including vacuuming and statistics updates.
• Executed ELK stack (Elasticsearch, Logstash, Kibana) setup for centralized logging and monitoring.
• Proposed and implemented a data tiering strategy within Elasticsearch for efficient long-term data storage.
• Demonstrated proficiency in deploying and managing Redis for caching, Citus for distributed PostgreSQL, and RabbitMQ for message brokering.

Tools: Azure, PostgreSQL 13, Linux, Greenplum, Kafka, Debezium, Elasticsearch, Redis cache, Citus DB.

• Conducted in-place and side-by-side upgrades of SQL Server instances, ensuring minimal downtime and data integrity.
• Applied cumulative updates and service packs for SQL Server.
• Executed migrations from Azure SQL Database (IaaS) to on-premises SQL Server using Azure Database Migration Service.
• Managed migrations from Azure SQL Managed Instance (PaaS) to on-premises SQL Server using the BACPAC method.
• Configured and maintained SQL Server Merge and Transactional Replication.
• Implemented monthly index maintenance routines (reorganizing and rebuilding indexes).
• Monitored and resolved blocking and deadlock issues by analyzing execution plans and optimizing queries.
• Utilized performance counters and dynamic management views for server resource tracking.
• Set up and configured logical replication in PostgreSQL.
• Utilized PostgreSQL's pgcrypto module for column-level data encryption.
• Conducted comprehensive performance tuning for SQL Server and PostgreSQL databases (index optimization, query rewriting, execution plan analysis).
• Scheduled and managed automated jobs using SQL Server Agent, Argent Scheduler, and Windows Task Scheduler.

Tools: Azure, PostgreSQL 13, SQL Server, Argent scheduler, Windows, Linux.

• Implemented backup and recovery strategies for SQL Server and Oracle databases (full, differential, transaction log backups).
• Managed database files and filegroups in SQL Server for performance and storage optimization.
• Followed best practices for Oracle database file placement.
• Configured and maintained Row-Level Security (RLS) policies in SQL Server.
• Managed SQL code deployments using version control, scripting, and automated deployment tools.

Tools: SQL Server, Oracle.

• Developed efficient stored procedures, functions, views, and triggers.
• Analyzed execution plans and performed query tuning.
• Performed regular index maintenance (reorganizing and rebuilding).
• Configured and managed Always On Availability Groups using Windows Server Failover Clustering.
• Performed point-in-time recovery operations using transaction log backups.
• Identified and resolved blocking and deadlocking issues.
• Implemented backup strategies (full, differential, transaction log backups) and performed restore operations.
• Managed and scheduled automated tasks using SQL Server Agent.
• Provided training and guidance to SQL developers on best practices.

Tools: SQL Server, Windows Server.