Database Administration Intern
Are you applying to the internship?
Job Description
About American Equity Investment Life Holding Company®
American Equity Investment Life Holding Company® is a leading provider of annuity products designed to empower individuals in their retirement planning. With a strong commitment to its employees, the company fosters a unique culture by hiring high-energy individuals who embody its values.
Key Highlights:
• Headquartered: West Des Moines, Iowa for over 25 years.
• Satellite Offices: Charlotte, NC and New York, NY.
• Impact: Funds over half a million retirements nationwide.
• Summer Internship Program: Offers a real-world experience mirroring the career journey of an American Equity professional.
Database Administration Internship Description
General Purpose:
The Database Administration internship provides hands-on experience managing and optimizing a variety of database platforms, including PostgreSQL, Microsoft SQL Server, Snowflake, Pervasive, and DynamoDB. Interns collaborate with a dynamic team to enhance database performance, ensure robust security, and support network and server administration efforts.
Essential Duties and Responsibilities:
• Shadowing: Learn essential duties and functions of a Database Admin through observation.
• Performance Optimization: Fine-tune SQL queries to enhance performance for business users, report generators, and developers.
• Documentation & Building: Create and maintain comprehensive documentation on database systems and processes. Build and configure database management systems (DBMS) instances.
• Troubleshooting & Upgrades: Diagnose and resolve system issues. Perform and test upgrades for DBMS servers.
• Collaboration: Work with data architects, engineers, and developers to establish, maintain, and monitor data networks.
• Migrations & Conversions: Oversee database server migrations and develop conversion scripts between different platforms.
• Management & Security: Monitor, manage, and maintain database performance, security, and functionality.
• Design & Optimization: Develop and refine the physical design of database systems. Manage user access and assist with ETL tool repositories such as Informatica and SSIS.
• Automation & Reporting: Automate routine administrative tasks. Provide detailed status reports on ongoing and upcoming projects.
• Other Related Work: As assigned.
Qualifications:
• Actively pursuing a bachelor’s degree in Computer Science, MIS, Mathematics, Information Management, or a related field.
Skills & Abilities:
• Communication: Strong verbal and written communication skills, with the ability to present complex information clearly and effectively.
• Adaptability: Ability to handle change, unexpected events, and pressure with professionalism and poise.
• Analytical Mindset: Strong problem-solving skills with a keen attention to detail. Adept at analyzing data and drawing actionable insights.
• Technical Proficiency: Comfortable with Microsoft Office Suite and capable of interpreting technical documents and business procedures.
• Team Player: Ability to work effectively with diverse teams and manage multiple priorities in a fast-paced environment.
• Customer Focus: Outstanding customer service skills with a commitment to excellence in all interactions.
• Initiative: Proactive and dedicated to completing tasks efficiently and effectively.
• Simplicity in Communication: Skilled at breaking down complex concepts into easy-to-understand terms.
