Specific Responsibilities include:
Installation, configuration, administration and support of database solutions, including but not limited to MySQL, Postgres, Cloudera HaDoop, MongoDB, and Oracle
Expert in understanding data structure and implementation of schemas, tables, partitions, indexes, views, stored procedures and triggers.
Expert in data preparation, ingestion/ETL/pipelining process, extraction, SQL, PLSQL, noSQL, aggregations, client accessibility to DB (ODBC, JDBC, drivers, DB UIs)
Create, maintain and ensure data integrity, availability, accessibility, security and monitoring of resources and data pipeline processes.
Understands and recommends best practices for backup, disaster recovery, redundancy, upgrades, server & query performance, capacity and storage planning.
Working knowledge of data warehousing, data lake and cloud deployments.
Provides SQL query performance reviews and advises team on proper query best practices.
Provides periodic training, feedback sessions, and reporting of DB usage, performance and future implementations.
Maintains documentation of current implementation and data pipeline processes.
Familiarity of Linux and Windows OS basic administration to support DB applications, features and functionality.
Familiarity of scripting languages such as shell, python, java, R a plus.
Working knowledge and experience of micro services, virtualization, AWS Kubernetes/ECS, Docker and serverless databases a plus.
Experience in an Agile environment utilizing JIRA/Scrum a plus.
Actively takes ownership of projects, issues, and day to day activities with minimal oversight and guidance.
Background & Competencies Required:
5+ years’ experience:
Deploying and maintaining database solutions and maintaining data pipeline processes.
Complex data manipulation, processing, ETL, retrieval, PLSQL, SQL query JOINs, Meta structure, schema and table deployments.
Database monitoring and performance management such as proper partitioning, indexing, implementing stored procedures and triggers to semi-automate aggregations and DB management processes.
3+ years’ experience:
Working with data warehousing, data lake, and cloud solutions.
Working with Linux & Windows OS to perform basic administration of files and installations to support database features and functionality.
Other:
Graduate in Computer Science with background in Wireless telecom will be a definite plus
Demonstrated research and problem solving skills via prior work experience.
Strong communication and documentation skills.
Must have a strong work ethic, integrity and work extremely well in a team environment
Must be able to perform duties in a group or individual capacity with minimal oversight or direction
Less
Specific Responsibilities include:
Installation, configuration, administration and support of database solutions, including but not limited to MySQL, Postgres, Cloudera HaDoop, MongoDB, and Oracle
Expert in understanding data structure and implementation of schemas, tables, partitions, indexes, views, stored procedures and triggers.
Expert
More..