We provide IT Staff Augmentation Services!

Database Administrator Resume

Silver Spring, MarylanD

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.

Hire Now