Oracle DBA

Description

KEY RESPONSIBILITIES (other duties as assigned) Administer all database objects tables, clusters, indexes, view, sequences, packages and procedures on both the Oracles and Postgres databases. Schedule and optimize maintenance tasks such as reorg/reindex, update statistics to ensure optimal performance and availability. Reorganize databases structures at regular intervals to provide an efficient database environment that will maximize productivity and improve performance. Analyze, test, and implement database design supporting various business applications for development, integrated test and production environments. Design, implement, and enforce the company's data security policies. Responsible for logical and physical database design, backup and recovery strategy including disaster recovery, high availability, load strategy design and implementation, security, and change management. Identify and lead strategic database initiatives, including upgrades, new technology and processes (e.g., patches, compliance, security), and new roles; engaging the appropriate cross functional technical resources to determine solutions, recommend outcomes and drive project plan through to timely completion. Provide first level application support in Oracle, Postgres, and Microsoft database environments running on Linux and Windows servers. Facilitate application development and customer problem resolution with optimum speed and efficiency. Conduct application transaction volume and traffic analysis assessing the impact of database performance. Monitor database growth and usage to ensure optimum performance and stability in production environment. Design and configure database architecture, including hardware and physical layout. Perform data refreshes on request to support development and model office test environments.