Key Roles and Responsibilities:
- Database Maintenance and Management:Oversee the configuration, installation, maintenance, and upgrade of database software and related components to ensure database reliability, availability, and performance.
- Performance Tuning and Optimization:Perform database tuning, performance monitoring, and optimization using various techniques to ensure efficient database operation.
- Troubleshooting and Problem Resolution:Diagnose and resolve database issues promptly, ensuring minimal downtime and maintaining high availability.
- Backup and Recovery:Manage database backups, recoveries, and disaster recovery plans to safeguard data integrity and availability.
- Compliance and Security:Ensure databases meet compliance, security, and confidentiality standards by managing access controls, applying necessary patches, and monitoring for vulnerabilities.
- Automation and CI/CD:Design and execute processes to perform upgrades and other maintenance tasks using tools like Jenkins, Docker, and Kubernetes.
- Cloud Integration:Utilize cloud platforms such as Azure for database management and infrastructure services.
- Data Replication:Implement and manage data replication solutions using Oracle GoldenGate.
Required Qualifications:
- Bachelor s degree in computer science, Information Systems, or related field.
- 6+ years of experience in Database, Data Management, or Engineering roles.
- 4+ years of progressive experience in high volume/high transaction data administration.
- 4+ years of experience with relational databases such as Oracle, MySQL, or PostgreSQL.
- 4+ years of experience in performance tuning and database monitoring.
Preferred Qualifications:
- 2+ years of experience managing NoSQL databases such as Cassandra, MongoDB, or CosmosDB.
- 2+ years of experience in the architecture and design of data systems using multiple data platforms.
- 2+ years of experience with Redis, SOLR/ElasticStack.
- Proficiency in Unix/Linux command line.
- Experience with Oracle GoldenGate for data replication.
- Experience working within Agile/Scrum/Kanban development teams.
- Excellent written and verbal communication skills with the demonstrated ability to present complex technical information clearly to peers, developers, and senior leaders.
Technical Skills:
- Databases:Cassandra, PostgreSQL, CosmosDB, MongoDB, Oracle.
- Messaging and Caching:Redis.
- Search and Monitoring:Solr, ElasticStack, Prometheus/Grafana.
- CI/CD and Containerization:Jenkins, Docker, Kubernetes.
- Data Replication:Oracle GoldenGate.
- Cloud Platforms:Azure.
- Patching and Vulnerability Management:Applying database patches and managing vulnerabilities to maintain security and performance.
