Database Administrator at Indra

Key Responsibilities/Accountabilities

1. Assist with the creation, monitoring, and maintenance of production and test databases for our customers.
2. Assist with the setup and management of database resilience and backup strategies.
3. Execute activities to ensure database high availability, security and optimum I/O throughput.
4. Take lead on data replication and backup across cluster nodes and between production and disaster recovery environments.
5. Assist with the automation of regular database support activities including backup scripts
6. Establish the right data security and best practices on database management
7. Work closely with Technology Infrastructure team to implement database management best practices including- security, capacity planning, optimization, business continuity and support.
8. Monitoring of all database services as per the laid down thresholds and standards defined in the SOPs for abnormalities and out of line occurrences to ensure availability of both Primary & Data Recovery sites.
9. Ensure daily database performance monitoring and optimization practices which include monitoring database servers (CPU, Disk, bandwidth, and RAM) are within approved threshold using real-time monitoring tools.
10. Manage the security and disaster recovery aspects of the mission critical production databases.
11. Establish the needs of users and monitor user access and security.
12. Monitor performance and manage parameters in order to provide fast responses to front-end users.
13. Consider both back-end organization of data and front-end accessibility for end-users
14. Install and test new versions of the database management system (DBMS) and other related systems.
15. Work closely with vendors and OEMs to ensure acceptable deliverable of services
16. Determine, enforce, and document database policies, procedures and standards
17. Develop, manage and test backup and recovery plans
18. Ensure that storage and archiving procedures are functioning correctly
19. Carry out capacity planning and audits of the infrastructure
20. Communicate regularly with technical and operational staff to ensure database integrity and security
21. Install new applications and customize existing applications in order to make them fit for purpose

Knowledge, Skills, Qualifications, and Experience

The applicants must fulfil the following requirements:

1. University graduate in Computer Science/Engineering or related degree from a reputable university.
2. Excellent academic performance. Only First Class or Second Class Upper Division degree holders will be considered.
3. Relevant professional certifications and/or courses on MOOCs (Udemy, Coursera, edX etc.)
4. Minimum of 3+ years of progressive experience designing, implementing, managing and supporting enterprise production database environments
5. Note that you will be invited to attend a hands-on technical interview to demonstrate your experience in the skill areas below:
   1. Installation and administration of Database Servers (Oracle, MS SQL, Mongo DB, PostgreSQL etc.)
   2. Implementation of replication services for DB clusters across data centres.
   3. Server Hardware Administration and Troubleshooting.
   4. SQL Programming and Performance Tuning/Optimization.
   5. Unix/Windows Shell Scripting/Programming.
   6. Operating System Administration (Windows and Linux/Unix). The candidate should be able to install, and trouble shoot OS level problems.
   7. Basic programming knowledge in Java, C/C++ etc. The idea is that the candidate should be able to perform basic trouble shooting of an application.
   8. Knowledge of Source Code Management (SCM) tools and Version Control (e.g. SVN, Git etc.).
   9. Basic Network Administration and Troubleshooting skills.
   10. Knowledge of Virtualization technologies and their administration (e.g. MS Hypervisor, KVM, ZEN, Ovirt etc.) is an added advantage.
   11. Knowledge of Application Containerization technologies and their administration (e.g. Dockers etc.) is an added advantage.
   12. Knowledge of Cloud technologies and their administration (e.g. Amazon Web Services, Microsoft Azure etc.) is an added advantage.
6. An innovative spirit: This is a challenging technical job that requires creativity in generation of ideas and unique solutions to technical problems.
7. Excellent written and verbal communication skills. You will be expected to participate in preparation of both Technical and End User oriented Documentation.
8. Excellent Interpersonal skills and a good team player. You will work in Teams composed of colleagues of diverse skill-sets in addition to fellow System Administrators. Good synergy with your colleagues will therefore be critical to your success.
9. Readiness to travel be assigned to projects outside the country when the need arises.

All interested applicants should submit an application with a well written CV (properly structured and clearly formatted) that clearly shows your main academic qualifications, professional