DBA Administrator

2 Days ago • 4-6 Years

About the job

Summary_{By Outscal}

DBA Administrator with 4+ years of experience in managing Oracle databases, migrating from 11c to 19c on Linux Red Hat, strong troubleshooting skills, and a team player with excellent communication skills. Must have experience in complex SQL, data modeling tools, and performance tuning.

This is a high-profile role for technical operations candidates to join a Managed Service (MS) and Cloud within a major software house. The right candidate will be a member of the growing Cloud Ops Team with key responsibilities in service engagement with our Cloud hosting clients.

The ideal candidate must be conversant with operational Unix commands and procedures around the management of a secure data network, the physical servers and environments will not be at our site and will be physically managed by third parties, we are responsible for managing some of the infrastructure components as well as all of our applications running at those sites.

We are looking for bright, articulate candidates with strong drive and capability to learn and expand their current knowledge. Working as a team covering up to 24x7 hours the candidates must exhibit a high degree of professionalism including the ability to escalate when needed, a desire to provide high customer satisfaction and be reliable.

The range of equipment and applications to be managed will also be expanding. Much of the expansion will be on Linux based platforms.

Locations: Pisa, Milan

Key Responsibilities

Work with the ASP and cloud operations staff to help with customer database issues and deal with standard operational activities for production systems
Create maintenance plans and jobs, backup and recovery, user accounts, database log space monitoring, and maintenance on mission-critical database systems
Co-ordinate with the development team and conduct fine-tune performance using a combination of database optimization, queries and automated workload repositories (AWR) for both development and production database systems maintained at the data centre
Enforce security and access control across all database servers in the network
Research and implement hardware specifications for cluster setup, load balancing and shared storages – ideally Red Hat Cluster
Contribute to overall capacity planning and configuration management of the supporting infrastructure
Create DB recommendation for production and development environments
Provide development and design assistance to development and other application support teams
Working with Project Managers to identify and manage risks, issues and opportunities for the system/s, including the development of contingency plans
Ensure system integrity, efficiency and performance through management of core system resources (CPU/Memory/IO Performance)
Follow the problem management, change management and service management processes
Assess and perform systems utilization and headroom reports to assist in troubleshooting and performance tuning
Evaluate and manage existing software and licensing configurations, systems and the design, implementation and management of new/improved systems

Required Skills and Knowledge

Bachelor’s degree or equivalent in related field required.
Oracle certified DBA with vast knowledge in this area. Must have at least 4+ years’ work experience.
Migration experience from 11c to 19c, Linux Red Hat based.
2-4 years of experience as a DBA in production and development environments.
Strong troubleshooting skills.
Must be a team worker with outstanding communication skills, both oral and written.
Ability to work independently on multiple tasks with minimal guidance.
Ability and desire to work in a fast-paced environment.
Attention to detail.
Excellent work ethic, dependable and responsible.
Experience in writing and analysing complex SQL (stored procedures, triggers, etc.).
Experience with data modelling tools.
Experience in troubleshooting and resolving database problems.
Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
Experience with backups, restores and recovery models (RMAN).
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for Oracle.
Knowledge of indexes, index management.
Production support/troubleshooting Data Guard setups.
Good knowledge of Italian and English languages.