• tiyeconsulting@outlook.com
  • 202  536  2880
Oracle Database Administrator

Oracle Database Administrator

Job Title: Oracle Database Administrrator
Location: Baltimore, MD
Salary/rate: $55-70/hour

An Oracle Database Administrator evaluates existing or proposed systems to ensure structure and access to the database, designing and implementing modifications to forms, menus, and reports, and maintain technical documentation related to database management. The database administrator will install and maintain database software, create storage structures, and set up user accounts. Additional duties include performance monitoring, security, backups, troubleshooting, and data recovery.

Responsibilities:

  • Propose and implement database management policies, procedures, and standards
  • Providing database monitoring and statistical reports using Oracle Enterprise Manager Grid Control 19C. Monitor alerts, schedule daily, weekly, and monthly backups
  • Coordinating the installation and implementation of database management system software and related software tools with vendors, other data processing staff, and systems users
  • Maintaining security and integrity of data access policies, standards, and methods by establishing recovery plans to minimize data losses and system downtime and by performing back up routines for the database management system software and the stored data
  • Monitoring database performance and make modifications and adjustments to database architecture, storage methods and management system software to fine tune the database for optimum response time
  • Monitoring database capacity and allocate space according to overall needs of systems users, available data storage, and database management system requirements
  • Maintaining hourly, daily, weekly, monthly, and yearly test backup and recovery process for Disaster Recovery readiness using Oracle RMAN, data pump, and cold and hot backups
  • Providing support in Oracle Golden Gate configuration, implementation, and conflict resolutions for data replication
  • Performing periodic database refreshes, cloning from Production to Development, and Test environments
  • Providing database support during full development cycle of application from design to testing and implementation, on-call production, test and development support
  • Proactively research the latest database technologies and perform lab tests as needed/requested, document and make recommendations by performing return on investment analysis for higher management
  • Creating new Oracle databases using DBCA, as per the standards to upgrade existing Oracle databases and/or apply the latest Oracle Security patches
  • Migrating data and database objects from Oracle to MS SQL Server database
  • Migrating and configure Oracle application and database servers to the latest Oracle version as needed
  • Designing, building, and managing cluster and virtual machine environments
  • Evaluating and recommending new database technologies
  • Managing and integrating various database platforms
  • Managing and maintaining Windows, Linux, and environments
  • Developing and implementing flexible database management policies, procedures, and standards
  • Managing and resolving database and application systems failure and provide alternate solutions
  • Training database system users on the use of database management systems
  • Developing database recovery plans
  • Preparing statistical reports of database management activities and special purpose report
  • Coordinating the database management system interfaces with other data processing units
  • Troubleshooting problems related to database file space, database software, data flow, and data storage or data access
  • Managing web database security
  • Managing access control security systems
  • Providing working experience to implement and manage Oracle stand by databases
  • Providing working experience to implement and manage Oracle database encryption methodologies preferably with Transparent Data Encryption (TDE) and Oracle Wallet
  • Procure, manage, and install Oracle Forms JAVA jar files as required
  • Managing Trucker Verification E-Modal system
  • Managing MPA Oracle databases with Oracle Enterprise Manager tools

Candidate Requirements:

  • Bachelor’s degree from an accredited college or university in Computer Science, Database Administration, or a related field
  • Five (5) years of current experience in managing and administering Oracle databases. Note that “current experience” is defined as experience in supporting either the latest version or the next to latest database version
  • Possess excellent oral and written communication skills, effective time management skills, good interpersonal skills, and must be able to demonstrate effective judgement with respect to business and financial matters that affect the work under the resource’s management
  • Possess effective analytical and problem-solving skills. Must collaborate effectively with other operational support teams
  • Possess a general understanding of ITIL processes and framework. ITIL foundation certification is preferred. Administers Oracle Software licenses and assures license compliance
  • Possess an Oracle Database Administration certification
  • Minimum of five years of practical experience as a database management resource
  • Minimum of five years of experience in an Oracle Database Administration
  • Minimum of two years of basic system and Network infrastructure administration
  • Minimum of one year of experience in various Virtualization tools, VMware and/or Microsoft Hyper-V, and Oracle Virtual Machine
  • Minimum of two years of experience with PL/SQL programming using SQL developer, Toad; experience in Microsoft SQL Server database management
  • Minimum of two years of experience working in virtualization environment preferably with Oracle VM servers and MS Hyper-V VMware infrastructure
  • Minimum of two years of experience with installation, configuration, deployment, migration, backup, and recovery of Oracle application servers
  • Minimum of two years of Oracle Advanced Security experience