Oracle Database Administrator Resume
2.00/5 (Submit Your Rating)
EXECUTIVE SUMMARY:
- I am a highly skilled IT professional with over 5+ years experience providing mission critical oracle database solutions to private and government clients. Background experience involves working with technical teams and clients to determine data requirements,data storage, data analysis, administration, security in both transactional or datawarehouse environments.
- Excellent experience in installation and configuration of Oracle 10g, 11g, and 12c in LINUX/UNIX and windows operating system.
- Expertise in Installation, configuration and use of OEM and Grid Control.
- Advanced knowledge in SQL commands.
- In depth knowledge of Oracle upgrade from 11g to 12c.
- Proficiency in Oracle Datapump/Data Migration.
- Expertise in utilizing OPatch.
- Proficiency in Oracle database Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
- Experience with Oracle unique features like ASM, ASH, AWR, ADDM, ASSM, AMM, Undo management, Grid Monitoring and Recycle Bin.
- Experience with Oracle Configuration Management.
- Experience with troubleshooting and changing parameters.
- Knowledge of creating and assigning profiles and granting privileges.
- Experience in performing daily DBA activities like creating schemas, users and table spaces management, performing export and import, loading flat file data using SQL loader.
- Ability to meet required targets set with quality results regardless of work pressure.
- Punctual, dedicated and very disciplined in work.
- Excellent verbal and written communication skills
- Sets logical and analytical thinking paramount in daily handling of tasks.
- Great team worker and disciplined in little to no supervision job duties.
- Yearning to continue growing in skills in every work environment I am in.
- Strong prioritization skills and ability to meet multiple concurrent deadlines.
TECHNICAL SKILLS:
METHODOLOGIES: SDLC, Agile, Scrum, WATERFALL,EXTREMEDATABASES: Oracle (10g, 11g, 12c)
Tools/Applications : Oracle enterprise manager, Datapump, Recovery Manager, Database Configuration Assistant, Database Upgrade Assistant, Network Configuration Assistant, Universal Installer, Network Manager, SQL data modeler, SQL developer, Sql*Plus, VMware, Virtual box, Microsoft suites(Excel, Word, Powerpoint)
Languages: sql, pl/.sql, tsql
Operating System: Windows, Mac OS X, Linux
PROFESSIONAL EXPERIENCE:
Confidential
ORACLE DATABASE ADMINISTRATOR
Responsibilities:- Hands on working with various versions of Oracle (10g, 11g and 12c).
- Installing and configuring Oracle database software.
- Creating and managing database users, roles, privileges and permissions.
- Configuring and managing the various database security approach.
- Designed and configured Oracle backup strategy for the company.
- Performance tuning - index tuning, partitioning, materialized views, function based index, sql parsing.
- Very good with oracle database performance tool, Enterprise Manager.
- Externsive development of stored procedures and packages using PL/SQL.
- Software quality control and assurance., Organize and attend client meetings to get client system requirements, Project manager for a few clients. Maintain Client ticket request system and company’s internal ticket request system.
- Database design, implementation, development, maintenance, regression testing and improvements.
Confidential
Oracle Database Administrator
Responsibilities:- Creating users, profiles and assigning profiles to the database users.
- Granting privileges and roles to database users.
- Performed import an export of schemas using IMPDP and EXPDP
- Installation and configuration of OEM.
- Upgrade from 11g to 12c.
- Database migration using impdp and expdp.
- Regular backup of the database.
- Troubleshooting and changing of parameters.