
Experienced Database Administrator proficient in SQL Server, UNIX Shell Scripting, and Linux Environments. Skilled in ensuring data accuracy, resolving issues through Root Cause Analysis, and utilizing Atlassian Jira for efficient workflow management. Strong knowledge and basic experience in Azure SQL DB.
Years of post-secondary education in Cloud Computing
Months of experience as a Full Stack Java developer in Trainee
• Managed PostgreSQL, and Microsoft SQL Server databases, and made adjustments to meet application requirements.
• Successfully migrated data from MSSQL and Oracle to GCP Cloud SQL and Azure SQL, ensuring smooth transition to new environment.
• Utilized SQL/MySQL queries to handle trade errors and temporarily resolve product defects in backend database.
• Improved database performance by optimizing SQL query plans, resulting in 30% improvement in software performance.
• Monitored and optimized SQL query plans by recompiling PL/SQL stored procedures, ensuring high performance and availability.
• Implemented data maintenance procedures that reduced data-related errors by 20%.
• Ensured databases were consistently backed up and implemented reliable recovery procedures to safeguard against data loss in memory-related events.
• Proficient in UNIX/Linux scripting for automation, facilitating batch jobs, and end-of-day processes.
• Streamlined database operations through automation and issue tracking using Atlassian JIRA, resulting in
15% reduction in manual tasks and improved overall efficiency.
• Primary point of contact for various clients, providing excellent customer support and promptly resolving critical issues during bridge calls.
• Achieved outstanding 99.99% uptime rate by quickly resolving critical issues in client production environments during bridge calls.
• Ensured data accuracy and completeness through Root Cause Analysis (RCA) and efficient data maintenance procedures.
• Complied with security procedures and contributed to access and user account management within database.
Microsoft Azure Fundamental AZ-900