Responsible for administration, security and support of our databases involved with the Fox Digital Vault and FMS organization. Data Base Administration skills necessary to support ongoing monitoring, management and development for our Oracle and MySQL databases. Continued support of newly developed applications involving the databases. Management of all backup sets, recovery and disaster planning involving our organizations.
·Works closely with Systems Engineering to establish and audit system security not limited to the Oracle database, Applications including our commercial products and those custom developed.
·Adheres to Security policies established in the department and works closely with other team members to ensure that data files are maintained in a secure application environment.
·Establish policy and security procedures relating backup and restoration of the data from our databases.
2. Production Support
·Monitors the Oracle database as production workflows operate keeping track of transaction load, exceptions, table locks and other database processes.
·Responsible for the FMS Oracle11g and DV Oracle10g RAC systems.
·Additional responsibility for FMS MySQL installation which includes maintenance, upgrades and ongoing support.
·Monitors all database resources including and not limited to connection pools, table space and Artesia events.
·Performs maintenance on the Fox queue manager system and associated components.
·Documentation of all processes that we develop and evolve.
·Full Data Base Administrator responsibility for the Digital Vault/FMS Oracle Clusters, development and QA.
·Monitors all system backup activity including rotation of backup sets and restoration spot testing.
·Responsible for the installation of all patches and upgrades adhering to production maintenance windows.
·Adheres to department standards, policies, procedures and industry best practices.
·Proactively formulates all planning around administration tasks.
·Perform software development in contemporary languages such as Java, C, C++ and/or scripting in PL/Sql, Bash, Cshell Perl.
4. Quality Assurance Testing
· Assists in formulating QA test plans
·Assists in performing testing not limited to database functions but covering the entire system.
5. Other Duties As Required
· Administration of our Artesia Content Management system including but not limited to operational monitoring, log trimming and record conflict resolution.
·Works closely with Fox Corporate IT for all Oracle workflow issues including but not limited to system version compatibility, upgrades, patches and conflict resolution.
·All responsibilities include both production and disaster sites.
Education: Bachelor's Degree
News Corporation - 21 months ago