Database Administrator

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.Job DescriptionPrimary Purpose The Application DBA is responsible to perform database Administration activities such as database setup, defining/maintaining database objects, backup and recovery. He/She is also involved in database design and review, application SQL tuning and maintaining documentation meeting customer’s expectation. As the experience in this position grows, there will be opportunities to expand to database consultancies areas such as performance tuning, data governance and data policies.Key Responsibilities- Migrating data from Mainframe DB2 on z/OS to flatfiles using scripts or tools in the mainframe environment.- Plan and perform database migration- Monitor & measure the performance & availability of databases proactively; implement corrective actions identified to improve performance & availability.- Monitor the agreed service level, document & maintain the configuration of the databases; provide regular reporting to relevant parties.- Ensure service level meet requirement. Propose and implement action plan when required. Lead and monitor databases according to standard operations procedures.- Implementation of service continuity measures, i.e., backup/restore procedures & disaster recovery plan, to ensure continuous operation of the business.- Define data governance policy related to database operations management. Manage database permission, hardening standards, database naming standards.- Keep abreast of database technologies.- A good team player.- 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 rest of organization through CoPs or other in-house forums- Contribute to knowledge repository on experience learnt through project implementationQualifications• This position requires mandatory Mainframe DB2 on z/OS database administration experience of at least 4 years.• Required to possesses good knowledge of database design, implementation and operation support.• Should have experience in migrating data from Mainframe DB2 on z/OS to flatfiles using scripts or tools in the mainframe environment.• Knowledge and experience in other databases such as MS SQL Server or DB2 uDB as well as cloud platforms (eg. AWS or AZURE) is an added advantage.WHAT’S ON OFFERYou will be remunerated with an excellent base salary and entitled to attractive company benefits. Additionally, you will get the opportunity to enjoy a fun and collaborative work environment, alongside a strong career progression.To submit your application, please apply online or submit your CV to [email protected], Your interest will be treated with strict confidentiality.CONSULTANT DETAILSConsultant Name : Ashwak AhmedPrivacy 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' privacy policy.