Job brief

We are looking for a 2 – 4 years experienced Database Administrator to join our team! As a Database Administrator at our company, you will be responsible for designing, testing, planning, implementing, protecting, operating, managing and maintaining our company’s databases and troubleshooting of databases.

Responsibilities

• Provide first-level Support and maintain Postgres. MySQL database environment
• Create shell scripts and SQL scripts for database administration
• Provide appropriate resources and skill sets to support the DBA functions for the Applications as required
• Setup, maintain and test backup and recovery processes of databases
• Propose database changes to ease monitoring and administrative effort
• Document and implement changes to databases via proper Change Management methodology
• Monitor and analyze database activity to proactively identify and prevent potential Incidents and also recommend performance improvements
• Apply new patches and versions when required
• Participate in situation management of incidents related to database operations
• Be proactive in performance tuning and optimization to help improve database efficiency
• Excellent problem solver with strong attention to detail
• Enforce security measures to protect company data
• Performs database testing to ensure performance is met and compares with expected results
• Identifies gaps in scripts and procedures
• Work with Database developers and application developers to identify and resolve issues impacting production
• Assist with schema design, code review, SQL query tuning
• Collate, prepare and present statistical information for internal and external use
• Minimize database downtime and manage parameters to provide fast query responses
• Determine, enforce and document database policies, procedures and standards
• Perform tests and evaluations regularly to ensure data security, privacy and integrity

Requirements:

• Bachelor’s degree in computer science or a related information technology field 
• 2 – 4 years of experience with programming languages such as PL/SQL coding
• Easily design and implement a business process into functional and efficient code
• Implement and manage company data management practices and policies
• 2 – 4 years of experience with Postgres & MySQL
• Good understanding of joins and indexes
• Good understanding of database design, schema standards, implementation, troubleshooting and maintenance 
• AWS EC2 & RDS experience is desirable but not mandatory.
• Working knowledge of WAL management, Auto and manual vacuuming, Server configuration parameters, transactions and locks management.
• ISO 27001 and PCI knowledge would be beneficial
• Critical thinking and problem-solving skills
• Team player
• Good time-management skills
• Great interpersonal and communication skills