Database Administrator

• Expert Oracle and Microsoft SQL Database administration experience, Azure experience

• Participate in the review of maintenance release artefacts - Use Case, System Requirement Specification, etc.;
• Prepare database change in DACPAC and develop Azure CI/CD release pipeline to promote DACPAC
• Promote database changes through Development, Integration Testing, QA, UAT, Production environments;
• Plan, configure, maintain, administrate, tune performance of Microsoft Azure SQL database and Synapse database
• Provide database space calculations for the supported database environments;
• Perform reference data administration as required;
• Migrate Oracle 12.1 databases to multi-tenant databases;
• Plan and co-ordinate implementation with developers, UNIX and .NET application support and other Data Management staff;
• Design and write data loading and/or conversion scripts/stored procedures;
• Build and test database backup/recovery scripts;
• Build and test database automation scripts
• Deliver detailed system design documents and any other supporting documentation conforming to Ministry standards;
• Perform database administration, including patching/upgrade, monitoring, performance tuning, partitioning, capacity planning, OEM upgrade/enhancement, achieving, etc
• Document and resolve any database problems/issues\

LanceSoft