Pegasus is a fast growing and dynamic software company with over 5,500 customers worldwide serving the global hotel and hospitality industry. Pegasus is headquartered in New York City with offices across Europe and Asia. With video conferencing technology including Google Hangouts and Skype, we’ve created a culture of teamwork and face-to-face collaboration across the globe. Our people bring together expertise in the marketing, technology, and hospitality sectors and we work together to create, refine, and then shape new ideas into great products for our customers.
Working at Pegasus is an opportunity to join an exciting entrepreneurial company with a track record of success. We are highly selective in our hiring process seeking individuals with demonstrated excellence in their professional and academic backgrounds. We look for smart leaders who are passionate about technology and the web, who care deeply about their careers, and who want to work hard and have fun.
Role & Responsibilities
Analyze, develop, and administer Travel Tripper’s (dba Pegasus) complex Relational Database Management Systems (RDBMS) database system based on the Informix database architecture. Be responsible for database architecture, physical and logical database design, backup and recovery, and performance tuning of Informix databases. Monitor and develop database performance profiles, including monitoring and ensuring security and integrity of multi-platform database systems and environments. Perform key database administration functions including database instance creation, data migration, database replication, as well as initialization, configuration and administration of Informix systems and SQL provisioning and capacity planning to address database warehousing capabilities for large-scale reservations data management. Perform technology assessment audits, data structure tuning, database/table reorganization and utilities and scripts execution and monitoring. Utilize Perl, csh, ksh, sh to develop solutions in disaster recovery, DBSPI/scripting and all other real-time, high availability and performance monitoring procedures. Support database backup failure, review SQL queries for performance issues, and analyze space reports and response query alerts. Plan Informix data warehousing server capacity upgrades while also troubleshooting all database system failures and performance issues. Collaborate with the cross-functional team to design and develop new database-driven software and enhance existing software applications. Ensure and deliver on high availability and uptime of our products and processes, and study, research, and recommend new database solutions for improvements in database infrastructure effectiveness and overall performance.
Skills & Requirements
Master’s Degree or equivalent in Computer Science, Computer Information Systems, Computer Engineering, or related field plus three (3) years of Database Administration or related information technology experience: working with RDBMS Database Administration in Informix 11.x, 10.x or 9.x environments; monitoring and performance tuning of databases; maintaining database security and integrity of large-scale data management systems; addressing business critical issues with the infrastructure and application teams; configuring database enhancement, database replication, disaster recovery and critical data recovery; supporting database backup failure issues, resolving data and index corruption issues, and reviewing SQL queries for performance issues; developing and monitoring DBA utilities and scripts; utilizing various scripting languages including Perl, csh, ksh and sh; and utilizing Shell Scripting, SharePoint, HPL and Solaris. Telecommuting permissible.
Qualified candidates may apply at email@example.com.