Intercontinental Exchange - Atlanta, GA

posted 4 months ago

Full-time
Remote - Atlanta, GA
Securities, Commodity Contracts, and Other Financial Investments and Related Activities

About the position

The Database Administrator is a critical role within our organization, responsible for the implementation, testing, maintenance, and control of our databases, messaging, and caching systems across various platforms and technologies. This position requires a technology enthusiast with strong technical, organizational, and analytical skills, particularly with exposure to SQL and No-SQL database technologies. The successful candidate will troubleshoot and resolve issues in both production and non-production environments, ensuring the smooth operation of our database systems. In this role, you will be part of the Global DBA Team, where you will handle DBA tasks while also maintaining and administering the overall infrastructure. You will be responsible for the change and release management process for software developments and implementations. Your responsibilities will include building and configuring database and non-database environments, ensuring availability, and providing day-to-day database support. You will also design, evaluate, and optimize database objects in collaboration with the Development and Engineering teams. Your duties will encompass the installation, maintenance, backup, recovery, and monitoring of databases, as well as following change management procedures for all database-related changes. You will prepare and maintain documentation of developed procedures and best practices, configure monitoring systems, and proactively review statistics for errors, capacity, and performance issues. Additionally, you will engage in programming and scripting in various languages, including shell scripting, to accomplish assigned tasks. Performance tuning of queries, indexes, stored procedures, and functions will also be part of your responsibilities, along with monitoring and analyzing system performance and conducting cost analysis for users.

Responsibilities

  • Build and configure database and non-database environments.
  • Ensure availability while providing day-to-day database support.
  • Design, evaluate, and optimize database objects in conjunction with Development/Engineering teams.
  • Installation, maintenance, backup, recovery, and monitoring of databases.
  • Follow change management procedures for all database-related changes.
  • Prepare and maintain documentation of developed procedures and best practices.
  • Configure monitoring and proactively review statistics for errors, capacity, and performance issues.
  • Programming and scripting in various languages including shell to accomplish assigned tasks.
  • Performance tuning of queries, indexes, stored procedures, and functions, making recommendations regarding enhancements and improvements.
  • Monitor and analyze system performance, perform cost analysis for users, and conduct systems testing.

Requirements

  • Bachelor's degree in computer science or a related discipline, or equivalent technical knowledge.
  • 2+ years of Database Administration experience supporting one or more database technologies such as Oracle, MySQL, MariaDB, PostgreSQL, MongoDB, Cassandra, or similar technologies.
  • Exposure to Kafka, Redis, ELK or similar technologies is a plus.
  • Good knowledge of Linux/Unix operating systems is required.
  • Strong programming skills in languages such as Python, Java, C/C++, or Perl, preferably in a database context.
  • Understanding of system architecture and system administration tasks is a plus.
  • Excellent problem-solving, issue identification, analytical, and technical documentation skills.
  • Strong interpersonal skills and ability to work well in a team environment.
  • Good written and verbal communication skills.
  • Willingness to take on-call rotation including weekend work.

Nice-to-haves

  • Exposure to Kafka, Redis, ELK or similar technologies.
  • Understanding of system architecture and system administration tasks.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service