We are seeking to recruit a qualified candidate for the role of Senior Database Administrator to join our IT team within Kina Group of Companies. The incumbent will report to Head of IT Support. The Senior DBA position will be responsible for maintaining the company’s database systems (currently MS SQL Server) including back-up, performance tuning, capacity planning, monitoring critical events and documentation.KEY RESPONSIBILITIES INCLUDE:
- Display Kina’s Mission and Values
- Working across functions with peers within Kina Bank to ensure collaboration for shared goals.
- Enable a culture/philosophy of continuous learning and collaboration
- Enable accountability and a strong performance and risk management culture
- Ensuring consistent and high-quality service delivery
- Escalate IT Database issues where necessary
- Create and manage multiple databases and assist in capacity planning.
- Monitor, maintain database systems and troubleshoot problems that may arise.
- Maintain data integrity and security (manage roles and permissions of database users).
- Use tools like SQL Profiler for database tuning. Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them.performance issues, deadlocks/contention and resolve them.deadlocks/contention and resolve them.
- Be familiar or hands on with Oracle database system
- Experience with maintenance of a distributed Oracle Database System
- Design, development, administration, performance monitoring, reporting, and tuning of Oracle databases
- Develop strategies and implement solutions for managing back-ups, restoration and replication.
- Create and manage constraints and indexes.
- Support software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures.
- Proactive housekeeping/archiving and shrinking of databases.
- Manage production, QA and development database environments.
- Create detailed documentation including diagrams of database infrastructure.
- Learn relevant business processes and understand the data flow, criticality and dependencies.
- Effectively coordinate and communicate with all the stakeholders (internal teams and clients).
- Set up and maintain database infrastructure for the company’s BI needs.
Job Requirements:
THE CANDIDATE MUST HAVE
- Degree in computer science/Information Technology or equivalent education and experience.
- 5-10 years’ experience in administering Microsoft SQL server databases (SQL Server 2012).
- Extensive experience writing T-SQL and stored procedures and query tuning on high transaction systems.
- Experienced in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
- Experienced in ETL (Extract-Transform-Load) development / data integration.
- Ability to learn and work on changing technologies
- Project management
- Change Management
- In-depth knowledge of database queries, database theory, database design, etc.
- Up-to-date knowledge of the database software trends.
- Sound knowledge of RDBMS concepts, database architecture and SQL/T-SQL.
- Proficient with SQL server profiler for monitoring and troubleshooting database activity and performance.
- Experience in SQL Server Clustering and HA technologies including mirroring, log shipping, failover cluster and various replication technologies would be an advantage.
- Knowledge of other databases like MySQL, No SQL databases and In-memory databases and MCTIP certification will be an advantage.
- Ability to develop procedure documents and maintain detailed database related documents.
- Innovative approach to work, constantly looking for upgrading the system to more efficient and effective new technologies.
- Fluent in both oral & written English
- Demonstrate ability to shape the work environment
- Strong teamwork player in strategy, vision, priority, value and ethic.
- Demonstrates capacity to adapt to changing environment
- Strong interpersonal skills and a demonstrated ability to effectively resolve conflict
- Strong customer service ethos.
- Ability to work well with people.
- Strong communications skills.
- Excellent organisational skills.
TO APPLY
Please send applications by 12 October 2018 with resume and three (3) current referees through to:
Email hr@kina.com.pg
Mail Group Manager - People & Culture, Kina Bank Limited, PO Box 1141, Port Moresby
Hand Deliver Level 9, Kina Bank Haus, Port Moresby
Closing Date 12 October 2018
Next :