SUMMARY

• Highly Professional database administrator with more than 7 years’ experience designing, coding, testing, and supporting next - generation database solutions in PostgreSQL and Oracle environments.
• Experience in database design, analysis, modeling, development, administration, implementation, troubleshooting, and quality management.
• Exceptional analytical, problem-solving, and communication skills. Excellent attention to detail and experience with numerous types of database software. Ability to work well on a team and individually.

• Performance Tuning & Capacity Monitoring Ensuring availability
• Configuration and installation
• Upgrade and Patching
• Excellent analytical and problem - solving skills Backup & Recovery
• Outstanding team leadership abilities Data Security
• Data modeling and database design Procedural skills
• Database schema creation and management Ensuring data integrity
• General database management Automation
• General systems management and networking skills Migration
• Streaming replication
• Scripting
• PLSQL developer
• Data warehousing (ETL)

TECHNICAL SKILLS

Operating Systems: HP-UX, Sun Solaris 9, 10, AIX, RHEL, Linux Enterprise Server 9, 10. Windows 2012, 2016

RDBMS: PostgreSQL 9, 10, 11 and 12, Oracle 10g, 11g, 12c, 18c and 19c

Tools: /Utilities: Bart, Pgbadger, MTK, Pgbench, pg dump, pg basebackup, pgbouncer, pgadmin, PEM, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, TOAD. PgTune, pgcrypto, SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, Data Pump, Export, Import.

PROFESSIONAL EXPERIENCE

Confidential, Santa-Clara, CA

Responsibilities:

• Installation of PostgreSQL Server.
• Participated in all phases of the system development life cycle from requirements analysis through system implementation.
• Responsible for supporting all tickets and incidents related to database in production environment.
• Ensuring security in Database Servers, environment.
• Ensuring Database backups in production environments
• PITR in Database production environment
• User creation, assigning roles and permissions to users.
• Performing Database housekeeping activities
• Coordinating with applications owners, infra team
• Working on assigned incidents within SLA, timely escalation of issues.
• Performing DB Health Checkup on daily basis.

Confidential - Jacksonville, FL

PostgreSQL | Oracle Database Administrator

Responsibilities:

• Installing and Configuring PostgreSQL 9.6, from source or packages on Linux machines.
• 5 years plus of proven working experience as a database administrator with a hands-on experience with database standards and end user applications.
• Lead DBA and I mentored all the other DBA’s
• Capacity Planning
• Daily log analysis using pgbadger tool and query tuning.
• Responsible for all backup, recovery, and upgrading of all the PostgreSQL databases.
• Good mastery of PGBOUNCER, REPMGR and BARMAN.
• Monitoring databases to optimize database performance and diagnosing any issues.
• Maintaining custom vacuum strategies at table and db level.
• Extensive knowledge using pg dump, pg dumpall for logical backups and pg basebackup for physical backups.
• Configured BART for Incremental backups, implement retention policies and point-in-time recovery requirements for large-scale Postgres deployments.
• Designed and implemented table partitioning for handling very large tables.
• Used EXPLAIN and EXPLAIN ANALYZE to identify and fine tune sql queries for performance improvements.
• Optimize PostgreSQL. conf for performance improvement.
• Review all PostgreSQL logs with pgbadger 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.
• Improve query performance by following performance enhancement tips and database best practices.
• 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.
• Performs quality control audits to ensure accuracy, completeness, and proper usage of data in tables and various support tools, such as database dictionaries.
• Scheduling daily Point in time recovery (PITR) to the development environment for proper product testing.
• Vast Knowledge in memory resizing and tuning.
• Proactive in updating the latest security patches to database, which are provided by PostgreSQL Enterprisedb.
• Writing queries for reporting purposes, PL/SQL queries, creating and altering stored procedures, functions, triggers, and some Linux shell scripting.
• Ability to implement automation to reduce manual administrative tasks through use of jobs, scripts, cron, or other techniques.
• Configured pgbouncer and pgpool to automate connection pooling.
• Specific hands on experience include administering large and complex Databases, Database Design, Normalization, Replication, Log Shipping, Full text indexing, and Database Application Development using varied development tools.
• Generate reports of all processes and jobs currently running on PostgreSQL with details like users, start and end time, CPU Usage and time, Memory usage, IO Time, locking.
• Proactive managing standby replication methodologies like Streaming replication and hot standby for disaster recovery.
• Configure logical replication for real time data replication.
• Performs quality control audits to ensure accuracy, completeness, and proper usage of data in tables and various support tools, such as database dictionaries.
• Daily log analysis using pgbadger tool and query tuning.
• Participating in daily meetings to discuss about the new database design, modeling, and creation.
• Performed migration from oracle to PostgreSQL using EDB Postgres Migration Toolkit.
• DBA supporting three major projects from Development to Production via Tech-Test environments, involving daily configuration, administration all running on Red Hat Linux 5.3. Database sizes range from 4GB to 1TB (in ODS & EDW environments).
• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
• Applied 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.
• Experienced in Data Center migration of databases to prepare the proof of concept, DB migration procedures and scripts, developed templates that include check list for migrating the databases.
• Perform Database upgrades, migrations; take logical exports from the QA, DEV etc instances and importing the data on to the production systems etc.
• Construction of Catalog databases and developed scripts to perform Backups of Large Databases to fit the backup window using RMAN.
• Wrote shell scripts for purging trace files, alert log and network log files in Linux boxes which is used as standard script across all the databases.
• Expertise in PL/SQL, SQL, and UNIX Shell Scripting (Implemented UNIX Scripts using CRON JOB for Day-to-Day activities and Windows Task Scheduler).
• Extensively worked on setting up auditing in many databases we supported
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 12c Grid Control.
• Experience with Clearcase & ClearQuest MicroSoft SQL-Server
• Managing and monitoring databases using SSMS
• Installation and configuration
• Automating Alerts, using SQL to set thresholds and triggers.
• Debugging SQL work with developers to fine tune sql/pl to enhance performance
• Import table into new database
• Backup database (full/log/diff)
• Restore database and give it a new name(using SSMS)
• Encrypt database using TDE
• Performance tuning
• High Availability (always on, log shipping, clustering)
• Migration
• Data Warehousing (SSRS, SSIR)

Confidential - Deerfield, IL

PostgreSQL | Oracle Database Administrator

Responsibilities:

• Setup and maintenance of postgres master-slave clusters utilizing streaming replication.
• Cross-datacenter disaster recovery and backup architecture.
• Performing schema management, database sizing, maintaining privileges.
• Analyze/Develop business description of user needs, program functions, and steps required to develop or modify systems, including Business Requirements Documents and supporting documents, diagrams, data, and database specification.
• Establish policies and procedures pertaining to data management, security, maintenance, and utilization.
• Perform database installations, configurations, upgrades, and migrations.
• Experience with database replication, hot stand-by, clustering, and table partitioning.
• Consult with development and architecture teams to help meet continued application growth.
• Define and implement database schema and configurations working with our development teams.
• Research and evaluate new databases, technologies, and trends to provide innovative ideas and solutions to improve the existing infrastructure and support new projects and requirements.
• Audit for data integrity and consistency across systems.
• Detailed understanding of Postgres database server architecture, concepts, features, and high-availability technologies.
• Expert knowledge of PL/PgSQL, triggers, and stored procedure development and optimization in PostgreSQL.
• Administration of PostgreSQL databases throughout the development and production lifecycles.
• Implement automated methods and industry best practices for consistent installation and configuration of PostgreSQL for production and non-production environments.
• Proactively monitor and setup alerting mechanism for both database and supporting hardware to ensure system health and maximum availability.
• Create users, establish database security, create resource queue, performance tuning in terms of query execution.
• Manage Disaster Recovery environment.
• Drive end to end availability, performance monitoring, and capacity planning for PostgreSQL, using different tools.
• Rebuilding the indexes at regular intervals for better performance.
• Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.
• Configure logical replication to replicate real time data.
• Designing and testing database installation, implementation, and recovery scenarios.
• Determining test to use and collecting appropriate data according to established guidelines.
• Participating in analysis, development, and implementation of unique database recovery plans in response to client-impacting outages.
• Performing database software installations and upgrades and implementing backup/recovery strategies.
• Reviewing and approving application and database design decisions to ensure that application solutions exhibit high levels of performance, security, scalability, maintainability, and reliability upon deployment.
• Configuring Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Developed RMAN Cold Backup Script to take backups automatically every week for about 200 databases vary in size from 200GB to 2TB and automated the process through crontab.
• Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers, and Indexes on the tables.
• Database refreshes using expdp, impdp, RMAN Duplicate and cloning.
• Loading data from flat files to database using SQL*Loader, External Tables.
• Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
• Involved in the installation, configuration, and extended support to Oracle 11g, 12c two Node RAC (Real Application Cluster) with ASM file system on AIX platform.
• Involved in converting a single instance database to Oracle 11g, 10g RAC databases.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).
• Experienced in cloning the databases using HOT and COLD backups.
• Used RMAN Duplicate and HOT/COLD backups to migrate the data from 11.1.0.7 to 11.2.0.3.
• On call Production & Development database support and administration.
• Implementing Data pump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• Implemented Flashback technology of the Oracle 11g, 10g along with Recyclebin for a faster recovery of the databases and database objects.
• Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
• Performed Database upgrade from Oracle 10g (11.2.0.5) and to Oracle 12c (12.1.0.2) RAC database.
• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.
• Migration of Oracle databases from windows to Linux.
• Performed SQL tuning and assist developers with coding PL/SQL.
• Provided support to Application Database Administrators in designing the database.
• Management of schemas, objects partitioning the tables & indexes.
• Automation of data load using shell scripting and SQL*Loader.
• Responsible for setting and managing user accounts and granting required privileges to users.