Oracle DBA Resume Waterloo, ON - Hire IT People

SUMMARY

Oracle Certified professional seeking a position as a Junior - to-intermediate Oracle Database Administrator (DBA). Core competencies include:
Skilled Oracle Database Administrator and Architect with over 2 years of in-depth technical knowledge and strong management skills.
Involved in creation, installation, maintenance and administration of Databases in UNIX, LINUX, AIX, Sun Solaris and WINDOWS Platforms
Good experience in EXPDP-IMPDP backup -recovery & restore, and in-depth understanding of security strategies to ensure database integrity
Experience in management tools like Oracle Enterprise Manager, TOAD and SQL Developer. Creating, Updating, Altering Tablespace, Indexes, Tables, Views, Synonyms, Profile, Role, Privileges
Creating/Managing users profiles and analyzing their privileges and Tablespace quotas
Knowledge of Oracle Real Application Cluster (RAC), Data Guard and ASM
Detailed oriented, able to work on own initiative as well as following Sr. DBA’s procedures and guidelines, Energetic self-starter with excellent analytical and organizational skills.

TECHNICAL SKILLS

RDBMS: Oracle 10g/11g, Data Guard, Oracle 11g Real Application Cluster (RAC) and ASM, SQL Server, MS Access

Operating Systems: UNIX, SUN, Linux, Windows NT/2000

Programming Languages: SQL, PL/SQL, UNIX Shell Script

Database Tools: RMAN, OEM, Data Pump (expdp, impdp), SQL Developer, TOAD, DBA Studio, Grid Control, Putty, SQL Loader, Erwin

Methodologies/Technologies: TKPROF, EXPLAIN PLAN, ADDM, AWR

PROFESSIONAL EXPERIENCE

Oracle DBA

Confidential, Waterloo, ON

Responsibilities:

Experience in a very fast paced environment administrating, supporting and maintaining multiple production and development Oracle databases.
Performed numerous Oracle 10g to 11g software installs, upgrades, patching and database builds.
Responsible for addressing security vulnerability fixes by applying CPU and PSU patches in all development and production databases environments. Created a shell script dat reports to DBA group Oracle databases dat are missing patches, both one-offs, CPUs, and/or PSUs (based on a list of deemed necessary patches).
Proficient and very comfortable in command line interface usage (me.e. SQLPlus, UNIX etc.)
Monitored and maintained databases using tools like TOAD, SQL Developer, OEM and SQL Navigator.
Promoted and implemented on a weekly basis database changes received from teh development organization to pre-production and production environments. Typical changes involved teh creation and updates of tables, columns, indexes, views, synonyms, function and procedures. Also, me ensured dat changes were authorized by management; changes followed teh standard development/pre-production/production life cycle; were scheduled, implemented and completed within standard maintenance windows with teh exception of emergencies.
Established and maintained sound backup and recovery policies and procedures for hundreds of non-production and production databases. Ensured teh nightly RMAN and DataPump backups ran successfully; refreshed and cloned schemas and databases in development at application owners’ request.
Experienced in administrating 3-node RAC (Real Application Cluster) database and Physical Standby database according to established procedures and guidelines put in place by Sr. DBA members.
Implemented and maintained Tablespace quotas, users and roles; assigned system and object privileges dat are fully compliant with teh business rules of teh company.
Performed database tuning and performance monitoring using AWR and ADDM.
Used OEM to Monitor and Plan for growth (capacity planning), created new Tablespaces, added datafiles to existing Tablespaces, monitored Tablespace size and resized Tablespaces.
Performed general technical troubleshooting of errors in alert.log (e.g. ORA-600, ORA-7445, etc). Opened SR’s as necessary with Oracle Support to address recurring issues or to obtain bug fixes.
Attended DBA team meetings fostering strong cohesiveness regarding all major databases issues, plus departmental direction, annual plans, licensing, policy changes, etc.
Experienced in scheduling jobs through Oracle Job Scheduler, Cron and BMC control-M.
Provided 24/7 on-Call support (rotation). Skills Utilized:
Oracle 11g, 10g, HP, SUN, Windows NT, Data Pump, Toad, OEM, RMAN, Putty, SQL, PL/SQL, Shell, Scheduler, Cron and Resource Manager

We provide IT Staff Augmentation Services!

Oracle Dba Resume

Waterloo, ON

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship