Uploaded File
add photo
Vilma
Kinyuyvilma@gmail.com
540-805-0158
Harrisonburg, VA 22807
Currently working Oracle/PostgreSQL Database Administrator
7 years experience W2
0
Recommendations
Average rating
6
Profile views
Summary

I am a proactive Oracle/PostgreSQL database administrator, detailed oriented, team player with Five (5) years of experience working on different oracle/PostgreSQL versions oracle (10g,11g,12c, 18c and 19c) PostgreSQL (9 and 10). existing on different platforms such as Linux. Unix and Windows. I have good experience in backup and recovery, performance tuning, security, migration and refreshes. I have participated in projects like. Data guard, Golden Gate, RAC, patches, upgrades Migration from Oracle to PostgreSQL. I have done installation and configuration of oracle and PostgreSQL and aws software’s.

SKILLS SET

  • Oracle Database Administrator having hands and experience in database installation, administration, configuration, production support, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation.
  • Over 5 years of PostgreSQL installation, configuration, performance monitoring, database design, migration form Oracle to PostgreSQL, security, troubleshooting, as well as backup and data recovery.
  • Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 12c Grid and 11g on ASM and OCSF2 file systems.
  • Highly experienced in Oracle 11g, 12c Automatic Storage Management (ASM) required to fulfill the storage needs.
  • Installation and configuration of oracle Golden Gate.
  • Experience in using Golden Gate to support data replication in the Oracle database environment.
  • Experience in Golden Gate upgrade from 11g to 12c.
  • Experience in applying PSU patch on standalone as well as RAC databases.
  • Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 12c, 18c RAC servers for the purpose of disaster recovery procedures.
  • Setup and maintenance of Postgres master-slave clusters utilizing streaming replication. Cross-datacenter disaster recovery and backup architecture
  • Performing schema management, database sizing, maintaining privileges. Data migration while upgrading database versions ranging from 8.2 to 9.6.
  • Experience with Warm Standby (PostgreSQL 8.x and earlier), and Hot Standby (PostgreSQL 9.x and greater)
  • Migration to aws setup database in aws.
  • Create aws instances and managed them for performance.
  • Manage EC2 instances.
  • Installing pivotal-support packages to monitor performance like (gpsupport and mem_watcher.. etc)
  • Fixing the memory issues and suggesting the best practices.
  • Responsible for monitoring environments using monitoring tool viz. Nagios, Check_Postgres.pl, pgOn, custom scripts and other supporting tools like pgBadger and tailnmail.
  • Created SQL reports per requirement.
  • Troubleshoot and resolve database problems.
  • Configured Manager, Replicate and Extract processes and implemented unidirectional replication using Oracle 11g/12c Golden Gate on RHEL 5.
  • UNIX shell scripts for hot backups, SQL*Loader, export and import of database.
  • Proficient with Database Cloning, Migration, and Patching of Oracle Databases.
  • Installed Oracle 11g with ASM and OCFS2 File systems.
  • Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
  • Configuring backup strategies with image copy, level 0 and level 1 RMAN backup
  • Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
  • 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”.
  • Highly experienced in implementing Oracle's Transportable Tablespaces (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
  • Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 10g, 11g, 12c and 18c.
  • Experienced in using 10g features like 10g RMAN, Data pump Flash-Back Recovery and ASM.
  • Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.
  • Expertise in maintaining Database Security using auditing.
  • Experience in doing upgrades including maintenance & monitoring implementation.
  • Extensive knowledge in UNIX platforms includes SOLARIS, AIX, and LINUX.
  • Knowledge in configuring ASM (Automatic Storage Management)
  • UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.
  • Database Performance Tuning Diagnosing using AWR (Automated Workload Repository) / Stats pack and ASH (Active Session History) reports, ADDM (Automatic Database Diagnostic Monitor) analysis.
  • Proactive database monitoring via automatic Email and Text alerts of Alert.log, Listerner.log and Space errors to DBA cell phone
  • Experience in Upgrading databases, applying patches.
  • Managing Security Management, Schema Management, Instance Management, Storage/Space Management.

Experience
Currently working Oracle/PostgreSQL Database Administrator
Information Technology
Nov 2019 - present

Responsibilities: Tuning auto vacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples.

  • Contributed to decreasing need for downtime by developing and improving procedures for automated monitoring and proactive intervention.
  • Studied and stayed current on features and functionality of PostgreSQL.
  • Proactive managing standby replication methodologies like Streaming replication and hot standby for disaster recovery.
  • scheduling daily Point in time recovery (PITR) to the development environment for proper product testing.
  • Design High Availability applications on AWS across availability zones and different Regions.
  • Championed database/application migration from on premises Oracle and PostgreSQL to AWS RDS on the cloud, using Migration Tools such as DMS, SCT, VM IMPORT/ EXPORT
  • Used S3 cross replication to implement S3 bucket backup strategy.
  • Setup S3 cross region replication on AWS same account and AWS different accounts.
  • Utilized VPC, EC2, RDS, Lambda, Route53, ELB, CloudFormation and other AWS services to migrate on-premises applications to AWS.
  • Expertise in Amazon AWS Cloud Administration which includes services like: EC2, S3, EBS, VPC, ELB, SNS, RDS, CLOUD WATCH, ROUTE 53, Auto Scaling group, Cloud Trail, Cloud Formation, security groups, CloudFront Aws Lambda, ECS and ECR etc
  • Templated several AWS resources in CloudFormation template to ensure immutable infrastructure deployment.
  • Implemented disaster recovery strategy by using Lambda function to copy over database snapshots to another region and using cloud formation template to build same environment in the target region within the RPO/RTO time frame.
  • Have created and mange PostgreSQL databases on EC2 instances.
  • Have created and mange PostgreSQL databases on RDS as well as oracle.
  • Restore database backups in my sS3 bucket.
  • Configuring log analyzation tools like pgfouine and pgbadger etc.
  • Installing and configuring Nagios check postgresql.pl plugins for Monitoring PostgreSQL instances effectively.
  • Proactive in updating the latest security patches to database, which are provided by PostgreSQL open-source community.
  • Installed, configured, and maintained Oracle 11g and 12g, 18c and 92c on Linux and windows. Also Upgraded from Oracle 11g to 12c and 12c to 18c & 19C.
  • Database Oracle and PostgreSQL performance monitoring and tuning. Backup and recovery and instituting backup strategies.
  • Migration from Oracle to PostgreSQL using EDB MTK (EDB 's Migration tool kit) and exposure to AWS migration procedure.
  • Configure Physical standby data guard for disaster recovery.
  • Configure enterprise manager and AppDynamics tools for monitoring databases.
AWS AWS EC2 AWS RDS AWS S3 Data Replication Database Backups DBA Disaster Recovery Nagios Oracle PostgreSQL SQL SQL Server Windows
Remove Skill
SQL Server Database Administrator
Information Technology
Apr 2017 - Oct 2019
Chicago, IL
  • Experience as SQL Server Database Administrator and Support of SQL Server
  • 2005/2008/2012 in production Development and QA environments.
  • Experience in availability SQL Server solutions including Log shipping mirroring replication and clustering.
  • Experience with install, configure, and administer database software within the Microsoft SQL server stack including SSRS, SSAS and SSIS.

CORE RESPONSIBILITIES

  • Monitoring SQL related incident tickets, change requests and service calls for 27/7 environment.
  • Monitoring the sql servers by accessing remotely & analyzing the databases size.
  • 1nstallation, configuration and maintenance of MS SQL Server 2005/2008R2/2012.
  • Checking the status of backups, Troubleshooting the failed backups and restoration. of databases.
  • Monitoring SQL Server Error log and windows event log.
  • Scheduling sql jobs using sql server agent.
  • Monitoring SQL Server Agent jobs - Review for failed SQL Server agent jobs.
  • Ensuring data consistency in the database through DBCC commands.
  • Checking Storage - Validate we have sufficient storage on our drives to support databases, backups, batch processes etc.
  • Adding users in the database and granting necessary permissions as and when required.
  • Manage end-to-end complex data migration, conversion, and data modeling.
  • Participating quality management reviews as outlined in the Verification and Validation.
  • Overview. Ensure security in reporting and data warehousing.
  • Delivering innovative BI & Data warehouse solutions
  • Experience Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases.
Data Migration Data Modeling Data Replication Database Backups DBA PostgreSQL SQL SQL Server SSAS SSRS Windows
Remove Skill
RAC and non RAC databases
Information Technology
Feb 2015 - Feb 2017
Greensboro, NC

Responsibilities:

  • Tuned performance of RAC and non RAC databases. Found bottlenecking queries that impede application performance and fine-tuned them.
  • Installed Oracle Database 11gR2 with Real Application Cluster (RAC) with CRS and ASM in linux environment.
  • Involved in migration to aws
  • Implemented and troubleshooting Golden gate (unidirectional and bidirectioal) for real time replication purpose both on homogenous and heterogenous environments. .
  • Tuned databases for memory tuning by adjusting Buffer cache size, log switches and reducing check pointing, increasing sort area sizes, shared pool area, prioritizing Oracle processes and increasing SGA overall.
  • Manage database runing on aws
  • Coordinate, allocate and setup disks for data files, backups and achieve log sizes for ASM through SAN storage, SAN storage to setup VOTING and OCR ASM LUNS per cluster, swap storage and shared memory needed per each node.
  • Tuned performance of databases. Found bottlenecking queries that impede application performance and fine-tuned them.
  • Periodically clone terabyte databases to QA and UAT.
  • Setup instances on aws and manage performance issue in databases.
  • Troubleshooting Golden Gate issues involving collusion, replication erros and lags.
  • Used Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM), ASH report, SQL tuning advisor, SQL access advisor, Segment advisor, SQL profiles, SQL baselines, SQLT reports, TOP, SAR, VMSTAT, IOSTAT, GLANCE for Performance tuning
  • Implemented Dataguard Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 11g R2.
  • Hands on experience in E-business suite application monitoring, configuring and instalations.
  • Cloned/Migrated databases using RMAN and traditional Data Pump export/import utilities in Oracle 11gR2..
  • Perform RMAN operations (Incremental Backups). Helped developer to install Oracle Client, troubleshoot and establish the connection to Oracle database through ODBC, JDBC.
  • Invole in Exadata implimenation, monitoring, upgrade, patching and migration.
  • Implemented and troubleshooting Data Guard and GoldenGate for high availability/disaster recovery purpose.

Data Replication Database Backups Disaster Recovery Oracle Performance Tuning SAN SQL
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Skills
Data Replication
2021
5
Database Backups
2021
5
SQL
2021
5
DBA
2021
3
Disaster Recovery
2021
3
Oracle
2021
3
PostgreSQL
2021
3
SQL Server
2021
3
Windows
2021
3
Data Migration
2019
2
Data Modeling
2019
2
Performance Tuning
2017
2
SAN
2017
2
SSAS
2019
2
SSRS
2019
2
AWS
2021
1
AWS EC2
2021
1
AWS RDS
2021
1
AWS S3
2021
1
Nagios
2021
1
Adobe Flash
0
1
Data Center
0
1
Database Design
0
1
Database Installation
0
1
Database Upgrades
0
1
Scripting
0
1
Shell Scripts
0
1
Storage Management
0
1
UNIX
0
1