Cloud DBA Lead (Gurugram)

Role & responsibilities - Work with business partners and stakeholders to understand data requirements. - Knowledge of Database fundamentals, SQL, and distributed computing. - Proficiency in more than one of the following scripting languages: SQL, Python, Csharp/C++/C, Java, Golang, and other up-to-date languages. - Perform code versioning and code deployments for data pipelines. - Knowledge of IaC technologies like Terraform, and CI/CD technologies like Ansible, Chef, Puppet, etc. to partner with DevOps to build CI/CD pipelines associated with RDBMS-related elements of the overall IaC platform. - Knowledge of container build process and container orchestration tools, such as with Docker or Kubernetes, within CI/CD environments to realize IaC. - Demonstratable experience writing complex, highly optimized SQL queries across large data sets. - Develop and implement data quality checks, database monitoring/optimizing routines, and assist with data quality checks and metrics, as part of performance monitoring of data infrastructure. - Design, develop, and implement large-scale, high-volume, high-performance data models. Familiarity with pipelines for time series databases a plus. - Proficiency working with multiple vendor DBMS platforms, with experience in one or more of PostgreSQL, MySQL, SQL Server, and data warehouses (i.e., Snowflake, Redshift, Vertica, Oracle, etc) - Experience with cloud providers such as AWS, and familiarity with one or more hosted technologies such as S3, DynamoDB, RDS, Redshift, Aurora, and DMS - Desired experience with ETL tools, database migration from on-premises to Cloud, and cloud-hosted technologies for database service management. Required Qualifications: - Bachelors degree in computer science or a related field. - 8-11 years of experience in database administration, information technology, database architecture, or a related field. - Experience with MySQL/Postgres/Aurora/MsSQL server tuning, query optimization, replication strategies, storage engines, monitoring, capacity planning, backups, recovery, HA, Clustering, etc. - Ability to develop procedures, processes, and conventions to standardize database operations. - Proficient in one of the scripting languages (shell, Perl, PHP, Python etc) for monitoring and custom automation. - Good understanding of relational and dimensional data modeling Preferred Tech Stack: - Time series data in SQL - No SQL - Influx dB - Redshift - Vertica - Redis - PostgreSQL - SOC2 - Experience with cloud services (AWS, Microsoft Azure) .