Cloud DBA- Associate

Cloud DBA

Avensys is a reputed global IT professional services company headquartered in Singapore. Our service spectrum includes enterprise solution consulting, business intelligence, business process automation and managed services. Given our decade of success, we have evolved to become one of the top trusted providers in Singapore and service a client base across banking and financial services, insurance, information technology, healthcare, retail and supply chain.

We are currently looking to hire a Cloud DBA. This is an exciting opportunity to expand your skill set, achieve job satisfaction and work-life balance. More details as below.

JOB TYPE:

Long Term Contract

Job Overview:

The Cloud Database Administrator is responsible to be part of a team of Data Engineers to perform database Administration activities such as database setup, defining/maintaining database objects, backup and recovery in a cloud environment. He/She is also heavily involved in database design and review, application SQL tuning and maintaining documentation meeting customer's expectation. He/She will also provide database consultancies such as performance tuning, data governance and data policies.

Key Responsibilities

- Monitor & measure the performance & availability of databases proactively; implement corrective actions identified to improve performance & availability.

- Regularly reviewing query execution plans to identify inefficient queries.

- Monitoring CPU and memory usage to detect resource bottlenecks, Setting up alerts for abnormal database behavior.

- Data Access Control for Azure Database Admin

- Implementing role-based access control, Assigning permissions based on the principle of least privilege,Regularly reviewing and updating access levels.

- Meet agreed service level, document & maintain the configuration of the databases; provide regular reporting to relevant parties.

- Propose and implement action plan when required.

- Prepare standard operations procedures for Database Administration activities.

- Participate in service continuity measures, i.e., backup/restore procedures & disaster recovery plan, to ensure continuous operation of the business.

- Involve and lead in database implementation.

- Define data governance policy related to database operations management. Manage database permission, hardening standards, database naming standards.

- Keep abreast of database technologies.

- Work with application team to review the database design and recommend suitable changes to the data model with understanding of the business and application environment

- Develop standards and procedures related to database environment and ensure that it is followed through for all implementations

- Engage customers to explain the rationale of the database design, or other technical issues

- Educate application team on best practices in coding and design

- Share knowledge with the team and develop and train junior Data Engineer

- Share knowledge with the rest of organization through CoPs or other in-house forums

- Conduct technical courses related to database management

- Contribute to knowledge repository on experience learnt through project implementation

- Maintain documentation related to database environment

- Assist and respond promptly to incident, investigate & provide temporary &/or permanent resolution of incidents escalated. Provide timely status updates to relevant parties.

- Adhere to strict security practices for compliance

- Depending on project requirement, there is a need to support 24x7 requirement. DBA is expected to come back to office and work.

- Implement and oversee backup procedures and disaster recovery strategies.

Relevant Experience:

- Minimum 5 years in database administrators in an operational support environment.

- Minimum 3 years in software development or server infrastructure Project

- Application development experience with relational databases such as SQL server Databases.

- Participated in development projects with full exposure as database administrator in either AWS Cloud or Azure Cloud environment.

- Good Operational Experience with Cloud database Administration

- Good practical experience in data modelling and review meeting play the role of data architect.

- At least 5 years of hands-on experience in trouble-shoot technical problems faced by the project team.

- At least 3 years of working experience in Application performance Tuning and database Performance management

- Experience in setting DB replication and Replication management environment

- Certification in SQL server or other database technologies is value add.

- Good to have experience in other Database products like DB2, MariaDB and MySQL.

To submit your details, please apply online or send your updated CV at [Confidential Information].

CONSULTANT DETAILS

Consultant Name: Khalid Farooq

Avensys Consulting Pte Ltd

EA Licence 12C5759

Privacy Statement: Data collected will be used for recruitment purposes only. Personal data provided will be used strictly in accordance with the relevant data protection law and Avensys personal information and privacy policy