IT Business Analyst (Oracle)
Posted on Nov 18, 2020 by Morson International (IT)
1 Dec 2020
€350 - €360 Daily
- Oracle Database Implementation - design and implement development, test and production databases for maximal performance, scalability, flexibility, and reliability.
- Install and maintain DBMS software including patches, fixes and version upgrades.
- Work closely with architects to create and maintain schema objects, design and debug triggers, stored procedures and user-defined functions.
- Performance Monitoring and Tuning -monitor and maintain maximum performance of databases.
- Identify poorly performing queries and work with development teams to tune accordingly.
- Monitor database logs for hardware, memory or disk space/capacity issues and take appropriate action.
- Implement database parameter and configuration changes for optimal performance with the host operating system.
- Availability, Backup and Recovery - design and implement processes and procedures to reduce and eliminate database outages and downtime. Implement data backup and recovery procedures to prevent the loss of data from all types of failure. Document, plan and test Disaster Recovery procedures.
- Work on the deployment of new Database releases for the Dev, Test and Production services and applications.
- Create, validate and execute complex SQL queries for the update and alignment of applications data
- 3+ years experience with Change Management processes and ICT Operations
- 3-5+ years experience with Oracle SQL Server DBMS required
- 3-5+ years experience with Linux and Windows operating systems required
- 3+ years experience writing SQL programming
- 3+ years experience with database, query, stored procedure and SQL performance tuning
- Ability to resolve incidents and problems following ITIL standards and policies
- Able to manage and deploy application database modifications
- Experience with Microsoft SQL Server and SQL Server Reporting Services (preferred)
- Experience with MySQL Server installation, configuration and support.(preferred)
- Oracle Database SQL Certified Associate, MySQL and Microsoft SQL Server certifications considered as a plus.