Oracle Database Administrator Resume
2.00/5 (Submit Your Rating)
Ashburn, VA
PROFESSIONAL PROFILE:
- A motivated and proactive individual with a wide range of IT knowledge and expertise gathered over the span of 7+ years in fields such as Healthcare, Financial and the Communication domain.
- Able to maintain strategic vision of the organization and link it with everyday work.
- Very passionate about projects and able to carry out tasks that are time sensitive in an efficient manner to guarantee the growth and success of the organization.
- A wonderful team player and a fast learner who values collaboration and communication, eager and possesses a very strong work ethic and can relate and work efficiently with diverse groups. Hardworking and honest young man with much potential.
- Execute multiple tasks without supervision and ambition for challenging jobs.
- Ability to work under pressure with or without supervision.
- Experienced in installing, upgrading, migrating, patching, refreshing databases and cloning oracle homes
- Upgraded GRID Infrastructure, RAC - Data guard setups for 11gR2 and 12c
- Enforced database security strategies by creating database users, user roles, profiles, audit trails, audit banners and transparent data encryption
- Experienced in database Backups RMAN (Full/Incremental backups) and in traditional hot/cold backups and in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable Tablespaces
- Experienced with Oracle RAC, Oracle Enterprise Manager Grid Control, Data Guard including Active DG and Flashback.
- Performed PL/SQL development, Shell scripting and Performance tuning, OS utilities AWR/ADDM.
- Installed and configured Oracle 11g RAC data guard physical standby and data guard broker.
- Used OEM, SQL Developer, Mobaxterm, SCT, DMS, PGAdmin and TOAD to administer database.
- Experience with My Oracle Support (MOS)/Meta link for Oracle SR, patch download Experience and TFA reporting
- Determined problem-solver with success in aligning the business and industry’s best practices and technical vision in order to initiate, implement, and improve innovative business technology solutions
- Experienced with HP service Manager’s service desk and on-call tools for problem/incident management and on-call support.
- Goldengate configuration for business intelligence purposes.
- Excellent communication, inter-personal and organizational skills.
TECHNICAL SKILLS:
- Oracle 12c/11G/10G Architecture Linux/UNIX/Window Client/Server Environments Maximum Availability Architecture Oracle software installation and maintenance Production support and maintenance
- Backup & Recovery strategies Database Security & Space Management Shell and SQL scripts to monitor databases Shell scripting AWR/ADDM/ASH report generation VMware, Oracle Virtual Machine, AWS, Oracle Cloud Infrastructure (OCI), Goldengate
PROFESSIONAL EXPERIENCE:
Confidential, Ashburn, VA
Oracle Database Administrator
Responsibilities:
- Upgraded several databases from 4
- Manages several databases on AWS RDS Instances.
- Migrated Oracle OnPrem Databases to AWS Aurora Postgres
- Migrated Oracle OnPrem Database to Oracle cloud infrastructure using Standby DR strategy for minimal downtime.
- Using Schema Migration Tool (SCT) and Database Migration Service (DMS) to migrate to the cloud.
- Goldengate installation and configurations.
- Enable TDE on all OCI database running on Exadata in the cloud.
- Oracle secure backups to the cloud
- Applied quarterly PSU Patches to RAC/Non-RAC databases.
- General administration and routine operations including ASM disk group management, applying database tuning improvements, managing users and database security, troubleshooting and performance tuning.
- Upgraded several databases from .1.2.0
- Configuration of container and pluggable databases
- Working with Jenkins and Docker for DevOps automations.
- Upgraded GRID Infrastructure, RAC-Data guard setups from 2
- Export and import of tables and schemas as per development/Application team requirements using Data pump
- Generated scripts for daily maintenance routine activities, growth rate monitoring and optimizing database performance
- Oracle RAC/data guard Installation and upgraded from 11.2.0.1 CRS/ASM to 11.2.0.4 GRID infrastructure.
- Routine database replication using either active active or active passive topology.
- Provide planned maintenance for the implementation of new releases and Database migrations
- Provide support after normal business hours (i.e., nights, weekends, and holidays) and participate in a 24 x 7 on-call rotation.
- TDE configuration for tablespaces as new security measure for cloud databases.
- I manage about 210 databases with the minimum size of 40G and Maximum size of 1 - 5 Terabyte which keeps growing.
- Recently migrated 7 databases between 900G and 5 Terabyte to the cloud using Data guard for minimum downtime.
Confidential, Fort worth, TX
Oracle Database Administrator
Responsibilities:
- Delivered 24/7 database administration support to more than 250 servers and 310 databases, which include oversight of DBA on-call rotations.
- Proactively provided support to RAC, ASM, and Data Guard physical standby databases throughout daily production operations.
- Resolved archivelog gaps and other related problems. Effected switch over manually and using DMGDRL
- Used AutoSys, windows task scheduler and Crontab to schedule weekly backup and file clean jobs
- Closely tracked and administered the production environment, which includes database alert logs, file system disk space, tablespace monitoring, system shut downs, and database restarts for maintenance purposes.
- Performed refresh of schemas from production to test environment using the DATAPUMP utility (expdp/impdp).
- Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 12c Grid Control, OraTools and TOAD
- Successfully run complete, incremental, and archive backups with Recovery Manager (RMAN).
- Upgraded multiple databases from 11.2.0.3 to 11.2.0.4.
Confidential, Adrian, MI
Oracle Database Administrator
Responsibilities:
- Installed and configured Oracle 10g/11g software on Linux.
- Refreshed databases and configured them to meet developer and user requirements
- Applied Oracle Critical PSU on our databases on quarterly basis.
- Managed backups and recoveries using RMAN, data-pump export/import utilities Managed tablespace, control file and online redo logs.
- Conducted regular status checks, monitoring the Alert log, trace files of databases.
- Monitor databases which include basic health checks, growth of objects, and performance of databases.
- Monitored database activity and file usage by removing old or obsolete files to ensure necessary resources are released to enhance database performance.
- Checked database and servers for disk contention, monitored resource usage, system events, to maximize performance.