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.