Oracle Database Administrator

5/2021 – 6/2021

Worked as an L2 Oracle DBA for a major client in the banking sector, ensuring availability for over 5000 databases and performing activities such as backup/restore, database migrations and performance tuning

Oracle Data Guard, Oracle Database, SQL

8/2019 – 4/2021

Oracle
• Administered and configured High Availability solutions such as Oracle RAC and Data Guard
• Planned and executed DB/GI upgrades, patches installation and database migrations
• Worked with RMAN by performing restore and recovery activities and configured backup scripts
• Worked with ASM storage (migrated disks from one technology to another and investigated disk issues)
• Performed SQL query optimization and performance tuning and migrated data with Data Pump
• Worked with Oracle Enterprise Manager 13c (OEM 13.4 installation and agent deployment on all hosts)
• Coordinated and designed the automation initiative for recurring DBA tasks (e.g. add space)
• Worked with Amazon RDS for Oracle (db.m5.large/db.m5.xlarge)
Microsoft SQL Server
• Executed administrative tasks (e.g. creating databases, schemas, logins, backups/restores)
• Migrated databases from Microsoft SQL Server to PostgreSQL
• Migrated databases from Oracle to Microsoft SQL Server
PostgreSQL
• Designed the PostgreSQL environment, installed and configured PostgreSQL 11
• Created, administered and ensured availability of all PostgreSQL databases
• Migrated databases from Oracle to PostgreSQL

Microsoft SQL-Server (MS SQL), Oracle Data Guard, Oracle Database, Postgresql, SQL

6/2016 – 8/2019

• Ensured availability for over 4000 databases by solving critical and medium level incidents
• Worked with Oracle RAC, Data Guard, Oracle GoldenGate, ASM storage
• Collaborated with multiple teams (e.g. UNIX, Network, Storage, Application Support)

Oracle Data Guard, Oracle Database