The SQL and iMIS Administrator will design, install, monitor, maintain and performance tune databases while ensuring high levels of data availability. The incumbent will ensure that iMIS performs at the highest level possible and successfully integrates with external applications including the website, LMS, HigherLogic (Informz), accounting software, and other platforms as needed.
Candidates should be able to demonstrate the knowledge to diagnose system problems and implement fixes
add new functionality to enhance capabilities
document workflow clearly and accurately
generate automatic and one-off reports
Duties include but not limited to:
Handle all database instances, installing, configuring, and maintaining them across development, staging, and production environments
Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets
Work with the Infrastructure vendor to ensure databases and critical data are properly backed up and protected in accordance with the needs of the application's primary stakeholder and the firm's disaster recovery and data retention policies
Provide day-to-day support for the company's SQL systems and applications, including monitoring database health to ensure a stable environment as well as diagnosing and resolving database access and performance issues
Gather requirements and translate them into data distribution and utilization needs; design databases meeting specifications addressing content management, content indexing, reporting, and workflow requirements
Design, implement and maintain iMIS/SQL database and other platforms
SQL High-Availability Cluster Implementation, configuration and management
Support Applications implementation projects from initiation to completion
Installation of middle tier application layer when required
Provide third line applications support and database administration support; troubleshoot and resolve escalated issues
Provide timely responses and resolution towards database backup, restore, mirroring, synchronization requests, patching, and change control maintenance
Other duties as assigned to fully meet the requirements of the position.
Coordinate and complete all membership dues renewal process and dues collection
Manage IMIS upgrades and updates
Provide support to accounting as needed
Ensure data remains consistent across the database and perform data clean-up as necessary.
Ensure the database reflects the needs of users, the organization and enhances the member experience.
Create, Build, and Maintain: IQA’s, Process Automations, SSRS reports, Crystal Reports, RiSE pages, and other iMIS functionality
Ensure seamless integration of the database with the website and other third-party tool.
Coordinate training of IMIS to users Required Knowledge, Skills and Abilities:
Prior responsibility for managing an IMIS database in membership setting
Bachelor’s degree in Information Technology or related field
SQL certification preferred (a plus)
iMIS certification preferred (a plus)
5+ years of technical experience with previous and current versions of Microsoft SQL database administration in the installation, configuration and management in a 24 x 7 global support environment
5+ years of experience managing and improving iMIS database
Expert understanding of SQL Clustering/Replication/High-Availability Implementations, and Disaster Recovery with respect to the database systems
Understanding of cloud database technologies (Microsoft Azure, Amazon Web Services, etc.…)
Strong understanding of the client/server application stack
Strong knowledge of Transact-SQL, Stored Procedures, SQL Mail, SSRS and triggers
Working knowledge of Windows Server, IIS, DNS, DHCP, and Active Directory
SQL administration experience in versions 2000 forward with confidence in converting databases to upper versions
Ability to document processes and procedures, including technical diagrams towards organizational data flow
Essential Competencies & Behaviors:
Detail-oriented, with strong organizational, analytical, and planning skills
Aptitude for the management and effective use of information systems
Excellent time management skills
Outstanding communications/interpersonal skills
Commitment to continuous quality improvement to ensure the integrity of the system and that staff can use the system effectively
Responsiveness to staff members, external vendors and Association member requests in a timely and helpful manner
Ability to manage various projects and meet deadlines
The American Society for Gastrointestinal Endoscopy (ASGE)
Since its founding in 1941, the American Society for Gastrointestinal Endoscopy (ASGE) has been dedicated to advancing patient care and digestive health by promoting excellence and innovation in gastrointestinal endoscopy. ASGE, with more than 15,000 members worldwide, promotes the highest standards for endoscopic training and practice, fosters endoscopic research, recognizes distinguished contributions to endoscopy, and is the foremost resource for endoscopic education.
ASGE is an Equal Opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation, gender identity, ethnic or national origin, disability or any other status protected by State and Federal Law. Our commitment to diversity, equity, inclusion and belonging drives us forward every day. Together, we will continue to build a culture that welcomes, encourages, supports, and empowers the diverse voices of our employees.
ASGE's Mission Statement is:
"To be the leader in advancing patient care and digestive health by promoting excellence and innovation in endoscopy"