Database Administrator

at  GOCODE GEEK PTE LTD

JOB HIGHLIGHTS:

• Attractive Compensation & Benefit
• Joining a growing company in a growing industry
• Good Positive working culture

POSITION OVERVIEW:

As a Senior Database Administrator (DBA) at our IT company, you will play a critical role in managing and optimizing our database systems to support the organization’s information technology infrastructure. You will be responsible for the design, implementation, and maintenance of our databases, ensuring high availability, performance, and security. This role requires strong technical expertise in database management, excellent problem-solving skills, and the ability to collaborate with cross-functional teams to meet business objectives.

JOB DESCRIPTIONS:

• Design, implement, and maintain database systems, including but not limited to MySQL, PostgreSQL, Oracle and MongoDB.
• Experience with cloud based database systems e.g. Amazon RDS
• Implement and manage database clustering solutions for high availability and scalability, such as MySQL Cluster, PostgreSQL Citus, Oracle RAC, or SQL Server Always On.
• Configure and maintain cluster nodes, load balancers, and replication mechanisms to distribute workload and ensure fault tolerance.
• Monitor cluster performance and troubleshoot issues related to node synchronization, network latency, and cluster failover.
• Design and implement data sharding and partitioning strategies to optimize cluster performance and resource utilization.
• Collaborate with system administrators and network engineers to ensure proper infrastructure support for database clustering.
• Develop and maintain disaster recovery plans and procedures for clustered database environments and also perform regular database maintenance tasks, such as backups, restores, upgrades, and patches.
• Monitor database performance and capacity, identifying and resolving issues to optimize system efficiency.
• Collaborate with software developers and system architects to design database schemas, data models, and storage strategies that meet business requirements.
• Develop and maintain database documentation, including data dictionaries, entity-relationship diagrams (ERDs), and database schemas.
• Implement database security measures, including user authentication, authorization, and data encryption, to protect sensitive information.
• Identify and troubleshoot performance bottlenecks, slow queries, and other database-related issues. Optimize database configurations, indexes, and query execution plans to improve performance and scalability. Implement database monitoring tools and alerts to proactively identify and address performance issues.
• Plan and execute data migration projects to transfer data between different database systems or environments.
• Integrate databases with other systems and applications, ensuring seamless data exchange and interoperability.
• Ensure data consistency and integrity during the migration and integration process.
• Develop and maintain database backup and recovery procedures to ensure data availability and integrity.
• Test backup and recovery processes regularly to verify reliability and effectiveness.
• Create and maintain disaster recovery plans to minimize data loss and downtime in the event of system failures or disasters.
• Enforce database security policies and access controls to protect against unauthorized access, data breaches, and cyber threats.
• Ensure compliance with data protection regulations and industry standards, such as GDPR, HIPAA, and PCI DSS.
• Conduct regular security audits and vulnerability assessments to identify and mitigate risks.
• Set up database monitoring tools to track performance metrics, storage usage, and other key indicators.
• Generate reports and dashboards to communicate database performance, availability, and capacity to stakeholders.
• Monitor system logs and audit trails for security incidents and compliance violations.

QUALIFICATIONS:

• Bachelor’s degree in Computer Science, Information Technology, or related field.
• Minimum 3 years of experience as a Database Administrator or in a similar role, preferably in an IT company or enterprise environment.
• Proficiency in one or more database management systems (e.g., MySQL, PostgreSQL, MongoDB, Oracle.
• Strong SQL programming skills and understanding of database query optimization techniques.
• Experience with database design, normalization, and data modeling concepts.
• Knowledge of database security best practices and compliance requirements.
• Familiarity with database backup and recovery procedures, including tools such as mysqldump, pg_dump, or Oracle RMAN.
• Strong communication and collaboration skills, with the ability to work effectively in a team environment.

Please refer the Job description for details