Senior 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 Senior Database Administrator is responsible for all aspects of the operations, management, and maintenance of the Company’s MySQL databases including, but not limited to: installation, updating, security administration, proactive monitoring, support, troubleshooting, recoverability, and failover. The Senior Database Administrator will partner with Engineering to review new database implementation requests, provide feedback, and ultimately deploy and maintain these requests.

In addition to supporting MySQL databases, the Database Operations team is responsible for supporting other technologies in varying degrees, including Oracle, Pentaho reporting and Informatica. Additionally, the Company continuously evaluates new database tools and technologies and the Senior Database Administrator will participate in these evaluations and proof of concept projects. Finally, 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 Senior Database Administrator may be asked to train on and support these technologies. * Ensuring 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. * Database performance troubleshooting and tuning * Troubleshooting nightly ETL jobs. * Develop database backup and recovery processes and procedures and test quarterly. * 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 * Five years in technical, database related roles with administrator experience. * 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.