AGA Job Openings

Database Administrator/Programmer

The database administrator is reports to the Director, Information Services and is responsible  for developing and maintaining AGA electronic databases and online integration.

Duties and Responsibilities:

  • Monitors database systems to ensure the functionality of the database and the availability of system data.  Identifies actual and potential database problems and recommends and/or implements timely solutions.  Coordinates and controls database recovery processing.
    • Corporate Database – responsible for the routine maintenance and integrity of the database and its modules; write adhoc complex reports; serve as the staff liaison to the vendor;
    • DDW Database – oversee the add/delete/update processes of the sister society membership information; import DDW registration and CME records.
  • Reviews database maintenance jobs for unexpected conditions as required. Develops ad hoc queries to monitor potential or actual database integrity problems according to industry standards. Uses appropriate methods to ensure database recoverability. Ensures that back-ups of database structure and data are performed on a regular basis.
  • Assists IS personnel and software/hardware vendors in installation, maintenance support, software interface requirements and problem determinations and resolution.  Makes recommendations to management on database software/hardware acquisitions and/or upgrades. Provides guidance and recommendations involving program modifications or upgrades that interface with database software as needed.
  • Assists IS personnel in establishing database parameters. Coordinates and establishes requirements of database emergency disaster recovery readiness. Assists in developing interface requirements needed to utilize the database system and support tools when required. Carefully evaluates and makes timely recommendations on acquisitions and upgrades for database and products which use database.
  • Works with vendor and technical support personnel in producing documentation and other required problem-solving information in a timely manner.
  • Appropriately assists other staff members with complex queries and with analyzing queries for efficient database access.
  • Interacts with all levels of personnel in a way that promotes respect, encourages cooperation and contributes to excellent performance.  Communicates accurate information to all personnel in a professional and courteous manner that conveys a willingness to assist. Accepts direction and feedback from supervisors and follow through appropriately. Accepts responsibility for mistakes and take action to prevent similar occurrences. Uses appropriate established channels of communication.

Qualifications

  • Knowledge of data collection, storage, and maintenance concepts.
  • Knowledge of electronic database programs, including Excel, Access, with a strong emphasis on SQL 2005 or later.
  • Database organization, design, and maintenance skills.
  • Project coordination skills.
  • Research skills.
  • Strong knowledge of Microsoft Business Intelligence Studio and VB 2005 and later.
  • Ability to design and maintain technical databases.
  • Ability to troubleshoot database programs.
  • xWeb programming knowledge a plus.

Assistant Controller

The Assistant Controller is a Manager in the AGA Accounting/Finance Department. His / her primary responsibility is to run the daily operations of the accounting/finance department and maintain the integrity of the company’s general ledger(s). The Assistant Controller will help to establish and maintain the organization's accounting principles, practices, and procedures. He/she will aid in the preparation and evaluation of financial reports, including audits and budgets

The Assistant Controller is responsible for managing the accounting staff and their duties. He/She will directly supervise the Accounting Assistants, and is responsible for supervising and training them.  Such management involves assigning and reviewing their work, educating them in the proper execution of their jobs, counseling them to enhance their job performance, arbitrating disputes, and providing support. 

Specifics

  • Accounting System for all Companies – Ensures the integrity of the accounting systems (financial reporting, accounts payable, accounts receivable, general ledger, timesheets, and budget). 
  • Accounts Payable - Oversees accounts payable process to ensure its function is accomplished in a timely and accurate manner.  Serves as secondary reviewer of accounts payable edits for accuracy.
  • Accounts Receivable - Oversees accounts receivable process to ensure that all accounts receivable are invoiced (including but not limited to pledges, sponsorships, exhibitor fees, employees). 
    Reviews receivables with accounting staff and other departments and assists with appropriate follow up and collection efforts.
  • Audits – Serves as primary liaison for AGA, AGA Institute, FDHN audit and DDW audit.  Produces schedules, financial analysis and documentation as requested.
  • Budget Preparation for all Companies – Provides support during the budget preparation process.
  • Cash Management: Assists in executing proper internal controls and programs designed to prevent fraud.
  • Financial Reporting – Executes the monthly closing process in order to compileand produce monthly financial statements for AGA, AGA Institute, FDHN, DDW and GRG.
  • Account reconciliations: Responsible for reconciling all investment, intercompany, and fixed asset accounts for all companies on a timely basis.
  • Creates ad hoc reports as he/she sees necessary to provide financial control or as requested by management.