Montgomery Street, San Francisco, CA94105(555) 432-1000, resumesample@example.com
Summary
Highly motivated Sales Associate with extensive customer service and sales experience. Outgoing sales professional with track record of driving increased sales, improving buying experience and elevating company profile with target market.
Skills
Operating Systems
HP-UX 11.x. Sun Solaris 8, 9, 10. AIX 5.x, 6.x, Linux Enterprise Server 9, 10. Windows 2010, 2012
RDBMS
Oracle 19c, 12c, 11g, 10g, MySQL, PostgreSQL from 9.6.x to 12.x, Oracle 10g, AWS solution Architect.
Configuring PostgreSQL Streaming Replication and Pgpool for load balancing. Managing the monitoring tools for better performance like PgBadger, Kibana, Graphana, and Nagios.
Experience in upgrading and migrating various versions of PostgreSQL database on different platforms.
Responsible for backup, recovery, and upgrading of PostgreSQL databases.
Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization.
Extensive experience with Cloning and Refreshing pre-prod/dev databases with prod databases.Extensively used Database Administrative tools like Oracle Enterprise Manager, SQL
PLUS, AWS Console, SQL Server, TOAD etc.
Enforced Security Administration, system monitoring by adding and removing users, auditing, and analyzing security problems.
Wrote scripts to inform DBAs regarding the status, performance, and space management of the database.
Experience in Linux (RHEL 5.0, 6.0), Oracle Enterprise Linux 6.5, Centos.
Installation, configuration, and Hardening of standalone Linux servers.
Proficiency in Linux Command Line and Operating System.
Configuration and management of network services (HTTP, NFS, SCP NTP).
Experience in Performance Tuning (I/O, Memory & SQL Tuning) by using tools/utilities like Automatic Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM), Explain Plan, Autotrace, TKPROF and Statspack.
Experience in maintaining Oracle Data Guard and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods.
Good knowledge in Hot/Cold Backup, Recovery, and Cloning of databases using RMAN.
Installed and Configured the Oracle Databases (10g/11g) RDBMS, Performing Pre-installation, and Post-Installation Tasks
Expertise in Installing and configuring ASM and RAC for high availability databases.
Performed Strategic Planning, Logical and Physical Data Modeling & Application Tuning.
Strong troubleshooting, problem solving, analytical and design skills.
Experience in cloning Database from Production to Test and Development and from Development to Production.
Experience in cloud computing (AWS & IBM Cloud).
Good knowledge in Agile Methodology & DevOps Culture.
Have comprehensive knowledge and experience in Creating, Installing, Managing, Upgrading, Patching Oracle RDBMS, Cloning, Backup and Recovery Strategies, Managing Security, Users, Disk Space, Oracle File System Management, Task Scheduling, Oracle DATAGUARD, Performance Monitoring and Tuning, Real Application Clusters (RAC) and Oracle Flashback Technology and documentation.
Extensive knowledge on database administration for Oracle 10g, 11g and 12c, 19c with experience within very large-scale database environment and mission critical large OLTP and OLAP systems.
Excellent experience in installation, setup, and configuration of Oracle 10g and 11g in HP-UX, Sun Solaris, IBM AIX, Windows and UNIX/Linux Environment.
Hands on experience in configuring, managing, troubleshooting, and migrating single instance databases to multimode 10g, 11g R1, R2 and 12c, 19c RAC environments on various flavors of UNIX systems for high availability and load balancing.
Data loading using SQL
LOADER, Logical backups using full export and DATAPUMP.
Expertise in maintaining Database Security using security compliance auditing, and expertise in loading data from flat files using external tables, SQL
LOADER.
Participated in planning and implementation of off-site Disaster-Recovery planning and testing
Worked with development and operations staff in resolving problems quickly and efficiently
Configured and maintained Physical, Logical, Snapshot standby databases supported by Data guard on Oracle 11g, 10g RAC servers for disaster recovery procedures
Experienced in using Oracle's Transportable Tablespace (TTS) feature allows users to quickly move a user tablespace across Oracle databases.
Good experience in applying Patches, Critical Patch Update (CPU)/Patch Set Update (PSU) and One-off Patches using OPatch and run installer, also involved in Upgrading and Migration of an Oracle server to higher version available.
Proficient in Zero Downtime Migration to Oracle Exadata Using Oracle Golden Gate.
Experienced in capacity planning and estimating the growth of Oracle databases
Good exposure in Configuring Single instance, Oracle Real Application Clusters (RAC) and Automatic Storage Management (ASM), ZFS Storage, Exadata and Golden Gate
Expertise in installing, configuring, and maintaining Standalone and RAC databases.
03/XXX0 to CurrentPostgreSQL / Oracle Database Administrator (Consultant)Verizon | City, STATE,
PostgreSQL Installation, Configuration, Migration, Upgrades and Patches.
Server versions ranged from PostgreSQL 9.6, 10, 11 and 12.
Working as Lead PostgreSQL DBA and handling various duty of PostgreSQL DBA and providing support to consulting clients for various projects for ongoing issue in Development, Testing and PROD environment including Database upgrade, Application patches and DR activities.
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.
Installing and configuring new servers as per customer's request.
Cloning the Development, test and UAT environments with production data as per customer's request.
Design and implement disaster recovery for the PostgreSQL Database.
Configuring the backup jobs on customer system.
Experienced in performing PITR.
Patch, Upgrade and keep the PostgreSQL DBs current.
Develop and enhance scripts to automate and execute various DBA tasks.
Assist engineering team in the design of appropriate DB Schema and indexing strategy for performance and scalability.
Experience supporting a mission-critical database environment with 24x7 On-Call Support including weekends.
Identifying and resolving database issues.
Support developers for efficient SQL query and Identifying long running queries and optimizing.
Setup/Maintenance of Test/Development/UAT Servers setup.
Monitoring of system logs, OS logs, database logs, trace files, database alert files to detect and troubleshoot runtime problems.
Planning, deploying RDBMS Upgrades/Patches and performing other weekend maintenance activities as a part of On Call support.
Active participant in discussions related to Backup Strategy, DC/DR architecture.
Maintained, patched, and upgraded servers as required.
Disaster recovery planning or Emergency Recoveries and Ensuring Recoverability of Databases.
Optimize postgresql.conf for performance improvement.
Review all PostgreSQL logs for problems.
Ensure night corn jobs for backups, re-Indexing & vacuuming & materialized views executed properly on 24/7 high availability Postgres production and development databases.
Performed day-to-day activities like resolving tickets for multiple environments, provided environments, provided Production support, coordination with development for Application tuning.
Provided daily production support, worked on tickets assigned to my queue, making sure I meet the SLA for each ticket, making sure the stream controllers are running, attaining meetings and sending in daily reports.
Responsible for creating users, Groups, roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
Performed daily health checks on different servers and sending in reports for constant follow-up to developers, constantly monitoring the performance (V$ dynamic performance views at peak load) of the databases and viewing Alert log files.
Supported Production DBA on OLTP, Data warehouse environment.
Involved in Change/Release/Patch management, Production development, data center migration and Upgrade.
Administration including design, deployments, tune, troubleshoot.
Efficient to manage 50+DB.
Experience in monitoring, backups, scheduling instance startup and shutdown schedules, refreshes management, configuration of the AWS console.
Experience in migration and deployment of data to test, dev and prod.
For troubleshooting and performance resolution, I have gathered table statistics manually or using the OEM, I have run the AWR report, ADDM report, explain plans, SQL Tuning advisor and multiple other tools.
Proficiency with Installation and maintenance of replication tool Golden Gate by creating extract process, extract pump, and replicate.
Expertise in loading data from flat files using external tables, SQL.
Loader.
Experience with SQL, PL/SQL, UNIX Scripting.
Define and implement database schema and configurations working with our development teams.
Maintain and Monitor Oracle Golden Gate configuration for Real Time Replication of Data.
Timely respond to user Requests meeting our service level agreement.
Actively participate in monthly code releases as Main Oracle DBA Support.
Perform Monthly, Bi-weekly and weekly Production Refresh to Non-Prod environment.
Regularly provide Data to developers and Testers for analytics.
Monitor System and database performance.
Support 24/7 Oncall Rotation.
Apply Quarterly PSU Patches for Bug fixes.
Support Developers with daily deployments and monthly code release.
Respond to users’ requests within record time meeting our SLA.
Participate in Quarterly Fail-over simulation exercise for DataGuard for the purpose of disaster recovery.
Resolve system and database vulnerabilities to stay compliant.
Mentoring New-Hires and less experienced Team members bringing them up to speed.
Demonstrated expertise in creating architecture blueprints and detailed documentation.
Experience in Monitoring and Tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
08/2019 to 02/XXX0PostgreSQL/AWS (Solution Architect)/ Oracle Database Administrator (Consultant)BP Energy | City, STATE,
Installing and configuring new servers as per customer's request.
Cloning the Development, test and UAT environments with production data as per customer's request.
Design and implement disaster recovery for the PostgreSQL Database.
Configuring the backup jobs on customer system.
Experienced in performing PITR.
Patch, Upgrade and keep the PostgreSQL DBs current.
Develop and enhance scripts to automate and execute various DBA tasks.
Assist engineering team in the design of appropriate DB Schema and indexing strategy for performance and scalability.
Experience supporting a mission-critical database environment with 24x7 On-Call Support including weekends.
Identifying and resolving database issues.
Support developers for efficient SQL query and Identifying long running queries and optimizing.
Setup/Maintenance of Test/Development/UAT Servers setup.
Monitoring of system logs, OS logs, database logs, trace files, database alert files to detect and troubleshoot runtime problems.
Planning, deploying RDBMS Upgrades/Patches and performing other weekend maintenance activities as a part of On Call support.
Active participant in discussions related to Backup Strategy, DC/DR architecture.
Maintained, patched, and upgraded servers as required.
PostgreSQL Installation, Configuration, Migration, Upgrades and Patches.
Server versions ranged from PostgreSQL 9.6, 10, 11 and 12.
Operation support for Oracle & DB2 database 11g/12C.
Administer and managed large Databases of 10TB.
Provide front-line database support for Customers-facing Applications & Databases.
Track and close Tickets using SLACK and documentation using confluence.
Proactive monitoring of System & Database performance such as blocking Locks issues and long running queries, Load spike, resource contention, space issues etc using DB Artisan, Toad & OEM 13C top, Grafana Dashboard, to avoid any form of outage.
I have also created users, grant necessary privileges, roles and profiles; I have also been involved in database security where I managed users Profiles and passwords.
I have set and reset user's passwords, while creating, granting and revoking roles to users.
In administering database security, I have also configured and managed database auditing such as enabling standard, value-based and fine-grain auditing and monitor database activities.
Experience in maintenance and configuration of user accounts for dev, QA and Prod servers, creating roles for EC2, RDS, S3, and CloudWatch.
Experience in migrating and implementation of multiple applications from on premise to cloud using AWS service like SMS, DBMS, CloudFormation, S3, Route53, Glacier, EC2, RDS, SQS, and SNS.
Experience in migration and deployment of data to test, dev and prod.
Experience in monitoring, backups, scheduling instance startup and shutdown schedules, refreshes management, configuration of the AWS console.
To ensure the security of my databases I have implemented Auditing by enabling standard, value-based and fine-grained auditing and maintain audit trail.
I have also implemented some advanced security measures as projects such as TDE (transparent data encryption), network encryption and SSL authentication or database encryption.
For troubleshooting and performance resolution, I have gathered table statistics manually or using the OEM, I have run the AWR report, ADDM report, explain plans, SQL Tuning advisor and multiple other tools.
Proficiency with Installation and maintenance of replication tool Golden Gate by creating extract process, extract pump, and replicate.
Demonstrated expertise in creating architecture blueprints and detailed documentation.
Created bill of materials, including required Cloud Services (such as EC2, S3 ) and tools Involved in the end to end deployment process.
Experience in Monitoring and Tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
Performed Oracle Change data capture (CDC) Capturing changes in DB tables and storing them in special oracle tables which is used in accelerating data warehousing, enable real-time data integration across the enterprise, which improves the availability and performance of your databases.
Lift and shift of an existing on-premises application to AWS.
Selecting the appropriate AWS service based on data, database, or security requirements.
Identifying appropriate use of AWS architectural best practice.
02/2016 to 07/2019PostgreSQL / Oracle Database AdministratorHumana Inc | City, STATE,
Installed, Configured, Setup, Maintained and Supported Oracle 11gR1, 11gR2, 12c RAC, Physical and Logical Standby database on Test, Development and Production environments for various home-developed applications like Portfolio Management Systems and vendor applications such as SAP Business solutions.
Configured Oracle Golden Gate 11g and 12c for multiple databases as well as Monitoring and Troubleshooting GoldenGate issues.
Involve in 24x7 on-call support for 12c databases of at least 2.0 TB, 3 Node production 11g RAC databases using OEM 12c for Alert Monitoring and Notification.
Experience with SQL, PL/SQL, T-SQL, bash and shell scripting.
Migrated to Multitenant Architecture using CDB and PDB of applications that otherwise have their own instances and qualify to be PDBs.
Troubleshooted and resolved slowness or performance issues with extensive investigation using OEM or scripts and later follow-up with respective application teams with RCA and proposed solutions.
Configure Dataguard and Broker for administration of seamless switchovers.
Upgraded DBs from 11g to 12c with physical standby DBs in place and applied upgrade patch, maintenance and interim (opatch) patches on all the databases.
Analyzed and Utilized AWR, ASH and ADDM reports, EXPLAIN PLAN, SQL Baselines, SQL Profiles and SQL Tuning Advisor to troubleshoot and provide tuning recommendations to the application team.
Refreshed Dev and Test instances with data from Production on a regular basis using the datapump utility.
Day-to-day usage of Oracle 11gR2 features - Real Application Testing, automatic SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Flashback Database, compression techniques and several others.
Usage of enhanced 12c New features like - Real Application Testing, Table and partition recovery using RMAN, Invisible columns, DDL Logging.
Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.
Working with Application Development team to address any issues they encounter and provide support and resolution action plan.
Managed all indexing, debugging optimization and performance tuning using SQL Profile and SQL server Agent.
Involved in data integration by identifying the information needs within and across functional areas of an enterprise database upgrade and migration with SQL Export Utility.
Configured and administered SQL Clusters (Active/Passive, Active/Active) Database mirroring, Replication and Log shipping.
Responsible for all backup, recovery, and upgrading all of the PostgreSQL databases.
Participates in monthly failover from Source to Target for planned maintenance activities.
Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases 9.6, 10, 11 and 12.
Monitored and trained junior DBA.
Led projects like streaming Replication, Logical Replication,.
Performed Point in time recovery.
Conducted a lot of capacity planning.
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, and operational guidelines.
Migrated from Oracle to PostgreSQL with MTK, EDB Portal.
Migrated from On-Premise Oracle to Amazon RDS database with SCT and DMS.
Migrated from On-Premise PostgreSQL to Amazon RDS database.
Managed and Administer PostgreSQL on AWS RDS.
Using SSL with PostgreSQL DB Instance.
Managing upgrades of the PostgreSQL database version from 9.6,10 to 11.
Installed and configured SQL Server, Importing data into PostgreSQL on Amazon.
Used python to create and connect to a database, create tables, insert and update data.
Implemented automation for Unix and Linux environment using Python and Shell scripts.
Refreshed the Development, test and UAT environments with production data.
Active participant in discussions related to Backup Strategy, DR architecture.
Patch, Upgrade and keep the PostgreSQL DBs current.
Develop and enhance scripts to automate and execute various DBA tasks.
Planning, deploying RDBMS Upgrades/Patches and performing other weekend maintenance activities as a part of On Call support.
Establish and maintain security and integrity controls.
Perform quality control audits to ensure accuracy, completeness, and proper usage of data in tables and various support tools, such as database dictionaries.
Schedule and Ensure night cron jobs for backups, re-Indexing & vacuuming & refreshing materialized views executed properly on 24/7 high availability PostgreSQL production and development databases.
Tuning auto vacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples to optimize performance.Expertise in Analyzing data Quality checks using shell scripts.
Implemented Disaster Recovery and High Availability solution with PostgreSQL like Streaming Replication (1 Master 2 Slaves) with EFM for automatic failover.
Configured Logical Replication for real time replication.
Configured PgBouncer for Connection Pooling.Take backups with pg_dump, pg_dumpall, pg_basebackup and BART for incremental Backup.
Scheduling daily Point in time recovery (PITR) to the development environment for proper product testing.
05/2013 to 01/2016PostgreSQL / Oracle Database AdministratorMayo Clinic | City, STATE,
Installing and Configuring PostgreSQL from source or packages on Linux machines.
Data migration while upgrading database versions ranging from 9.6, 11 and 12.
Extensive experience with hot Standby (PostgreSQL 9.6, 11 and 12).
Fixing the memory issues and suggesting the best practices.
Responsible for monitoring environments using monitoring tool PEM, Nagios,Check Postgres.pl, custom scripts and other supporting tools like pgBadger.
Performance monitoring and optimization.
Experienced in migrating from Oracle to PostgreSQL with MTK.
Experienced in migrating from on premise Oracle to Amazon Aurora, RDS database.
Experienced in migrating from on premise PostgreSQL to Amazon Aurora RDS database.
Experienced in migrating from MySQL to Amazon Aurora RDS database.
Managed databases on Amazon RDS.
Cloned/Migrated databases using RMAN and traditional Datapump 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.
Scheduled and monitored Physical backups (hot & cold) in CRONTAB using RMAN utility.
Highly experienced in implementing Oracle's Transportable Tablespace (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.
Performed Installation and configuration of Oracle 11.2.0.1 database on Linux platform.
In addition, successfully performed some migrations from Oracle 11g and 12c to RAC Databases.
Used to run scripts for space management of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
Created Physical Standby databases using RMAN with zero downtime, performed Failover and Switchover using Data Guard Broker and manually as well and when required.
Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.
Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
Maintained the data integrity and security using integrity constraints and database triggers.
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”.
Education and Training
Expected in Bachelor’s Degree | Crop Production Technology, , GPA:
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
How this resume score could be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
