Senior Oracle Database Administrator - Information Technology Resume S
Senior Oracle Database Administrator - Information Technology Resume S
My Spider Scam Awareness Contacting Us F. A. Q.
 
Job Seekers
Search Jobs
Browse Jobs
Post a Resume
Job Alerts
 
Employers
Search Resumes
Browse Resumes
Post a Job

Senior Oracle Database Administrator Resume


Desired Industry: Information Technology SpiderID: 68510
Desired Job Location: Troy, Michigan Date Posted: 5/6/2013
Type of Position: Full-Time Permanent Availability Date: 2 weeks
Desired Wage:
U.S. Work Authorization: Yes
Job Level: Management (Manager, Director) Willing to Travel:
Highest Degree Attained: Masters Willing to Relocate: Yes


Objective:
10 years of experience as
Database Administrator.
Extensive knowledge and
experience of Oracle and SQL Server
Tools and Utilities and third-party
utilities.
Installed and migrated Oracle
and SQL Server database servers and
migrated data.
Loaded bulk flat files data.
Create databases with proper
storage requirements for tablespaces and
database objects.
Proactively monitored databases
using performance and diagnostic
utilities, dynamic performance views and
OEM.
Implemented OFA model for proper
I/O load Distribution.
Configured and maintained Hot
Standby environment for high
availability and disaster recovery.
Cloned databases for developers
testing. Participated in fail-over and
DRP testing.
Evaluated and Implemented Backup
and Recovery strategies with and without
using RMAN.
Designed, developed and
maintained database applications.
Experience of SDLC (Requirement
Analysis, Design, Implementation,
Testing, Maintenance, Documentation).
ORACLE Certified Database
Administrator (OCP 11g) and Oracle
Certified Expert (Oracle 10g RAC).
A highly motivated professional
and a team player.


Experience:
EXPERIENCE
07/08 03/13 Cyber Internet
Services
Senior Oracle
Database Administrator

Installation of Oracle 11.2.0.1
server software on Sun Server with
operating system Sun Solaris 5.10.
Migration of existing databases
from Oracle 10.2.0.4 to 10.2.0.2.
Installation, upgraded, and
patching of MS SQL Server suite of
products (2005 and 2008).
Managed all primary on-call DBA
activities such as checking on table
space problems, checking for
fragmentation, checking on
nightly/weekly backup problems,
responding to any Oracle errors, and
deadlock conditions.
Strategized and provided
direction and roadmap with respect to
environment setup
Troubleshoot any environment
related issues
Developed the scripts for
creating the Users and allocation of
rolls to the users and maintaining
system security.
Worked with other team members
to understand baseline requirements and
their technical implications.
Implemented the database in the
various environments used by the team
(e.g. development, test, pre-production,
and production).
Created and maintained
documentation of all environments (e.g.
development, test and production),
including installation guides as
required by the client.
Fine-tuned and adjusted all
components of the database (e.g. tables,
indexes, views, roles, privileges,
security features, performance-enhancing
features) based on ongoing development
and testing activities.
Developed, maintained, and
enforced policies to safeguard the
overall design, security, and integrity
of the database in all environments.
Developed the scripts for Hot
backup and Data pump.
Designed and implemented High
Availability (HA) solutions using Real
Application Clusters (RAC) using
Automatic Storage Manager (ASM).
Cloned database data from
production into Staging and PTE
environments on demand from Project
teams.
Worked closely with Oracle tech
support by creating problem tickets to
Oracle internal issues detected in
production databases. Download, test and
apply patches suggested by Oracle to
resolve those issues.
Gathered production database
growth numbers and prepared DB growth
projections by working in close
partnership with Development and
Architecture teams.
Set up, configured and
maintained the data replication tools
such as Oracle streams
Delivered assigned tasks on time
and on budget.
Designed and implemented
database backup/restore infrastructure
using Oracle RMAN
Installed, configured and
administered Data Guard Environment.
Provided production support
(24x7).
Checked Alert log file and Trace
files regularly.
Worked on invisible indexes and
virtual columns.
Configured, created, and
troubleshoot all SQL Server components
such as SQL Server properties, database
properties, table/column properties, SQL
Server agent jobs, DTS packages,
database maintenance plans, error logs,
alerts, and security.
Designed, implemented, and
executed database backup/restore
strategy based on service level
requirements.
Acted as gatekeeper on
production systems Reviewed and
optimized all database changes prior to
production setup for errors and optimal
performance.
Database objects migration,
Transferred and synchronized data
records, triggers, SPs, tables,
databases, SQL Server agent jobs, DTS
packages, etc. amongst different SQL
Servers promptly and with minimum
supervision.
Performance tuning Identify
performance bottlenecks (i.e. poor
written queries, hardware issues, etc.)
and recommend corrective course of
action.
Extensive use of SQL Server
tools such as Query Analyzer, Profiler,
and DTS Designer.
Windows Operating System
Diagnose and troubleshoot OS components
that may impact SQL Server availability,
such as memory, CPU, disk space,
security, etc.
Proficient in using OS tools
such as Perf Mon, Computer Management,
Event Viewer.
Created and maintained standby
databases (mirroring) and/or log-
shipping. Participated in planning and
execution of recovery activities.


Education:
Masters of Information
Technology- Preston University, Pakistan
1998.
Professional course in Oracle
10g Real Application Cluster (RAC)
Administration from Oracle University
Professional course in Oracle
10g Database Vault Administration from
Oracle University
Professional course in Oracle
11g new features from Oracle Corporation
Business Impact Analysis
Certificate
Risk Assessment Certificate
BCP 101 Certificate


Skills:
RDBMS: Oracle
11g/10g/9i/8.x/7.x, MS SQL Server
2008/2005/2000
DBA Tools: Oracle Enterprise
Manager, DBA Studio, LogMiner,
SQL*Loader, Datapump, RMAN, EXP/IMP,
STATSPACK, TKPROF, dbverify, DBArtisan,
Toad, Database control, SQL Navigator,
Database Vault, ADDM, Automatic Workload
Repository, Oracle Scheduler.
Languages: SQL, PL/SQL, HTML,
JavaScript, Visual Basic, Unix Shell
Scripting
Platforms: Unix (Sun Solaris,
HP-UX, AIX), RedHat Linux, Windows 2003
App Tools: Oracle Developer
(2000,6i), Oracle Designer, Erwin,
Visual Studio, Oracle Application
Server, Oracle Gateway.
Hardware: Sun Ultra Enterprise,
Sun SPARC, HP 9000, IBM RS/6000, Intel


Additional Information:
CERTIFICATIONS
Oracle Certified Database (OCP
10g)
Oracle Certified Database (OCP
11g)
Oracle Certified Administering
RAC (10g)


Candidate Contact Information:
JobSpider.com has chosen not to make contact information available on this page.
Click "Contact Candidate" to send this candidate a response.


    





© 2019 Job Spider
Privacy Policy | CC Marketing Sites | Site Map | Links