Database Administrator

Roles and Responsibilities:

  • Strategic Database Management:
  • Develop and implement strategies for improving the structure and efficiency of Invenco?s databases.
  • Collaborate with IT and engineering teams to ensure the database architecture meets the current and future needs of our cloud systems.
  • Lower – level admin details like Partitions, indexing , fragmentation, shading .
  • Keep the DB house kept; manage back-up large table, create back-up scripts with FK-PF references
  • Hunt the costly queries and fix them without impacting business.

  • AWS Cloud Solutions Implementation:
  • Lead the design and deployment of robust data solutions and pipelines on the AWS Cloud Platform, optimizing database performance across various environments.
  • Data Management:
  • Handle large-scale data sets, both structured and unstructured, and develop an understanding of how to manage and utilize these resources effectively.
  • Continuous Integration/Continuous Deployment (CI/CD):
  • Utilize CI/CD principles and DevOps methodologies within the database management lifecycle to enhance data delivery and operational efficiency.
  • Advanced Database Knowledge:
  • Apply expertise in data modeling, SQL/NoSQL databases, data structures, and ETL processes to improve database setups and operations.
  • Indexing, partitioning, handling large table sizes and prescribing strategies for keeping the operational size in check.
  • Technology Proficiency:
  • Experience with data integration tools, ETL frameworks, and data pipeline orchestration tools such as AWS Glue and AirFlow (Nice to have)
  • Familiarity with Snowflake and dbt is advantageous but not mandatory.
  • Communication:
  • Demonstrate excellent verbal and written communication skills, facilitating clear and effective interactions across the organization.

Critical Skills to Possess:

  • Proven experience as a Database Administrator, with extensive knowledge of database technologies including PostgreSQL, SQL Server, Oracle, MySQL, and particularly AWS database services.
  • Strong hands-on experience with relational SQL and NoSQL databases, such as PostgreSQL, and cloud database services.
  • Deep understanding of database security, backup and recovery, and cost optimization strategies.
  • Excellent analytical, problem-solving, and organizational skills.
  • Ability to prioritize effectively in a fast-paced environment.

Preferred Qualifications:

  • BS degree in Computer Science or Engineering or equivalent experience
Not sure where to start? Ask IVY.
IVY