We provide IT Staff Augmentation Services!

Sr Database Administrator Resume

TexaS

SUMMARY

  • Over all 10+ years of experience as Database Administrator (Oracle, PostgreSQL, Mysql and AWS RDS & Aurora) having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell & Python scripting and documentation.
  • Experience in managing very critical, complex and very large databases in OLTP database systems as well as data warehousing environment.
  • Experience in Oracle, PostgreSQL and Mysql database administrator.
  • Experience working on ORACLE EXADATA Machine X4 - 2 for the extreme performance of the database and Oracle ZFS Storage Appliance ofAnalytics, a system for dynamically observing the behavior of your system in real-time.
  • Excellent experience in Installing, Configuring, Up-gradation, Migration, Patches Oracle, PostgreSQL and Mysql database administrator on Operating Systems such as Sun Solaris, AIX, Confidential -UX, CentOs, Ubuntu, Red Hat, Linux, and Windows. Skilled in cross platform migrations from Windows to Linux, Solaris to Linux.
  • Experience with Large Scale database migrations (On-prem to Cloud, On-prem to On-prem).
  • Plans and coordinates the administration of PostgreSQL databases to ensure accurate, appropriate, and effective use of data, including database definition, structure, documentation, long - range requirements, Replication and operational guidelines.
  • Highly proficient in all aspects of database administration, including backup/recovery/replication, clustering, advanced performance tuning, and proactive monitoring in Mysql.
  • Experience in Implementing experience with primary AWS/similar services like - (EC2, ELB, RDS, Route53 & S3).
  • Experience in AWS cloud ecosystem (specifically, RDS, Aurora, and DynamoDB) and management, troubleshooting and monitoring of highly available instances in AWS.
  • Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases to 11g,12c/18c/19c RAC environment.
  • Specialist in BMC Patrol, OEM 12C/13C, SolarWinds Database Performance Analyzer, SolarWinds System and Application Monitoring, AppDynamics Application Performance Management (APM).
  • Expertise in RMAN database backup and recovery to tapes and disk in catalog and no catalog mode. Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup.
  • Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard.
  • Proficient in setting up Standby/Dataguard Database by RMAN utility tool, activating and Re-building Standby/ Dataguard Databases both Physical and Logical supported. Expertise in sync of standby databases when it is out of sync with production database.
  • Excellent Experience in installing and maintaining Oracle Dataguard to implement physical Standby Databases for Disaster Recovery, configuration dataguard broker and Excellent Experience in Implemented Fast Start Fail over (FSFO) to initiate failover and switchover over by DGMGRL for annual test.
  • Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
  • Strong knowledge of PL/ SQL and SQL.
  • Configured DDL Replication in Golden Gate to enable DDL Synchronization and Troubleshooting Golden Gate issues.
  • Implementing Oracle GoldenGate in Oracle RAC environments (Source database) and Fine tuning existing GoldenGate processes with method of adding GoldenGate Parallel processing, Acceptation handling & adding heartbeat process to maintain lag reporting. Designed implemented, and supported both unidirectional and bidirectional replication leveraging multiple features within the Oracle Goldengate product suite.
  • Performance tuning of the database - SQL Tuning, Used Tuning utilities like TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
  • Expertise in performance tuning and troubleshooting on mission critical highly available databases.
  • Experience in taking Logical Backups by using Oracle Utility EXPDP and IMPDP and experience in loading data from flat files to database using Oracle utility SQL*Loader .
  • Worked with Oracle Support SR, and 24X7 support Environment
  • Excellent experience of data migration, data archiving and data access techniques
  • Hands on experience on Devops tools (Jenkins, Github, Docker and Anisble ).
  • Expertise in using Jenkins, its administrations, Pipeline as a code for workflow of projects.
  • Expertise in Experience in Shell/Python Scripting and automation.

TECHNICAL SKILLS

RDBMS: Oracle 8i/9i/10g/11g, 12c//18c/19c, PostgreSQL 8/9Mysql 7/8/9

Operating Systems: UNIX, Solaris, Linux, AIX, Confidential -UX, Centos,Ubuntu,Windows NT/95/98/2000/XP

Languages: PL/SQL, Shell Programming, Paython,C, C++, C#, PHP, HTML, XML, JavaScript, Batch Programming.

Tools: SQL Developer, PgaAdmin,Workbench,Oracle Enterprise Manager,Appdynamics,Solarwinds, Toad, Putty, Hummingbird 10, Erwin, Oracle Database Upgrade Assistant. ADDM, OEM12c, ADF, BC4J, ADF.

PROFESSIONAL EXPERIENCE

Confidential, Texas

Sr Database Administrator

Responsibilities:

  • Planed, Designed, Installed and configured Oracle/Mysql/Postgres/AWS RDS and Aurora database in production/lower environments on multiple platforms and as well as in Network systems .
  • Responsible for upgradation/patches of the multiple RDBMS databases (Oracle,Mysql,PostgreSQl), code deployments and database migrations (On-prem to Cloud, On-prem to On-prem) on multiple platforms.
  • Configured 12c/13c and Upgraded 12c from13c versions of Oracle enterprise manager (OEM) and configured the AppDynamics and SolarWinds system as well for monitoring of database and application servers.
  • Coordinating with oracle support in applying Full Quarterly Stack Patches on Oracle Exadata machine(patching the storage servers, compute nodes, grid, databases and InfiniBand switches).
  • Remote monitoring and administration using Integrated Lights Out Manager (ILOM) using both GUI and command line prompt. Generating ILOM snapshots for Oracle Support.
  • Configuring ZDLR backup policy for database via OEM.
  • Experience in Reviewing the Cluster Logs for troubleshooting and Implementing Cluster Health Check in RAC.
  • Experience in patching RAC databases in rolling fashion to maintain high availability.
  • Configuring Dataguard databases for prod database and Configuring Data Guard broker to manage standby databases for switchover as well as Data Guard Fast Start Fail over (FSFO) to initiate failover to the Dataguard databases.
  • Fixing Dataguard syncing issues by incremental backup or Restore archivelog files from backup .
  • Create and configure new 12/19c pluggable databases (PDB’s) as well.
  • Configured DDL Replication in Golden Gate to enable DDL Synchronization and Configured and setup complex bi-directional topology-based replication using GoldenGate Replication in Standalone and RAC environments.
  • Diagnosed and resolved extract, replicate and network issues during golden gate replication and Identified and resolved causes of slow startups, monitored process lag and statistics, identified network and disk bottlenecks, and performed tuning of key components.
  • Troubleshoot GoldenGate erroneous Skipping Transactions using LOGDUMP utility and Improved performance of GoldenGate Replicat using Range & BatchSQL Parameters.
  • Implementing backup and recovery (Logical and Online) .Setup and maintenance of replication setup in PosgreSql and Mysql databases.
  • Performing schema management, database sizing, maintaining privileges.
  • Responsible for Space Management for Capacity Planning and SQL analysis, schema revisions, security administration and user account maintenance.
  • Assisting the application teams during performance issues by identifying performance bottlenecks on the database system, storage area, Network level and assisting application team to resolve the issues without missing the User’s SLAs (Service level agreement)
  • Participating in problem management call and Provide root cause Analysis of problems and subsequently, make and implement recommendations to prevent future occurrences and document and shared in shared folder for references.
  • Monitor CPU usage, memory paging and I/O contention on UNIX server. Identify resource and performance bottleneck. Provide technical direction to system administrators.
  • Extensive Experience in writing Stored Procedures, Functions, Triggers and packages using PL/SQL.
  • Experienced in loading data from flat files into database tables using SQL*Loader, ETL Tools and External Tables.
  • Hands on experience in Building and maintaining automated processes within a CI/CD pipeline(Git/Gitbub/Jenkins and Dockers).
  • Participating in an active on call rotation
  • Providing off hours support to avoid impacting database availability during normal business hours.

Confidential, Texas

Lead Database Administrator

Responsibilities:

  • Working as Lead Database Admonitor/SME role in current project and Supporting and participating in root cause analysis and Problem Management activities for continuous improvement initiatives for service improvements, incident reduction and performance enhancements.
  • Implemented Active Data guard, creating both Logical and Physical Standby databases in 10g,11gRAC, 12C & 18c environment for the Production databases.
  • Develop, manage, and test database backup & recovery strategies, verifying data integrity in PostgreSQL
  • Perform database installations, configurations, upgrades, and migrations in PostgreSQL
  • Experienced PostgreSQL developers with strong skills in query tuning and analyzing explain plans.
  • Install, configure, monitor, upgrade and maintain MySQL databases in production and non-production environments
  • Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
  • Experience inOracle supplied packages, Dynamic SQL, RecordsandPL/SQL Table
  • Knowledge and work experience in RDBMS concepts, Views, Triggers, Stored Procedures, Indexes, and
  • Troubleshooting Cluster Startup Issues, Node Evictions, Network Issues and Storage Related Issues in RAC.
  • Experience in Reviewing the Cluster Logs for troubleshooting and Implementing Cluster Health Check.
  • Experience in patching RAC databases in rolling fashion to maintain high availability.
  • Configuring Datagurd databases for prod database and Configuring Data Guard broker to manage standby databases for switchover and failover operations.
  • Fixing Datagurd syncing issues by incremental backup or Restore archivelog files from backup .Implemented Data Guard Fast Start Fail over (FSFO) to initiate failover to the Datagurd databases.
  • Create and Configure new 12c pluggable databases (PDB’s) and upgraded 11g Databases to 12c databases.
  • Configured and setup complex bi-directional topology based replication using GoldenGate Replication.
  • Diagnosed and resolved extract, replicate and network issues during goldengate replication.
  • Improved performance of GoldenGate Replicat using Range & BatchSQL Parameters.
  • Used Logdump utility to troubleshoot and fix Goldengate replication issues by analyzing Goldengate trail files.
  • Fine tuning existing GoldenGate processes with method of adding GoldenGate Parallel processing, Acceptation handling & adding heartbeat process to maintain lag reporting.
  • Setting up CDC replication as active to passive & bi-directional topology for high availability active standby in data recovery scenario.
  • Designed implemented, and supported both unidirectional and bidirectional replication leveraging multiple features within the Oracle Goldengate product suite.
  • Identified and resolved causes of slow startups, monitored process lag and statistics, identified network and disk bottlenecks, and performed tuning of key components.
  • Performed Extract and Replicat ETROLLOVER in cases when needed recovery due to loss of Trail files.
  • Responsible for Proactive Performance Management using tools AWR, ADDM, ASH for diagnosing the root cause.
  • Fixing the problematic SQL quires, Loading hints from optimal plan value into SQL statements which are preforming slowness to pin the optimal plan value .
  • Examining the SQL statements by explain plan to see if it is doing a full-table scan and how cost is being used.
  • Checking database health and analyzing Schemas statistics when objects’ statistics are not up to date.
  • Monitor CPU usage, memory paging and I/O contention on UNIX server. Identify resource and performance bottleneck. Provide technical direction to system administrators.

Environment: Oracle11g/12c/18c and 19c,Mysql,PostgreSql,Aws,Golden gate12c/18c/19c,AWS, PGAADMIN,Mysql,Workbeanch,TOAD,SQLSERVER,AppDynamics,SolarWinds,Git/Github,Jenkins/Dockers,RMAN,ASM, RAC, TOAD, OEM12c, Java, J2EE, PL/SQL, SQL*Plus, SQL * Loader, Stored Procedures, Sql Developer .

Confidential, Texas

Oracle,PostgreSql and Mysql Database Administrator

Responsibilities:

  • Working as Sr Oracle Database administrator in dba for 24x7 supports inboth production and development environments
  • Monitoring Reports like Missed Backups, Orphan Users and Failed Jobs etc in Mysql Databases
  • Rebuild and reorganize indexes at regular intervals for better performance
  • Ensuring high availability of the database concepts of Mirroring and Log shipping on Mysql Databases.
  • Responsible for monitoring of Transactional Replication on Mysql Databases
  • Designing, planning, developing, deploying and supporting 19c/12c/11g Oracle databases, Golden Gate, Data Guard, RAC and ASM environments.
  • Implemented Active Data guard, creating both Logical and Physical Standby databases in 10g,11gRAC,12C,18c and 19c environment, Configured Data Guard broker to manage standby databases for switchover and failover operations and Implemented Data Guard Fast Start Fail over (FSFO) to initiate failover to the standby site in Production/Dev/Uat databases.
  • Troubleshooting Cluster Startup Issues, Node Evictions, Network Issues and Storage Related Issues in RAC.
  • Implemented Oracle Multitenant and migrated 50+ development databases to Pluggable databases.
  • Migrated the Oracle Database to AWS EC2 using One/Two and Zero Downtime Migration strategy.
  • Dealt with Datacenter migration to Amazon Web Services (AWS) infrastructure and provided support to Applications and Database teams.
  • Implemented TDE Security on database.
  • Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL & MYSQL databases.Installing and monitoring PostgreSQL database using the standard monitoring tools like Nagios.
  • Expertise in Tuning Memory, I/O and CPU Utilization, Disk Usage and Space Utilization.

Environment: Oracle 11g,12c &18c,Postgres,Aws(RDS,S3) Sql developer, ASM, RAC, OEM12c/13c, Goldengate 12.2/18c, Confidential -UX, IBM AIX, ASM, RMAN, Explain Plan, Data Pump, SQL*Loader, AWR and ADDM.

Confidential

Oracle Database Administrator

Responsibilities:

  • Working as Oracle database administrator specialist role in this project, taking care of all performance issues, and fixing them without missing of User’s SLA.
  • Excellent expertise in production database administration, support, installation, configuration, upgrades, code deployments, database migrations, patches, performance tuning, backup and recovery, cloning, space management, database security & auditing, Data Guard, RMAN duplicate, cloning, Goldengate replication and Data Domain Boost backups.
  • Installation, configuration and maintenance of Oracle 10g and 11g, 12c databases.
  • Implementation multi node RAC on Oracle 10g and Oracle 11g.
  • Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
  • Analyzing database performance and tuning database on Oracle Exadata using Real Application Testing (RAT)
  • Install, configure and support Uni-directional and Bi-directional Oracle-to-Oracle replicated environments utilizing GoldenGate.
  • Fixing the problematic SQL quires, Loading hints from optimal plan value into SQL statements which are preforming slowness to pin the optimal plan value .
  • Involved with code deployments in a replicated environment in a multi data center architecture.
  • Involved and guided the team in 6 Major Global Releases.
  • Performed Database Refresh from Production to QA, UAT and Development databases.
  • Upgraded the Oracle 10g database to 11g version and also applied patch set and interim patches whenever required to make the database software up to date.
  • Also added nodes to RAC for minimizing the downtime and maximizing the availability and also achieving load balancing.
  • Expertise in performing systems monitoring using Site scope and Oracle Enterprise Monitoring (OEM) tools
  • Installed Oracle Enterprise Monitoring for 10g, 11g and 12c Databases.
  • Configured the all the Databases into Oracle Enterprise Monitoring.
  • Monitoring Day-Day Backups, Log’s.
  • Extensive experience in DatabaseBackups RMAN(Full/Incrementalbackups) and in traditionalhot/coldbackups.
  • Experience inLOGICAL BACKUPSand Databasemigrationtools withDATA PUMP,Export/ImportandTransportable Tablespaces.
  • Good experience in writing/editing UNIXShell Scripts.
  • Implemented Data Guard with maximum availability, protection and performance configurations and worked with Data Guard Fail over and Switch over cases.
  • Resynced Out-of-Sync tables in GoldenGate replication.
  • Dealt with numerous errors in GoldenGate replication and ensured data synchronization between multiple data centers.
  • Achieved business continuity and high availability using GoldenGate.
  • Synchronized data changes that occur on the Source database near real time to the target database using GoldenGate.
  • Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases.
  • Implemented DRP (Disaster recovery plan) for critical databases.
  • Provided instance level performance monitoring and tuning for Wait Events, Sessions, Physical and Logical IO and Memory Usage.
  • Worked extensively on Performance tuning of Queries.
  • Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, TKPROF, AWR,SQLRPT and ADDM.
  • Assessed database capacity by monitoring online storage, requirement, growth and file system space, in adherence to the OFA.
  • Creation of Users and granting them the required Roles and Privileges accordingly.
  • Involvement in space management, rectification of lock problems, managed quotas.
  • Proficient inSQL, PL/SQL, Stored Procedures,Functions, CursorsandTriggers.
  • Responsible for capacity planning, database security, recovery planning and installing patches
  • Conducted time to time analysis and monitoring of the software and hardware requirements and act accordingly.

Environment: ORACLE 10/11g, PostgresSQL 8/9,PgaAdmin12C SQL SERVER, AIX 5, Confidential -UX 11, SLES 11, RHEL (Red Hat Enterprise Linux)6, SQL, PLSQL, RMAN, TOAD, OEM GRID, DATAGUARD, Golden Gate.

Confidential

Responsibilities:

  • Supported as 24X7 Oracle production/development database administrator to 25+ databases on 10 different servers with 2 TB in size.
  • Installation and configuration of Oracle Database Software 11gR2.
  • Implemented ASM on RAC. Managing disks and disk groups with ASM.
  • Performed migration from 10.2.0.4 to 11.2.0.4 for large databases up to 7.5 TB.
  • Installed and Configured 3 Node 11gR2 RAC on Red Hat Linux and added 2 Node to make it a 5 Node RAC.
  • Tons of experience in installation, configuration, troubleshooting RAC environments.
  • Involved in the project implementing and configuring Real Application Clusters (RAC) on Oracle 11g on different nodes using ASM.
  • Experience in patching RAC databases in rolling fashion to maintain high availability.
  • Setup Oracle Audit Vault and Database Firewall for monitoring and blocking SQL statements according to the company standard policies.
  • Configured Data Guard broker to manage standby databases for switchover and failover operations.
  • Implemented Data Guard Fast Start Fail over (FSFO) to initiate failover to the standby site.
  • Experience in setting up Oracle Database Vault for restricting access to special record for administrative users as a standard to SOX Compliance.
  • Experience in Enabling and Disabling Oracle Database Vault.
  • Used Oracle’s Transparent Data Encryption and Oracle Wallet to encrypt some of the data in the database.
  • Enabled Fine-Grained auditing at the Object level & specific DML Operations.
  • Experience in setting up Oracle Database Vault for restricting access to special record for administrative users as a standard to SOX Compliance.
  • Enabling and disabling Oracle Database Vault.
  • Performed Cloning for Oracle 11g databases to transport it to different machine, from development to testing environment applied patches using Opatch when required.
  • Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances using RCONFIG.
  • Migrating single Instance Databases to 2 Node RAC environments using Rconfig.
  • Built physical standby databases for RAC and standalone databases on Linux and UNIX platforms.
  • Load balancing of RAC instances.
  • Monitoring and administration of databases through OEM12c Cloud control 12.1.0.3.
  • Using Oracle Data Pump Network Link utility making faster exports/imports on large databases and saving lot of time.
  • Upgrading database from Oracle version 9i and 10g to 11g and migration of data.
  • Installation, Configuration and deployment of Oracle 11g database and Real Application Clusters (RAC) on different nodes with Automatic Storage Management (ASM).
  • Setting up Physical Standby Database environment using Dataguard in /11g in Max Availability Mode.
  • Responsible for providing DBA support for multiple SAP large databases in production, development and test environments.
  • Created Oracle partition tables and applied patches as per the requirements of the partitioning module and applied patches for DBMS software.

Environment: Oracle 11g/10g/,RAC, AIX 6.1, OEM Grid Control, LDAP, RMAN, TkPROF, LDAP, RHEL (Red Hat Enterprise Linux) v5.8.

Confidential

Responsibilities:

  • Responsible for providing DBA support for multiple SAP large databases in production, development and test environments.
  • Part of a 5-member DBA team managing 450+ production/QA/Development instances with databases sizes varying from few GB's to 75 TB's.
  • Developed UNIX shell script to automate the process of RMAN backups using RMAN Catalog.
  • Developed SQL Scripts to perform database checks.
  • Manage Oracle 11g/10g RAC databases of size 500g to 8TB.
  • Installed, configured, add, remove nodes in RAC environment and migrated single instances to RAC environment and performed RAC administration.
  • Involved in designing of disaster recovery using Data Guard, High Availability using 10g RAC
  • Adjusting Optimizer settings for improve SQL performance.
  • Role transition (Switchover/Failover) in Data guard.
  • Experience in upgrading the old OEM agents to the new OEM 12c agents and configuring different targets in 12c cloud control.
  • Created and setup rulesets for in OEM12c for user-defined metrics.
  • Worked on setting up Active directory based authentication in OEM 12c for determining the User Identity Access to enterprise manager cloud control.
  • Enabled Fine-Grained auditing at the Object level & specific DML Operations.
  • Used Data masking Pack as a security feature to secure the production environment data in other Non-Prod environment.
  • Involved in POC for DB Installation and configuration 11gR2 on Linux VM Environment’s.
  • Experience with Automatic Storage management implementation and also analyzing different problems including CSS related issues.
  • Adding, deleting and creating different ASM disk groups.
  • Performance analysis using AWR/ASH/ADDM reports and wait event analysis.
  • Manage Oracle 11gR2 RAC database varying from 2-6 nodes.
  • Administered 10g/11g Real Application Clusters (RAC) system on Linux x86-64 bit systems on ASM storage environments.
  • Involved in maintenance tasks like bouncing production databases and changing log modes of DB.
  • Test and Implemented NetApp Snap Manager for Oracle solution for configuring Backup & Restore for DB versions from 10.2.0.4, 11.1.0.7 and 11.2.0.2.
  • Installed Oracle 11gR1 & 11gR2 database for developers to test applications.
  • Performed regular Database Administration activities which involved - Database
  • Upgrades from 10g to 11gR1 and 11gR2. Installation of Oracle Software, Cloning Databases, Database Reorg and Backup and Recovery.

Hire Now