Successful Database Administrator with SIX years of experience in database development and production environments. Areas of expertise include maintenance and security. Proactive in establishing backup and recovery processes and protocols to protect and retain valuable company data. Extensive technical skills and advanced understanding of Oracle, MSSQL, and Postgresql administration. Strong collaborator and team player with excellent communication skills and expertise in analytical problem-solving.
Skills
Backup and Recovery
Upgrades and Migration
Database Security and Patching
Database Cloning
Database development
Oracle Data Guard and Data pump
Unix Shell Scripting and Automation
Transparent Data Encryption (TDE)
Performance Monitoring and Tuning
Database Design, QA
Education
, Expected in ā āBachelor of Science:Computer And Information Sciences - GPA:
Certifications
Comptia security +
Oracle Certified Associate (12c)
AWS Certified solutions Architect
Oracle Cloud infrastructure Architect - Professional
Oracle Autonomous Database Specialist
Work History
Fidelity National Information Services - Database Administrator Manchester, NH, 06/2020 - Current
Responsible for monitoring and making recommendations/ implementation for performance improvement in both production and non-production databases.
Monitoring CRON tab jobs on daily basis.
Assist with impact analysis of any changes made to the database.
Updating database tables with daily Excel spreadsheet.
Constantly monitoring performance of Databases and viewing Alert log files & Trace files.
Importing data from files into tables using the copy command.
Provide a day to day routine of the oracle,sql and ingress database both production and non-production
Monitor database logs for performance trends to identify abnormalities or errors.
Check status of databases such as growing table sizes, extent allocation, free space and used space.
Fidelity National Information Services - Database Administrator Monterey Park, CA, 01/2018 - 05/2020
Good Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, DST, Patch sets as per Oracle recommendations.
Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN(full and incremental).
Involved in each phase of life cycle (SDLC) including requirement gathering, technical design, development, system integration phase, quality assurance phase and production support activities.
Developed database monitoring/health check alert scripts for database up-time/downtime status, and sizing issues using grid control (OEM) and extensively used of Oracle Enterprise Manager to do daily tasks regarding performance, maintenance.
Upgrading and migrating Oracle 11gR2 RAC Databases running on legacy infrastructure to Oracle 12c Pluggable Databases running on latest platforms.
Extensive experience with Database Cloning and Refreshing pre-prod/dev databases with prod/pre-prod databases.
Implementation of Flashback Technology, Automatic Database Diagnostic Manager (ADDM).
Used EXPDP & IMPDP to take backup at database level or table-space level and also to accomplish table level and full database de-fragmentation (Data pump).
Experience in Extracting, Transforming and Loading (ETL) data using SQL loader utility.
Provide senior level DBA support for applications, including developing data migration scripts, data validation queries, and maintenance plan for various development versions of these applications.
Managing PostgreSQL and MSSQL Production Databases and their associated Non-Production Databases.
Configured Oracle Data Guard to ensure disaster recovery, high availability and data protection and also handling synchronization issues between primary and standby.
Expertise in database monitoring and performance tuning - this involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk tuning.
Hand on experience in cloning non-multi-tenant container database to pluggable database in 12c using PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature.
Implemented Golden Gate in moving large volumes of transactional data, with minimal impact to online systems.
Monitoring, Troubleshooting RAC cluster using SRVCTL and TAF.
(Performance tuning).
Performed multiple cross platform migration from regular file system to ASM.
Used RDA, Explain plan, ADDM and AWR reports to monitor database performance.
Installation and upgrading Golden Gate 12c software.
Diagnosed Oracle bugs and coordinating with Oracle support through metalink to resolve them in timely manner.
Migrated from oracle to Postgresql on perm to on perm using MTK tool kit.
Monitored and troubleshot Golden Gate replication issues.
Fidelity National Information Services - Database Administrator Oakland, CA, 07/2014 - 12/2017
Cloned/Migrated databases using RMAN and traditional Data-pump export/import utilities in Oracle 11gR2.
Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
Scheduling Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring scheduled jobs.
Pre-patch analysis for patches and document preparation with pre and post patch steps.
Creating Application Users, Profiles, Responsibilities, Menus, Functions for user.
Validating and creating grants & synonyms on Apps schemas, performed Jar file/forms generation as post patch step, relinking Oracle Apps programs.
Performing tracing for various use sessions and for various Concurrent programs (Performance tuning).
Monitoring Alert log and trace files for errors (performance tuning).
Managing OLTP databases RAC and Non-RAC having 24.
Providing Database dumps and schema level dumps to DEV and TEST database environments.
Performing re-org of schema/tables and data archiving at regular interval of times.
Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
Maintained data integrity and security using integrity constraints and database triggers.
Provided on 24X7 on call support for all production and development databases.
Configure Golden Gate Downstream Mining and integrated components for active-passive and active-active replication.
Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using run-Installer and.
Patch.
Highly experienced in implementing Oracle's Transportable Table-space (TTS) feature using Data-pump Export/Import (Oracle 11g, 10g) allowing users to quickly move user Table-space across Oracle databases.
Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Data-pump, conventional Export/Import of Oracle 11g, 10g.
Successfully migrated 12c Non CDB databases to pluggable databases.
Created Oracle Wallets and implemented Table-space level TDE security.
Created Physical Standby databases using RMAN with zero downtime, performed Fail-over and Switchover using Data Guard Broker and manually as and when required.
Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.
Maintained SQL Server Databases; ensured accuracy of information and automated numerous functions.
Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.