SUMMARY

• Accomplished database administrator with over 6 years of experience in building, provisioning, and supporting next - generation RDBMS solutions.
• He has mainly worked on PostgreSQL and Oracle databases but is also proficient with MySQL and SQL Server engines.
• He is proficient in Installation, Configuration, Upgrades and Patch management, Migration, Database Refresh, Backup and Recovery, Cloning, Replication, Database Security, Data guard, Memory Management, Data Modeling, Performance Monitoring and Tuning.
• Athanase has an analytical mind to quickly solve problems. A dedicated team player who thrives on collaborating with diverse teams’ members using a his communication skills.

TECHNICAL SKILLS

Database Technologies/Tools: PgAdmin, PgBadger, PgBackRest, PgHero, PgBouncer, RMAN, OEM 10g 11g & 12c, Oracle Data Guard, Oracle RAC, Data Pump, GoldenGate, SQL*Loader, ASM, AWR, ADDM, SQL* Plus, SQL Developer, SiteScope, HP ALM, Serena, BMC remedy, OpsWare, Toad, DB Artisan, SolarWinds, MTK, AWS

Languages: SPARK, PL/PGSQL, PL/SQL, Shell Script, PERL, Java, C++, HTML.

Business Productivity Tools: Tableau, MS Office Suite (Word, Power Point, Excel, Outlook), MS Visio, Adobe Photoshop, and Dreamweaver

Platforms & Operating Systems: AWS RDS, AWS Aurora, HP-UX 10.x, 11. x. Sun Solaris 2.x, 8.x 9.x, 10.x AIX 5.x, Centos 7.x, 6.x, 5.x, RHEL 2.1, 3.x, 4.x, 5.x., Windows 98/XP/Vista/7,8 & Server, Mac OS

Other tools: BMC Remedy, MS-Outlook, Putty, VMware, Oracle VirtualBox, and VNC

PROFESSIONAL EXPERIENCE

Confidential - New York, NY

PostgreSQL Database Administrator

Responsibilities:

• Hands-on experience in PostgreSQL community edition as well as EDB PostgreSQL architecture.
• Configuration of EDB PostgreSQL for production, pre-production and non-production environments.
• Upgrading databases servers leveraging pg dump, pg restore and pg upgrade.
• Administrated PostgreSQL databases throughout SDLC including the non-production (Sandbox, development, test,) and production environment
• Exposure to database migration on Greenplum server in non-production environment
• Perform database backup and restore using the gpbackup and gprestore utilities from Greenplum
• Experience with optimizing database performance through exhaustive pro-active testing
• Perform Installation/configuring PostgreSQL. Mainly PostgreSQL VERSIONS 9.6, 10.11 and 11
• Perform cross platform migrations from Oracle databases to PostgreSQL leveraging AWS Cloud Aurora and using SCT and DMS.
• Develop test plans and testcases to demonstrate database readiness post migration
• Perform MKT migration from oracle server to EDB advanced server
• Manage and monitor databases using pgAdmin
• Plan and implement streaming using replication slots on a reporting system
• Leverage pghero for Performance tuning mostly. SQL Tuning using EXPLAIN ANAYZE and PG STAT ACTIVITY, PG STAT ALL TABLES
• Performing core DBA tasks such as, creating roles, granting privileges, creating tables.
• Implementing the use of indexes, and primary & foreign key constraints as required
• Support applications and manage and monitor production databases using ticketing system. And Assisted in defining and implementing MAINTAINANCE PLAN for the database system.
• Performing maintenance activities like vacuum, vacuum full, analyze etc
• Experience of tuning PostgreSQL server settings & Troubleshooting performance issues.
• Configuring pgBadger for generating statistic reports.
• Configuring and troubleshooting PgBouncer for connection pooling.
• Used Customized scripts in crontab, to monitor database growth, TABLE growth, automated backups using cronjobs.
• Using customized scripts to perform maintenance;
• Checking the AUTO VACUUM jobs, Customized VACUUM on certain tables and columns
• Experience in handling logical and physical database BACKUPS using pg dump, pg basebackup as well as pgBackrest.
• Assisted in developing and implementing best practices for Disaster Recovery and Backups.
• Hands on experience on restoration techniques on PostgreSQL like pg restore and (PITR) Point in Time Recovery.
• Perform BACKUPS, and RESTORE, BACKUPS tuning, Database Or Schema REFRESHES
• Configuring streaming replication (including cascading replication). I have configured a REPLICATION between MASTER and STANDBY, and monitoring On-Going REPLICATION

Confidential - NewYork, NY

PostgreSQL/ Oracle Database Administrator

Responsibilities:

• Install and configure servers for PostgreSQL versions 9.7,10.7 and 11.4 on both Windows and UNIX platforms
• Experienced in tuning PostgreSQL server settings and troubleshooting performance issues.
• Configure REPLICATION between MASTER and SLAVE, and monitoring replication on a daily basis.
• Exposed to cross platform migrations Oracle to PostgreSQL where I documented and assisted during migration from ORACLE Databases to PostgreSQL database in AWS Cloud Aurora.
• Configured PgBouncer for connection pooling and PgBadger for generating statistical reports.
• Perform maintenance activities like checking on AUTO VACUUM jobs, Customized VACUUM on certain tables and columns.
• Rewrote and implemented a backup strategy following company SLA; execution of backup schedule for both physical using Pg basebackup and PgBackRest and Pg dumpall and Pg dump for logical backups
• Championed database migration from Oracle to PostgreSQL on premises and on AWS, using Migration Tool Kit, Ora2pg, DMS and SCT.
• Support daily administration, monitoring, tuning, and troubleshooting of clusters and single instances on UNIX/Linux and AWS Console (Database sizes range 100GB to 21TB)
• Implement table and index partitioning to improve query speed.
• Monitor CPU utilization, memory, Database Connections and storage space daily using pg stat activity, PEM, Pg view and AWS CloudWatch alarms. Also use customs shell scripts deployed on crontab to monitor performance and resources.
• Clone databases using creation templates and pg dump for testing purposes.
• Daily logs revision for unusual events and performance issues and took appropriate action according to company policies and incident reports.
• Perform PL/PGSQL errors fixes for application issues.
• Deployed Database security policy and installation, using passwords, privileges and user profiles, Enabled Encryption for databases.
• Participate in capacity planning meetings to meet the demands of the dynamic aspects of storage and memory for the databases
• Perform Database Refreshes from production environments
• Perform patching and upgrades of Databases using AWS minor versions upgrades, pg upgrade, pg dumpall and logical replication
• Provided Memory tuning by using ASMM (Automatic shared Memory Management). Sort area size, Buffer cache, Shared pool size, Different pools like Recycle pool, Keep pool.
• Migrated database from Solaris to Linux with Data Pump and Golden Gate . Migrated from SQL Server / DB2 to Oracle and Oracle to SQL Server unidirectional and bidirectional using Golden Gate 11g and 12c.

Confidential - Columbus, OH

Oracle Database Administrator

Responsibilities:

• Primary DBA for 100+ databases of Oracle 10g/11gR2 on Linux REHL, HP-UX. Worked as per ITSM/Remedy Incident ticket/Critical Response Time (CRT) call.
• RAC- Administration/Trouble-shooting of 3 Node cluster on Oracle 10g/11G R2. Configuring Grid Infrastructure SCAN Listeners on 11gR2.
• Migrate OCR files to ASM, Troubleshoot Resource related issues. Cluster-wide Resource management such as create resource plan, Service configuration, parallel instance group, Application Isolation. Stress testing, benchmarking of clustered database.
• Involved in projects using Golden Gate 11.2 for data replication , data distribution, database synchronize and database migration and data consolidation. Skillful in data mapping and real time replication. Migrated VLDB database between various RDBMS platforms with Golden Gate with limited downtime
• Managed ASM storage. ASM cloning. Prepare/Add/remove ASM disks. Tuning of I/O on ASM based databases. Troubleshoot ASM crashes & memory problem.
• Data guard - configure primary -standby using duplicate from active database command of 11g. Apply SCN-based Incremental backup to sync standby after loss of Archive logs on primary. Measure data loss based on latency/lag. Cross-platform migration using Data guard
• Performed incremental backups using Recovery Manager (RMAN). Created recovery catalog, performed complete and incomplete recovery using RMAN.
• Installation of 2 nodes 10g RAC on Linux & Solaris with veritas cluster. Configured ASM, OCFS and RAW devices. Troubleshooting & tracing of RAC processes & CRS components. Relocate service. Tuning of RAC environment. Managing fail-over of instances. Resource utilization on each node. Monitor top objects in cache fusion and traffic.
• Backup by RMAN and Data Pump. Consistent backup using Data Pump. Diagnose and repair block level corruption using RMAN. Script and test RMAN backup/restore. Optimizing backup by compressing.
• Troubleshooting RMAN restore. Used RMAN convert command to transfer datafile from ASM.
• Audit database performance using ADDM reports, AWR snapshot and diagnostic SQL scripts. Identify and tuning of ad-hoc queries, PL/SQL code which are highly intensive resources. Tuning instance by init parameter. Used explain plan and stats pack/TKPROF utility to Improve response time of query. Create/manage local partitioned and bit-map indexes.
• Developed, modified and optimized very complex queries to data retrieval using Explain Plan, SQL Trace, TKPROF, parallel processing and partitioning techniques.
• Monitoring the CPU, memory usage, I/O contention on servers using top, iostat, sar, glance, vmstat etc.
• Designed daily, weekly Backup and Recovery procedures for production, non- production databases using RMAN backups taking periodic Complete, cumulative and differential Incremental Backups
• Data Refresh/Cloning from Production environment to setup QA/ DEV using RMAN Duplicate
• Scheduled UNIX scripts in crontab jobs to automate daily tasks like backups, monitoring the alert logs, backup logs, cleaning the old archive logs, old log files, tablespace monitoring
• Performed Online and Offline backups with RMAN, export/import and expdp/impdp. Implemented Point in time recovery using RMAN
• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups. Extensively implemented Data Pump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of databases
• Experience using like - Real Application Testing, Table and partition recovery using RMAN, Invisible columns, DDL Logging
• Extensively used Oracle 11gR2 features - Real Application Testing, automatic SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Merge backup, Oracle Data Pump, big file tablespaces, new EM Grid Control, Database Control, AWR, ADDM, SQL Tuning/Access Advisors, SQL Performance Analyzer, Database Replay, SQL Plan Management, SQL Tuning Automation, Flashback Database, compression techniques and several others
• Performance Tuning of Oracle Database Objects using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, STATSPACK for optimized results
• Performed Schema as well as Table Level Replication using Oracle Streams. Implemented downstream capture at the destination database using Oracle Streams.
• Installed and Configured Oracle OEM (Oracle Enterprise Manager) Grid Control.
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using "runInstaller" and perl based utility "Opatch"
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O.
• Experienced in configuration of ASM for RAC and NON- RAC environments and migration of databases from NON-ASM to ASM.
• Configured Repository and clients for GRID Control and also implemented DB Control for some databases.
• Supported & maintained the Production/Development databases on various servers
• Extensively worked on setting up auditing in many databases we supported
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 12c Grid Control.