SUMMARY

• I have 8 years of experience in the IT industry and 6 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. 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.
• 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
• 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, Sun Solaris OS (5.1, 5.2, 5.3, 5.9, 5,10, 6.1), 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

Applications Utilities: AD Utilities, OIM, OAM, OBIEE, OID, ODI, FNDLOAD, FNDCPASS

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

Confidential, Reston, VA

Database Administrator

Responsibilities:

• 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 environment
• 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 installed 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.

Confidential, Amelia, OH

Database Administrator

Responsibilities:

• 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.
• Experience on 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
• 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 installed 12c and 18c binaries on server.
• Administrative tasks for PostgreSQL, like creating a database, creating users, creating a table, etc
• Administrative task 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 database
• 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