LiveCareer-Resume

senior database administrator resume example with 6+ years of experience

JC J S S JS J S S JS J S S JS J S S JS J S S JS J S S JS
Jessica Claire
Montgomery Street, San Francisco, CA 94105 (555) 432-1000, resumesample@example.com
Professional Summary
  • 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.
Skills
  • Backup, UNIX shell scripts
  • C, Upgrades
  • Capacity planning, Upgrading
  • Clarify, Utilities
  • Interpersonal and communication
  • CPU
  • Database administration
  • Database Management
  • Database
  • Databases
  • Disaster recovery
  • Documentation
  • Features
  • Fluent in French
  • Functional
  • Linux
  • Managing
  • Access
  • Migration
  • Management Information Systems
  • Operating system
  • Oracle
  • DBA
  • Oracle DBA
  • Developer
  • PL/SQL
  • PL/ SQL
  • Problem solving
  • Scheduling
  • Servers
  • Shell scripting
  • Scripts
  • Shell
  • Solaris
  • SOP
  • SQL
  • Strategy
  • Tables
  • TOAD
  • Troubleshooting
Work History
06/2018 to Current Senior Database Administrator Honeywell | Baltimore, MD,
  • Environment: Oracle 10.2.0.4 , 11.2.0.4, 12.1.0.2, Data Guard, RAC, RMAN, OEM, Datapump, DBCA, Netca, AWR, ADDM, ASH, TOAD 11.0 10g Linux, Solaris, SQL Developer, PL/SQL Responsibilities:.
  • 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.
  • Achieved optimal performance tuning using explain plan, STATSPACK, SQL TRACE, TKPROF utilities.
  • Created database objects Tablespaces, Application Users, Database schemas, profiles, granting privileges and roles, and database links.
  • Diagnosing/Troubleshooting database issues on-day-to-day basis.
05/2017 to 05/2018 Database Administrator Square Trade | Hartford, CT,
  • Environment: Oracle 11g/10g Linux, Solaris, SQL Developer, PL/SQL, Shell scripting (Bourne), OEM, Statspack, RMAN, EOM, NETCA, AWR, ADDM, Data Pump.
  • Responsibilities:.
  • 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/2017 Database Administrator Square Trade | Las Vegas, NV,
  • 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.
Education
Expected in to to Master of Science | International Educational Management School For International Training , VT , GPA:
Expected in to to Bachelor of Science | Management Information Systems Metro State University , Colorado, GPA:
Expected in to to Cerificate | Database Management Certificate Metro State University, Colorado, GPA:
Additional Information
  • Part of DBA team responsible for implementing and managing Oracle databases (18c, 12c, 11g and 10g) RAC and Data Guard. Projects 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 11.2.0.4 to 12.2.0.1 on RHEL 7.1 Upgraded from 11.2.0.4 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.

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

Resume Overview

School Attended

  • School For International Training
  • Metro State University
  • Metro State University

Job Titles Held:

  • Senior Database Administrator
  • Database Administrator
  • Database Administrator

Degrees

  • Master of Science
  • Bachelor of Science
  • Cerificate

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: