Jan Kevin Ramos

About Jan Kevin Ramos

Jan Kevin B. Ramos is a Database Admin Manager based in Austin, Texas, USA (Onsite). An…

Experience

1. Database Admin Manager

   Accenture

   May 2023 — Present · Austin, TX, US

   RESPONSIBILITIES:• Provide 24/7 database administration support and troubleshooting for production, test, and development environments of database systems, and perform additional duties as assigned.• Perform Oracle ASM and database software installation (RDBMS) and/or upgrades, including OS re-platforming and/or upgrades, as well as configuring Oracle Data Guard and setting up replication.• Configure and manage RMAN backup and recovery; perform database cloning and data refresh using export and import data pump backups.• Monitor database performance; perform data change requests, migrations, and object rebuilds for database maintenance.• Analyze database capacity and growth, including tablespaces, using various automated testing tools and performance optimization techniques.• Utilize UNIX shell scripting to automate system administration and support developers with efficient SQL query optimization and performance tuning.• Install, configure, and manage scheduler jobs for both CRON and DBMS to perform daily health checks of the database server system. Maintain Oracle databases hosted on the RHEL platform, along with other related components (e.g, MSSQL, MongoDB).• Provide lead support across all platforms (Oracle, MSSQL, MongoDB) for both AO Run and AO Build, covering end-to-end operations and upgrades, including project estimation, planning, and deployment.• Team management and resource capacity planning.

Skills

• Oracle Applications
• Hp-UX
• Microsoft Office
• Oracle
• Requirements Analysis
• Rman
• Sdlc
• Microsoft Sql Server
• Pl/Sql
• Database Administration
• Software Development Life Cycle (Sdlc)