We provide IT Staff Augmentation Services!

Senior Oracle Dba Resume

Arlington, VirginiA

SUMMARY:

  • All of the responsibilities and duties apply to custom applications developed in Operations.
  • Improve the quality of the custom application databases.
  • Design databases with consideration for future integration.
  • Design databases to ensure optimal database performance.
  • Recommend appropriate use of (and help create) stored procedures functions and packages.
  • Collaborate with development teams to tune the existing database queries stored procedures and packages.
  • Assist the development teams with the design of bulk data upload processes.
  • Maintain database security (test and production) by limiting access to user IDs with DDL privileges. Minimize risk to test and production environments by implementing all required database changes. supporting Oracle databases versions 9i through 10gR2. Candidate must be skilled in Oracle database administration in UNIX environments with excellent communication and documentation skills. Job Duties: Tune administer and maintain Oracle instances according to set standards - Patch upgrade and maintain Oracle binaries
  • Develop and document procedures for backup and recovery of databases -Update and maintain established security policies set forth by the DISA STIG -Implement mitigations of security vulnerabilities -Work independently and coordinate with various teams in accordance with defined standards and practices -Monitor and manage legacy backups using command line -Monitor and tune RMAN backups using EM Grid Control and command linesupporting Oracle databases versions 9i through 10gR2.
  • Candidate must be skilled in Oracle database administration in UNIX environments with excellent communication and documentation skills.
  • Job Duties: -Tune administer and maintain Oracle instances according to set standards -Patch upgrade and maintain Oracle binaries
  • Develop and document procedures for backup and recovery of databases -Update and maintain established security policies set forth by the DISA STIG -Implement mitigations of security vulnerabilities -Work independently and coordinate with various teams in accordance with defined standards and practices -Monitor and manage legacy backups using command line -Monitor and tune RMAN backups using EM Grid Control and command line Supporting Oracle databases versions 9i through 12c in UNIX environments.

TECHNICAL SKILLS:

  • Tune, administer and maintain Oracle instances according to set standards -Patch, upgrade, and maintain Oracle binaries (Database 11g/12c, RAC, DataGuard, GoldenGate, OEM, CRS, app server, and GC agent)
  • Develop and document procedures for backup and recovery of databases
  • Update and maintain established security policies set forth by the DISA STIG -Implement mitigations of security vulnerabilities
  • Work independently and coordinate with various teams in accordance with defined standards and practices
  • Monitor and manage legacy backups using command line -Monitor and tune RMAN backups using EM Grid Control and command line
  • Responsible for writing detailed architectural and infrastructure documentation.

PROFESSIONAL EXPERIENCE:

Confidential, Arlington, Virginia

Senior Oracle DBA

Responsibilities:

  • Oracle 11g to 12c upgrade and migration.
  • Design, create and maintain materialize view, partition tables and indexes.
  • Setup RMAN backup and restore police.
  • Implement Oracle Database Performance/Tunning and security audit and maintenance.
  • Apply Oracle Critical Patches Updates.
  • Responsible for performing physical implementation tasks on new and existing Oracle database in a large, complex databases.
  • Experience with Oracle Enterprise Manager, Instance Monitor, Quest Software DBA tools, SQLPLUS and utilizes Metalink.
  • Oracle installation/configuration in Oracle 11g/12c environment and using unix script for data loading. Database optimization and indexing.
  • Create and maintain Physical Standby and Data Guard database environment.
  • Using dgmgrl to create Oracle Data Guard Broker configuration and setting up monitoring script for dgmgrl’s behavior.
  • Interface with Oracle Support for technical issue resolution.
  • Creates and maintains application application user account, priviledges and priviledges.
  • Performed database failover/switchover activity on JDIS production database.
  • Upgrade oracle database from 11g to 12c.

Confidential, Alexandria, Virgina

Oracle DBA

Responsibilities:

  • Extensively worked with Oracle Enterprise Manager (OEM), Oracle RAC, Instance Monitor, Data Guard, GoldenGate, Quest Software DBA tools, SQLPLUS and utilizes Metalink.
  • Oracle installation/configuration in Oracle 11g environment and using unix script for data loading. Database optimization and indexing.
  • Create and maintain Physical Standby/Dataguard database environment.
  • Perform environments builds, upgrades, patching, cloning and maintenance.
  • Perform system monitoring, performance tunning, load balancing and capacity plan.
  • Execute disaster recovery/high availability activities, backups, restores and flashbacks.
  • Define operational procedures and create system documentation.
  • Configuration/Release Management. And information Assurance.
  • Oracle ASM, Oracle RAC environment.

Confidential, Reston, Virgina

Oracle DBA

Responsibilities:

  • Design Process modeling, entity-relationship diagrams, and data diagram for N-Tier concurrrent project on Oracle 9i.
  • Responsible for the management configuration and maintenance of Oracle Database Management System on the UNIX(Solaris) platform. Contact Confidential through TAR and Metlink for technical support and troubleshooting. Assist Developers in tuning database applications for better performance.
  • By using RMAN to handle backup.
  • Performance tuning by using STATSPACK.

Confidential, McLean, Virginia

Oracle DBA

Responsibilities:

  • Logical data model design with S-Designer, Physical data model design
  • Data Analysis. Project planning, Performance tuning, data cleansing skills.
  • Develop Policy Standards Procedures, project planning, requirements gathering, and systems analysis and design data integrity and data migration.
  • Implementing the database in a distributed environment
  • Installing Oracle 7.x in HP-UX on HP9000, creating databases, 24 x 7 backup, recovery, data conversion, performance tuning, monitoring the database on disk usage, I/O contentions, etc..
  • Also working with system administration team to perform HP 9000 system configurations.

Hire Now