Senior Database Administrator

At American Equity Investment Life Holding Companywe offer leading annuity products that help empower our clients to fulfill their needs and wants in retirement. Our success comes from hiring high-energy individuals who embody the beliefs that drive our unique culture. We currently fund over half a million retirements nationwide, and have been headquartered in West Des Moines, Iowa, for over twenty-five years with satellite offices in Charlotte, NC and New York, NY.

GENERAL PURPOSE OF THE JOB:

The Senior Database Administrator provides operational database administration across multiple database platforms.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

• Takes the lead on incoming projects and tasks as well as leading other team members as needed to ensure the on-time completion of the projects and tasks

• Creates requirements, scope and estimates for database projects.

• Part of an on-call rotation.

• Manages administration of SQL Server data platform.

• Works with database platforms including Postgres & Snowflake.

• Develops and maintains new or existing database systems.

• Supports and assists Developers with SSIS packages.

• Writes and maintains documentation on databases and processes.

• Builds DBMS instances and creates databases.

• Troubleshoots system issues.

• Performs and tests DBMS Server upgrades.

• Installs DBMS Server patch releases.

• Performs system upgrades prior to systems EOL.

• Manages, monitors and maintains company databases.

• Performance tunes queries and tables.

• Monitors database backups and implements database security.

• Develops and optimizes physical design of database systems.

• Manages users and user group access to objects in Informatica repositories.

• Manages Informatica platform global/local security levels.

• Automates administrative tasks.

• Ensures proper configuration of the Informatica components.

• Contributes to technical and system architectural planning.

• Provides status reports on all completed, on-going and future projects in order to keep management updated on progress.

• Interfaces with outside vendors.

• Assists Developers with DBMS code issues as needed.

• Continue to develop and maintain systems used for database monitoring and alerting.

• Performs other related work as assigned.

SUPERVISORY RESPONSIBILITIES:

Direct Reports: 0

General Description of Indirect Reports (2 and 3-downs): 0

EDUCATION AND/OR EXPERIENCE:

• Bachelor's degree in Information Technology, Computer Science or other related field of study; plus, a minimum of ten (10) years of progressively responsible related experience; or equivalent combination of education and/or experience.

• Eight (8) years of MS SQL database experience required.

• Five (5) years performance tuning and optimization required.

• Experience working with Azure SQL required.

• Experience working in AWS preferred

• Experience working with Snowflake platform preferred.

• Experience working with PostgreSQL preferred

• Experience administering an Informatica platform domain preferred

• Experience working in Insurance industry preferred.

CERTIFICATES, LICENSES, PROFESSIONAL DESIGNATIONS:

Microsoft Certified Database Administrator preferred

KNOWLEDGE, SKILLS AND ABILITIES:

• Knowledge of the principles, practices, methods, and techniques associated with administration of database systems.

• Outstanding customer service orientation and interpersonal skills.

• Effective verbal and written communication skills with ability to effectively present information and respond to questions from groups.

• Exhibits professionalism in all situations.

• Ability to adapt to change, delays and unexpected events.

• Mathematical skills and strong attention to detail.

• Strong organizational, planning skills and attention to details.

• Strong analytical and problem-solving skills: ability to define problems, collect data, establish facts, and draw valid conclusions on practical problems that deal with a variety of concrete variables in situations where only limited standardization exists in a timely manner.

• Proficient in the use of Microsoft Office Suite.

• Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations.

• Takes initiative and follows through with work.

• Ability to work cooperatively and successfully with employees, customers, and other outside third parties.

• Ability to successfully handle pressure and meet deadlines in a fast-paced work environment.

• Minimal to no travel is required in this position.