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.

Specialist Database Administration