Database Administrator
Sydney, Australia
• Support Infrastructure Outsourcing for the airline Industry, Navitaire• Build, configure and administer SQL server instances and databases for the various Navitaire systems, such as, reservations, check-in, crew management, baggage handling, payments etc. All environments employ transactional replication which must be configured by the DBA’s• Ensure that all environments are configured with automated local/offsite database backups, server/instance/database monitoring and index… Show more • Support Infrastructure Outsourcing for the airline Industry, Navitaire• Build, configure and administer SQL server instances and databases for the various Navitaire systems, such as, reservations, check-in, crew management, baggage handling, payments etc. All environments employ transactional replication which must be configured by the DBA’s• Ensure that all environments are configured with automated local/offsite database backups, server/instance/database monitoring and index rebuilding• Install and configure clustering• Configure transactional replication between OLTP and ODS• Perform ETL data refreshes of lower environments (Test, Train and UAT) from production • Plan and perform database upgrades for the various products• Provide 24/7 standby on call support across all environments rotated amongst the DBA team members• Engage in ongoing knowledge transfer and documentation• Monitor and resolve production database performance, storage capacities, fragmentation and errors. Show less