Oracle Data
Resume:
DAVID D DIMAS
********@*****.***
Laurel MD 20723
ORACLE DATABASE ADMINISTRATOR
Certified Oracle Database Administrator with over 4 years solid working
experience in ORACLE 9i, 10g and 11g on Unix/Linux and Windows.
SUMMARY:
. A self-motivated, responsible and reliable team player with strong
technical skills in team building and problem-solving with an
established reputation for effectively working with diverse groups of
people and adaptability to changing environments.
. Vast in Performance Tuning, Backup, Restore, Recovery (RMAN), CRON,
managing VLDB, SQLPLUS, Shell scripting, RAC, Data Guard and PL/SQL.
PROFESSIONAL EXPERIENCE:
CHAVERAN INC, BOWIE, MD - Oracle DBA supporting FID Application
(August. 2009 - Present)
Responsibilities:
. Controlling and monitoring user access to databases and maintain
database security using Oracle audit feature and triggers on (UNIX)
Sun Solaris 10 production server
. Creating, monitoring and resizing database files from logical model
using ASSM
. Upgrading from 11gR1 to 11gR2 on Linux (Red Hat 5.5) and Unix (Sun
Solaris)
. Creating users and assigning appropriate profiles and roles as defined
by business rules.
. Tuning databases using Oracle Grid setup as per ADDM findings, SQL
Tuning Advisor etc.
. Creating range, hash, composite partitioning on Medis database
. Refresh job following releases between production and development/test
databases.
. Working with developers on writing fraud investigation code for FID
application.
. Applying Integrity Constraints in the databases as per business rules
requirements
. Setting up and maintain backup and recovery tactics using RMAN, and
support the different backup strategy with RMAN backup scripts, set up
backup shell scripts in Cron Jobs.
. Building Oracle 11g RAC on Linux, Oracle10gr2 Data Guard with Oracle
OEM grid control
. Setting up Oracle 10g Data guard standby databases and use it to
replicate database from primary to standby databases.
. Developing Unix/Linux Shell scripts to automate and monitor database
operation.
. Configuring ASMM for flexible and adaptive memory management scheme
. Creating export/import scripts using Oracle10g data pump.
. Creating pfile from spfile, and creating spfile from pfile.
. Dropping, creating/re-creating online redo log files group and
control files.
. Providing 24 x7 on-call support, participate in off-hours (on-call)
support and maintenance to ensure their performance, availability and
security;
. Provide weekly Backup and Database performance report.
Best Offshore Support Services, Victoria Island - Oracle DBA (May. 2008-
March. 2009)
Supported Mobile and Shell Petroleum Development Company TRS releases 07.1A
& 07.1B
Responsibilities:
. Oracle 9i, 10g installation and database creation on Sun Solaris and
Windows platforms.
. Upgraded databases from version 9i to 10g R1
. Created databases and tablespaces from logical data model
. Created tables, sequences, indexes and views
. Created packages, functions, procedures and triggers.
. Created users, roles, profiles and assigned to users as defined by
application requirements and company policy
. Creating rman catalog database/user on server, and registering target
database to using TNS connection.
. Performed database tuning using DBMS packages to ensure better
performance of databases
. Refreshed development Windows Server 2003 environment with production
data using datapump
. Wrote, tested and implemented TRS 07.1B application code as per
business rules requirement from development, Q.A to production server.
. Exported, imported and synchronized data warehouse databases.
. Perform daily hot incremental and full weekly cold incremental backup
using RMAN
. Partitioned tables in VLDB for improved performance and effective
space management
. Set up Oracle11g RAC on Unix under test/development environment.
. Physically monitored and tested Standby (Data Guard) database for
disaster recovery
. Designed and tested backup /recovery scenarios for databases including
point in time and full recovery from backups, individual table
recovery via datapump and RMAN utility.
United Church of Christ - Oracle DBA
(September 2007 - May 2008)
David provided Oracle database support for District 5 Accounts
Automation Application.
Responsibilities:
. Installed oracle 9i,10g and applied patches on Sun Solaris, Red hat
3.0
. Created oracle database and datafiles conforming to oracle's
optimal flexible architecture (OFA) standard
. Query database using joins.
. Enforced business rules within relational schemas by enabling,
disabling and dropping Integrity Constraints.
. Assisted in design Automated accounting systems using forms 4.5
. Maintained data integrity, managing users, roles profiles,
resources and password security
. Configured Oracle networking components such as the listener and
connection protocols for clients.
. Performed point in time recovery of district 5 windows 2003 server
using backup files.
. Enhanced scripts to verify the integrity of data within the
inventory and accounting DB.
. Grant/revoked privileges on database objects, locked and unlocked
accounts, file and folder permissions as per need.
TOP CREST SERVICES, Victoria Island - Oracle DBA Intern/System
Administrator
(Jan. 2006- September 2007)
Provided support for Customer Databases on Windows Server 2003.
. Installed the oracle software version -Oracle 9i, 10g on windows
servers
. Created and managed databases, tables, views, indexes, sequences.
. Created and managed profiles, roles and users.
. Performed upgrades, installation of software, drivers and
essential desktop troubleshooting
. Performed backup and recovery in line with company strategy
. Refreshed job periodically between production and development/test
databases
. Checked alert log files & trace files daily to make sure production
databases run smoothly 24x7 to provide a high availability service.
. Assisted in troubleshooting user problems relating to operating
system issues (Win9x, NT, and Win2000), Network Connectivity,
TCP/IP configuration, upgrades, MS Office products and Internet
connectivity.
. Deployed updates, service packs and hot fixes using Windows Update,
Automatic Updates, and Group policies.
. Installed logical printers on a print server and preparing print
server to host clients.
. Troubleshooted hardware peripherals like printers modem etc
. User rights and permission, disabling and enabling accounts, file
and folder permissions and configuring security templates.
. Assisted on hardware troubleshooting and local system upgrades.
EDUCATION:
Bachelor of Arts - English
University of Maiduguri
National Diploma - Finance
Ramat Polytechnic, Maiduguri
Professional Certifications:
Oracle 11g Database Administrator Certified Associate, OCA
REFERENCE:
Anthony Koranteng
Manager 301-***-****
Chaveran Inc
Yaw Appiah
Team Lead 240-***-****
Chaveran Inc
Contact this candidate