SUMMARY

• I am a Certified Oracle database administrator with over 6 years of extensive experience providing critical Oracle database solutions to private clients and federal contractors.
• My experiences include, database installation 11gR2, and 12c on windows, Linux platforms, AWS EC2 and RDS instance configuration, administration, oracles quarterly patch upgrades, migration, Data guard replications (Physical, Active, Logical, Snapshot) standby databases, database performance tuning, schema management, database security, implementations of database backup and recovery strategies, and performing periodical backup restorations tests. I can create partitions, mount files systems, file management, file permissions, manage ownership of files and directory groups.
• Create users, and group accounts, RPM package management, boot processes, scheduling jobs, is to name a few some of my Linux system administration skills attained through school.
• I have great communication skills with management, development teams, vendors, systems administrators, and other related service providers.

TECHNICAL SKILLS

Operating Systems: UNIX, Oracle Enterprise Linux 7, Fedora, CentOS, Ubuntu, many flavors of Linux. Windows

Tuning Tools: AWR, STATSPACK, ASM, ASH

Oracle Tools: Data Guard (Physical, Active, Logical, Snap Shot standby databases, RMAN, Import / Export, Data Pump (Expdpd, Impdp), Access manager, TOAD, Fusion Middleware (Discoverer, Business intelligence), SQL Developer, ERWIN, SSH

Languages: SQL Plus, Shell Scripting

Database: Oracle 11gR2/12cR1, 2, Windows SQL Server 2008

PROFESSIONAL EXPERIENCE

Confidential, Washington, DC

Oracle Database Admin

Responsibilities:

• Create Oracle databases 12c
• Create CDBs and PDBs
• Install and Configure Linux servers
• Installed oracle grid
• Monitor databases
• Created standby database
• Migrate from 11g to 12c pluggable database
• Migrate from on perm to Elastic cloud computing
• Utilize expdp/impdp data pump to migrate full database, schemas, tablespaces, trans. Tablespace, etc.
• Create tablespaces, users, indexes, views, tables, and much more
• User creation and management
• Backups for recovery
• Performance tuning (awr, ash, sql tuning, explain plan, OEM)
• Quarterly patches
• Created files, directories, user groups, grant permissions
• Backup up Linux servers

Confidential, Washington, DC

Oracle Database administrator

Responsibilities:

• Provide all activities related to the administration of computerized oracle databases
• Designs, creates, and maintain oracle databases in a client/server environment
• Create Oracle 12c CDBs and PDBs as well as objects and schemas in their respective environment
• Max protection, availability, performance with Oracle Data Guard
• Installation of Oracle Grid
• ASM configuration
• Partition ASM disk group
• Creating a Physical, Active, Logical, and Snap shot standby databases from primary
• Configure switchovers from primary or standby for database availability in case of database failure
• Management of oracles quarterly Patches
• Migrating full database, schemas, transportable tablespaces, tablespaces, tables, etc.
• Migration in AWS using ADMS
• Managed RDBMS on AWS EC2 instances
• Backup CDBs and PDBs
• Performs database programming and supports systems design
• Prepare detailed reports which sometimes includes system requirements, concurrent usage factors, data storage requirements, response rates, and discuss procedures for processing data using database management systems (DBMS)
• Maintenance of database dictionaries, overall monitoring of standards and procedures, file design and storage, and integration of systems
• Monitor and manage oracle performance using Oracle Grid
• Evaluate data base design, impacts on user expectations, performance levels, and space allocation requirements
• Used oracle data guard for oracle database replication, database availability, and for migration propose
• Implement backups and scheduled backup per company’s policy’s
• Linux script

Confidential, MD

Database Administrator

Responsibilities:

• Install and maintain Oracle database 11g, 12c on Linux and Windows’ platforms
• Install and maintain Oracle database 11g, 12c Client
• Create Container databases along with pluggable databases in 12c
• Created database in the development, test, and production servers on Linux
• Used Oracle Fusion middleware Discoverer
• Updated Oracle database by testing and implementing patches
• Database Migration from 11gR2 to 12cR1
• Database Cloning for Test, Development, QA, and Production.
• Monitor and perform ongoing tuning of database instances using OEM, AWR, and scripts
• Create database, tablespaces, tables, indexes and other database objects
• Rebuilding indexes and other Database objects
• Maintain database security by creating, modifying, and managing users’ accounts; grant privilege and restrict access to database objects
• Worked with Sys. Admins, Network Admins and Q/A’s to establish a productive and friendly work environment.
• Experience in maintain database security regulations and procedures.
• Configure and maintain RMAN backup.
• Creating and configure RMAN catalog database
• Implement and Design backup and recovery strategies (Hot or Cold).
• Perform periodical backup for the database restoration
• Monitoring the log files, backups, database space usage and the use of system resources.
• Utilized RMAN carry out daily and scheduled database hot backup.
• Experience in user managed backup, and creation of standby database from primary
• Plan and implement cold and hot backup for restoration propose
• Checking Alert log Files, Trace Files, and System Event Logs by using Adrci prompt to view database errors and alerts
• Experience in space management for scalability, capacity planning for database updates/migration.
• Verify all scheduled jobs have run successfully without any issues.
• Use DataPump (expdp/impdp) to migrate data, database objects.
• Troubleshoot and resolve database and application problems encountered by end users.
• Patch management by monitoring current system patch level and identify to installing new patches (OPatch)
• Provided 24*7 on - call production database support and maintenance.

Confidential, Arlington, VA

Database Administrator

Responsibilities:

• Installed and configured Oracle database 11g on Linux and Window platform.
• Upgrade database using patch set.
• Performed database maintenance by applying required patches and software updates.
• Creates and manage users, objects and grant privileges to users.
• Create tables, tablespaces, Indexes-Bitmap/join indexes.
• Partitioned tables, index for increased query performance.
• Monitoring the log files, backups, database space usage and the use of system resources.
• Monitor Cold, Hot, incremental backup failures, fix issues, and ensure backups are successfully completed.
• Monitored rollback segment usage.
• Monitored space and report generation.
• Provide tuning recommendations to development team.
• Provide and assist in the operations and management of company database.
• Performance checks on different SGA components.
• Monitored database usage and report database performance and system availability.
• Assisted Developers team and contributed in the design of database.
• Utilized RMAN and recovery catalog to carry out daily and weekly database hot backups.
• Confirmed that backups have been made and saved successfully in the defined location.
• Checked Alert logs Files, Trace Files, and System Event Logs for unusual events.
• Used RMAN to backup and recovering databases.
• Verify all scheduled jobs have run successfully without any issues.
• Maintained and monitored security by managing privileges and roles for users of the database.
• Performed periodic password change for database security.
• Developed shell scripts and SQL scripts to perform routine checks and various tasks on the database.
• Provided 24*7 on-call production database support and maintenance.

Confidential

Database Administrator

Responsibilities:

• Installation of both Oracle 11g release 2 in Windows platforms.
• Created and maintain all databases required for development, testing, and production usage.
• Create tables, tablespaces, and indexes.
• Administered all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
• Install new versions of the Oracle RDBMS and its tools that access the Oracle database.
• Initialized migrations of programs, and database changes.
• Enrolling users and maintaining system security.
• Monitored Log files for and discrepancies.
• Used RMAN backups to perform daily backups.
• Controlling and monitoring user access to the database.
• Planning for backup and recovery of database information.
• Backing up and restoring the database.