Akshay Kumar Verma
Noida
Summary
Accomplished Database Engineer at S&P Global with expertise in Oracle and PostgreSQL, driving performance enhancements and cost optimization initiatives. Proficient in AWS services and Terraform, I excel in automating database operations while ensuring security compliance. A proactive problem-solver, I effectively manage production environments and deliver robust data protection solutions.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Database Engineer
S&P Global
Noida
12.2019 - Current
- Provided 24x7 production support for enterprise-scale Oracle and PostgreSQL databases across on-prem and AWS cloud environments
- Managed Oracle databases (9i-19c) including RAC, Standalone, Data Guard, and Exadata systems
- Administered PostgreSQL and Aurora PostgreSQL databases on AWS RDS, including upgrades and performance tuning
- Upgraded Aurora PostgreSQL clusters and RDS instances to latest versions ensuring minimal downtime
- Designed and built AWS RDS Aurora PostgreSQL infrastructure using Terraform pipelines and Git-based automation
- Migrated Aurora PostgreSQL databases across AWS accounts with minimal service disruption
- Implemented performance tuning strategies for PostgreSQL (RDS), enhancing query efficiency and lowering latency
- Configured CloudWatch monitoring and alerts for database infrastructure, ensuring proactive management across all production AWS accounts
- Led security group remediation across AWS accounts, resolving vulnerabilities and ensuring compliance standards
- Executed AWS cost optimization initiatives, achieving more efficient resource usage
- Managed Oracle GoldenGate (Microservices) replication and resolved replication/Attunity-related issues
- Executed quarterly patching cycles (PSU/CPU) for Oracle databases ensuring security compliance
- Automated database refresh activities using Actifio and supported backup/recovery using Rubrik
- Performed RMAN backup management and troubleshooting for Oracle environments
- Monitored database health using OEM, AWR, ADDM, and implemented proactive issue resolution
Software Analyst (Database Administrator)
HCL Technologies
Noida
02.2017 - 12.2019
- Supported Oracle databases in production environments
- Managed backup and recovery operations using RMAN, ensuring database integrity during refresh activities
- Configured archive log mode and performed database cloning
- Performed user and tablespace management, and routine health checks
- Assisted in patching and monitored performance to troubleshoot and resolve database issues
- Handled incident management processes using ServiceNow and Remedy to support timely resolution of database incidents.
Education
B.Tech - Electrical & Electronics Engineering
Skills
- Oracle & PostgreSQL
- SQL and PL/SQL
- Oracle data tools
- AWS services
- Terraform and Git
- TOAD and SQL Developer
- Data protection
- Unix systems administration
- Windows administration
- Putty and Linux
- Grafana and ServiceNow
- Remedy and Actifio
Websites
Certification
- AWS Certified Cloud Practitioner
- Oracle Cloud Infrastructure 2022 Certified Foundations Associate
Timeline
Database Engineer
S&P Global
12.2019 - Current
Software Analyst (Database Administrator)
HCL Technologies
02.2017 - 12.2019