| 20,000+ Fresh Resumes Monthly | |
|
|
| | Click here or scroll down to respond to this candidateCandidate's Name
PROFILE SUMMARY9years IT experienceOracle DBAPostgres DBASQL ServerAWSMongoDBBackup and recoveryReplicationVacuumDataguardRACMigrate.Oracle.postgresGolden GatesPerformance tuningCloningShell scriptingData modelingInstallation-upgrade-patchingData securityBash ScriptingETLAnsible and dockerSSMSEDUCATIONMasters Degree in Biostatistics, Hasselt, Belgium, 2013Bachelors Degree in Mathematics /computer science Buea, Cameroon, 2005Oracle Database 12CSQL FundamentalsDBA SKILLSDatabases: PostgreSQL 10, 11 Oracle 11g, 12cOperating Systems: Linux, Centos7, Windows HP-UX, AIX, RHELTuning Tools: PgHero, KPROF, EXPLAIN PLAN, AWR, and ADDM, clustercontrolLanguages: SQL, PL/PGSQL, R, PERL, SASUtilities: RMAN, OEM, PgSQL*Loader, EXP, IMP, Data pump, TOAD, Oracle SQL Developer PgAdmin, PgAgent, Crontab, PgBadger, PgBouncer, PgDump, PgDumpAll, Pgbackrest.Cell: PHONE NUMBER AVAILABLEEmail: EMAIL AVAILABLESkype: SKYPE ID AVAILABLEVisa: Green CardOracle/SQL-server/Postgres Database AdministratorPROFESSIONAL SUMMARYExtensively used Database Administrative tools like: SSMS SSIS, SSRS, SSAS, Spotlight, SolarWinds, Enterprise Manager (PEM and OEM), SQL-Loader, PgAdmin, Postgres SQL*PLUS, SQL*DEVELOPER, TOAD for tuning and monitoring purposes.Production support, database management and performance tuningWorked on different Sql-server database versions (2012, 2014, 2016, 2017, and 2019)Good experience in installation and Configuration.Create and manage databases on Azure, AWS- EC2 and RDS, and manage S3 and EBS storageData warehouse for data consolidation OLAP and BI,ETLData modeling using Erwinworked as a team member for 24*7 support with on call rotation in PROD, QAT and DEV environmentsGood experience in applying Critical Patch Update(CPU) for security and Patch Set Update(PSU) for security and bug fixes using OPatch utility.Migrated databases ranging from 200GB to 2TB to different platforms using SSMS, SCT-DMS, Migration Tool KitParticipated in Strategic Planning, Logical and Physical Data Modeling & Application Tuning.Excellent in Hot/Cold Backup with or without catalog, full backup, incremental, cumulative backups, Recovery and Cloning of databases using RMAN.Extensive knowledge with OLTP and OLAP systems.Manage application such as Enterprise Business Siute..EBSData loading using external tables, SQL*LOADER, PgSQL*Loader, Logical and physical backups using full export, Pgdump, PgDumpall and DATAPUMP.Configured Master-Slave replication and monitored on-going replicationInstalled, configured and maintained Goldengate on Oracle 11g, 12c for disaster recovery and data protection purposeAnsible and Terraform for automation of scripts across serversEnforced Security Administration, system monitoring by adding and removing users, configuring quotas, auditing, TDE, network and database encryption.Migrations from SQL Server databases (2008, 2012,2016, 2019) to Azure.Perform Installations, Upgrades, PatchingDisaster recovery: SQL Recovery Tool, Backup and Restore, Fail-over clustering, Log shipping, Database replication, Always on and Availability groups.High Availability-, SQL Server: (Azure).REPLICATION: SQL Server : ( Native SQL Server Replication (Snapshot replication, Transactional replication, Peer-to-peer replication), Qlik Replicate.Performance Tuning (Partitioning, indexing, T-SQL, query optimization, Server tuning)Speaks English, French and Dutch. A very good team player with advanced analytical skills, self-motivated, dedicated in any work environment and excellent in documentation.PROFESSIONAL EXPERIENCESUNTRUST BANK - TAMPA, FL FEB 2017 PRESENTOracle/Postgres DATABASE ADMINISTRATORMicroSoft SQL-ServerInvolved in Installing/configuring MS Server 2016,2017 and Azure 2019.Data Design and Development on Microsoft SQL Server 2012/2008R2/2008/2005/2000, T-SQL,Experience with High Availability and Disaster Recovery solutions for SQL ServerExperience working with Windows Server, including Active Directory and proper disk configuration for SQL ServerTroubleshooting, SSIS/DTS Package Configuration, SSRS, SSAS and Data-warehousing.Create DTS packages and jobs to monitor, backup, import/export data and data warehouse extractsProficient in developing Continuous Integration/ Delivery pipelinesManage and monitor databases and queried using Sql workbench.Specific hands on experience include administering large and complex Databases, Database Design, Normalization, Replication, Log Shipping, Full text indexing, and Database Application Development using varied development tools.Hot and Cold Backups, Disaster Recovery Planning, Security Management, Managing server and clients, T-SQL, Pl/pgsql, Stored Procedures, Functions and Cursors and Triggers etc.Experience with High Availability and Disaster Recovery solutions for SQL Server.Create and maintain fully CI/CD Pipelines for code deployments using PowerShell.Knowledgeable in setting up TDE for critical database and database tables for security reasons.Providing database security administration such as User IDs, Passwords, roles, etcManage and maintain logical database structures, physical structures, data, file systems, disk sub-systems, accounts/passwords, logical and physical backups, and database tuningPerform DBA tasks to install, configure, test, maintain, backup, recover, patch, and upgradeTune, administer, and maintain SQL Server instance according to set standardsDevelop and document procedures for backup and recovery of SQL Server database environments.Performing BASIC TASKS on OBJECTS such as, creating roles, granting privileges, creating tables.Experience with using SQL Profiler, Extended Event Sessions and Database Tuning Advisor in troubleshooting and tuning database and queries related issues.Working knowledge on HA and Always on clustering. Creating and deploying always on AG groups on brand new VMs in a cluster setup and troubleshooting related issues that may arise in case of poor data synchronization or listener related issues.Implementing the use of indexes, and primary & foreign key constraints as requiredProviding PRODUCTION SUPPORT based on a ticketing system.Assisted in defining and implementing MAINTAINANCE PLAN for the database systems.High Availability (always on, log shipping, clustering)Data Warehousing (SSRS, SSIR, SSAS)ORACLESuccessfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.Administered and monitored over 150 databases both on 10g/11g on prod/test/dev environments.Administering Oracle Databases 10g/11g of sizes ranging from 100GB to 5TB.Data warehouse solution for large databases for data consolidation, intended for OLAP and BI,ETL, using tools such as ERWIN, INFORMATICA, SQL-LOADERMigrated databases from File-system to Automatic Storage Management (ASM).Up-gradation of single instance databases from 10.2.0.4 to 11.2.0.3 on Linux.Responsible for using Flashback query mechanism along with automatic undo management.Automating Alerts, using SQL to set thresholds and triggers.Installed 12C grid control and Used Oracle Enterprise Manager Grid control 11g/12c for monitoring databases.Programming in shell to create shell scripts that automate the database backups and maintenance.Involved in Mass Agent Deployment using Oracle Enterprise Manager 12c.Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.Applied Bug fixes patches, Quarterly Security Patches for RAC and non-RAC servers for issues when upgrading, DR switchover testing.Reconfigured the OCR, public and private interconnects, modifying the VIPs and the subnet masks for 2, 3, 4 Node RAC Clusters and Upgraded single instance 9i/10g databases to 11gR2 RAC.Setup, reconfigured and monitored 2, 3 Node RAC Primary to 2, 3 Node RAC Dataguard for DR.Tested the Dataguard (DR) SWITCHOVER of RAC to RAC Dataguard as part of the migration.Created new databases/instances on 12c/11g RAC and single instances using customized scripts, DBCA.Handled all daily DBA activities and excellent experience with SQL scripting, PL/SQL coding, stored procedures, functions, packages, triggers to enforce the referential integrity constraints.Performance monitoring and Database/Instance/ clustered Application tuning using Dictionary views, AWR (Statspack), ADDM, ASM reports, OEM Grid Control, tuned SGA/PGA parameters, initialization parameters and reorganized physical objects (tables & indexes) and tablespaces to improve the performance.Redesigned table and index partitioning strategies, using HINTS to improve the query performance.Developed, modified and optimized very complex queries to data retrieval using Explain Plan, SQL Trace, TKPROF, parallel processing and partitioning techniques.POSTGRESQLImplementing Best Practices for migration Oracle to PostgreSQLDesign and implement disaster recovery for the PostgreSQL Database.Patch, Upgrade and keep the PostgreSQL DBs current. Develop and enhance scripts to automate and execute various DBA tasks.Configuring and fixing the Issues with Pgadmin-III client application. Responsible for monitoring environments using monitoring tool viz. Nagios, Check_Postgres.pl, pgOn, custom scripts and other supporting tools like pgBadger and tailnmail.Implemented Oracle database 12C RAC databases using Oracle Clusterware for achieving high Availability.PostgreSQL Installation, Configuration, Migration, Upgrades and Patches. Server versions ranged from PostgreSQL 8.2 to 9.5.Disaster recovery planning or Emergency Recoveries and Ensuring Recoverability of Databases.Optimize postgresql.conf for performance improvement. Review all PostgreSQL logs for problems.Experience working on POC of 12c new features like Redaction policy, adaptive query optimization, multiple indexes on single column, Restore table through RMAN.Installed and set up High Availability Oracle Golden Gate (OGG) systems on Oracle 11g and 12c environments. Upgraded Oracle Golden Gate (OGG) systems from 11g to 12c.Have implemented two type of standby databases supported by Data Guard, logical standby and physical standby databases in 11gR2 on two node RACHaving hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN.Data warehouse for data consolidation OLAP and BI,ETL, ERWIN, INFORMATICA, SNOWFLAKE.Installing databases preferably on-premise and Cloud PostgreSQLDesigning/developing/maintaining database schemasCALPINE CORP - HOUSTON, TX Jan 2015 Jan 2017Oracle/Postgres Database AdministratorCreated tablespaces, tables, indexes, set privileges and user logins on PostgreSQL and oracle databases.Perform maintenance activities like checking auto vacuum jobs, and customized vacuum on certain tables.Configured PgBouncer for connection poolingConfigured PgBadger for generating statistical reportsSupported Oracle DB backups (online/offline), logical backups and UNIX scripts, created clone databases, performed DBA day-to-day activitiesImplemented shell-scripts for automation of day to day activities.Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both OEM (client), Oracle 10g database control & SQL*Plus, as well as pre-developed UNIX shell scripts.Hand on experience in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature.Backed up and recovered/Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2 and 11g.Backup Oracle DBA for two major projects involving periodic administration, troubleshooting & tuning of 10 Oracle databases (10g & 11g single instances running on both IBM AIX 5.3, SunOS 5.8 & HP-UX B.11.11.Installing databases preferably on-premise and Cloud PostgreSQLDesigning/developing/maintaining database schemasConverting database schemas from on-premise Oracle databases to PostgreSQL database structures.Writing data conversion scripts from on-premise Oracle databases to PostgreSQL database structures/stored proceduresCare Heath - Edison, NJMar 2013 Jan 2015Oracle Database AdministratorSuccessfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.Oracle Production Support Database AdministratorAdministered and monitored over 150 databases both on 10g/11g on prod/test/dev environments.Administering Oracle Databases 10g/11g of sizes ranging from 100GB to 5TB.Migrated databases from File-system to Automatic Storage Management (ASM).Involved in migrating applications from Solaris 10g/11g to Linux 11.2.0.3 using Transportable Tablespace, RMAN Convert.Up-gradation of single instance databases from 10.2.0.4 to 11.2.0.3 onInstalled 12C grid control and Used Oracle Enterprise Manager Grid control 11g/12c for monitoring databases.Programming in shell to create shell scripts that automate the database backups and maintenance.University of Antwerp- AntwerpenMar 2011 Jan 2013Statistical consultancy and BIStatistical analysis, data managementStatistical reporting, and presentation.Data Modelling, mathematical ModellingStudy design and mentorship and external client consultation |