SUMMARY

• Self - motivated, smart and dynamic certified passionate Oracle Data Base Administrator with more than 5 years’ experience in Information Technology and Data Base Administration.
• Strong knowledge on oracle architecture.
• Worked with oracle exadata which it comes already pre-configured and enhance performance tighter security, compression of data.
• Designs, tests, implements, maintain and control the organization's production and non-production databases.
• Experience in Working on 10gR5/11g
• Had gone through Data Base Administration Training.
• Experience in Oracle Database Administrator * Install, configure, and implement
• Backup/recovery strategies using Oracle RMAN and Linux Shell scripts for daily database backups.
• Implementation of Oracle Backup and Recovery using RMAN
• Experience with multiple replication products, such as Golden Gate, RAC, Share plex.
• Configure and maintain loads in huge data warehousing system using informatica power-center ETL supporting data warehousing.

TECHNICAL SKILLS

Platforms: Oracle Architecture 10g and 11g in AIX and Solaris, Windows 2003, 2008, 2011 Server, Win XP. Red Hat Linux

Language: MySQL, Data Dictionary Language, Data Manipulation Language

Maximum Availability: RAC, ASM, ACTIVE DATAGUARD, RMAN, FLASHBACK TECHNOLOGIES, GOLDEN GATE, EXADATA

PROFESSIONAL EXPERIENCE

Confidential, Silver Spring, Maryland

Database Administrator

Responsibilities:

• Work in RAC environment to deliver high performance and high availability.
• Worked with OEM expediting solutions and maintenance operations such as patching of application across IT environment.
• Worked with oracle exadata which it comes already pre-configured and enhances performance, upholding security and compression of data.
• Effectively work with Active Data Guard providing high availability for database servers.
• Work in ASM environment.
• Providing Oracle 10g/11g/12c database administration, database security and production support, primarily in a UNIX environment.
• Upgrade and working on Apps 11i to r12.
• Do remedy
• Works on 10gR5/11g
• Implement data encryption
• Installation, configuration, upgrade and migration of existing databases
• Using change management processes to prevent production disruptions and outage
• Set up highly available architecture. Automate various DBA tasks.
• Partnering with other IT teams to ensure quality support and delivery to the end-user
• Optimize database performance by index creation and tuning
• Create database reports (e.g. user data, financial data, etc.)
• Support game updates; monitor the database for integrity and solve outstanding issues
• Review processes and identify areas of improvement
• Monitor database performance trends to identify anomalies or errors. Report analysis, detect and resolved table-space fragmentation and migrations. Turned SQL queries using EXPLAIN PLAN and TKPROF utilities.
• Designs, tests, implements, maintain and control the organization's production and non-production databases.
• Collaborates on the development of technical and security standards with other database administrators and technical resources.
• Provides on-call support for production environments.
• Provides 24/7 support for various activities including: Database maintenance, application releases, disaster recovery, database upgrades, and patching.
• Provides consultation to application developers in SQL coding and tuning, and coding and deployment of stored procedures
• Provide Oracle DBA technical support in a UNIX infrastructure.
• Plan and build database instances and objects.
• Implementation of Oracle Backup and Recovery using RMAN
• Assist in capacity planning of Oracle database servers
• Responsible to resetting accounts.

Confidential, Bowie Maryland

Oracle Database Administrator

Responsibilities:

• Oracle Database Administrator * Install, configure, and implement backup/recovery strategies using Oracle RMAN and Linux Shell scripts for daily database backups.
• Reading, writing and manually creating shell scripts using PL/SQL from the command lines of both UNIX and Linux environments.
• Creating user accounts and appropriate privileges as well as maintaining database security.
• Using Enterprise Manager to schedule backups
• Ensure daily RMAN backups are completed and valid for restore and recovery
• Create different table spaces, tables, schemas, and users accounts
• Managing physical database design and implementation, database security implementation and monitoring.
• Configure and maintain loads in huge data warehousing system using informatica power-center ETL supporting data warehousing.
• Creation and management of development and production schemas, databases, tables-paces, views, exports, imports
• Perform daily incremental backup and full weekly backup using Oracle backup utility RMAN
• Oracle Auditing, Fine grain auditing, Audit vault and Database Firewall and OCFS2
• Providing database diagnosis and tuning for performance and stability
• Implementing various database routines such as upgrades and patches and fail-over testing.
• Provide technical assistance and guidance to application support staff and project teams
• Installs the Oracle server and client software applications
• Experience with multiple replication products, such as Golden Gate, RAC, Share plex.
• Install, implement, and configure Oracle Enterprise Manager on Windows and Linux environment to administer databases in production environment.
• Advanced troubleshooting using trace files, alert log, and external links (Oracle Support)
• Develop, document, and implement operational support procedures for the Oracle infrastructure components
• Generating Reports and preparing memo to communicate progress and providing early alerts for major updates
• Refresh development/test databases from copies of production.