PostgreSQL DBA

Keerthi Reddy (US Citizen)

PostgreSQL DBA

*******.**@*******.***

SUMMARY:

·15 years of IT experience in the Database Administration, 7 plus years of PostgreSQL DBA experience.

·Strong Experience with PostgreSQL replication.

·Experience with SQL coding and tuning

·Applied patches both interim patches as well as patch set patch using Opatch and OUI in RAC environment.

·Tested ‘add node’ for scalability

·Expert level of PostgreSQL RDBMS installation/configuration, patching, troubleshooting, performance tracking/tuning, back-up/recovery, remote monitoring skills with hands-on experience in -large and very dynamic environments.Created database objects like table, view, database links, and synonym and materialized views.

·Monitoring disk space and mount points.

·Monitoring of different Tablespaces like undo, redo, temporary, archive redo log files

·Monitoring the performance of the database.

·Performing basic databases health checks

TECHNICAL KNOWLEDGE:

Operating systems: Windows 98, Windows 2000 Professional, Red Hat Linux 4, Red Hat Linux 9, Sun Solaris, HP-Unix, AIX-Unix and UNIX.

Languages/Tools: Amazon Web Services (AWS),Oracle 11g/10G RAC, PostgreSQL 8.4.x,9.5.x, SQL*PLUS and PL/SQL, Export, Import, Recovery Manager RMAN, SQL Explain Plan, SQL trace, Statspack, Tkprof, OEM, Logminer, Toad, Shell

Databases: Oracle,MySQL,Sybase.

PROJECT EXPERIENCE:

ADP- Andover, MA Apr 2017 – Till date

PostgreSQL DBA/AWS DBA

Working as PostgreSQL/AWS Database Administrator for VLC systems.

Responsible for following tasks

Installed/Configured PostgreSQL Version 9.6, 10 and 11 and monitored and managed them using PgAdmin and PSQL

Experience with physical Standby (PostgreSQL 8.x and earlier), and Hot Standby (PostgreSQL 9.x and greater) using Streaming replication.

Installing and configuring connection pooling tools like Pgbouncer and pgpool etc.

Responsible for all backup, recovery of all of the PostgreSQL databases using Barman to Backup PostgreSQL.

Using the PostgreSQL Workload Analyzer (POWA) performance tool to monitor, collect, aggregate and purge statistics on a PostgreSQL instance from various sources.

Automate database tasks using Shell scripting and Python programming.

Managing MySQL on AWS on EC2 and RDS services. Migrated Oracle databases to AWS Cloud environment with size of 300TB+ and 500+ instances.

using the PostgreSQL Workload Analyzer (POWA) performance tool to monitor, collect, aggregate and purge statistics on a PostgreSQL instance from various sources

Provision and Support Databases on AWS RDS cloud environment.

Migrating databases to AWS Cloud Environment.

Object Creation and Management

User and Role Management

Performance tuning

Able to troubleshoot problems with little or no assistance

Providing configuration, monitoring and on-call support for development, test, and production environments

Able to assist clients with PostgreSQL issues on the phone and via screen sharing software on the spot

Linux and Microsoft Windows experience required

Netflix – CA Dec 2013-Apr 2017

PostgreSQL DBA

Responsibilities:

Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases.

Administration of community edition PostgreSQL databases throughout the development and production lifecycles in a AWS environment.

In depth knowledge of the PostgreSQL architecture

Ability to diagnose problems and triage/resolve issues across various tiers (application, network, database, server, or storage tiers).

Ability to implement automation to reduce manual administrative tasks through use of jobs, scripts, cron, or other techniques.

Expert level of PostgreSQL RDBMS installation/configuration, patching, troubleshooting, performance tracking/tuning, back-up/recovery, remote monitoring skills with hands-on experience in -large and very dynamic environments.

Experience with PostgreSQL Monitoring tools

Experience with AWS/Cloud Services

Must be hands-on, technically adept DBA, capable of performing required DB tasks.

Good knowledge of disaster recovery principles and practices, including planning, testing and backup/recovery.

• Work with application owners to support database consolidation, migration and virtualization.

• Work with developers and analysts to support development efforts.

• Work with various internal teams such as server, storage, backup & network administration teams to coordinate and troubleshoot infrastructure related issues.

Strong understanding of PostgreSQL database backup/recovery techniques and replication techniques in a production environment.

VCE NY Feb 2013 to Dec 2013

Role: Sr. Database Engineer

Responsibilities:

As a DBA consultant, lead a e project for Database infrastructure refresh for the period from 02/10 – 04/13. Additionally performed following activities.

Oracle Database configuration, installation, migration & upgrades (standalone).

Real application cluster configuration and implementation.

Manage databases on clusterware and monitor the same for high availability enabled applications.

Oracle Database patching (interim PSU, standalone), rolling upgrade patch sets (RAC).

Plan database backup strategy based on business/application requirements and database criticality.

Database tuning using Oracle tools like AWR, ADDM, Sql Baselines and analyze query execution using different techniques.

Tuning database queries to improve better response time at application level.

Experience in building a new OEM 12c server, installing OMS, RCAT.

Database cloning based on application requirement using traditional, data pump and recover manager tools.

Recovery Manager (RMAN) for database upgrades and cloning from time to time based on application demands.

Setting up Standby databases and configure Data Guard on 11g environments.

Active participant of disaster recovery activities, testing production backups on the DR sites for data consistency and data availability.

Manage database on ASM storage, which involves monitoring of disk availability, addition of new disks and managing disk rebalancing based on database load.

Configuring Oracle Grid Control for advanced database monitoring and alerting mechanism.

Unix shell scripting for database advanced monitoring and alerting mechanism & corrective actions for any critical alerts.

Configuring & implementing Apex

Provide on on-call support during weekends to address critical issues and perform weekend production database maintenances.

As an Golden Gate consultant,

Initiate Database replication using Oracle Golden Gate.

Implement unidirectional replication on Dev, Test & Production environments.

Bi-directional setup on testing environment to produce the functionality and advantages t the business.

Monitor database replication to make sure the databases are in sync and handle replicate abend errors.

Golden gate process monitoring scripts to track issues and implement required corrective actions.

Maintain documentation on tasks performed at database levels and adhering to processes defined within the organization.

Upgrade from 10g to 11.1.1

Technology : Oracle 9i, 10g,11g, 10g/11g Grid, RMAN, RAC 10g, 11g, ASM, Data Guard, OEM, Golden Gate

CTS, Irving, TX Aug 2012 to Feb 2013

Role:Oracle DBA

Responsibilities:

Upgraded RAC databases from 10gR2 to 11gR2.

Add or Remove Node from RAC

Worked with customer for different RAC related issue

Troubleshoot performance issues for the RAC instances (GC events).

Monitoring health of database by keep on eye on all Alert log and trace files and if any error comes find out the root cause & analysis for resolution.

Regular maintenance activities like cloning, patching and custom code migration provide by developer and working with their issues.

Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold backups.

Migrate over 3 TB data from Across the Platform

Implemented and managed optimum physical database design (tablespace, data files, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space.

Running Statspack/AWR reports and analyzing them, take proper action base on information

Preparing Shell scripts and automating them through CRON and Control M scheduler for scheduled database monitoring tasks.

Daily Space monitoring in production server as well as development and UAT environments.

weekly table partition management

Monitoring Day-Day Backups, Log's & recovering them as per the requirement.

Analyzes data requirements, application and processing architectures, data dictionaries, and database schema(s), and then designs, develops, optimizes, to meet system(s) requirements.

Gathers, analyzes, and normalizes relevant information related to, and from business processes.

Identify poor SQL and pass to development teams for review

Involved in designing and implementing Oracle backup and recovery methods and disaster recovery methods using RMAN.

Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration.

Use of 10g flashback features such as flashback query, flashback table as well as undo management.

Created SQL*Loader scripts to load data into the temporary staging tables

Developed some Unix Shell scripts to automate database operation and database monitoring.

Implementing the changes in the database design and modifying stored procedures in PL/SQL if necessary.

Successfully Implemented key RMAN 10g features such as block change tracking, use of flashback recovery area and taking incrementally updated backup to meet backup and recovery goals.

Manipulated tables to manage the data and data types. Modified tables to change the data types and insert new columns (according to requirement).

Managed the databases on 2-node 10g RAC. Configured storage devices using ASM

Worked on the advanced features of Oracle 10g such as Automatic Storage Management (ASM), Automatic Shared Memory Management (ASMM) and Automatic Segment Space Management (ASSM).

Developed scripts to refresh of databases in stage and development environments using EXP, EXPDP or RMAN Duplicate database.

Generated DDL statements for creation of new database objects like tables, views, sequences, synonyms, indexes and created triggers, packages, procedures, functions and granted privileges.

Implemented and monitored all databases using Oracle Enterprise Manager (OEM) for maximum uptime and optimal performance.

Storage and space management including table spaces and data files.

Used Oracle 10g Enterprise Manager db console tools such as ADDM, AWR for diagnosing & monitoring events, jobs & performance related problems.

Migrated database objects from development to production instances.

Provided support to Application Database Administrators in designing the database.

Wrote PL/SQL packages tocalculate Missing Information and Determining Eligibility in the processing of Applications.

Used Shell Scripts to automate database operation and schedule batch jobs using CRONTAB

Applied security patches on staging and production databases

Environment: Oracle 10g, Oracle 9i, Automatic Storage Management, Solaris, Oracle Enterprise Manager, TOAD, Recovery Manager, Real Application Clusters, Tkprof, Crontab utility, Automatic database diagnostic monitor, Golden Gate

HCL America, OK Sep 2011 to Nov 2012

Role: Oracle DBA

Responsibilities:

Involved in installation of Oracle RAC on AIX.

Involved in performing migration from Oracle 10g to Oracle 10g RAC database.

Installation and maintenance of Oracle 10g Data Guard 24*7 Production Environment.

Upgrade and Migration of Database from 9.2.0.6 to 10.2.0.2 and applying patches whenever required.

Responsible for around 60 Oracle databases on 11 servers.

Maintained instances of around 750GB with 500 Users and around 60 Production and Development instances.

Troubleshooting on the databases for Application Server and Oracle database related issues.

Developed PL/SQL packages, Dynamic SQL, DML, DDL, Oracle tables, stored procedures, functions, Cursors, triggers and UNIX Shell scripts.

Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.

Involved in Oracle Warehoused Builder creating Star schemas, Partitioned Materialized Views and logs utilizing Query Rewrite and Start Transformation.

Created database objects like tables, indexes, synonyms, views etc. using SQL* Plus, used SQL*Loader control files to load data from external data sources into Oracle database.

Optimizing Oracle RMAN and ASM environment.

Taking Periodic Backup of the databases and the software using RMAN.

Flash Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).

Monitoring CPU usage, I/O Contention, memory paging on UNIX server. Provide technical direction to system administrator.

Environment: Oracle 9i/10g, AIX,Sun Solaris, Linux, RAC, SQL, PL/SQL, Oracle Streams, Stored Procedure, SQL*Loader, RMAN, Oracle Dataguard. OEM, Sybase.

SMART TRUST, New Jersey Jun 2010 - Sep 2011

Oracle DBA

Responsibilities:

Database creation/maintenance of database instances oracle8i/9i, Managing logical and physical database structures and rollback segments.

Monitoring Database Activities, Checking for Tablespace Availability, Checking the Alert Log File for errors, and monitoring the Hit Ratios.

Tuning for I/O Contention, Memory contention, Row Migration, Block Contentions, etc.

Planning Backup & Recovery procedures, Performing Backup and Recovery activities (both in archive & no archive mode) using Export/Import utilities.

Configuration/Troubleshooting of tnsnames, listener’s setup.

Configuration of standby Database.

Monitoring storage parameters for tables and indexes, monitoring databases for fragmentation at table space, table, row and de-fragmentation for optimal utilization of physical storage.

Cloning of production database to the test environment using hot backup & recovery.

Worked with backup team and was responsible for configuration and implementation of backup & recovery strategies using Export/Import, Hot / Cold Backup, RMAN.

Managing Application user profiles and managing concurrent managers, concurrent processing, load balancing etc.

Export and Import of database objects to copy from one database to another database with convention oracle export, import for 9i database.

Keeping database up-to-date by applying patches and worked with oracle support on different database issues.

Documentation of Data Base Setup, replication setup, important scripts and administration of Server Environment.

Environment: Oracle Database 8i – 9i, Linux, Solaris.

Radian May 2009 - Jun2010

Oracle DBA

Responsibilities:

Involved in logical and physical database design and implementation

Involved in the setup of the network and creating the DBA Processes

Responsible for creating and managing user accounts efficiently

Perform day-to-day database administration and ensure integrity, security, and daily health checkup of the database

Routine Alert Monitoring and Administration of Oracle Databases

Upgrade the database from 8.1.7 to 9.2.0.3

Taking Backup of Database Using Logical (Export & Import) & Physical (Online & Offline).

Developing the front end for issue tracking, Quick issue search and Miscellaneous feature screens of E-Trace

Environment: Oracle Database 8i – 9i, Linux

CIGNA, India Feb 2007 to May 2009

Oracle Database Administrator

Responsibilities:

As a database administrator I used to manage core Database activities like Database installation and configuration, Oracle Application Server 10g implementation. I have experience in implementing and configuring Oracle 10g Grid for advanced database pro-active monitoring.

Installation, configuration, Managing, upgrading of Oracle Database environments and related products (9i, 10g) on Unix and windows Environment.

Deployment of existing and new databases on Oracle 10g Grid control for advance monitoring.

Database refreshes (Prod to Test, Prod to Dev)

Manage Logical and Physical backups.

Periodic performance monitoring and fine tuning of Databases/Applications.

Perform database backup and recovery using RMAN.

Configuring Disaster Recovery Sites (DR) for production and critical database.

Configuring various monitoring scripts using shell scripting for advanced database monitoring.

AWR, statspack analysis for performance enhancement.

Develop PLSQL codes as per requirement and assist application team.

Identify top SQL that are consuming heavy resources.

Perform internal Database audits.

Health check report alerts to track database growth, tablespace issues, archive hung issues and file system storage issues.

Technology : Oracle database 9i/10g, 10g Grid, RMAN, Data Guard, OEM

OS : Rhel, Solaris, AIX, Windows Server

Oracle DBA Consultant Feb 2005 to May 2007

Putnam - Boston, MA

Responsibilities:

Monitor Oracle Alert log file for error handling and solving problem.

Monitoring Archive log location space and maintaining sufficient archive location space.

Creating of Oracle user and granting proper privileges to user as per request.

Configuration of Listener and Tnsnames through NETMGR and NETCA and statically also.

Creating Indexes, views and Synonyms to increase the performance.

Database backup and Recovery.

Creating AWR, ASH and ADDM report.

Renaming and resizing of datafiles in Oracle database.

Cloning using Hot and Cold backup (manually) in Oracle database.

Creating and managing RMAN catalog in Oracle database.

RMAN cloning for Oracle database.

RMAN block media recovery in Oracle database.

Export and Import using data pump in Oracle database.

Configure disaster recovery site (Physical standby database) in Oracle database.

Adding / Resizing data files in Oracle database if needed.

Marking TNS entries and checking Listener status, connectivity of Oracle database.

Generating AWR/ADDM reports in Oracle database.

Taking Oracle RMAN Backups (Scheduling for day wise backup)

Export of important tables at regular intervals in Oracle database.

Creating user Profiles, granting specific privileges and roles to the users in Oracle database.

Maintaining table spaces & data files, Control files, Online Redo log files in Oracle database.

Contact this candidate