DBA Administrator

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.

Preferred Skills and Knowledge

• 2 years of experience using SQL server
• Knowledge of High Availability (HA) for SQL server.
• Certified SQL server DBA
• Experience using single node cluster with ASM - Oracle.
• AWS / EC2 Cloud database knowledge.
• Bash / Ksh shell scripting experience, writing/troubleshooting scripts.
• Using PL/SQL / TSQL to automate basic database tasks.