Job Openings

Under the direction of the Chief Operating Officer, the SQL Server Database Administrator will be responsible for the administration of the organizations Association Management System (AMS) and related applications. The Database Administrator will serve as the resident expert for AAPA staff as it relates to the iMIS environment and while iMIS database is desirable it is not completely necessary. This person will be responsible for providing a wide range of database functions including establishing and maintaining documentation of data, reporting protocols, and assisting with best practices for the management of AAPA main SQL database-iMIS, preparing stored scripts, examining iMIS workflow and processes and ensuring quality control procedures. The DBA will be responsible for the integration of new database systems, applications and services.

The position requires a highly skilled professional that can manage an enterprise application and that is experienced with SQL server databases management such as IMIS and other business applications.

- Consults at multiple levels of the organization on the design, development, and implementation of logical data structures and classification schema,
- Develops strategies and procedures for building, maintaining, and leveraging data models,
- Works with the organization’s business subject matter experts and technical staff to document business information and data requirements in Conceptual, Logical, and Physical data models,
- Develops Enterprise and business area/domain logical data models to Third Normal Form (3NF) complete with Foreign Key details,
- Ensures metadata and data standards and definitions support unit-level business processes, system implementations, and corporate requirements for interoperability and data sharing,
- Develops, coordinates, and supports implementation of enterprise data integration strategies,
- Enforces standards and ensures consistency through the proper use of data modeling tools.

Responsibilities: Have immediate openings for two individuals proficient in Oracle PL/SQL programming and previous experience in data management, quality control operations, data quality assessment, and providing excellent, timely customer service. This is a mid-level position responsible for maintaining and improving the quality of Enterprise Data used in AAMC web services, applications, and research. The individual in this position will contribute to developing, programming, implementing, documenting and monitoring standardized control processes for data cleaning, data matching, ETL and data quality assessment with the objective of assuring the highest level of data quality in AAMC data. This Data Management Specialist position collaborates with other staff to ensure data integrity, consistency, security, and privacy in all database and software projects. Other key responsibilities for this multi-tasker include: evaluating and implementing new data management tools, providingsupport for development and implementation of Master Data Management processes; and preparing reports of the quality of the data and effectiveness of data quality methods. This position will make a substantial contribution to the quality of AAMC's shared Enterprise Data.

Requirements: Bachelor's degree required (technical or data operations & analysis oriented). Degree may be waived with substantive experience in data operations, data quality assurance and customer service. A minimum of 4 years of progressive and demonstrated experience in large database data matching, ETL operations, database customer support, data integrity operations, data quality operations, and data quality assessment and analysis reporting. Strong intermediate or better Oracle SQL+ and PL/SQL required. Experience with UNIX a plus. Knowledge of Master Data Management processing and/or Data Quality Management certification a plus. Demonstrated organizational, analytical and problem-solving skills. Superior communication, writing and interpersonal skills. Ability to work independently and interact collaboratively with multiple levels of staff required. Include minimum salary requirements and resume

What the AAMC Has to Offer!
The AAMC offers a total rewards package that is second to none – We offer competitive base pay, a real work-life balance, as well as proven career growth and advancement in a progressive, supportive business environment.

The AAMC strives to provide the most equitable and cost-effective benefits for its employees in recognition of the influence benefits have on the economic and personal welfare of each individual. Our benefits platform includes three medical insurance choices, a dental/vision plan; a time off from work program as well as a flexible weekly work schedule; a retirement savings plan with generous match; tuition reimbursement; life insurance; commuting benefits; and more!

AAMC fosters an environment where continuous employee development is encouraged and diversity is welcomed and respected. We are an Equal Opportunity Employer.

Application Process:
Please send a resume to [Click Here to Email Your Resumé], along with your salary requirements.