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