Specialist Database Administration

Job Description

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.