SUMMARY

• A Postgre SQL DBA with 7 years of overall experience and having knowledge on development of lifecycle management of the databases, installation and configuration of PostgreSQL, performance monitoring, Architecture, Administration, disaster recover, migration, connectivity, and shell scripting.
• Implement, configure, and troubleshoot database instances, replication, backup, partitions, storage, and access. Set user privileges within and outside the database environment
• Configuring PostgreSQL Streaming Replication and Pgpool for load balancing. Managing the monitoring tools for better performance like PG Badger and Nagios.
• Experience in upgrading and migrating various versions of PostgreSQL database on different platforms.
• Proficient in PostgreSQL DBA activities including configuration settings, database index creation and maintained and Query optimization.
• Implementing and maintaining database security (create and maintain users, roles and assign privileges).
• Exposure to Database administration activities like maintenance, space management, management of log files, data files & control files, taking logical and physical backups.
• UNIX shell scripting and business reporting using sqlldr and SQLPlus. Have strong logical and physical database architecture and design experience, provide day to day DBA support.
• Administration, Maintenance and Monitoring of Oracle 8i,9i,10g,11g,12c databases with 24x7 availability of more than 300 Oracle databases in different environments.
• Managing Backup and recovery by planning and performing weekly/monthly backups using Online and Offline with RMAN Utility.
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large VLDB and Complex Databases.
• Good knowledge of implementing changes to development, test, and production environments.
• Check the Accuracy of the Data being updated and ensure Perfect Reporting and Verify the Data Accuracy through various SQL Queries.
• Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization.

PROFESSIONAL EXPERIENCE

Confidential

Sr. PostgreSQL DBA

Responsibilities:

• 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.
• Installation of PostgreSQL software and database and worked on PostgreSQL server build.
• Worked on troubleshooting the replication issues and rebuild standby
• Database user management - User creation, Application script execution and granting roles.
• Taking database/table/cluster/schema backups and scheduling backups on server
• Worked on database upgrade from 8.4 to 9.x versions and applying database patch in server.
• Monitoring database servers using Nagios monitoring tool and taking response of the alerts.
• Performed few activities like finding locks/blocking sessions/Long running queries/maintenance jobs/idle transactions
• Install and configure Nagios check postgresql.pl plugins for Monitoring PostgreSQL instances effectively.
• Develop and enhance automation of tasks in UNIX Shell and crontab to improve database performance in both development and production systems.
• Plans and configures the physical database environment. Evaluates and recommends the purchase and utilization of technologies such as DMBS/s, servers, extract and conditioning tools, metadata management, security tools and archival and recovery tools and data access.
• Develops project plans for implementing database environments. Provides input to technical projects and oversees the tactical aspects of all database related tasks.
• Schedule daily Point in time recovery (PITR) to the development environment for proper product testing.
• Install, configure, test, monitor, upgrade, and tune new and existingPostgreSQLdatabases.
• Responsible for PostgreSQL databases backup, recovery & upgrades. Proven skills communicating effectively with various levels of technical, non-technical, business & executive audiences.
• Monitoring lock files, backup and performance issues. Proactive managing standby replication methodologies like Streaming replication and hot standby for disaster recovery.

Confidential, KS

Sr. PostgreSQL DBA

Responsibilities:

• Maintenance of PostgreSQL RFID tracking databases. Plan and coordinate the administration ofPostgreSQLdatabases to ensure accurate, appropriate, and effective use of data, including database definition, structure, documentation, long-range requirements, and operational guidelines.
• Evaluates and recommends the purchase and utilization of technologies such as DMBS/s, servers, extract and conditioning tools, metadata management, security tools and archival and recovery tools and data access.
• Configure log analyzing tools like pgbadger . Perform quality control audits to ensure accuracy, completeness, and proper usage of data in tables and various support tools, such as database dictionaries.
• Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases.
• Review database design and integration of systems, and makes recommendations regarding enhancements and/or improvements.
• Install and configure Nagios check postgresql.pl plugins for Monitoring PostgreSQL instances effectively.
• Provide appropriate consulting, interfacing, and standards relating to database management, and monitors transaction activity and utilization.
• Contributed to decreasing need for downtime by developing and improving procedures for automated monitoring and proactive intervention.
• Prepare and/or review activity, progress, and performance reports. Experience configuring and maintaining database monitoring/trending tools.
• Diagnose, resolve and implement preventive measures to prevent problems for availability, recoverability and performance of all supported database environments.
• Develop SQL reports that meet client expectations for the application (used by custom application).

Confidential, CA

DBA

Responsibilities:

• Responsible for issue resolutions participates in client meetings and presentation. Managed performance of team members, career, training and development planning.
• Facilitated goal and objective setting, promotions and performance reviews. Experience designing database structures, indexes, views, partitioning.
• Implementing backup and recovery (Logical and Online) Setup and maintenance of postgres master-slave clusters utilizing streaming replication.
• Removing the Index bloat concurrently to improve the performance. Scheduled maintenance activities to vacuum, analyze to improve the query response time.
• Maintaining custom vacuum strategies at table and db level. Query optimization and troubleshooting.
• Hosting Weekly calls for customers as per the schedule. Close collaboration with engineering on schema additions and updates utilizing Liquibase. Participation in week-long on-call rotations
• Configuring log analyzation tools like pgfouine and pgbadger etc.
• Controlling migrations of programs, database changes, reference data changes and menu changes through the development life cycle.
• Data migration while upgrading database versions ranging from 8.2 to 9.5 Troubleshoots with problems regarding the databases, applications and development tools.
• Performed Architectural Health Check (AHC) on client systems with recommendations. Active participant in discussions related to Backup Strategy, DC/DR architecture
• Cross-datacenter disaster recovery and backup architecture. Performing schema management, database sizing, maintaining privileges. Data migration while upgrading database versions.
• Providing response for all system / database issues on 24 x 7 Schedule responding to critical events and situations outside normal work hours.

Confidential

Oracle Database Administrator

Responsibilities:

• Identifying and resolving incidents and address to user problems/concerns. Trouble shooting database issues. Worked on Manufacturing and Install Base Projects.
• Identifying and resolving incidents and address to user problems/concerns. Trouble shooting database issues. Worked on Manufacturing and Install Base Projects.
• Identifying performance bottlenecks using AWR and ADDM reports and resolving them. Worked on SQL and PL/SQL tuning.
• Worked on systems with high transactions rate. Identifying deadlocks and other lock contention issues during stress tests.
• Extensively involved in fine tuning home mortgage application SQL's. Proactive tuning, suggesting recommendations to avoid performance problems.
• Extensively used EXPLAIN PLAN, Auto Trace and TKPROF for query refining. Analysis of Execution plans for each and every query for above application and recommending required Indexes, hints and partitioning to improve SQL query performance.
• Setup, configuration and installation of the RAC environment and ASM. Participated in designing and development of software using agile development practices
• Developed user interface (UI) and data analysis component with integration of duplicate file finder. Developed multiple automation scripts using shell script. Used Grid Control and OEM Tool to monitor Stress tests. Oracle Advanced features to resolve performance issues.
• Extensively worked on Partitioning to improve performance. Configured Active Data Guard for maintaining physical standby databases. Extensive knowledge for PL/SQL programming.
• Performed POC for implementation of Oracle 11g new features. Architectural design for Golden Gate Implementation. Lead architect in data retention and data purging strategy. RMAN for backup and recovery.

Confidential

DBA

Responsibilities:

• Implemented database monitoring system using Oracle Enterprise Manager Grid Control
• Installed and configured RMAN for automatic backup and recovery of databases at pre-defined schedules
• Designed, developed and maintained PostgreSQL database architecture. Single Point of Contact for technical support, application support, users and help desk personnel of all applications.
• Expertise in writing Shell Scripts. Setting up new environments (Development, Production etc.). Schema, Table, Database refreshes on demand for dev teams. Cloning the databases from Production to Test environment using Hot/cold/export/RMAN backups.
• User creation and providing necessary Roles, Privileges and quota as per the requirement. Monitoring the Table spaces and adding/resizing data files.
• Performing reviews on the design and code frequently to ensure the site standards are being adhered to.
• Evaluating releases of Oracle and its tools, and third party products to ensure that the site is running the products that are most appropriate.
• Installing new versions of the Oracle RDBMS and its tools that access the Oracle database.
• Planning and implementing backup and recovery of the Oracle database.