Description The Wex Health DBA will be responsible for the maintenance, performance and recoverability of the Greenplum database platform. This role will be part of a team which is responsible for the health and stability of the entire production system. Duties and responsibilities include: Provide support for production databases including performance monitoring, daily management to prevent data loss, unplanned downtime or performance degradation. Install, administrate and maintain schema and data to ensure maximum availability Monitor and tuning databases for efficiency and help drive improvements Coordinate with IT and developers on new product releases Analyzes and resolves problems associated with server hardware and applications software Create shell scripts required for monitoring and alerting, as well as automating day-to-day tasks Assure that all databases are being backed up properly and are recoverable Create new roles, schemas, group roles and assign to resources as appropriate Participate in Disaster Recovery exercises Participates in a 24x7x365 OnCall Rotation Qualifications Required Qualifications: 5 years of overall industry experience working with SaaS or web development 2 years of supporting MPP data warehouse environments Experience with Greenplum and Postgres database administration, and Postgres SQL Experience supporting OLAP workloads in multi-terabyte environments Experience in Red Hat Enterprise Linux 6.x Experience with writing shell scripts (K-shell and\/or Perl) Experience with Greenplum backup\/recovery strategies, including gp_dump, gpcrondump, gpdbrestore and pg_dump, and psql loading utilities Experience installing, configuring, upgrading and maintaining Greenplum environments Understanding of the standard Greenplum architecture and catalog tables and views Knowledge of system performance tuning as well as Greenplum tuning Strong understanding of the Greenplum client tools along with data load utilities including gpload and gpfdist etc. Bachelor's degree in Computer Science, IT, Engineering or related field Desired Additional Qualifications: Experience with SQL 2012 Experience with Source Control, specifically Team Foundation Server (TFS) Knowledge and experience with industry standard change and incident management procedures Ability to work in a fast-paced and dynamic environment while being highly motivated and resourceful Self-starter capable of working independently or in groups Experience working in cross-functional, multi-location teams Demonstrated ability to deal with complex challenges independently and collaboratively with team members Possess excellent communication skills both in written and verbal form Willingness to work occasional evenings and weekends in support of deployments and releases Ability to work under pressure and in high stress situations with a calm demeanor
Website : http://www.wexinc.com
WEX gives you precise financial and information management solutions to help your company strengthen its balance sheet and achieve unparalleled control and security. Since 1983, WEX has been a fleet card pioneer, steadily building a proprietary U.S. network that has earned site acceptance at over 90 percent of the nation's retail fuel locations and over 45,000 vehicle maintenance locations. This extensive network has earned the trust of commercial and government fleets, which use our charge cards for their over 7.6 million vehicles to purchase fuel and maintenance services. One foundation of WEX’s marketplace leadership is our proprietary software, which lets fleets control purchases in the field, and gives them comprehensive information and analysis tools to effectively manage their operations and reduce costs. WEX today provides category-leading fleet, corporate and prepaid payment solutions across a wide spectrum of business sectors around the globe. Our portfolio of business encompasses a MasterCard-branded corporate card; TelaPoint, a provider of supply chain software solutions for petroleum distributors and retailers; Pacific Pride, an independent fuel distributor franchisee network; and international subsidiaries. Through the efforts of more than 1,300 associates around the world, WEX will continue to provide its clients with unparalleled services and precise solutions to help them pursue ambitious goals and improve business efficiency.