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
BSc Degree 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.