Manager Security

Location:

Castle Rock, CO

Salary:

95k-105k

Posted:

November 12, 2020

Contact this candidate

Resume:

VICTOIRE MANIALE

Orace Database Administrator

Cell. +1-301-***-**** Email: ********@*****.***

1. Summary

Certified Oracle/SQLserver Database Administrator with U.S Citizenship offering 7 years of hands on experience assuring the availability, performance, integrity, and security of databases both on premises and cloud servers. Draws on expertise in monitoring and tuning, upgrade, migration, backup and recovery, security implementation and development. Familiar with Agile principles and practices, I possess track record of working effectively as a skilled problem solver, able to troubleshoot effectively and collaborate with team members to overcome roadblocks in fast-paced, high-pressure environments.

2. Professional Experience

•Configured Elastic Cloud Computing (EC2, VPC, EFS, AMI, Security Group) using AWS resources;

•Created Database Services And Analytics(RDS);

•Configured Networking and Monitoring Services such as VPC, NAT, CloudWatch;

•Created Instances Security Management such as IAM, MFA, API;

•Created Object Storage Options (S3, CloudFront, Snowball);

•Configured Load Balancing, Auto-Scaling And Route 53;

•Configured and managed Automation tools that increase organization’s speed to deliver applications and service (OpsWork, BeanStalk).

•Configured CodeCommit to manage source control services that make it easy to team to collaborate on code,

•Applied Continue Integration/Continue Deployment (CI/CD), and Continue Delivery methodology to deliver high quality services.

•Administered many databases across Development, QA, UAT and PROD environments using command line and Oracle tools, Oracle Enterprise Manager, Cloud 12c, SQL server Management Studio 2014.

•Installing Oracle Golden gate on RHEL and setup table level replication as well as DDL replication too.

•Evaluated Oracle 11gR2 Golden Gate for future purposes that is for reducing the complexity involved in Oracle Streams.

•Installed Oracle 11g RAC and Upgrading Oracle 10g RAC databases.

•Upgraded databases from 10g to 11g and 12c.

•Set up Active Dataguard Configurations for oracle database 11.2.0.3 for thirty databases whose size varies from 5TB to 10TB on a 3 nodes RAC.

•Designed GoldenGate configuration for databases & implemented filters with rules to meet the business usage which will reduce load on the production databases for better performance with replication on multiple sites.

•Migrated and upgraded Oracle 11gR2 Databases from Sun Solaris 10 to Red hat Linux 5 using Goldengate.

•Worked on SQL Tuning and used available tools outside of Oracle Enterprise Manager.

•Worked on Performance Tuning, troubleshooting and identifying large objects, analyze those objects and recommend changes to improve performance.

•Installed and Administered Oracle 11g & 10g RAC software with ASM.

•Implemented & Managed Physical Standby and even Configured Automatic Storage Management (ASM).

•Applying Patch set, Critical Patch Update (CPU)/Patch Set Update (PSU) and One-off Patches using OPatch and run Installer under UNIX and Windows.

•Performance Tuning of Oracle database using OEM, SQL analyzer, AWR, ADDM, ASH, Explain plan.

•Implementing Archiving, replication, ETL and Cloud Strategy, DB modeling, load testing.

•Data transferring using Export/Import utilities and SQL*Loader.

•Resolved database network problems using Oracle Net Configuration Assistant, Oracle Net Manager, Netstat and ping utility.

•Involved in writing stored Procedures, Functions and Triggers in PL/SQL to interface application with database system.

•Ability to work independently in complex environments of multi-vendor systems, worked in 24x7 environment and on-call project requirements.

3. Work History

3.1 ACCENTURE (AFS) Arlington, VA 06/2019 – Now Application Tech Specialist

•Designed, developed, and tested features for management functions in an Agile environment;

•Performed tasks for virtual machine maintenance for Microsoft Servers. Snapshots, backups, patching, and monitoring.

•Provided application support using Unix, VMS, and Oracle;

•Developed monitoring tools, including Oracle Enterprise Manager, Tested and assessed deliverables in an Agile/Scrum delivery model;

•Reviewed test deliverables and provided feedback to ensure they meet expectations;

•Worked across the Service Delivery Lifecycle on engineering solutions for new system roll outs;

•Worked with team members to gather and interpret user or system requirements into design specifications;

•Maintained applications according to SLAs;

•Use of compute/storage/network services in virtual environment such as VMWare or AWS.

•Successfully installed and configured Oracle 11.1.0.7 databases on AIX platforms.

•Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10gGrid Control.

•Refreshing Dev and Test instances with data from Production on a regular basis.

•Administer users accounts: created and assigned appropriate roles and privileges to users using active Directory,.Migrated 10TB database from regular file system to ASM using RMAN.

•Displayed a high level of expertise while handling the various scenarios of database Backup & recovery and cloning using the RMAN tool in RAC and Data Guard environments of large to very large databases; also setup RMAN catalog for the same.

•Have installed and implemented 12c cloud control and migration of 11g grid control to 12c cloud control.

•Have Tuned and troubleshooted Oracle Databases for performance improvement using AWR, ADDM, ASH and other OS related utilities like Oracle Enterprise Manager(OEM) 11g and 12c to monitor single instance and RAC databases.

•Supported Oracle Databases of sizes ranging from 100 GB to 10 TB.

•Virtual Machine Administration – performance of all tasks for virtual machine maintenance for Microsoft Servers. Snapshots, backups, patching, and monitoring.

•Used compute/storage/network services in virtual environment such as VMWare, Azure, or AWS.

•Created users, roles for Windows, Microsoft SQL, and Application access using Active Directory.

•Used scripts to automate routine tasks (PowerShell)

3.2 QVC - West Chester, PA 02/2016 – 05/2019

Oracle DBA

•Implemented Best Practices for migrating regular databases across platforms.

•Implemented High availability using Golden Gate Replication. Implanted Bi-directional replication using golden gate.

•Migrated 10TB database from regular file system to ASM using RMAN.

•Have installed and implemented 12c cloud control and migration of 11g grid control to 12c cloud control.

•Performed oracle Software's Installations, Created new standalone and clustered databases.

•Provided application support using Unix, VMS, and Oracle;

•Developed monitoring tools, including Oracle Enterprise Manager, Tested and assessed deliverables in an Agile/Scrum delivery model;

•Reviewed test deliverables and provided feedback to ensure they meet expectations;

•Worked across the Service Delivery Lifecycle on engineering solutions for new system roll outs;

•Worked with team members to gather and interpret user or system requirements into design specifications;

•Maintained applications according to SLAs;

•Use of compute/storage/network services in virtual environment such as VMWare or AWS.

•Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.

•Also worked on Network data encryption to improve the security and also implemented SSL wallet to secure the connections.

•Database Services creation for distributing the applications across multiple nodes, extensively used all command line utilities SRVCTL, CRSCTL, ADR, ASMCMD,

•Redefinition of tables using DBMS_REDEFINITION, partitioning the tables in the production, re-defining the columns data types, and moving the LOBS to different tablespace

•Partitioned tables Maintenance, adding new partitions, exchanging one-year old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.

•Implemented 11g Interval Partitioning for monthly partitioning of large tables.

•Developed RMAN Backup strategies for cloning the test databases with the production environment and worked on RMAN active (active duplication ).

•Experience with Logical backups EXPDP/IMPDP and extensively used for Re-hosting the application using Golden Gate and worked with conventional EXP/IMP for migrating data from 9i to 10G.

•Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS_JOBS, DBMS_SCHEDULER, Crontab and $UNIVERSE.

•Designed and implemented different backup strategies like Cold, Hot, RMAN with Flash Recovery Area and Logical Backups EXPDP/IMPDP.

•Handled Chained Rows and Row migration and solved the database performance issues.

•Experienced with ASM, adding, deleting disks to the disk group.

•Supported development teams for all the database related issues and handled the critical issues like network failures and ASM DISK group errors and node failures in the RAC cluster.

•Generated AWR reports using OEM 12C from Oracle 11g database and analyzed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth.

•Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries.

3.3 Xcel Energy - Minneapolis, MN 4/2013 – 01/2016 Oracle DBA

•Successfully installed and configured Oracle 11.1.0.7 databases on AIX platforms.

•Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10gGrid Control.

•Refreshing Dev and Test instances with data from Production on a regular basis.

•Created and assigned appropriate roles and privileges to users depending on the user activity.

•Supported Oracle Databases of sizes ranging from 100 GB to 10 TB.

•Designed, installed, administered, capacity planning, upgrade, security, management, performance tuning, backup & recovery, patch management, shell scripting, 24/7 technical support of Oracle 12c/ 11g, 10g databases, on Development, Test, QA and Production environments.

•Responsible for implementation and administration of disaster recovery strategies for 24/7 operations and deployment of high availability systems on Oracle 11g, using Oracle RAC, Data-Guard, Streams, ASM, RMAN.

•Have Extensively used AWR, ADDM and explain plan for periodic performance tuning.

•Have used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 10g/11g environments.

•Implemented proactive monitoring using Tuning Pack, Diagnostics Pack and EXPLAIN PLAN.

•Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

•Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) and Network attached storage (NAS).

•Documented the Standard Processes for peers to follow.

•Have applied upgrade patch, maintenance and interim (opatch) patches on all the databases.

•Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.

•Refreshed/cloned databases using RMAN utility.

•Successful applied RDBMS patches, security patches for improving the security and functionality of the databases.

•Achieved optimized performance for the databases by rebuilding indexes on tables.

•Performed Physical backup (hot and cold) as well as Logical backup (Export/Import).

•Proactively managed the databases; set up alarms for managing any exceptions in day to day management of the databases; pre-empted and prevented issues, disasters from happening.

•Involved in session management and monitored the critical wait events, blocking sessions in the database.

•Export and Import of database objects to copy from one database to another database.

•Investigating suspicious database activity using Auditing.

Operating Systems

Linux Enterprise Server 9, 10. Windows 2012, Sun Solaris, AIX

RDBMS

Oracle 10g, 11g, 12c. Postgres, Sql Server

Languages

PL/SQL, Shell Scripting

Tools

OEM, SQL Developer, SQL Tuning Advisor, Putty, WinSCP, RMAN, MobaXterm

Database Utilities

SQL*Plus, Oracle 12c / 11gR2 / 10g /, RAC, Dataguard, Golden Gate, Transportable Tablespaces, SQL*Loader, DataPump, Export, Import.

4. Education

•Bachelor in Law, University of Yaounde II, Soa, Cameroun 2004

Certifications:

•AWS Solution Architect 2020

•CompTia Security+ 2020

•Oracle Cloud Infrastructure Architecture 1Z0-932 2020

•ICAgile Professional 2019

•Oracle Certified Associate in Oracle Database 12c 2018

•Oracle SQL Fundamentals 2018

Contact this candidate