Job summary
Seeking a Principal Database AdministratorResponsible for supporting cloud Data Warehouse and Data Lake environmentsDesign, configure, and manage Data Warehouse Database Systems on Cloud
Job seniority: mid-to-senior level
Responsibilities
• Design, configure, and manage Data Warehouse Database Systems on Cloud (AWS Redshift, EMR HBase and Snowflake)• Monitor and report on performance metrics, system health, and logging compliance on database services or database appliances• Perform database administration tasks including backup and recovery, troubleshooting, performance tuning and SQL optimization• Design database schema, tune data types and data distribution for performance optimization• Configure and implement workload management for resource allocation and query event handling• Support users and troubleshoot data access applications and ad hoc queries• Develop and support shell scripts for database activities, such as data loading, unloading, and maintenance• Manage data replication, data encryption, backup storage and archiving procedures• Follow standards and best practices for availability, security, backup and recovery, and integrity of client databases on-prem and cloud• Evaluate new Data Warehousing and Analytics cloud services and technologies and recommend to technical management
Requirements
• BS in Computer Science or related technical discipline or equivalent practical experience• 10+ years of experience in general database administration• At least 6 years of experience managing and maintaining Data Warehouse technologies, such as IBM Netezza, Teradata, Greenplum or similar• At least 3 years of experience managing Cloud Data Warehouse database technologies, such as AWS Redshift, Snowflake, Databricks or similar• Proven expertise in migrating large on-prem Data Warehousing solutions to the public cloud• Strong knowledge in Hadoop eco system components such as YARN, MapReduce, HDFS, HBase, Zookeeper, Hive• Experience interacting with vendor support to ensure open issues are resolved within defined SLA• Proficiency in Data Warehousing MPP architecture, technologies, and concepts• Expert skills in writing and analyzing complex SQL queries for performance• Competence to read and interpret query plans, database statistics and database performance measurements and optimize SQL
Key Skills Needed
• Database design• Performance tuning• SQL optimization• Shell scripting• Data replication• Data encryption• Backup and recovery methodologies• Unix/Linux• Hadoop ecosystem
