SUMMARY:

• Hardworking, detailed - oriented, and proactive PostgreSQL and oracle database admin, with a proven track record of using my excellent troubleshooting, maintenance, security, Backup and recovery, high availability solutions such as golden gate and PostgreSQL streaming replication with interpersonal skills to carry out my duties in a professional, timely and accurate manner. I have strong communication skills with team members, Developers, System Engineers and Devops to realize project goals.

PROFESSIONAL EXPERIENCE:

POSTGRESQL DATABASE ADMINISTRATOR

Confidential, Franklin, TN.

Responsibilities:

• Participated in cross platform migration from SQL SERVER to Postgres RDS using MIGRO, SCT and DMS.
• Installed, configured, and manage PostgreSQL databases in AWS
• Worked with offshore team on daily bases to provide them with table/stored procedure scripts, Packages and agents from Production environment needed to complete task.
• Performing BASIC TASKS on OBJECTS such as, creating roles, granting privileges, creating tables.
• Experience supporting a mission-critical database environment with 24x7 on-call support including weekends.
• Documented high level task and stored newly created custom scripts in the designated directory.

POSTGRESQL DATABASE ADMINISTRATOR.

Confidential, Tysons Corner, VA.

Responsibilities:

• Installation, configuration, troubleshooting Postgres Community Edition and Enterprise DB version 9x, 10x and 11x on LINUX platform
• Experienced Upgrading database versions (PG DUMP/PG RESTORE and PG UPGRADE).
• Managed Postgres databases on AWS RDS and EC2 instance
• Configured a REPLICATION between MASTER and REPLICA and monitoring ongoing REPLICATION
• Performed maintenance activities like checking on AUTO VACUUM jobs, customized VACUUM on certain tables and columns.
• Implemented physical backup schedules using PG BASEBACKUP, PGBACKREST for incremental and differential backups and PG DUMPALL and PG DUMP for logical backups.
• Configured PGBOUNCER for connection pooling and PGBADGER for generating and interpreting log statistical reports.
• Used EXPLAIN ANAYZE for SQL Tuning as well as PG STAT ACTIVITY.
• Experienced in tuning PostgreSQL server settings using PGTUNE and troubleshooting performance issues.
• Used ANSIBLE for automation.
• Monitored CPU utilization, memory, database connections and storage space daily using PG STAT ACTIVITY, and PG VIEWS. Also used customs shell scripts deployed on crontab to monitor performance and resources.
• Implemented table and index partitioning to improve query speed.
• Deployed Database security policy and installation, using passwords, privileges and user profiles, and Enabled Encryption for databases.
• Participated in capacity planning to meet the demands of the dynamic aspects of storage and memory for the databases.
• Reviewed Logs for unusual events and performance issues and took appropriate action according to company policies and incident reports.
• Performed database Refreshes from production environments.
• Performing BASIC TASKS on OBJECTS such as, creating roles, granting privileges, creating tables.
• Used client-side applications like pgAdmin and putty to connect and manage PostgreSQL databases on-premises and on cloud.
• Experience supporting a mission-critical database environment with 24x7 on-call support including weekends.

POSTGRESQL/DATABASE ADMINSTRATOR.

Confidential, Hanover, Maryland.

Responsibilities:

• Evaluate Oracle features and Oracle related products
• Proactively monitor the SQL database servers to ensure high performance and RDBMS optimization design.
• Administered database, troubleshooting and database software maintenance.
• Created technical documents, transportable tablespace, and user managed backup and concept of database system and security.
• Coordinated with team members to setup documentation standards. Proactively monitor database performance while tuning database for improvement and efficiency.
• Data guard and Broker configuration for physical and standby databases.
• Database backup using crontab and shell scripting, restore and recovery using RMAN, RTO/RPO and optimization.
• AWR, ADDM, ASH, TOAD and Oracle Grid Cloud monitoring.
• Failover and Switchover for high availability, maximum performance, and protection.
• Create and configure Oracle security and policies using Oracle Enterprise Manager. I have experience in assessing and evaluating Oracle RAC environment for documenting.
• Experience interfacing with Oracle support, while providing trouble shooting and offering consultation to developer’s teams and clients.
• Provide periodic reports on the performance, capacity, and availability of database.
• Database patches, management, duplication, migration, and tuning.
• Implemented and administered users and database permissions.
• Installed and Configured Grid Control, Multitenant and Pluggable Database Cluster database.
• Assess and evaluate existing Oracle environments for documenting and recommending Life Cycle Replacement options.
• Review the performance of databases tuning on a periodic basis
• Database PeopleSoft tools creation, cold, hot, and user-managed backups.
• Experience in creating users, tables, views, stored procedures functions in SQL database.
• Verify SQL database and backup jobs run successfully according to their defined schedules.
• Provided technical domain expertise and leadership required to effectively deliver high quality, timely solutions and services that meet business needs with a focus on the line of business.
• Create and configure Oracle advance security and policies using Oracle Cloud Control Enterprise Manager.
• Installed cluster RAC database and Grid Control.
• Meeting business needs while monitoring ticketing system such as BMC Remedy and delivering high quality services in a timely manner and applying patches.
• Participated in cross platform migrations such as Oracle to PostgreSQL.
• Involved in Installing/configuring PostgreSQL version 9.6 to 11.
• Documented and assisted in Data migration from Oracle Databases to PostgreSQL database on premises.
• Monitoring the bloat repot on every table and performing maintenance with minimal downtime.
• Documented high level task and stored newly created custom scripts in the designated directory.
• Analyze daily log using PGBADGER for fully detailed reports or graphs and monitor custom vacuum full strategies at table and database level.
• Create new schemas and set their search paths, update, alter and delete old ones as per user request. Management database sizing, and grant and revoke privileges per SLA.
• Configured and connected PGADMIN client to access the database servers.
• Identified and resolved user incidents and guided them to resolve problems/concerns. Diagnosed database issues and terminated inactive sessions.
• Monitored PostgreSQL server networking connections using HBA.CONF and connection pooling with PGBOUNCER.
• Setup Streaming Replication for Disaster Recovery and High Availability solutions.
• Tested PostgreSQL streaming Replication in preparation for project to deploy standby server in production.
• Executed and implemented disaster recovery for the PostgreSQL Database as per company policies.
• Performed point-in-time recovery of production server to recover a deleted schema.
• MIGRATION from ORACLE to POSTGRESQL with AWS DMS and SCT.
• Performed re-Indexing & vacuuming & materialized views executed properly on 24/7 high availability Postgres production and development databases.