Anas Lahrim

703-***-****

adxt59@r.postjobfree.com

RELEVANT EXPERIENCE

** ***** ** ************ ** experience in Oracle database administration, database design, conceptual analysis, in Oracle 7/8/8i/9i/10g/11g/12c/18c/19c

Leadership role in Oracle technical design, hosting and administration, development, and support.

Leadership role in leading and overseeing an Oracle DBA team.

Hands on providing technical leadership and direction for the design, installation, customization, implementation, and support of an Oracle client server and web-based environment with over 200 clients and up to 100 servers including experience in configuring and supporting SQL*NET V1 & V2, and Net8.

Expertise in using Oracle Enterprise Manager, OEM 10g Grid Control, OEM 12c Cloud Control and is certified in Oracle 7, Oracle 8, Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g, and Oracle 12c.

CLEARANCE

Top Secret.

TECHNICAL SKILLS

Technologies: Client Server, Web Server, ASM, CRS, Oracle 11g, OEM 12c/OEM 13c Cloud Control, OEM Grid Control, Red Hat Linux, UNIX, Sun Solaris, RMAN, Oracle Enterprise Manager, ADDM, Oracle 11g RAC, TOAD, Grid Control, Windows, SQL, AWS, Azure.

EDUCATION

Bachelor of Science, Computer Science, George Mason University

Master of Science, Information Security and Assurance, George Mason University

TRAINING

Oracle Database12c: New Features for Administrators Ed2

Oracle Database12c: RAC Administration

Oracle Database10g: RAC for Administrators Release 2

PostgreSQL Database Administration

ITIL Training

PMP training

Google Cloud (GCP) Fundamentals

AWS Certified Cloud Practitioner

AWS Solution Architecture

Exadata Training.

Certification

OCP in Oracle 7, Oracle 8, Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g, Oracle 12c

Oracle Cloud Infrastructure Foundations 2021 Certified Associate

CompTIA Security+ CE.

PROFESSIONAL EXPERIENCE

Gov Tact, Inc December 2020- Present

Senior Oracle Database Administrator

Managed Oracle 19c RAC databases on a Super Cluster/ Exadata environment.

Migrated 11g RAC database to 12c RAC on Red Hat Linux

Successfully troubleshot database performance issues.

Successfully applied the Quarterly Oracle Security Patches.

Setup Oracle 12c and Oracle 19c Data Guard on Red Hat Linux.

Successfully troubleshot Oracle 19c Data Guard issues.

Environment: Client Server, Web Server, Oracle 12c, 19c, OEM 13c Cloud, RMAN, Red Hat Linux, ASM, OEM 13c Cloud Control, Putty, Data Guard.

STEAMPUNK, Inc

Senior Oracle Database Administrator October 2019- December 2020

Supported Azure and AWS environments, installed, configured Oracle 12c, 18c, and 19c database on Linux.

Successfully implemented transparent TDE encryption at the tablespace level.

Successfully configured SSL from client to a database server.

Successfully troubleshot database performance issues.

Environment: Client Server, Web Server, Oracle 11g, 12c, 19c, OEM 13c Cloud, RMAN, Red Hat Linux, ASM, OEM 13c Cloud Control, Putty, Azure, AWS, Data Guard.

ManTech International

Senior Oracle Database Administrator/Engineer July 2018- August 2019

Created and scheduled scripts to check the availability of Oracle 11g/12c databases.

Sanitized export scripts using data pump to refresh development environment from production environment.

Maintained and checked RMAN backups daily.

Migrated Oracle 11g R2 database to Oracle 12c AWS Cloud.

Successfully led the migration of Oracle 11g RAC R2 to Oracle 12c RAC R2 in Oracle Linux 7.

Successfully Installed Oracle Linux 7 software and provided Linux System Administration.

Successfully installed, configured, and maintained Oracle 12c RAC R2, Data Guard Broker.

Successfully troubleshot and fixed Oracle 11g RAC R2 and Data Guard issues.

Successfully applied Oracle Quarterly security patch.

Successfully troubleshot database performance issues.

Successfully setup and maintained Oracle12c GoldenGate.

Successfully applied STIGs on 11g and 12c databases.

Environment: Client Server, Web Server, Oracle 11g, OEM 13c Cloud, RMAN, 11gR2, Oracle 12c RAC R2, Windows 2012, AWS, Oracle Linux 7, ASM, Data Guard Broker, OEM 13c Cloud Control, AWR, ADDM, ASH, GoldenGate

Technatomy, Inc

Senior Oracle Database Administration/DBA Team Lead September 2016- June 2018

Support the Veterans’ project.

Oversaw the DBA tasks and led a team of 5 Oracle DBAs, juniors and seniors, to complete their assignments.

Conducted performance reviews for Oracle DBAs.

Led the Oracle Upgrade from Oracle 11g RAC to Oracle 12c RAC.

Re-created Oracle 11g RAC standby databases.

Maintained Oracle 11g RAC R2 production databases including performance tuning and troubleshooting.

Performed database installation, patching and upgrades of Oracle 11g RAC R2 to 12c RAC databases in production, test, and development environments on RHEL servers.

Installed Oracle 12c, Oracle Storage Management in the Microsoft Cloud Azure environment.

Setup and maintained Oracle11g GoldenGate.

Successfully applied database STIGs.

Environment: Client Server, Web Server, Oracle 11g, OEM 12c Cloud Control, Red Hat Linux, Sun Solaris, RMAN, Oracle 11g RAC, 11gR2, ASM, Oracle 12c RAC, Azure Cloud, AWR, ADDM, ASH, Oracle 12c GoldenGate.

Skylon Technology, Inc

Senior Oracle Database Administrator September 2015- August 2016

Setup and configured Oracle Wallet on Oracle 11gR2 on Linux.

Installed and configured Oracle 11gR2 database on Red Hat Linux Server.

Performed Linux System Administration tasks.

Wrote Unix shell scripts and applied PSU patches.

Performed 11g RAC database performance tuning and setup RMAN backups.

Maintained OS disk space using Automatic Storage Management (ASM).

Performed Oracle 11gRel2 Standalone and RAC Install

Environment: Client Server, Web Server, Oracle 11g RAC, ASM, OEM 12c Cloud Control, Red Hat Linux, WebLogic, ADDM, AWR, ASH.

Unified Business Technologies May 2015 – September 2015

Senior Oracle Database Administration

Installed Oracle 11g RAC R2 on Windows

Performed Database tuning using AWR and ADDM reports.

Wrote PL/SQL procedures to implement Database alerts.

Environment: Client Server, Oracle 11g, Oracle Enterprise Manager, HP UNIX, TOAD, SQL Developer, Data Guard, RMAN, 11gR2, Oracle 11g RAC, OEM 12c Cloud Control, ASM, Linux, PL/SQL

Sun Technologies, Inc December 2014- September 2015

Senior Oracle Database Administrator

Successfully installed, configured, and maintained Oracle Enterprise Manager 12c Cloud Control.

Successfully created, managed, and tuned Oracle 12c databases.

Setup Data Guard physical standby databases using RMAN on Oracle11g R2.

Duplicated databases and performed backup recovery strategies using RMAN.

Performed database creation, setup, administration, management, performance tuning, and backup.

Performed schema refresh using export/import data pump.

Performed database performance tuning using ADDM, AWR.

Installed, configured, and maintained 11g R2 RAC, ASM on Windows 2008.

Applied Oracle Quarterly security patches on the Oracle grid and the databases.

Performed index rebuild, tables re-org to improve performance.

Performed schemas’ comparison using SQL Developer and created scripts to resolve data issues among schemas

Successfully installed Oracle Management Agents on remote servers to communicate with OEM 12c.

Implemented email notifications using PL/SQL procedures.

Environment: Client Server, Oracle 11g, Oracle Enterprise Manager, HP UNIX, TOAD, SQL Developer, Data Guard, RMAN, 11gR2, Oracle 11g RAC, OEM 12c Cloud Control, ASM, Linux, PL/SQL, ADDM, AWR, ASH.

ALTA IT Services, Inc. May 2014- September 2014

Senior Oracle Database Administrator

Provides Oracle Database Administration for DTIC.

Responsible for troubleshooting 11g RAC errors as well as Oracle database 11g issues.

Uses Oracle Enterprise Manager 12c Cloud Control to manage databases, troubleshoot and correct performance issues.

Rectified communication issues between Oracle Management Server and Agents.

Added database services to be managed by OEM 12c Cloud Control.

Tunes Oracle 11g databases using ADDM tool, AWR.

Responsibilities include highly technical expertise and guidance in the design, implementation, operation, maintenance, and tuning of 60 databases to improve performance.

Applied the Oracle Quarterly Security patches.

Applied Database STIGs.

Provided technical leadership to appropriate personnel on highly complex system administration activities.

Developed and analyzes highly complex system standards, thresholds, and recommendations to maximize system performance.

Performed dbackup and recovery using RMAN.

Performed import/export to refresh schemas in the production databases.

Provides technical solutions and escalated support for non-routine, highly complex technical issues.

Modeled databases based on a logical data structure created in support of data architect.

Environment: Client Server, Web Server, Oracle 11g, OEM 12c Cloud Control, Red Hat Linux, Sun Solaris, RMAN, Oracle 11g RAC, 11gR2, ASM, ADDM, AWR.

EDC Consulting, Inc

Senior Oracle Database Administrator August 2012- May 2014

Provided Oracle Database Administration for Department of Army.

Installed and configured Oracle Enterprise Manager 12c Cloud Control and plug-ins.

Configured, installed, deployed, and maintained OEM 12c Agents.

Installed and configured Oracle Audit Vault tuned 11g database instances, SQL queries, installed Oracle 11g database on Red Hat Linux Server, performed database backups using RMAN. Fixed database backup issues using RMAN

Upgraded several databases from 10g to 11g in Linux, Sun Solaris.

Responsible for troubleshooting 11g RAC errors as well as Oracle database 11g issues.

Responsibilities include highly technical expertise and guidance in the design, implementation, operation, maintenance, and tuning of 60 databases to improve performance.

Used Oracle Enterprise Manager to manage databases, troubleshoot and correct performance issues.

Tuned databases using ADDM tool, AWR, and Statspack.

Applied STIGs to Oracle 11g databases and Exadata servers.

Maintained Oracle 11g RAC in Exadata environment.

Environment: Client Server, Web Server, Oracle 11g, OEM 12c Cloud Control, Red Hat Linux, Sun Solaris, RMAN, Oracle 11g RAC, 11gR2, Peoplesoft, ASM, Exadata.

ITG, Inc

Senior Oracle Database Administrator September 2011 to July 2012

Provided Oracle Database Support for GSA.

Performed Oracle database backup, fixed database backup issues using RMAN, re-built 11g test databases, and troubleshot 11g RAC errors.

Tuned databases using ADDM tool, AWR, hints, and Statspack.

Performed flashback recovery.

Worked with Weblogic.

Environment: Client Server, Web Server, ASM, Oracle 11g, Oracle 10g, Oracle 10g Grid Control, Linux, Windows 2008, RMAN, Oracle 10g RAC, Oracle 11g RAC, 11gR2, Flashback, Weblogic

CACI, Inc

Senior Oracle Database Administrator/DBA Lead November 2009 to August 2011

Has provided Oracle Database Administration for Federal Emergency Agency.

Setup a Dataguard physical standby, exported and imported data between databases, performed backups and recovery using RMAN, tuned database instances, SQL queries, and installed Oracle 11g database on Red Hat Linux Server, migrated 10g to 11g database.

Responsible for maintaining Oracle 9i, 10g, and 11g databases and managing a Data Guard physical standby database.

Exported and Imported data between databases, performed backups and recovery, tuned databases, and SQL queries for increased performance.

Setup Dataguard and performed switchover of primary and standby databases.

Syncing primary and standby database whenever they are not in sync.

Created and setup Oracle 11g database. Installed Oracle 11g database on Red Hat Linux server.

Migrated Oracle Database 10g to Oracle Database 11g.

Performed tuning using Oracle Statspack, Backup and recovery processes, Space management, and user management. Backed up databases using Recovery Manager, RMAN.

Run MySQL scripts to populate tables with data.

Environment: Client Server, ASM, Web Server, Oracle9i, Oracle 10g, Oracle 11g, Oracle Enterprise Manager, HP UNIX, Red Hat Linux 64 bit, Linux Red Hat server, SQL Developer, Data Guard, RMAN, 11gR2, MySQL.

SAIC, Inc

Senior Oracle Database Administrator February 2008-October 2009

Has provided Oracle 10g RAC support for State Department. Setup streams on Windows environment, rectified streams as well as Oracle replication issues.

Performed export and import of databases to refresh dev and test environments.

Responsible for keeping approximately one hundred 9i and 10g RAC databases running on Windows 2003 on 24x7 in support of State Department issuance Visa and Passport.

Performed installation and setup of Oracle on new servers, applying patches and upgrades on new servers.

Exported and Imported data between databases, performed backups and recovery, tuned databases using ADDM, AWR, and Statspack to improve performance.

Rectified Streams and replication issues on 10g RAC environment. Installed Oracle 10g RAC.

Environment: Client Server, Web Server, Windows 2003, Oracle9i, Oracle 10g RAC, Oracle Enterprise Manager, TOAD, Grid Control

Association of American Medical Colleges

Senior Oracle Database Administrator January 2007 to January 2008

Has provided Oracle database support for Association of American Medical Colleges. He performed performance tuning of Oracle 9i and Oracle 10g databases on UNIX environments.

Migrated several databases from Oracle 9i to Oracle 10g database.

Worked with application teams to design and build databases, database objects, and optimized SQL.

Installed, configured and managed Oracle databases 9i and 10G.

Conducted routine database tasks including the following: Backup and Recovery, Data imports/exports, SQL Optimization, Database Tuning using ADDM, AWR, Statspack, Database Patching, and ticket solving.

Proactively prevented production incidents through daily monitoring and review/verification of the database environment and scheduled database jobs. Performed 24x7 support for production systems.

Recommended, implemented procedures to ensure integrity, security, and privacy of the corporate database.

Managed database security through user administration and granted correct roles and privileges.

Created, maintained, and enforced corporate database standards, procedures, and documentation.

Migrated several Oracle9i databases to Oracle database 10g.

Environment: Client Server, Web Server, UNIX, Sun Solaris, Windows 2000, Oracle9i, Oracle 10g, Oracle Enterprise Manager, TOAD, Statspack, OEM 10g Control Grid, ADDM

Lockheed Martin Corporation

Database Architect February 2006 to January 2007

Has provided Oracle database administration support for EPA.

Created Materialized views in a Data Warehouse to enhance the performance of the production database.

Responsible for maintaining, creating Materialized views in a Data Warehouse environment and troubleshooting any performance issues using Statspack and Oracle Enterprise Manager Tools.

Refreshed the data warehouse using Perl and shell scripts, tuned SQL statements on IBM-AIX and HP-TRUE platforms, maintained space in Database and UNIX, and troubleshooted any database errors.

Migrated several databases across platforms in UNIX as well as changing the database character set.

Migrated a legacy database using Oracle Database 10g.

Created tables, columns in support of Data Warehouse.

Handled data load in the production database.

Environment: Client Server, Web Server, IBM-AIX, HP-TRUE UNIX, Windows 2000, Oracle9i, Oracle Enterprise Manager, TOAD, Perl, Statspack, OEM Grid

VSTI Inc

Senior Database Administration/Contractor June 2004 to February 2006

Has provided Oracle database support for DISA. He maintained, configured, and tuned Oracle 10g databases.

Backed up Oracle 9i databases using RMAN scripts and upgraded databases 10g release 1 to 10g release 2.

Maintained, configured, and tuned Oracle 10g databases, resolving database integrity issues, resolving connectivity issues, and applying Oracle security patches on Sun Solaris and Windows 2003 platform.

Backed up databases using RMAN scripts and upgraded databases from 10g release 1 to 10g release 2.

Converted ASM file system to regular RAID 5 file system. Maintained and provided database tuning for Oracle7/8i/9i/10g databases.

The range of database support also included installation of Oracle9i in Sun Solaris platform, Windows 2003, supporting a Data Warehouse, resolving database integrity, applying Oracle security patches, migrating databases from Oracle 7 to Oracle 9i, upgrading databases within 9i releases, writing Unix shell scripts, writing PL/SQL procedures, optimizing SQL statements, and backing up Oracle9i databases using RMAN scripts.

Helped configure and provide support to the centralized government database that supported 2000+ clients.

Environment: Client Server, Web Server, Sun Solaris, Windows 2000, Windows 2003, Oracle7, Oracle8i, Oracle9i, Oracle 10g, Oracle Enterprise Manager, Toad, SQLAB, RMAN

Provided performance tuning of Oracle9i databases.

Tuning entailed tuning database parameters using Statspack tool, tuning SQL statements, gathering statistics, rebuilding indexes, and rectifying row migration.

Monitored database locks to avoid deadlock situations.

Keane Federal Systems

Senior Database Administrator/Apps DBA October 2003 to June 2004

Has provided Oracle Apps database support for Pension Benefit Guaranty Corporation.

Provided 11i application database Administration for Pension Benefit Guaranty Corporation.

Provided installation and cloning of 11i application, CRM, Oracle 8.1.7.4 databases, troubleshoot CRM application, JTF, and Apache server errors.

Applied patches to the 11i application and Created database links to facilitate communication among databases. Used Toad and SQLAB tools to tune SQL statements.

Keane Federal Systems

Senior Database Administrator/DBA Team Lead November 2000 to October 2003

Has provided a variety of Oracle database support for Department of Justice.

Oversaw the DBA tasks and led a team of 5 Junior Oracle DBAs to complete their assignments.

He performed Oracle database migration from Oracle 7 SCO Unix to Windows NT.

Performed database tuning, troubleshooting database errors and provided on-going database support for more than 200 clients.

Involved in migrating several Oracle v7 databases in a SCO Unix platform to Oracle8i in a Windows NT platform.

Supported a Data Warehouse and performed monitoring and tuning many mission-critical EOUSA databases built in NT and Unix platforms in order to optimize database processes and performance. Tuning involved improve the database performance by configuring and adjusting database parameters, create primary/ foreign keys, analyze schemas, partition tables, resize an application indexes

Provided database administration support and technical guidance related to the design, implementation, operation and maintenance and enhancement of the Oracle8i RDBMS to the System Managers (SMs) at all 94 United States Attorney’s Offices (USA) districts nationwide (consisting of over 200 locations including branch offices) consisting of browser based and client server applications with multiple servers and well over 200 clients and 200 servers.

Environment: Client Server, Web Server, SCO UNIX, Sun Solaris, Windows NT, Windows 2000, Oracle8i, Oracle9i, Oracle Enterprise Manager

KPMG Consulting

Senior Consultant/Database Administrator June 1999 to October 2000

Has provided a technical lead database support for Sprint, Telecom Company. He also provided a variety of database support including migrating of MS Access databases to Oracle 8i using Oracle Migration Workbench utility. Designed and implemented security code and features at the database level.

Migrated several MS Access databases to Oracle8i using Oracle Migration Workbench utility.

Provided technical training for the application to applicable clients at various levels, from end users to hardware/software administrators.

Configured the Oracle databases parameters and resolved configuration and database server integration problems. Created and tuned several Oracle8i databases.

Provided technical training for hardware and software systems directly related to the database.

Installed the Oracle 8.0.5 RDBMS binaries and created databases on both NT and Sun Solaris servers.

Developed several PL/SQL procedures and database triggers that automatically generated email notifications to all MS Project plan owners.

Senior Consultant/Database Administrator

Oracle Corporation November 1998 to April 1999

Has provided Oracle database support for Federal Emergency Monitoring Agency. Performed SQL and database performance tuning. Provided DBA operational support and developed Tuning Subsystems for Federal Emergency Monitoring Agency (FEMA).

Tuned SQL queries to minimize response time (i.e. CPU time usage, and number of blocks used by the optimizer to retrieve rows from memory).

Used Performance Tuning Pack to capture the n top sessions that degraded performance. Changed the optimizer mode to choose the optimum path for queries.

ORKAND

Database Administrator July 1997 to November 1998

Provided 24 x 7 Oracle database support for State Department. He setup replication of databases, performed performance tuning, maintained tablespaces and indexes at optimum level.

Prepared and maintained work plans, schedules, and technical approach for replication of databases for the State Department. Provided 24x7 configuration and database server integration support to US Embassies and Consulates worldwide (approximately 100 servers and 200+ users).

CACI, Inc.

Database Administrator November 1996 to June 1997

Provided Oracle Database Administration for Department of Education.

Computer Sciences Corporation

Developer/Database Administrator May 1995 to November 1996

Responsibilities involved working with the online operations staff to analyze potential problems with the software, recommend and implement the solutions within the software.

Functions performed included updating forms, performing data manipulation functions, data definition language, creating database instances, developing and updating scripts for referential integrity constraints, and other integrity constraints.

Contact this candidate