Seven years of experience in Oracle database administration in development and production environments. Experience in Oracle Server installation, configuration, performance turning, client/server, connectivity, query optimization, applying patches and backup recovery
Configuring user creation, their roles and privileges profiles to control access over database objects.
Performance tuning using Utlstat scripts, Statspack, OEM Grid Control, dynamic performance views to monitor system statistics and wait events, ADDM and AWR, and Tuning of SGA
Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL
One-off Patch) using runInstaller, OPatch utility and OEM 11g/12c, 18c.
Supported application for user creation, schema management, export and import of various schema using expdp and impdp oracle utilities. Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.
Backup, UNIX shell scripts
Capacity planning, Upgrading
Interpersonal and communication
Fluent in French
Management Information Systems
06/2018 to CurrentSenior Database AdministratorCompany Name | City, State
Work site of 150 databases with the larger databases ranging from 1 to 2 TB in size.
Maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g RAC servers for the purpose of disaster recovery procedures.
Installed, configured and maintained Physical Standby using Oracle Data Guard for Disaster recovery process on Oracle, 12c, 11g, 10g.
Planned and applied PSU/CPU patches and upgraded databases 10 , 11g, and 12c.
Analyzed and tuned the Database to identify potential database bottlenecks such as response delay locking contention, wait event using tools like STATSPACK, EXPLAIN PLAN, and TKPROF.
Collaborated, worked together with development and operations staff and resolved problems quickly and efficiently.
Worked frequently with application developers to address and clarify data requirements to resolve technical and functional issues.
Worked closely with Application Developers to design new database schemas and objects.
Implemented database refresh of production data to dev.
And test environment using Datapump.
Extensively worked on complete & incomplete recoveries of the databases: Point in time recovery (PITR) and Tablespace point in time recovery (TSPITR) using RMAN utility.
Installed, configured, deployed, and monitored different databases and application servers using Oracle OEM 11g and 12c Grid Control.
Collaboration with application team for SQL tuning for Dev and Test databases using, SQL Trace, EXPLAIN PLAN and Indexes.
Worked efficiently in Database administration activities such as User management, Space management Monitoring, Creating Database, Managing Oracle Instance and Database security.
Performed frequent refreshing/cloning of production databases to development & testing databases using RMAN and DATAPUMP.
Fixed various database performance issues using Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM), Active Session History (ASH), and also for periodic performance tuning.
Installation of oracle 11g, 12c databases in production, development and test environments depending on project requirements.
Configuration of Listener and Tnsnames.
Doing the regular activities like monitoring the alert logs, redo log status, listener.
Log and checking the space for normal segments, rollback segments and tablespaces.
Building of Development and Test environments from production databases using different database cloning techniques (RMAN Active and Backup-based Duplicate and Data Pump).
Created database link to access the table data from one local database to remote database using distributed database features.
Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and helped designed the backup methodology for the organization.
Performed other Oracle DBA responsibilities like performance tuning, monitoring tablespaces, monitoring users, troubleshooting and problem solving.
Provide production support for the deployed project till it is stabilized.
Refreshing development/test database from production using Export/Import & RMAN backups.
Making structural changes to the databases.
Sizing database objects for effective space management and optimal performance.
Managing database security (creating and assigning appropriate roles and privileges to users on need base).
Defragmentation of tables and indexes for improved performance and effective space management.
Wrote SQL scripts to create database objects like tables, indexes, views and sequences.
Created procedures and functions using PL/SQL.
Performance tuning of database servers using AWR, ASH, ADDM and OEM 11g.
04/2014 to 03/2017Database AdministratorCompany Name | City, State
Run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
Created and managed database objects, such as Tables, tablespaces, Indexes, and Views, database storage structures.
Performed user and security administration activities such as setting up privileges and procedures to users and maintaining system security.
Creation, maintenance, backups and restoration of databases.
Performed general troubleshooting and tuning input/output to reduce the disk contention and enhance the database performance.
Monitored and tuned rollback segment, temporary table space, redo log buffer, sort area size.
Performed Installation and configuration of Oracle 10.2.0.1, 11g database.
Designed PL/SQL function, stored procedure, package to support reports.
Refreshing and manipulating data in tables using PL/ SQL procedures.
Generated reports from the database using PL/SQL, SQL, and OEM.
Installing, upgrading and applying quarterly patches (CPU & PSU) for development and test environments (10g and 11g).
Continuous monitoring of databases using Oracle OEM 11g and taking immediate corrective actions in case of any alerts.
Monitored and tuned undo segments, temporary tablespace, redo log buffer, sort area size.
Monitor and maintain the health of architected databases and database server environments.
User management, tablespaces management, privileges management and space quota management.
Scheduling Cold and Hot RMAN backups on Crontab for development and test environments and monitoring RMAN jobs.
Capacity planning, creation, and maintenance of documentation for DBA SOP's.
Ran Shell and SQL scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space and fragmentation.
Master of Science | International Educational Management School For International Training , City
Bachelor of Science | Management Information SystemsMetro State University , City
Cerificate | Database Management CertificateMetro State University, City
Part of DBA team responsible for implementing and managing Oracle databases (18c, 12c, 11g and 10g) RAC and Data Guard.
Configured and administrated Data Guard (Physical, Active, Logical and Snapshot standby) in different protection modes for oracle 11g and 12c databases as part of disaster recovery strategy.
Performed database upgrades and applied patches using dbua and Opatch utility.
Planned and performed critical database migration using different migration methodologies, such as Datapump, RMAN, Data Guard, and Transportable Tablespaces.
Worked in close collaboration with Application Developers to design/create new Oracle databases, database objects and making database changes on DEV and TEST environments upon request.
Installed, configured and upgraded from 22.214.171.124 to 126.96.36.199 on RHEL 7.1
Upgraded from 188.8.131.52 to 18c using Full Transportable Export/Import.
On a daily basis;
Monitored scheduled jobs to ensure they ran successfully
Resolved service requests as per severity
Worked closely with developers, performing data pump refreshes
Tuned my databases to increase performance using tools, such as AWR, ADDM, ASH, SQL tuning advisor, explain plan.
Developed RMAN scripts for database backup and recovery for both RAC and stand alone instances.
Implemented database backup and recovery using RMAN (scheduled full, incremental, cumulative backups by writing UNIX shell scripts for RMAN).
Create strategies for performing repetitive tasks such as maintaining and scheduling Cold Backups, Hot Backups, Export Dumps, Archive logs backups, and automating cleaning of archive logs.
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
How this resume score could be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
School For International Training
Metro State University
Job Titles Held:
Senior Database Administrator
Master of Science | International Educational Management Bachelor of Science | Management Information Systems Cerificate | Database Management Certificate
Create a job alert for [job role title] at [location].