Central Business Solutions, Inc

SaaS Database Engineer (BB-84676)

Found in: Talent IN

Position Role/Tile: SaaS Database EngineerLocation: Hyderabad or Bangalore​  About the rolePerform core database administration functions, viz. provisioning, optimizing configuration settings, database security, data protection, data archival, networking, Architecting, Storage and Capacity Planning.Design Database solutions and propose optimal database technology based on the application/business requirements and workload characteristics.Design Database High Availability architecture - Active/Passive, Active/Active, Sharding, Distributed databases to maintain 99.99% availability SLAStrong Experience in Database performance tuning, identifying bottlenecks, query tuning minimizing response time meeting performance SLAs as per business requirements. This requires close collaboration with Product Architects.Troubleshoot & Diagnose complex database issues, perform root cause analysis, propose fixes, identify resolutions, determine failure trends and mitigation strategies.Advanced scripting experience to automate processes and routine DB maintenance tasks using Ansible, Shell Scripts, Python, etc.Hardening & Security of Databases.Evaluate newer database technologies, upgrades, hot fixes, patches.Experience in database capacity planning, data lifecycle management, growth estimation, scaling (horizontal/vertical) infrastructure to meet business demands.Designing custom monitoring solutions – Prometheus, Grafana, and other monitoring toolsExperience working in any or multiple cloud technologies including Google Cloud(preferred), Azure, AWS and managing databases within both private and public cloud environmentsHow You'll Stand Out:Minimum 7-10 years of solid experience in various database technologiesProficient in MongoDB and having wide range of knowledge including:Deployment and Working expertise of Single and Multi-Datacenter HA solutions: MongoDB Replica Set and ShardingMaintaining very large clusters with multiple shards (100+ nodes); Knowledge of Shard keys, hashed and ranged shardingKnowledge of MongoDB Query Language, Storage engines (esp. WiredTiger), CRUD operations, aggregationsExperience in diagnosing and resolving multiple issues, upgrading to later versionsProposing best practices for schema design, backup & recovery strategiesTuning MongoDB to achieve high performance, read consistency, and write durabilityExperience in assessing performance of locking in transactions, tuning memory and cache, connection handling, wired tiger configuration and tuningExperience in using database profilers, sampling slow operationsKnowledge of creating chunks in Sharded cluster (if required), splitting/merging chunksExpertise in resolving replication gaps, fixing issues with replica sets, improving replication performanceMongoDB Enterprise tools: Ops Manager, etc.Proficient in PostgreSQL and having deep knowledge and experience in:Providing PostgreSQL database architecture solutionsDesigning PostgreSQL HA models – Streaming Replication, Logical Replication, Patroni, Slony, etcd, BDR, PG Logical experience (Experience with tools like Patroni is a huge plus)Supporting PostgreSQL databases in a high-volume customer facing environmentDeep understanding of SQL query execution, execution plan analysis & optimization, and index tuning strategiesAdvanced practical knowledge in database monitoring, diagnosing and tuning for high performanceImplementing standard methodologies for DR and BackupsUpgrading/Patching, Monitoring and troubleshootingMeasuring and optimizing system performance - Capacity planning and forecast managementExperience in Oracle to PostgreSQL migration is an added advantageExperience with other database technologies will be a huge plus - MySQL, Cassandra, Elastic Search, OracleA passion for automation to reduce repeatable mundane day-to-day tasks and improve consistency and in results.Expertise in Performance tuning, SQL TuningPerformance Tuning and SQL Tuning for production MongoDB, PostgreSQL databasesPSR – Performance and Stress Testing and Benchmarking using tools like swingbench, sysbench etc.Data Lifecycle Management, Data Archival, Data RedactionExperience in any/combination of Monitoring tools – PMM (Percona), OEM, Atlas, MongoDB Cloud Manager, Prometheus, Grafana, Alert ManagerExperience with Migration of Database Platforms – Oracle to PostgreSQL, MS-SQL to PostgreSQL, Aurora to MySQL etc. is preferredExperience migrating large data sets, production workloads from AWS/Azure to Google Cloud and from Private Cloud to Public Cloud.Perform zero downtime migrations from different database platforms (Oracle to PostgreSQL) and migrations from colo to cloud with zero to minimal downtime.Experience with Kubernetes, OpenShift, Google Kubernetes Engine is an added advantageExperience with running large databases on containers within Kubernetes/GKE clusterDevOps Experience with technologies such as Docker, Containers, Jenkins, CI/CD pipeline, gitopsParticipate in new technology/feature evaluation, design, and development of highly scalable distributed databasesAbility to do performance benchmarking between either two versions of same database technology or two different database technologiesAptitude to independently learn new technologiesExperience with documentation of standard procedures, architecture, design and deploymentsAbility to thrive in a fast-paced, tight deadline delivery environmentStrong communication skills and ability to work effectively across multiple business and technical teamsCentral Business Solutions, Inc,37600 Central Ct.Suite #214Newark, CA 94560.

calendar_today3 days ago


location_on Hyderabad, India

work Central Business Solutions, Inc

I expressly authorise the Terms and Conditions

Similar jobs