Serge Kona

Database Administrator (DBA) with over 10 years' extensive knowledge and proficiency, on premises and in the cloud (OCI and AWS) in database design, management, monitoring & performance tuning, security implementation and risk analysis, as well as backups and recovery in Windows, Unix, and SQL Server environments. Federal government contracting experience with the Department of Defense and Department of Treasury. Extensive experience on Oracle Database Administration 24x7 critical production and large databases using Oracle RDBMS.

Possess good work ethic, dynamic and detail oriented. Knowledgeable with MySQL, SQL Server, PostgreSQL, RDS, Aurora, Redshift & DynamoDB. Excellent communication and troubleshooting skills as well as a cohesive team member.

Flexibility to adapt to and excited in learning new concepts and technologies.

Oracle Database Administrator - Veterans Engineering and Technology

(2023-02)

Department of Treasury Fiscal Services

• Installed, configured, cloned and upgraded Oracle exadata Databases.
• Proficiency in SQL (DDL/DML), Linux/Unix systems, and Bash scripting.
• Managed over 50+ CDB/PDB architectures multi-tenant, including table spaces, schemas, users, roles and ensuring compliance with Oracle STIG policies.
• Performed guaranteed restore points and PITR for HA.
• Managed Oracle databases on AIX platforms configuring high-availability architecture using Oracle RAC and Oracle Data Guard.
• Configured and managed Oracle Data Guard and DG broker (DGMGRL) ensuring synchronization with production RAC databases.
• Performed patching (RU/PSU) and lifecycle management.
• Configured and administered Automatic Storage Management with ASMCA creating disk groups using bash scripting and SYSASM. Monitored ASM storage space and allocation from CLI with disk space command.
• Administered 50+ Oracle 12c/19c production and development databases ensuring high availability.
• Performed data migrations physical and logical Data Pump, DMS (AWS Database Migration Service) and Goldengate from on premise (Oracle) to the cloud (Azure).
• Analyzed Tables, Indexes and Clusters against chained and migrated rows and provided solutions.
• Capacity planning and monitoring to meet the demands of the dynamic aspects of storage and memory for the databases.
• Automated tasks at operating system level using Crontab and AT and at the database level using SQL Scripts and PL/SQL procedures.
• Automated jobs in the Enterprise Manager using ESP and Stonebranch to increase the workload automations, optimize job management and complete tasks with conditions and event based triggers.
• Identified and remediated critical database security vulnerabilities configuring audit policies and using weekly Guardium scans to reduce risk, exposure and improve compliance posture and security hardening to be in accordance with Oracle STIG policy.
• Oversaw multi-tenant production and non production CDBs providing security management, system level administration and provisioning.
• Administered data refreshes. Exported tables from the target schemas to retain them for future data restores using data pump utility (expdp/ impdp) and OEM jobs.
• Led patching, upgrades, and security hardening across enterprise databases using OPatch and rolling upgrade strategies.
• Installed, configured, and maintained Oracle Grid Infrastructure using multiple nodes for high availability databases.
• Monitored and troubleshot cluster services using CRSCTL and SRVCTL utilities.
• Performed OEM database (repository/OJVM java/ agent/application) and OMS quarterly combo patches.
• Oversaw Oracle 19c RAC databases providing storage, user and schema management at the PDB level.
• Insured database security creating role based access control.
• OEM (Oracle Enterprise Manager) Monitoring.
• Reconciled functional and technical problems through interaction with the client by researching and identifying the defined issue and by fully testing and confirming possible solutions to the problem.
• Encrypted audit tablespaces (TDE). Created documentation for basic tablespace encryptions.
• Administered Oracle Exadata databases to make in accordance with Guardium scan ORA 12c STIG rules.
• Developed standards and procedures for all aspects of Database space monitoring and utilization. Created incident rules in OEM to notify group via email any (critical 80%) or (warning 75%) level breach of tablespace storage.
• Backup/recovery strategist: (RMAN), Import/Export & Data pump, Data Restores, Replication (Streams) standby databases, Data guard, Flashback restore points and database cloning. Oversaw database availability, data guard synchronization, disk space, Fast Recovery Area, Tablespace storage.
• Design, test and support solutions for Disaster Recovery.
• Performance tuning of databases by indexing and range partitioning tables to speed up query performance.
• Troubleshooting using various tools: EXPLAIN PLAN, AWR, ADDM, v$ performance views, Alert log, SQL Tuning Advisor.
• Cloned pluggable databases for clients use in and out of container using the C##REMOTE_CLONING_USER.
• Database security policy creation and institution, using passwords, privileges in user profiles, role based access control, basic data encryption, network security.
• Restored and recovered pluggable databases to a timestamp using RMAN (ZDLRA RMAN backup, restore and recovery to a SCN number and timestamp).
• Added database targets to configure parameters in OEM (Oracle Enterprise Manager).
• Identify system enhancement and automation opportunities for maintaining database technologies and monitoring applications as well as alerting and remediating system breaches, outages or blackouts.
• 24x7 support working on a primary/ secondary rotation and supported on holidays, weekends and beyond regular hours to customers satisfaction. Responded to critical alerts, emails, teams appointments for troubleshooting in agile environments.
• Lead DBA team occasionally on specific projects such as database restores, migrations, database patching and upgrades.

Oracle Database Administrator/ OCI console Administrator - Credence Management Solutions

(2021-11 - 2022-05)

Department of Defense

• Performed Critical Patches and Patch set updates. Database OS Patching, Database GI Patching, Database DB Repository Patching.
• Can work with customer directly.
• Respond to the customer in emails and troubleshooting sessions with arising issues strategically and with high level technical support.
• SQL, PL/SQL Unix/ Linux shell scripting
• Administered Oracle 19c RAC databases space availability, disk space, alert log errors and tablespace storage.
• Optimized performance and cost by identifying triggers and events and automating management of cloud resources using Agentic AI.
• Enabled self-tuning, patching, and security optimizing the databases with Agentic AI.
• OCI access and management policies administered using IAM and role based access.
• Lead conversations in coming up with solutions and recommendations for optimal performance for the present and future monitoring requirements and proactively eliminating issues before arrival.
• Provided installation, configuration, maintenance and troubleshooting support for database application software both on premises and in the Cloud including standby database (Data Guard) Environment for High Availability and query testing.
• Design, test and support solutions for Disaster Recovery on premises and in the cloud.
• Facilitated discussions with development team on critical projects. (24-7 support). Prepare test data and execute detailed test plans with precise documentation.
• Backup/recovery strategist: (RMAN), Import/Export & Data pump, Replication (Streams) standby databases, Data guard. Backups and recovery of Dat