**Database Design and Administration** **Job Description: Senior Database Administrator** We are seeking a **Senior Database Administrator** with proven experience in managing, optimizing, and securing relational and NoSQL databases in high-demand environments. The ideal candidate will be responsible for designing, implementing, and administering robust and scalable database architectures, ensuring performance, integrity, and availability. Additionally, they will lead initiatives to implement database best practices and collaborate with technical teams to resolve critical issues. **Salary:** $60,000\.00 Gross **Key Responsibilities** * Design and administer relational databases (PostgreSQL, MySQL, Oracle, SQL Server) and NoSQL databases (MongoDB, Cassandra, DynamoDB, Redis). * Create optimized schemas for performance and scalability, ensuring compliance with standards such as ACID or BASE, as required. * Configure replication, partitioning, and high availability in distributed environments. **Performance Optimization** * Perform query tuning, index analysis, and query optimization to minimize latency. * Implement caching strategies and memory management for high-volume transactional databases. * Identify and resolve database infrastructure bottlenecks using advanced monitoring tools. **Security and Compliance** * Design and implement access control and security policies to protect sensitive data. * Ensure compliance with regulations such as GDPR, HIPAA, or PCI DSS in data handling. * Conduct periodic security audits and configure encryption at rest and in transit (SSL/TLS). **Deployment and Automation** * Automate deployment, backup, and recovery processes using tools such as Ansible, Terraform, or custom scripts. * Design and manage ETL pipelines to integrate databases with analytical and transactional systems. * Implement failover and disaster recovery processes, ensuring minimal recovery time objectives (RTO) and recovery point objectives (RPO). **Innovation and Continuous Improvement** * Evaluate and propose new technologies and architectures to enhance the database ecosystem. * Document and share best practices with technical and development teams. * Collaborate with cross-functional teams to optimize data flows and ensure application scalability. **Requirements** * **Education:** Bachelor’s degree or engineering degree in Computer Science, Computer Systems, Information Technology, or related field. * **Experience:** * Minimum 7 years of database administration experience, including relational and NoSQL databases. * Experience in distributed and high-availability environments. * Proficiency with monitoring and performance analysis tools such as Prometheus, Zabbix, DataDog, or Dynatrace. * Experience in data integration and migration across different systems. **Technical Skills:** * In-depth knowledge of advanced SQL, data modeling, and distributed database architectures. * Familiarity with concepts such as the CAP theorem, eventual consistency, and partitioning patterns. * Knowledge of database cluster administration and replication. * **English:** B2 level or higher. **Benefits** * Professional development and continuous training. * Opportunity to lead strategic data management projects. * Flexible hours and hybrid work model (as required by the project). * Performance bonuses and permanent contract subject to evaluation. **Position Type:** Full-time **Expected Start Date:** Immediate Position Type: Full-time Salary: $55,000\.72 \- $62,021\.07 per month Benefits: * Salary increases * Flexible hours * Option for permanent contract Education: * Completed bachelor’s degree (Mandatory) Experience: * Database Administrator: 5 years (Mandatory) * AWS: 3 years (Mandatory) * Postgres RDS Aurora on AWS: 2 years (Mandatory) * MySQL-RDS on AWS: 2 years (Mandatory) * Healthcare/Health: 1 year (Preferred) Work Location: Remote/hybrid at 11550, Polanco IV Sección, CDMX