Senior Database Administrator And Applications Manager
CurrentTechnical and functional support for all Oracle E-Business Suite environments including HCM, Payroll, Inventory, Purchasing and Financials.Technical and functional support for all SQL Server databases and applications.Technical and functional support for all company applications.Installs, maintains, and troubleshoots Oracle, SQL Server and other application systems and associated hardware.Ensure software license compliancy for Oracle applications and databases.Prepares technical and user documentation and provides user assistance.Management and support of other members of the Helpdesk level 1 support team. Provide level 2 support and problem resolution for all applications and if required, escalate application problems to external vendors to ensure all reported problems are resolved efficiently.Design and document database architecture, build and maintain database schemas, tables, procedures and permissions.Monitor database systems for availability, analyse and tune database for optimal efficiency.Restore and recover databases in production and during DR testing.Acts as an Oracle, SQL Server and applications technical resource in assisting users or project teams, take ownership of issues or problems assigned and ensures all key personnel are kept informed on progress in a timely manner.Makes Oracle, SQL Server and applications hardware and software acquisition recommendations in line with company purchasing procedures. Assist users to assess needs and provide/document justification for equipment and services.Performs routine Oracle, SQL Server and applications systems support housekeeping tasks (monitor backups, nightly batch jobs, application of patches, data retention policies).