Staffinc is looking for a skilled Database Administrator (SysDBA) to be outsourced at our client in IT company. The ideal candidate will have extensive experience with Postgres, Oracle, or MSSQL databases, as well as a solid understanding of replication concepts, financial transaction flows, and query optimization. Proficiency in at least one programming language such as Golang, Python, PHP, or JavaScript is also required.
Key Responsibilities:
Database Management:
- Administer and maintain database systems, ensuring their performance, security, and availability.
- Manage and configure Postgres, Oracle, or MSSQL databases to meet the organization’s needs.
- Perform regular database backups, restores, and disaster recovery procedures.
Replication & Connection Management:
- Implement and manage database replication, ensuring data consistency across environments.
- Configure and maintain replication settings, including slot_name and connection pools, to optimize performance.
Financial Transaction Flow:
- Understand and manage the flow of financial transactions within the database, ensuring accuracy and compliance with industry standards.
- Monitor transaction processing to prevent errors and ensure data integrity.
Query Optimization & Performance Tuning:
- Analyze and optimize database queries, functions, and table views to improve performance.
- Develop and implement query optimization strategies to enhance database efficiency.
Programming & Automation:
- Utilize at least one programming language (Golang, Python, PHP, or JavaScript) to develop scripts for database management and automation.
- Create and maintain database-related functions, triggers, and stored procedures.
Troubleshooting & Support:
- Diagnose and resolve database-related issues, providing timely support to development and operations teams.
- Monitor database performance and implement necessary optimizations.
Qualifications:
- Bachelor’s degree in Computer Science, Information Technology, or a related field.
- Extensive experience with Postgres, Oracle, or MSSQL databases.
- Strong understanding of database replication concepts, slot_name configuration, and connection pooling.
- Knowledge of financial transaction flow and its implications on database management.
- Proficiency in query logic, functions, and table views, with experience in query optimization.
- Proficiency in at least one programming language (Golang, Python, PHP, JavaScript).
- Strong analytical and problem-solving skills.
- Excellent communication and collaboration skills.
- Able to work on site in Bandung