Senior Database Administrator

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

 

• 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.