Oracle DBA

Job Position: Oracle DBA
Location: Piscataway, NJ~ Englewood Cliffs, NJ~ Ewing, NJ


Job type: C2C/W2


About the Role
Role Description:
Provisioned and configured Amazon RDS instances across Oracle, PostgreSQL, Redshift, Dynamodb
Managed RDS storage, instance classes, parameter groups, option groups, and maintenance windows.
Performed automated backup validation, manual snapshots, cross-region snapshot copy, and PITR restores.
Monitored performance using CloudWatch, Enhanced Monitoring, and Performance Insights.
Diagnosed and resolved bottlenecks including CPU spikes, slow queries, blocking sessions, and IOPS issues.
Implemented HA and DR solutions using multi-AZ, read replicas, and cross-region failover strategies.
Created CloudWatch alarms and alerts for CPU, storage, connections, replication lag, and backup failures.
Executed minor version upgrades, patching, and capacity scaling during scheduled maintenance windows.
Tuned SQL queries, indexes, and database parameters to optimize performance and resource usage.
Developed automation using AWS CLI and shellPython scripts for monitoring and reporting.
Performed database migrations from on-prem to AWS using DMS and native export/import tools.
Conducted performance benchmarking, load testing, and configuration optimization.
Optimized cost by rightsizing RDS instances, enabling storage auto-scaling, and cleaning unused snapshots.
Database refreshtable level refresh from production to non-prod.