Desired Skills and Experience
- Installs, maintains, and manages significant database servers across relational, NoSQL, Hadoop and big data technologies
- Design and automate solutions on storage, availability & scalability (replication, cluster)
- Consults with development and test teams around best practices for storage efficiency and performance
- Perform database admin activities such as cluster installation, backup, replication, recovery, upgrade as required
- Troubleshoot, optimize/tune dB queries for high performance
- Provides support for performance test teams and production operations to solve database-related performance and operational problems
- Design and automate data migration whenever required
- Write scripts to support specific requirements/automation
- Perform daily monitoring/health check of production database clusters
- Design and develop solutions for security
- Develop Self-Service tools that enable DevOps teams to troubleshoot and maintain performance
- Provide capacity planning of system resources to support database growth
- Investigate and provide thought leadership into leveraging cloud-based solutions
- Expert knowledge in managing Postgres environments
- Expert in designing, implementing and maintaining large data environments
- Proven expertise in managing medium to large sized production clusters/databases across multiple database technologies like Oracle, SQL Server, Teradata, Cassandra, MongoDB etc.
- Demonstrated experience with relational and NoSQL database implementation/administration, performance tuning, high availability & scalability, replication, clustering, data migration, performance, query monitoring, optimization
- Strong understanding of Big Data/Distributed Database concepts, NoSQL schema modelling, scaling database architectures etc.
- Demonstrated experience in Hadoop HDFS and HBase
- Working knowledge in cloud and on-prem deployments
- Experience with Linux shell scripting
- Chef, Puppet, CF Engine Experience or other automation tool a plus
- Good team player with strong analytical, communication, documentation skills
- Bachelor’s degree in Computer Science or related field, or equivalent training and experience