Senior Database Management

Role Overview:

We are seeking an experienced Subject Matter Expert (SME) with a robust background in Applications and Infrastructure management. The ideal candidate will have hands-on experience in designing, implementing, and maintaining databases, with a primary focus on performance optimization, troubleshooting, high availability, disaster recovery, and automation. With deep expertise in Open Database technologies including PostgreSQL, MongoDB, and Redis, with additional expertise in containerization and orchestration tools like Docker and Kubernetes.

 

Key Responsibilities:

1. Database Maintenance & Administration:
• Perform routine maintenance tasks including backup, recovery, patching, and performance tuning.
• Conduct standard database maintenance and administration tasks with attention to detail.
• Monitor database activity, health, and performance, using database management system software and tools to collect performance statistics.
• Optimize database performance, plan for forecast resource needs, and recommend corrective actions.
• Ensure database high availability, replication, failover, and clustering.
• Develop and configure tools to automate database administration tasks, enhancing efficiency and minimizing downtime.
• Maintain procedures and documentation for databases, ensuring compliance with standards for definition, security, and integrity of database objects.
• Implement disaster recovery strategies and maintain data integrity across environments.

 

1. Incident Management & Troubleshooting:

Handle critical escalations and complex troubleshooting for database issues.Diagnose performance bottlenecks, slow queries, deadlocks, and replication issues.Collaborate with DevOps, infrastructure, and application teams for RCA (Root Cause Analysis).

1. Backup, Recovery & Disaster Recovery:

Design and implement backup strategies and disaster recovery plans.Ensure data integrity, redundancy, and compliance with RPO/RTO requirements.

1. Database Design & Implementation:
• Design and architect scalable, high-performance database systems for enterprise applications.
• Implement database schemas, indexing, and optimization techniques to improve efficiency.
• Manage database configuration, including installing and upgrading software, and maintaining relevant documentation.

 

1. Containerization & Orchestration:
• Manage databases using Docker and Kubernetes to ensure scalability and resilience.
• Optimize containerized database solutions for performance optimization.
• Implement CI/CD pipelines for automated deployment and maintenance of databases within containerized environments.

 

1. Collaboration & Communication:
• Work closely with application teams to ensure seamless integration and optimal performance by understanding business logic, data models, and query patterns.
• Optimize database schema and queries for application performance improvement.
• Provide guidance on database best practices for developers and architects.
• Collaborate with team members to address user needs, providing timely issue resolution and guidance.
• Interact with customers, suppliers, and partners to deliver effective database maintenance.
• Make substantive contributions to discussions, planning, and implementation of database management improvements.

 

1. Monitoring & Reporting:
• Continuously monitor database performance statistics and generate reports to communicate findings and recommendations.
• Identify and investigate complex issues, proposing effective corrective actions.
• Utilize monitoring tools and frameworks to ensure proactive database management.
• Automate patching, backups, and deployments using scripts (Bash/Python) and configuration management tools (Ansible, Terraform).

 

1. Security & Compliance
• Implement database security best practices, including access controls, encryption, and auditing.
• Ensure compliance with GDPR, HIPAA, SOC2, and other regulatory standards.

 

1. Documentation & Reporting:
• Maintain comprehensive documentation of database architectures, processes, maintenance plans, and troubleshooting guides.
• Prepare reports detailing system health, performance metrics, and improvement plans.

Required Skills and Qualifications:

• Database Technologies: Deep knowledge of PostgreSQL, MongoDB, and Redis.
• Containerization & Orchestration: Hands-on experience with Docker and Kubernetes for deploying and managing databases.
• Application & Infrastructure Integration: Strong understanding of application and infrastructure interoperability, microservices, API interactions, and application workflows.
• Performance Tuning & Optimization: Proven experience in performance tuning, query optimization, system monitoring, and caching mechanisms.
• Maintenance Automation: Expertise in scripting and developing tools for automated maintenance tasks.
• Analytical & Problem-Solving Skills: Excellent troubleshooting capabilities with the ability to recommend effective solutions.
•  High Availability & Disaster Recovery: Backup, failover, replication, and multi-region deployments.
• Security & Compliance: Database encryption, access controls, auditing, GDPR/HIPAA compliance.
• Collaboration & Communication: Ability to work effectively within cross-functional teams and present technical concepts to non-technical stakeholders.
• Documentation: Strong documentation skills for architectures, procedures, and troubleshooting guides.

About Nomiso:

Nomiso is a product and services engineering company. We are a team of Software Engineers, Architects, Managers, and Cloud Experts with expertise in Technology and Delivery Management. 

Our mission is to Empower and Enhance the lives of our customers, through efficient solutions for their complex business problems. 

At Nomiso we encourage entrepreneurial spirit - to learn, grow and improve. A great workplace, thrives on ideas and opportunities. That is a part of our DNA. We’re in pursuit of colleagues who share similar passions, are nimble and thrive when challenged. We offer a positive, stimulating and fun environment – with opportunities to grow, a fast-paced approach to innovation, and a place where your views are valued and encouraged.

We invite you to push your boundaries and join us in fulfilling your career aspirations!

We are an equal opportunity employer and are committed to diversity, equity, and inclusion. We do not discriminate on race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, disability status, or any other protected characteristics.