Email:ad0ab4@r.postjobfree.com Tel: 469-***-****

PROFILE

I have 12 years of experience in the IT industry and 8 years plus experience Managing Oracle, and PostgreSQL, MySQL running both on prem and on cloud platforms such AWS, Azure and IBM. Worked on various Oracle versions like 10g, 11g, 12c, and 19c Databases across various platforms such as Linux, AIX, and Windows. My experience includes Installation, Configuration, Monitoring, Migration, Backup & Recovery, data guard implementation, Tuning & Troubleshooting, Cloning, Space Management, Security, and Auditing. Engineered/designed/developed/deployed additional technologies and automation for managed services on AWS infrastructure and services such as EC2, RDS, S3 and monitoring with CloudWatch within a managed service environment-VPC. Perform data migration of Oracle from on premises environments into AWS EC2 and RDS instances. Worked with Red Hat Enterprise Linux versions 5, 6, 7 and 8. Supported and coordinated with technical team members in monitoring of systems and in performance tuning and optimization of system I am a well organised, proactive, and highly motivated professional Database Administrator with extensive experience. I am a fast learner, good at disseminating information and documentations. I am a team player and culturally versed hence interacting professionally with others is easy. I am Bilingual in French, English and pidgin.

Certifications:

Oracle Certified Associate 12c

CompTIA Security plus

AWS solution architect

Oracle Database 12c: SQL Fundamentals

Bachelors degree in Banking and Finance

PROFESSIONAL SUMMARY:

Experience in Installation, configuration, maintenance and administration of Oracle Databases 10g, 11g and 12c multitenant, 18c, 19c RAC, GoldenGate, and DataGuard

Experience in Oracle Access Manager and Oracle Identity Manager and Governance

8 years experience working linux, window and AIX servers

Experience in Identity and Access Management Security Consulting

Experience with Oracle Identity Management.

Experience with installing/configuring PostgreSQL version 9.5 and 10 and 11

Experience with Migration to PostgreSQL

Experience in Creating and maintaining SQL Server Databases

Administer over 100 databases ranging from 300MB to 19TB sizes, across Development, QUAT and PROD environments via use of command line and different Oracle tools.

Experienced in RAC, GoldenGate and DataGuard Administrative activities.

Knowledge in Exadata

5 plus years on RAC Implementations.

5 plus years on implementing TDE.

AWS cloud infrastructure

6 plus years implementation of data guard configuration and implementation

Experience in patching Oracle applications using opatch, and Opatchauto.

5 plus years in supporting applications and systems in AWS.

Experience in Migration of Oracle Databases from Non-RAC to RAC and Non-ASM to ASM Instances

Experience with migration to AWS (EC2 and RDS) using DMS, RMAN, and DataPump

Cloning from single node to single node as well as multimode to multimode.

Installation and configuration of Oracle Audit Vault

Database / Application patch analysis and apply using, opatchauto.

Implementation of High Availability solutions with Oracle 11g/12c RAC, Data guard.

Capable of configuring of Physical standby database for high availability

Skilled in database administrative activities in ASM, RAC and DataGuard

Involved in database upgrade from 10g to 11g and 11g to 12c Multitenant databases.

Experience in configuring and performing Backups/Recovery using RMAN, Datapump and Flashback Technologies

Good experience in database cloning and database refresh activities using RMAN, transportable tablespace and Data pump.

Usage of performance views and usage of performance utilities (AWR, ASH, ADDM, TKPROF, EXPLAIN PLAN and STATSPACK.)

Experience in Installing and Configuring OEM 12c & OEM 13c cloud control with email alerts.

Implement, configure, and troubleshoot database instances, replication, backup, partitions, storage, and access. Set user privileges within and outside the database environment.

Technical Skills:

Oracle Databases (RDBMS) - Oracle 10G (10.2.0.5), Oracle 11G (11.2.0.2, 11.2.0.3, and 11.2.0.4), Oracle 12C (12.1.0.2 and 12.2.0.1), and Oracle 18c

Operating Systems - HP-UX, Red Hat Enterprise Linux, Oracle Enterprise Linux and Windows 2008 and 2012 R2, 5 years’ experience on AWS

ERP - Oracle E-Business Suit 11.5.10.2, 12.0.6, 12.1.1, 12.1.3, 12.2.2, 12.2.4 and 12.2.5

Database Utilities - OEM 12c & OEM 13c Cloud Control, Exp/Imp, Data Pump, DBCA. DBUA, OUI, RMAN, Goldengate Monitor, DGMGRL, GGSCI, vpc, security groups, subnet configuration IAM, EC2, RDS, Load balancers, auto scaling, route 53

Tools - Putty, Toad, SQL Developer, SQL*Plus, SQL*Loader, WinSCP, FileZilla, Splunk, DBeaver, SCT, VMware ESX,vCenter Dell servers, talent Cloud, Lucid chat, terraform

Scripting Languages - Sql, Pl/Sql and Unix Shell Scripting,

Professional Experience:

Saks/Saks Fifth Avenue July 2020 – Present

Database Administrator

Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 11g, 12c and 19c.

Performed RAC to single instance refresh and single instance to RAC.

Upgraded from Oracle Linux 7.8 to Linux oracle Linux 8.

Performed Upgrade using DBUA, datapump and automated method using java script.

Worked on disaster recovery of, dataguard physical standby Failover/switchover/loss of service /rebuild/corruption/loss of datafile testing.

Automated monitoring of databases, performance parameters, backup and recovery activities by running Cron jobs and customized various Unix Shell Scripts in sending Email for ORA- errors, reports for Quick Morning Check (QMC), automate routine DBA tasks of taking backups, exports, space usage monitoring, move Archive Logs to different mount point when Archive Destination is full and resync RMAN catalog.

Monitored and tuned long running jobs by working closely with the application development team and analyzing objects, created or rebuilt indexes, query tuning using SQL TRACE, TKPROF, Explain Plan, TOAD.

Performed Database replication from production to test/development environment Using RMAN, Data pump utilities and manually.

Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.

Installed Oracle and grid software on standalone servers on ASM and file system.

Performed activities on ASM, creating disk group with different Redundancy Levels/using Fail group, adding a disk to a disk group, making disks online/offline and mount/dismount disk groups as SYSASM.

Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.

Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.

Created Physical Standby databases using RMAN with zero downtime, performed Failover and Switchover using Data Guard Broker and manually as and when required.

Extensive experience in RMAN recovery testing, successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold backups for RAC and standalone database.

Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases

Installed and configured Oracle 12c, 18c, 19c database and cloud control 13c to monitor all databases.

Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 10g, 11g, 12c, 18c and 19c environments.

Involved in construction of DR sites, configuring data-guard and Enterprise Failover Manager for Production environments, participated in scheduled switch over tests..

Performed Database Refresh from Production to QA, UAT and Development databases.

Implemented and managed optimum physical database design (tablespaces, data files, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space.

Fannie Mae - Reston, VA November 2018 – June 2020

Database Administrator

Perform applications database administration (Oracle) services including SQL code review, performance analysis, query tuning, development support.

5 plus years on RAC Implementations

Work with business unit managers to understand project scope Work with business unit managers to understand project scope.

5 plus years in supporting applications and systems in AWS.

Kept up to date with latest industry knowledge and news to maintain and improve enterprise and business platforms.

Work with several third-party vendors in big data and other areas to support our overall cloud initiative.

Upgraded databases from 12c to 19c manually using silent installation method.

Knowledge and 5 plus years hands on experience deploying and configuring AWS VPCs, IAM Roles, S3 buckets, autoscaling, vpc peering, Subnets route table and other services.

6 plus years implementation of data guard configuration and implementation

Ability to quickly synthesize ideas, options, and thoughts into solutions to management to aid in decision-making.

Design, implement and maintain all AWS infrastructure and services within a managed service environment.

Design, Deploy and maintain enterprise class security, network, and systems management applications within an AWS environment.

Strong knowledge of Amazon Kinesis

Design, both technically compliant and secure Cloud solutions, as well as value-based, on-demand services to facilitate the effective transition and migration of projects and programs into unique and adaptive cloud environments.

Work with onboarding internal clients

Ability to design high availability applications on cloud adhering to DR and availability best practices.

Ability to develop and drive database administration strategies and initiatives as per the needs of the team.

Experience in having a new server and installing 12c and 18c and 19c binaries on server.

Knowledge and 5 plus years hands on experience deploying and configuring AWS VPCs, IAM Roles, S3 buckets, autoscaling, VPC peering, Subnets, route table and other services.

Provide database support in all phases of SDLC and agile experience.

Participate in 24X7 on call rotation schedule for various production support, database maintenance, housekeeping, and installations.

American Modern Insurance Group - Amelia, OH JULY 2015 – Oct2018

Database Administrator

Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and ADDM.

Performance tuning of Queries by maintaining aggregates, compression, and use of hints, stored outlines, and Statistics

Performed Table Partitioning, created Index Organized tables and Locally Managed Tablespaces

Monitoring Day-Day Backups, Log's & recovering them as per the requirement.

Monitored and provided weekly reports on the server’s memory, disk and CPU I/O using HP tools and UNIX command-line utilities.

Provided maintenance of user accounts, privileges, profiles, and roles

Experience in Backup & Recovery using RMAN.

Experience in OEM upgrade

Successfully installed and configured Oracle Enterprise manager (OEM)

administration, configuration, and maintenance of Oracle 11g, 12c, and 18c RAC for mission critical Application & Databases.

Implementing and managed DataGaurd for Physical Standby database (DR), Logical Standby (Reporting), Snapshot Standby (Testing), and Active DataGuard.

Experienced in working with data guard physical/logical standby databases for disaster recovery.

IT Security policy enhancement through role & privileges

Provided valuable inputs for various performance tuning issues.

Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM. Performance Tuning of the database (Memory Tuning, I/O Tuning)

Performance tuning on OS, Database, Database Instance, and application

Performed Database Refresh from Production to Test, Quat and Development databases using Exp/Imp

Planning and scheduling Backups, taking Logical Backups (with Export and Data pump utilities)

Creating &Managing Database Structures, Storage Allocation, Table/Index segments, Constraints, Database Access, Roles, and Privileges

Experience with data movement using Oracle utilities like Export/Import, Data pump and SQL *Loader

Installed and applied various patches which include Critical Patch Update (CPU), Patch Set Update (PSU), GI Patches, Rolling Patches and One-off patches using OPatch and runinstaller, also involved in upgrade oracle database 10g to 11g and 11g to 12c.

Planned and configured disk layout, mount points and capacity requirements for servers

Designed, developed, and maintained UNIX shell scripts to collect and monitor database metrics and Statspack snapshots and reports.

Involved with OLTP relational databases system analysis, design, implementation and management.

Administered 11g RAC environments, adding and removing nodes to the cluster and handled performance tuning using AWR report.

Supported off-hour on call support for database related issues.

Documented many of the Standard Processes for peers to follow.

Created and assisted in creation of documents for other DBA on shared point, like Data Guard Switch-over, upgrade from 12c to 18c, agent installation for OEM 13c, 18c DB creation, etc.

Installed 13c agent on many servers, sometimes must manually find targets on server with OEM 13c.

Monitored databases with OEM 13c and created users with enterprise manager.

Upgraded databases from 12c to 18c manually using silent installation method.

Experience in having a new server and installing 12c 18c and 19c binaries on server.

Administrative tasks for PostgreSQL, like creating a database, creating users, creating a table, etc.

Administrative tasks for SQL using SSMS like creating database, creating users, creating tables, etc.

Successfully installed and configured Oracle 11.2.0.3, Oracle 12.1.0.1 databases on AIX platforms

Performed Database upgrade from Oracle 10g to Oracle 11g (11.2.0.4) RAC databases.

Refreshed/ cloned databases using RMAN utility.

Participated in Disaster Recovery Drills, documented database, and application validation steps.

Detect corrupted blocks by using DBVERIFY utility.

5 plus years’ experience with AWS

Successful in in applying RDBMS patches, security patches for improving the security and functionality of the databases.

Monitored different databases and application servers using Oracle Enterprise Manager (OEM) and 12c cloud Control.

Achu, Meshelemiah Barika

Contact this candidate