DATABASE ADMINISTRATOR - SENIOR

Required skills - PostgreSQL,MySQL and MongoDB Must-Have Skills:• Extensive hands-on PostgreSQL administration (minimum 4 years, production systems)• Experience with MySQL and Oracle administration (production)• Query optimization and troubleshooting across PostgreSQL and MySQL• Experience with database migrations (on-prem to cloud)• Performance tuning using tools and EXPLAIN plans• Experience with AWS RDS and other DBaaS solutions• Scripting in Shell/Unix for database automation and monitoring• Hands-on replication setup and maintenance• Experience supporting 24/7 production websitesNice-to-Have Skills:• MongoDB cluster administration• Cloud-native DBaaS architecture design• Experience in Agile/CI/CD/DevOps environments• Knowledge of database security best practices• Automation/orchestration tooling for DBaaSTechnical Screen Topics:• PostgreSQL backup and restore strategies• Query performance tuning and indexing• Replication (logical and streaming) and failover• Troubleshooting slow queries (EXPLAIN/ANALYZE)• Database migration approaches and tools• Capacity planning and forecasting• Security hardening and access controlRelevant Project Experience:• Database Performance Optimization: Monitor, analyze, and optimize PostgreSQL/MySQL using Percona PPM and Datadog. Tune queries, indexes, and resources.• Database Maintenance and Backup Strategies: Design and implement robust backup/recovery for AWS and on-prem. Maintain scripts, schedules, and perform maintenance (vacuum, reindex, archive).• Security and Compliance: Implement access controls, encryption, apply security patches, maintain audit logs, and support compliance documentation.• Database Documentation and Knowledge Sharing: Document architecture, configurations, SOPs. Create KB articles and share best practices across the team. Requisitos:Responsibilities:·      Administer and maintain PostgreSQL, MySQL, Oracle and MongoDB database systems, ensuring their availability, reliability and security.·      Monitor and forecast database capacity requirements, and make recommendations for scaling database systems.·      Orchestrate DB interactions, develop solutions that are repeatable and recyclable.·      Plan and execute data migration and data transformation tasks as needed. Likely from on-prem to cloud using open-source tools and custom scripts as needed.·      Manage cross platform data replication using open-source tools.·      Monitor and optimize database performance by identifying and resolving bottlenecks, fine-tuning queries, and optimizing system resources.·      Some non-RDBMS work likely – maintaining and troubleshooting Mongo DB clusters as needed.·      R&D + Implementation of automation & orchestration for DBaaS solutions found within our Cloud Architecture. Participate in on call rotation as defined by management.·      Maintain comprehensive documentation of database configuration, procedures and troubleshooting guides.Requirements:·      5+ years’ experience handling large scale RDBMS and no-SQL systems and related database migrations·      Proficiency in database management systems such as Postgres, MySQL, Oracle and Mongo.·      Proficiency in SQL , query optimization and troubleshooting skills across multiple database platforms.·      Familiarity with database performance monitoring and optimization tools.·      Demonstrated ability to design and implement secure, scalable and high-performance database solutions.·      Knowledge of data security best practices.·      Experience working in Cloud, Agile, CI/CD, DevOps environments a plus·      Customer oriented with the ability to collaborate with technical and non-technical stakeholders ·      Experience working with 24/7 production websites·      Excellent communication and teamwork skills.·      Experience in developing, maintaining and optimizing Shell and Unix scripts to automate routine database tasks, backups, data migrations, and system monitoring.Education/Qualifications:·      Bachelor's degree in Computer Science, Software Engineering, or related field or equivalent experience.·      4+ years’ experience with PostgreSQL (extensive Oracle/MySQL experience with a willingness to learn PostgreSQL may substitute)English - Advanced / Fluent