Database Administrator Resume

OBJECTIVE:

To excel in the field of Information Technology as an Oracle Database Administrator by contributing continuously towards organisational growth by providing seamless database support and to utilise every opportunity to achieve both personal and professional development.

SUMMARY

As an Oracle DBA. Confidential is a leading software and services provider, leading providers of Billing, Customer Relationship Management (CRM).
Currently working on BELL Canada account which is one of the biggest Canadian telecommunications and media company
3 years of experience as Oracle DBA in very large production environments on Red Hat Linux, Sun Solaris, HP - UX and Windows Platforms. Oracle 10g, 11g,Postgres Databases.
Strengths include excellent interpersonal and managerial skills, the ability to interact well at all levels within as organization, superior problem solving skills, as well as proven track record of establishing strong relationships with teams, customer and vendors
Knowledge of RAC, Dataguard, ASM
Worked on postgres Database Administrator.

TECHNICAL SKILLS

Databases: Oracle 10g,11g,12c PostgreSQL

Database Utilities: Netca,DBCA,DBUA,Exp/Imp,Expdp/Impdp,SQL * Loader,Opatch,RMAN

Database Tools: Sqlplus, Toad, SQL developer, Putty, WinScp,PgADMIN,Exp/Imp,Expdp/Imdp,Oracle Enterprise Manage grid control

Operating systems: Windows, Linux.

Programming Languages: Unix shell programong SQL, PL/SQL.

PROFESSIONAL EXPERIENCE

Confidential

Database Administrator

Responsibilities:

Involved in the project to maintenance the database activities.
Supporting more than 100 instances and on-call support 24x7.
Maintenance of production, TEST, Development, UAT databases which includes tablespace space management, user creation, privileges, roles etc.
Maintaining archive, oradata and oracle related mount point issues by reclaiming the space after the alert Pop-up by DBMON.
Creating AWR report as per the request.
Export/Import of oracle tables, schemas and databases as per client requirement using traditional Export/Import and Expdp/Impdp
Upgradation of database from 11.2.0.3 to 11.2.0.4.
Resolving ORA error, listener and database down issues as per the alert pop-up by DBMON.
Performing Quarterly CPU and PSU Patching activity for Prod, Dev, Test and UAT environments.
Creation of new environments based on the requirement.
Looking into action requests (tickets) and resolving issues, providing the root cause, providing the permanent fix
Support has Database administration on Development and Production databases
Monitoring and Reorganizing Database objects Tables & Indexes to minimize fragmentation in the database using logical backup and restoration. (Export and import ) and Datapump
Developing database links for remote database access
Synonym creation with Dblinks.
Configuring new databases and users: set up backups, export, and other monitoring Scripts
Analyze SQL statements using Explain Plan
Perform recovery using RMAN

Confidential

Jr Oracle DBA

Responsibilities:

Installing oracle software on Linux, windows platform.
Installation of the oracle 10g, oracle 11g software.
Scheduling backups in crontab(Linux), Oracle Scheduler and scheduled task(windows)
Managing logical and physical structures i.e. Tablespaces and datafiles growth
Creating Schema’s and Working with Privileges, Profiles and Roles
Proactively Monitoring file system growth, Alert Log and Archive Destination
Performing export and import (exp/imp and Datapump)
Execution of Scripts on Quality and production database
As well as monitor and create additional table space and file space as needed.
Resolution of the listener issues in windows and Linux operating systems.
Add or resize the tablespace, resolve the ORA, archive, memory dump errors and zipping listener log files/trace files by the alert popup from OEM(oracle enterprise manager).
Check and work on the incidents, alerts and change request by priority in queue.

Confidential

Jr. Oracle DBA

Responsibilities:

Installation of oracle database 11g are per request.
Creation and maintenance of the tablespaces, Datafiles, Control file and redo log files.
Granting roles, privileges to the user and profile management.
Creation and administration of all database objects including tables, indexes, views, triggers, procedure, Functions, Sequences, synonyms, packages.
Alert log and trace files observation activity.
Generated the “SQLFILE” for the content of the given dump files from the client.
Disk space management, planning for backups and restorations for the mission critical databases.
Resolution of the listener issues in windows and Linux operating systems.
Expertise in taking both logical and physical backup of the database.
Expertise in “exp/imp” and “expdp/impdp” for the schema refreshment.
Database link creation for the remote databases to access the data for the production people.
Implementation of the temp tablespace group for each schema to increase the performance.
Generating the AWR reports for checking of the performance issues.