SUMMARY

• An experienced professional in Oracle and PostgreSQL database administration with progressive 4 years oracle experience and 3 years as PostgreSQL DBA.
• I have worked on platforms such as Linux, Unix, Solaris, Windows.
• I have handled performance tuning, conducted backups and ensure integrity and security in the database.
• I have equally worked on test and production environments carrying out DBA activities aimed at ensuring database performance and availability. During this period,
• I have worked with PostgreSQL databases as support where I migrated data from oracle to PostgreSQL in AWS cloud.
• I have also been involved in variety of oracle projects such as RAC for HA and scalability, Data guard for disaster recovery, Golden gate for replication, perform updates and quarterly patches when necessary.
• I am very flexible to novelties, enthusiastic, adaptable to changing environments, proactive and team player with exceptional writing, verbal, analytical, and possesses great problem - solving skills ability. 3+ years of supporting one or more: MySQL/Aurora, Postgres, Redshift
• Linux experience as it pertains to database and OS performance monitoring, log monitoring, MySQL installation and upgrades.
• Strong troubleshooting and problem solving skills with a nose for sniffing potential issues
• Ability to explain problems as well as solve them
• Identify alternatives, or different approaches specific to digital, information management and big data solutions with product mindsets
• Implement and maintain automation efficiencies using scripting languages (Python, KSH-KornShell, SED, or AWK) in a UNIX environmen
• Experience in architect and deploy the reliable AWS RDS Aurora Postgres
• Designing the user access provision based on the industry best practice
• Troubleshooting the performance related Issues on Postgres Instance using Performance Query plan Management (QPM).

TECHNICAL SKILLS

• INSTALLATIONS/DESIGN/PATCHING Hands on in Design, Upgrade, Patch management, Migration, Database Refresh, Cloning Configurations in OLTP as well as OLAP environments
• RDMS Databases
• Oracle 10g, 11g, 12c
• Postgres Server 9.6-11 on premises and on AWS RDS
• Microsoft SQL Server 2008 & 2012
• MySQL 5.7 & 5.6
• Database Technologies/Tools Pg Admin, Pg badger, PgBackRest, Pg Hero, RMAN, OEM 10g 11g & 12c, Oracle Data Guard, Oracle RAC, Data Pump, GoldenGate, SQL
• Loader, ASM, AWR, ADDM, SQL
• Plus, SQL Developer, SiteScope, HP ALM, Serena, BMC remedy, OpsWare, Toad, DB Artisan, SolarWinds, MTK
• Languages PL/PGSQL, PL/SQL, Shell Script, PERL, Java, C++, HTML.
• Business Productivity Tools Tableau, MS Office Suite (Word, Power Point, Excel, Outlook), MS Visio, Adobe Photoshop, and Dreamweaver
• Operating Systems HP-UX 10.x, 11. x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, Centos 7 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x., Windows 98/XP/Vista/7,8 & Server, Mac OS
• Other tools BMC Remedy, MS-Outlook, Putty, VMware, Oracle VirtualBox, and VNC
• DBA
• Postgresql
• Oracle Dba
• Sql Server
• RAC
• ETL
• Oracle Database
• Rman
• MYSQL

PROFESSIONAL EXPERIENCE

PostgreSQL Database Administrator

Confidential

Responsibilities:

• Hands - on experience in PostgreSQL as well as EDB PostgreSQL architecture.
• Configuration of EDB PostgreSQL for production, pre-production and non-production environments.
• Upgrading databases servers leveraging pg dump, pg restore and pg upgrade.
• Administrated PostgreSQL databases throughout SDLC including the non-production (Sandbox, development, test,) and production environment
• Experienced with optimizing database performance through exhaustive pro-active testing
• Performed Installation/configuring PostgreSQL. Mainly PostgreSQL VERSIONS 9.6, 10.11 and 11
• Exposure to cross platform migrations and performed and documented Data Migration from Oracle databases to PostgreSQL database in AWS Cloud using SCT.
• Managed and monitored databases using pgAdmin
• Planned and implemented streaming replication slots on a reporting system
• Managed and monitored many databases using pgAdmin
• Leverage pghero for Performance tuning mostly. SQL Tuning using EXPLAIN ANALYZE and PG STAT ACTIVITY, PG STAT ALL TABLES
• Performing core DBA tasks such as, creating roles, granting privileges, creating tables.
• Implementing the use of indexes, and primary & foreign key constraints as required
• I have provided production based on a ticketing system. And Assisted in defining and implementing MAINTENANCE PLAN for the database system.
• Performing maintenance activities like vacuum, vacuum full, analyze etc
• Experience of tuning PostgreSQL server settings & Troubleshooting performance issues.
• Configuring pgBadger for generating statistic reports.
• Configuring and troubleshooting PgBouncer for connection pooling.
• Used Customized scripts in crontab, to monitor database growth, TABLE growth, automated backups using cronjobs.
• Using customized scripts to perform maintenance;
• Checking the AUTO VACUUM jobs, Customized VACUUM on certain tables and columns
• Experience in handling logical and physical database BACKUPS using pg dump, pg basebackup as well as pgBackRest.
• Assisted in developing and implementing best practices for Disaster Recovery and Backups.
• Hands on experience on restoration techniques on PostgreSQL like pg restore and (PITR) Point in Time Recovery.
• Perform BACKUPS, and RESTORE, Compressed (gzip) BACKUPS, Database Or Schema REFRESHES
• Configuring streaming replication (including cascading replication). I have configured a REPLICATION between MASTER and STANDBY, and monitoring On-Going REPLICATION

PostgreSQL/Oracle Database Administrator

Confidential, Chicago, IL

Responsibilities:

• Install and configure servers for PostgreSQL versions 9.7,10.7 and 11.4 on both Windows and UNIX platforms
• Experienced in tuning PostgreSQL server settings and troubleshooting performance issues.
• Configure REPLICATION between MASTER and SLAVE, and monitoring replication on a daily basis.
• Exposed to cross platform migrations Oracle to PostgreSQL where I documented and assisted during migration from ORACLE Databases to PostgreSQL database in AWS Cloud.
• Configured PgBouncer for connection pooling and PgBadger for generating statistical reports.
• Perform maintenance activities like checking on AUTO VACUUM jobs, Customized VACUUM on certain tables and columns.
• Rewrote and implemented a backup strategy following company SLA; execution of backup schedule for both physical using Pg basebackup and PgBackRest and Pg dumpall and Pg dump for logical backups
• Championed database migration from Oracle to PostgreSQL on premises and on AWS, using Migration Tool Kit, Ora2pg, DMS and SCT.
• Support daily administration, monitoring, tuning, and troubleshooting of clusters and single instances on UNIX/Linux and AWS Console (Database sizes range 100GB to 21TB)
• Implement table and index partitioning to improve query speed.
• Monitor CPU utilization, memory, Database Connections and storage space daily using pg stat activity, PEM, Pg view and AWS CloudWatch alarms. Also use customs shell scripts deployed on crontab to monitor performance and resources.
• Clone databases using creation templates and pg dump for testing purposes.
• Daily logs revision for unusual events and performance issues and took appropriate action according to company policies and incident reports.
• Perform PL/PGSQL errors fixes for application issues.
• Deployed Database security policy and installation, using passwords, privileges and user profiles, Enabled Encryption for databases.
• Participate in capacity planning meetings to meet the demands of the dynamic aspects of storage and memory for the databases
• Perform Database Refreshes from production environments
• Perform patching and upgrades of Databases using AWS minor versions upgrades, pg upgrade, pg dumpall and logical replication
• Provided Memory tuning by using ASMM (Automatic shared Memory Management). Sort area size, Buffer cache, Shared pool size, Different pools like Recycle pool, Keep pool.
• Migrated database from Solaris to Linux with Data Pump and Golden Gate. Migrated from SQL Server / DB2 to Oracle and Oracle to SQL Server unidirectional and bidirectional using Golden Gate 11g and 12c.

Oracle Database Administrator

Confidential

Responsibilities:

• Primary DBA for 100+ databases of Oracle 10g/11gR2 on Linux REHL, HP - UX. Worked as per ITSM/Remedy Incident ticket/Critical Response Time (CRT) call.
• RAC- Administration/Trouble-shooting of 3 Node cluster on Oracle 10g/11G R2. Configuring Grid Infrastructure SCAN Listeners on 11gR2.
• Migrate OCR files to ASM, Troubleshoot Resource related issues. Cluster-wide Resource management such as create resource plan, Service configuration, parallel instance group, Application Isolation. Stress testing, benchmarking of clustered database.
• Involved in projects using Golden Gate 11.2 for data replication, data distribution, database synchronize and database migration and data consolidation. Skillful in data mapping and real time replication. Migrated VLDB database between various RDBMS platforms with Golden Gate with limited downtime
• Managed ASM storage. ASM cloning. Prepare/Add/remove ASM disks. Tuning of I/O on ASM based databases. Troubleshoot ASM crashes & memory problem.
• Data guard - configure primary -standby using duplicate from active database command of 11g. Apply SCN-based Incremental backup to sync standby after loss of Archive logs on primary. Measure data loss based on latency/lag. Cross-platform migration using Data guard
• Performed incremental backups using Recovery Manager (RMAN). Created recovery catalog, performed complete and incomplete recovery using RMAN.
• Installation of 2 nodes 10g RAC on Linux & Solaris with veritas cluster. Configured ASM, OCFS and RAW devices. Troubleshooting & tracing of RAC processes & CRS components. Relocate service. Tuning of RAC environment. Managing fail-over of instances. Resource utilization on each node. Monitor top objects in cache fusion and traffic.
• Backup by RMAN and Data Pump. Consistent backup using Data Pump. Diagnose and repair block level corruption using RMAN. Script and test RMAN backup/restore. Optimizing backup by compressing.
• Troubleshooting RMAN restore. Used RMAN convert command to transfer datafile from ASM.
• Audit database performance using ADDM reports, AWR snapshot and diagnostic SQL scripts. Identify and tuning of ad-hoc queries, PL/SQL code which are highly intensive resources. Tuning instance by init parameter. Used explain plan and stats pack/TKPROF utility to Improve response time of query. Create/manage local partitioned and bit-map indexes.
• Developed, modified and optimized very complex queries to data retrieval using Explain Plan, SQL Trace, TKPROF, parallel processing and partitioning techniques.
• Monitoring the CPU, memory usage, I/O contention on servers using top, iostat, sar, glance, vmstat etc.
• Designed daily, weekly Backup and Recovery procedures for production, non- production databases using RMAN backups taking periodic Complete, cumulative and differential Incremental Backups
• Data Refresh/Cloning from Production environment to setup QA/ DEV using RMAN Duplicate
• Scheduled UNIX scripts in crontab jobs to automate daily tasks like backups, monitoring the alert logs, backup logs, cleaning the old archive logs, old log files, tablespace monitoring
• Performed Online and Offline backups with RMAN, export/import and expdp/impdp. Implemented Point in time recovery using RMAN
• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups. Extensively implemented Data Pump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of databases
• Experience using like - Real Application Testing, Table and partition recovery using RMAN, Invisible columns, DDL Logging
• Extensively used Oracle 11gR2 features - Real Application Testing, automatic SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Merge backup, Oracle Data Pump, big file tablespaces, new EM Grid Control, Database Control, AWR, ADDM, SQL Tuning/Access Advisors, SQL Performance Analyzer, Database Replay, SQL Plan Management, SQL Tuning Automation, Flashback Database, compression techniques and several others
• Performance Tuning of Oracle Database Objects using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, STATSPACK for optimized results
• Performed Schema as well as Table Level Replication using Oracle Streams. Implemented downstream capture at the destination database using Oracle Streams.
• Installed and Configured Oracle OEM (Oracle Enterprise Manager) Grid Control.
• 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"
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O.
• Experienced in configuration of ASM for RAC and NON- RAC environments and migration of databases from NON-ASM to ASM.
• Configured Repository and clients for GRID Control and also implemented DB Control for some databases.
• Supported & maintained the Production/Development databases on various servers
• Extensively worked on setting up auditing in many databases we supported
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 12c Grid Control.