TIGO DATABASE ADMINISTRATOR (ORACLE)

Role Purpose Disaster recovery (backups and testing of backups), performance analysis and tuning, data dictionary maintenance, and database design. Roles of the DBA include: •   Installation of new software — It is the job of the DBA to install new versions of DBMS software, application software, and other software related to DBMS administration. It is important that the DBA or other IT staff members test new software before it is moved into a production environment. • Configuration of hardware and software with the system administrator — In many cases the system software can only be accessed by the system administrator. In this case, the DBA works closely with the system administrator to perform software installations, and to configure hardware and software so that it functions optimally with the DBMS. • Security administration — One of the main duties of the DBA is to monitor and administer DBMS security. This involves adding and removing users, administering quotas, auditing, and checking for security problems. • Data analysis — The DBA analyzes data stored in the database and makes recommendations relating to performance and efficiency of that data storage. This includes the effective use of indexes, enabling "Parallel Query" execution, or other DBMS specific features. • Database design (preliminary) — The DBA can be involved at the preliminary database-design stages, eliminating many problems that might occur. The DBA knows the DBMS and system, can point out potential problems, and can help the development team with special performance considerations. • Data modeling and optimization — By modeling the data, it is possible to optimize the system layouts to take the most advantage of the I/O subsystem. • Responsible for the administration of existing enterprise databases and the analysis, design, and creation of new databases. o Data modeling, database optimization, understanding and implementation of schemas, and the ability to interpret and write complex Structured Query Language (SQL) queries. o Proactively monitor systems for optimum performance and capacity constraints. o Establish standards and best practices for SQL. o Interact with and coach developers in SQL scripting. Key Responsibilities Responsible for ensuring availability and performance of the databases that support the system.  Work to ensure that the associated hardware resources allocated to the databases and to ensure high resilience and performance tuning.  To proactively monitor the database systems to ensure secure services with minimum downtime (both SQL Server and Oracle interface).  Responsible for providing trend analysis to management team to enable them to make informed decisions regarding resource management.  Responsible for troubleshooting and problem solving of SQL and Oracle development.  Responsible for improvement and maintenance of the databases to include rollout and upgrades.  Responsible for implementation and release of database changes according to agreed timescales and costs.  In depth SQL Server Database Administration experience and Oracle.  Experience of managing multiple MS SQL 2008 & 2005 RDBMS on large systems  Strong self-sufficiency and initiative working on Database projects  Experience Practical experience in monitoring and tuning a database to provide a high availability service.  Experience of Transactional SQL, and DTS stored procedures.  Practical experience in managing the internal and external MS SQL/Oracle  database security Position Requirements Bachelor degree in Information Technology and Computing Sciences. 3 to 4 related experience, APPLY NOW