Database Analyst

Shedd Aquarium is seeking a Business Database Analyst! — Do you have a passion for animals? Are you committed to Shedd’s mission and culture? You could become an integral part of the IT Team here at the Shedd Aquarium.

We are all learners, teachers, and have connections to our collections. Whatever the position, we do it with a sense of stewardship, quality, integrity and respect.

The DBA position works directly with Business Users to analyze their needs, explore solutions, and implement the best solution. These “solutions” will take the form of SQL queries, stored procedures, reports or configuration, or customization to the Shedd core packaged software suite (e.g. Great Plains). ? The ability to tailor solutions to support out business is crucial to this role.
It is required that the candidate has knowledge and experience with database configuration including database security, backup and recovery, and account management. It is also required that the candidate has experience writing SQL scripts for custom reporting and data transformation services.
In addition to the database responsibilities, this position also provides direct support to our end users for applications that utilize a database backend. The candidate will listen to others, recognize potential miscommunications, break down and explain complex ideas or information, identify and solve problems through gathering and applying information from a variety of sources.Supported applications include, but are not limited to:

  • Great Plains Dynamics
  • Business Portal
  • SharePoint
  • Tessitura
  • Forecaster
  • FRX
  • And more!
:
ESSENTIAL DUTIES AND RESPONSIBILITIES include the following. Other duties may be assigned. To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

  • Demonstrate commitment to Shedd’s vision, mission and values
  • Ability to determine database needs and requirements
  • Identify and tailor products and services to meet user needs
  • Perform logical and physical database design
  • Build new databases
  • Modify existing databases
  • Resolve complex database issues
  • Develop custom reports that span multiple disparate systems (using advanced SQL skills)
  • Maintain databases to include: daily, weekly, and monthly service, documentation, testing, upgrades, back-up and recovery, design.
  • Create and Modify databases and data security
  • Strong communication and customer service skills; including being able to talk through complex technical details in non-technical terms.
  • Ability to map and understand database schema
  • Perform back-up, recovery and restoration of large datasets
  • Provide weekly and custom reports.
  • Coordinate and assist Help Desk Support Staff.
  • Assist in training staff.
  • Performs other duties as assigned.
:
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

  • Experience in Writing T-SQL scripts and complex queries
  • Experience working with Microsoft SQL Server 2003, 2008 and newer
  • Experience mapping and understanding database schema
  • Experience performing back-up, recovery and restoration of large datasets
  • Proficient in writing database triggers, stored procedures, SSIS (integration services), SSRS (reporting services) and DTS (data transformation services) Great Plains, Tessitura, Forecaster and Management Reporting
    Background in Accounting or Finance is highly desirable.

Education:

  • Bachelor of Science in Information Technology or Computer Science with a concentration in Database Administration, or an equivalent combination of education and training.

Experience:

  • Minimum of 4-7 years’ experience in Information Technology or in a related position.
  • Minimum of 2 years supervisory experience of Information Technology personnel.

Certifications:

SQL Certification from Microsoft is preferred.

This entry was posted by Megan Huck. Bookmark the permalink.

About Megan Huck

At Shedd Aquarium, animals connect you to the living world, inspiring you to make a difference. That’s our mission. This is how we fulfill it: We’re cool teachers, creating experiences in which learning is fun. We’re dedicated stewards, caring for animals, people and the living world. We’re great managers, running a model organization. And it goes deeper, to the fundamental ways in which we act towards our guests and each other: Teach and learn something every day. Create an environment of fun. Be a connection to the collection. Be courageously creative. Be passionate. Whatever the job — feeding the fishes, training the whales, teaching a class, answering a guest’s question, creating a menu, planting a garden, sweeping the floor — we do it with a sense of stewardship, quality, integrity and respect. Count on it.