Database Development, Management and Administration – Responsible for analyzing system requirements and developing and optimizing database objects to meet those requirements. Works in conjunction with server admin team members to install, configure, upgrade, and maintain the performance of database servers and their related application servers. Defines users and enables data distribution to the right user, in appropriate format and in a timely manner.  Implements, and abides by policies, procedures, and standards to ensure the integrity and availability of systems. Designs, creates, and manages maintenance plans for backups, database updates, etc. per industry best practices. Provides proactive and reactive data management support and training to users. Creates automations for repeating database tasks and monitors scheduled job execution. Troubleshoots any errors that occur and monitors job performance.

Integration Development and Support - Designs and implements required integrations between databases. Monitors integrations to ensure compliance with business processes and updates integrations as necessary when requirements or systems are updated.

Reporting and Data Integrity - Designs, creates, and manages database reports, visualizations, and dashboards. Responsible for development & documentation of queries & routines to extract management information. Develops, documents & maintains standard system reports to ensure correct data relationships are represented. Assists users with creation of ad-hoc reports.  Oversees and designs tests and evaluations regularly to ensure data security, privacy, and integrity. Facilitates real time and/or batch updating of data; testing and correcting data for inconsistencies, redundancies, and other undesirable states; analyzing for data anomalies and correcting problems to ensure optimal performance and integrity of systems.

Maintenance, Support and Documentation – Provides necessary on-call and support coverage with little assistance in resolving problems. Troubleshoots applications and maintains systems. Works with system admins and other team members to ensure optimal performance & system integrity.  Provides system support documentation for future issue resolution.  Consults with software vendors regarding system functionality, enhancement requests, issues and planning for upgrades and future releases. Tracks issues, work performed, and outcomes in ticketing system. Creates and maintains internal documentation on processes, common issues, resolutions, etc.

Perform other duties (as assigned by supervisor).

NOTE: Management retains the right to modify or add duties at any time.

NORMAL WORK SCHEDULE:

Master’s degree, or four years proven experience working with databases, integrations, and enterprise applications.

Knowledge and experience with the following:

• Relational database design and development (PL/SQL, etc)
• Relational and dimensional data modeling
• Database management/developer tools, (SSMS, SQL Developer, etc)
• Database migration and data integration/ETL tools, such as SQL Server Integration Services (SSIS)
• Programming languages such as PHP, Python, Powershell, C#, Javascript, etc.
• Knowledge and experience using project/ticket management systems
• Knowledge and experience using version control (Git, SVN, etc)
• Effective communication skills, both verbal and written
• Demonstrated planning and organization skills
• Demonstrated interpersonal skills
• Demonstrated ability to handle multiple projects or tasks simultaneously
• Ability to work as part of a team in a multi-cultural environment