Senior Cloud DBA

Fourkites is seeking a professional DBA with the technical skills and knowledge that extends across Application / Server/ Storage/ Network technologies to administer a large, complex production DB environment and troubleshoot and provide system level guidance/ solutions. The role also performs effective centralized database administration for multiple databases globally.

Responsibilities

• Design, develop, implement, and maintain Postgresql & MYSQL database applications
• Design, develop, implement, and maintain NoSQL databases such as cassandra & mongoDB
• Ensure DB high availability & Proactively manage and maintain security standards and
• controls.
• Ensure to provide robust IAM solution with role based access control
• Actively seek to optimize and simplify our architecture and ensure the capacity planning & performance monitoring of databases
• Plan and execute migration of databases from one platform to another
• Perform the database upgrades, patches in a periodic timeline or as on when required without/minimal downtime
• Contribute to the creation and maintenance of disaster recovery plans
• Determine and document DB policies, procedures and standards
• Performance testing and evaluation to ensure data security, privacy and integrity
• Identification of bottlenecks and deadlock issues in databases & support for any production issues on time.
• Experience in database archival and partitioning/sharding

Required skills

• 5-7 years of experience with Database Administration for PostgreSql and NoSQL services
• Relevant certification on Azure database administration/AWS database certification will be a must and should be an expert in PostgreSql
• Must have the experience in migrating databases across platforms, ex AWS to Azure to GCP and vice versa
• Hands on Experience in Azure/AWS database service offering like Azure SQL, SQL data warehouse, Data factory, Cosmos DB and AWS RDS, Aurora, Redshift and data warehousing solutions
• Bachelor’s degree in computer science or other relevant discipline
• Experience in setting up the enterprise level database environment
• Experience in troubleshooting and resolving database problems
• Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
• Create a reliable backup strategy and experience in encryption methodologies in rest and transit.
• Ensure database backups are appropriately executed and periodic restorations are exercised to ensure backup quality.
• Knowledge of High Availability (HA) and Disaster Recovery (DR) options across the databases
• Experience in implementing operational automation using scripts
• Good Knowledge of indexes, index management, sharding and statistics
• Good knowledge of sql commands and scripting (including PowerShell)
• Good communication and documentation skills are essential
• Strong documentation skills