Database Engineer
ThinkMarkets has an exciting opportunity for an experienced Database Engineer to join our Chicago office. This position will be responsible for working with customers to define requirements and analyzing business and technical processes to design application functionality that will be accessible by internal customers from various branches across the globe. The ideal candidate must be a self-starter and work well with others, as well as have excellent written and verbal communication skills to effectively interact with all stakeholders. A successful candidate will apply extensive technical expertise of databases and data warehousing and will develop technical solutions to complex problems with ingenuity and creativity.
Responsibilities:
- Define standards and frameworks for data architecture design
- Formulate event modelling; conceptual, logical, and physical data warehouse design; data warehouse optimization and performance; load strategy design and implementation; change management
- Perform data profiling and analysis to assess data quality patterns, recommend data cleansing rules – conforming data standard rules and matching algorithms
- Implement and enforce database security based upon best practice, industry regulations, and company policies
- Perform SQL Migrations to new Servers and configure and setup BI tools (SSRS, SSIS etc.)
- Work with System/Network Administrators to develop and maintain the replication, backup, and restoration of data within the system
- Develop custom queries and reports for data modelling through various tool sets to aggregate, analyze, and report results
- Maintain clustered, highly redundant database environments
- Develop, implement, and maintain MySQL database structures in test, quality assurance, and production environments utilizing current standards policies and procedures
- Manage backup/recovery for MySQL instances and provide Disaster Recovery (DR) support
- Implement and enforce database security based upon best practice, industry regulations, and company policies
Requirements:
- Degree in Computer Science or an equivalent combination of education and experience
- 5+ years of experience in database engineering
- Experience in SQL, Database Development, and cloud integration (AWS or Azure)
- Experience with PostgreSQL, Cassandra and MongoDB
- Experience and advanced knowledge of security and management of databases
- Experience with deploying databases on a global scale
- Experience working with Real-Time/Time Series databases
- Experience with database administration and design of enterprise database systems. (Influx DB and Redis-AWS)
- Experience with utilizing database performance analysis tools: SolarWinds or Redgate
- Experience with BI and Tableau is a plus