Principal Database Administrator

ID Analytics is a leader in consumer risk management with patented analytics, proven expertise and real-time insight into consumer behavior. By combining proprietary data from the ID Network®—one of the nation’s largest networks of cross-industry consumer behavioral data—with advanced science, ID Analytics provides in-depth visibility into identity risk and creditworthiness.

The Principal Database Administrator is primarily responsible for all aspects of the design, operational management, and maintenance of the Company’s MySQL databases including, but not limited to: design, installation, security administration, analysis, proactive monitoring, support, troubleshooting, recoverability, and failover. The Principal Database Administrator will work collaboratively across all technical functions to ensure aligned execution of database related activities and is responsible to both strategically and tactically support the organization’s database requirements.

As the most senior member of the Database Operations team, the Principal Database Administrator is also expected to support additional database technologies and tools which include Oracle, Pentaho Reporting, and Informatica. The Company continuously evaluates new database tools and technologies and the Principal Database Administrator is expected participate extensively as well as lead these evaluations and proof of concept projects. This position is responsible for recommending strategic courses of action affecting short and long-term investments. Additionally, ID Analytics is investing heavily into Hadoop and associated Big Data technologies. The Database Operations team is responsible for the administration and maintenance of our Hadoop environments and the Principal Database Administrator will be expected to oversee these environments. * Database technology identification and selection. * Database performance troubleshooting and tuning. * Troubleshooting nightly ETL jobs. * Ensuring the data is available by maximizing database uptime, performance tuning, related scripting, data scrubbing, and analysis. * Install upgrades and patches to existing database servers, both during normal business hours and off hours. * Monitor database server and application performance and tune database servers as appropriate. * Evaluate, recommend, implement and maintain database monitoring tools. * Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets. * Participate in quarterly failover to secondary datacenter and database recovery back to primary. * Login maintenance (removing old logins, creating new logins, restoring proper logins after database restore, password maintenance, etc.). * Perform database maintenance, server administration, user administration, and security audits. * Develop database backup and recovery processes and procedures and test quarterly. * Training and education for cross functional technical teams. * Support and maintain Hadoop clusters and associated tools. * Participate in on-call rotations.

* Requires a BA or BS in a technical discipline or relevant job experience. * Minimum of ten years in technical, database related roles with a proven background in database administration. * Demonstrated expertise in MySQL. * Familiar with a wide range of RDBMs and tools. * Big data tools such as Hadoop, Map/Reduce, Pig and Hive is a major plus. * Experience designing, building, installing, configuring, supporting, and maintaining high-volume large database systems. * Strong communications skills, both verbal and written, are required. * Demonstrated ability to interface well with co-workers. * Requires organizational and project management skills and ability to set and manage multiple priorities/projects. * The person filling this role will have the ability to work effectively in a team environment, as well as work independently with limited supervision. * Independently analyze, resolve, and document complex technical problems