Sr. Data Platform Administrator
JOB DUTIES AND RESPONSIBILITIES:
* Serve as a core member of our data platform administration team while supporting and operating key aspects of infrastructure services including security, capacity planning, availability, and performance.
* Create and maintain scalable infrastructure in the Cloud and in our On-premise Data Center
* Research and deploy new tools and frameworks for the Data and Analytics platform
* Administer relational databases, data warehouses and NoSQL databases
* Plan and perform database configuration, maintenance, upgrade and patching
* Perform and manage system and database backups
* Perform manual switch to redundant system / database components, in case of system failure
* Create and maintain data modeling artifacts including conceptual, logical, and physical data models, data dictionaries, and source to target mappings
* Develop infrastructure as code using tools such as Terraform or CloudFormation
* Orchestrate container deployments with Kubernetes
* Develop pipelines in our CI/CD system
* Monitor, collect statistical information, and provide reporting on capacity and system performance
* Monitor the system, and act upon system and application automated alerts
* Perform diagnostics, testing, and troubleshooting of software, o/s, and database issues (ex. correcting installation, configuration, or data problems)
MINIMUM REQUIRED KNOWLEDGE, SKILLS, AND ABILITIES:
* 3+ years of DevOps experience in AWS (consideration will be given if the candidate has equivalent experience with other Cloud providers)
* 3+ years of experience physical data modeling (relational, dimensional data modeling)
* 3+ years of experience administering relational databases (PostgreSQL, SQL Server, DB2) and data warehouses (RedShift, Snowflake, Netezza, Teradata, Exadata)
* Experience designing, developing, deploying, testing in the AWS ecosystem, including some of the skills listed:
- IaaS: AWS EC2, VPC, EBS, ELB, KMS, Config, SNS, SQS, SES, SWF, S3, Glacier
- Monitoring: CloudWatch (Events/Logs), IAM, CloudTrail, EC2 Systems Manager, Zabbix, IAM
- Data Management: AWS RDS, EMR, RedShift, Kafka/Kinesis, SageMaker, DynamoDB, DMS
* Experience with scripting languages such as Python or Bash
* Experience with Continuous Integration and Deployment (CI/CD)
* Experience with configuration management tooling such as Ansible, Chef, Puppet, DSC, etc
* Ability to work with multiple projects and work streams at one time. Must be able to deliver results based upon project deadlines.
BONUS KNOWLEDGE AND SKILLS:
* Experience with infrastructure as code tools such as Terraform, CloudFormation, Jinja or ARM
* Experience with Containers and Container orchestration platforms such as Docker and Kubernetes
* Experience with Git as a version control system
* Cloud Certifications