| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Arlington, TX Street Address PHONE NUMBER AVAILABLE EMAIL AVAILABLESummaryI am a self motivated, deeply-driven, professional Certified Oracle Database Administrator with over 8 years of experience, with a profound knowledge in database security and user management, backup and recovery, database design, performance monitoring and tuning, migration, upgrades, Patches, cloning, replication, advanced configuration of RAC and Data Guard, OEM. Proficient in an assortment of technologies including Oracle 10g, 11g, 12c, 19c, MySQL, PL/SQL. Exceeds ongoing and overlapping deadlines in fast-paced environments. SkillsBackup and Recovery (RMAN)Data Pump and Export/ImportTransparent Database EncryptionDatabase SecurityDatabase Upgrade and MigrationOracle Performance TuningPatch Set ManagementOracle RACOracle Data GuardOracle Golden GateTOADSQL DeveloperSQL LoaderOracle Enterprise Manager (OEM)Oracle VM Virtual BoxLinux operating systemDatabase AnalysisExperienceSENIOR ORACLE DATABASE ADMINISTRATOR 08/2017 - Current Lonestar Trucking Academy - Mansfield, TXProviding administrative support and maintenance on Oracle 10g, 11g and 12c installations, database creation, database security, database optimization and tuning. Experience with providing and maintaining high availability and disaster recovery using ORACLE DATA GUARD. Monitoring and troubleshooting database performance using OEM, AWR, ADDM, ASH, Explain Plan, and TOAD. Performing other Security related tasks including Transparent Data Encryption (TDE). Implementing Security policy enhancement through roles, profiles, privileges and password policies as per business requirements.Cloning schemas, objects and databases on new server using exports from 10g database and imported in 11g using data pump.Performing backup and recovery procedures using RMAN and Data Pump utility for Oracle databases. Upgrading databases from 10g to 11g and 11g to 12c. Appling PSU and bug fix patch. Implementing, tuning and maintaining Oracle database using OEM. Developing Standard Operating Procedures (SOPs) for data extraction, outage reports with supporting resolutions, preventative maintenance documentation and weekly activity report. Participating in 24/7 on-call DBA rotation schedule. Managing Database Structure, Storage Allocation, Table partitioning, Table/Index segments, and Rollback segments, Constraints, Database Access, Roles and Privileges Oracle Database performance-tuning services with EXPLAIN PLAN, AWR reports, ADDM Extensive use of Oracle Enterprise Manager (OEM) Grid control for Performance, Administration and Maintenance of DatabasesDay to day maintenance included patching, cloning, and administration of concurrent manage process, Users, Forms, Reports and performance issues.24x7 remote support and on call rotationORACLE DATABASE ADMINISTRATOR 08/2014 - 05/2017Nima Transport Group. - Grand Prairie, TXCreating DBs and assigning appropriate roles and privileges to users depending on user activity. Installation of oracle 11g databases in production, development and test environments depending on project requirements.Oracle HA Stack: Install, Configure, Setup, Maintain and Support Oracle 11gR1, 11gR2, 12c RAC, Physical and Logical Standby database for Test, Development and Production for various home-developed applications. Configured and Managing Oracle 11g R2 Data Guard (Active Physical Standby on 2 nodes RAC ) Design and Maintaining Physical standby maintenance (Switch over using Data Guard Broker). Applying upgrade patch, maintenance and interim (Opatch) patches on all databases. Refreshing Dev and Test instances with data from Production on regular basis. Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS_JOBS, DBMS_SCHEDULER, Crontab. Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment. Tuning test and production database by altering parameters. Export and Import of database objects to copy from one database to another database. Investigating suspicious database activity using Fine-Grain Auditing. Write database documentation, including data standards, procedures, and definitions. Reconciled functional and technical problems through research and training workshops, achieving 65% increase in satisfaction rate of database end users and supervised coaching of junior DBAs. Developing Standard Operating Procedures (SOPs) for data extraction, outage reports with supporting resolutions, preventative maintenance documentation and weekly activity report. Applied Oracle's quarterly Critical Patch Update (CPU/ PSU application) using Opatch utility to install, test, and deploy patches to all database instancesUsed ASM for creating diskgroups, adding additional storage (DISKS) and troubleshooting ASM issues. Setup unidirectional replication on oracle 11g databases using Golden gate. Monitoring and troubleshooting gaps between source and target databases configured with Golden gate. Successfully upgraded databases from 11g to non CDB 12c. Successfully migrated 12c Non CDB databases to pluggable databases. Created Oracle Wallets and implemented Tablespace level TDE security. Responsible for Maintenance and Support of multi-terabyte databases in production, testing and development environments.Successfully installed Oracle Real Application Cluster (RAC) including; Grid infrastructure (Clusterware and ASM) and Oracle rdbms software on a 3 nodes RAC architecture in development and UAT running oracle. Plan for contingency, disaster management that includes standby databases, data guard and cloning/refresh of databasesPlanned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed backup methodology for the organization. Provided 24 X 7 Production & Development database support and administration Education and TrainingLos Angeles Trade Technical College - Los Angeles, CA Electrical And Power Transmission Installation, 08/2012 El Camino College - Compton CCNA, A+Computer Networking, 01/2006Brontech Academy - Greenbelt, MDOCP Certification.LanguagesEnglish:Full ProfessionalFrench:Native/ Bilingual |
