Database Administrator at Appzone Limited

Job Opening ID: 255

Job Description

• Provide sound, professional database advice, administration and proactive maintenance of the company data and database environments.
• Support the process for database architecture, installation, configuration, and management, while ensuring prompt and thorough backup, recovery, replication, and high availability.
• Perform optimization, including the writing of query, indexing, and optimization techniques to ensure efficient data retrieval and manipulation.
• Carry out database design, data modeling, and normalization to ensure scalable and performant database structures.
• Monitor, analyze, and optimize database performance, troubleshoot issues, and resolve problems related to query performance, indexing, and resource utilization.
• Set up procedures to monitor all database environments and ensure a minimum of 99.9% uptime.
• Work with the team to resolve issues and escalate extreme cases to the appropriate OEMs.
• Recommend new database and data architecture which would yield cost saving and enable increased growth of the revenue of the organization.
• Ensure periodic security checks on the database systems to prevent fraud and expose any compromise attempt noticed on the database.
• Ensure and test performance level on the databases and ensure compliance with data protection regulations and industry best practices.
• Plan Business Continuity operations and Disaster Recovery Operations to meet the required RTO and RPO as defined by the organization.
• Manage and maintain databases, ensuring high availability, performance, and security.
• Design and implement backup, recovery, and disaster recovery plans, and optimize server databases for efficiency and scalability.
• Troubleshoot database issues and implement long-term solutions; maintain database documentation, procedures, and governance policies.
• Collaborate with development teams to improve database architecture and optimize queries.
• Monitor disk usage, system performance, and capacity planning; update and maintain repositories with database-related code and scripts.

Requirements

• B.Sc in Computer Science, Information Technology or any related discipline.
• 3+ years’ experience in Database Administration or a related data role, preferably within the financial services, technology or fintech industry.
• Experienced in SSMS, TOAD, Jupyter, Anaconda and other data related tools.
• Microsoft Certified Professional or Oracle Certified Professional (i.e., Any RDBMS certified professional certification).
• Experience in leading a team of database administrators, with problem-solving and analytical skills, with a strong willingness to learn new technologies.
• Passionate about Data and Databases with strong data interpretation skills.
• Structured Query Language skills (SQL), Procedural SQL, TSQL Programming; Python Programming, Excel Skills, and Bash Scripting.
• Familiarity with cloud database technologies (Azure SQL, AWS RDS, or Google Cloud SQL) is a plus.
• Strong proficiency in Microsoft Office tools (Word, Excel, PowerPoint).
• Strong knowledge of Postgres database architecture, installation, configuration, and management, including backup and recovery, replication, and high availability.
• Proficiency in SQL, including query writing, indexing, and optimization techniques to ensure efficient data retrieval and manipulation.
• Knowledge of database design principles, data modeling, and normalization techniques to ensure scalable and performant database structures.
• Ability to monitor, analyze, and optimize database performance, troubleshoot issues, and resolve problems related to query performance, indexing, and resource utilization.
• Knowledge of Postgres security features, including user authentication, authorization, and access control, to ensure data privacy and protection.
• Ability to manage multiple priorities, troubleshoot complex data issues, and provide solutions.
• Excellent communication, documentation, and high attention to detail.