Sr. Postgresql Dba Resume
3.50/5 (Submit Your Rating)
SUMMARY
- A senior PostgreSQL DBA and Developer with 6 years of experience having knowledge on development of lifecycle, management of the databases, installation and configuration of PostgreSQL, performance monitoring, Architecture, Administration, disaster recover, migration, connectivity, Code testing and shell scripting.
PROFESSIONAL EXPERIENCE
Sr. PostgreSQL DBA
Confidential
Responsibilities:
- Expertise in configuring and installation of PostgreSQL, Postgresplus advanced Server on OLTP to OLAP systems on from high end to low end environment.
- Experience in backup/restore of PostgreSQL databases. Strong experience in performance tuning & index maintenance.
- Expertise in database performance diagnostics in both development and production systems as well as SQL levels.
- Design & manage PostgreSQL database schemas. Experience designing database structures, indexes, views, partitioning.
- Implementing of logical and physical backups. Monitor and manage database indexes for enhancing the performance.
- Expertize in migrating data from Oracle to PostgreSQL and PostgresPlus Advanced Server using ora2pg and EDB migration toolkit.
- Extensively worked on creating foreign data wrappers to connect to other data resources from within postgres.
- Knowledge in Setup and maintenance of Postgres master - slave clusters utilizing streaming replication
- Experience in security access control, testing, configuration management, version control, highly available web applications.
- Maintenance and establishment of integrity & security controls. Good knowledge of fault detection & resolution process. Capability of migration of the versions.
- Ability to implement database change controls, as well as development, staging & production PostgreSQL databases. Knowledge on Nosql databases like Mongo dB and Cassandra.
- Responsible for PostgreSQL databases backup, recovery & upgrades. Experience in working with the ODBC Drivers.
- Proven skills communicating effectively with various levels of technical, non-technical, business & executive audiences.
- Daily activities include monitoring lock files, backup and performance issues. Proactive managing standby replication methodologies like Streaming replication and hot standby for disaster recovery.
- Schedule daily Point in time recovery (PITR) to the development environment for proper product testing.
- Experience in writing the pg dump and pg restore scripts using parallel dump and restore methods for automation.
- Scheduling pg dump and pg restore scripts for every day dev and test server refresh as per apps team requests.
Sr. PostgreSQL DBA
Confidential, Hollywood, FL
Responsibilities:
- Plan and configure the physical database environment required for development, testing, and education and production usage.
- Plan and coordinate 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.
- 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 pgfouine and pgbadger etc. Worked with the psql ODBC drivers.
- Perform quality control audits to ensure accuracy, completeness, and proper usage of data in tables and various support tools, such as database dictionaries.
- Having hands on experience in creating and managing the PostgreSQL instance from Amazon RDS.
- Experience in tuning and creating security groups, roles through Amazon RDS. Experience in creating the read replicas in Amazon RDS for high availability.
- 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.
- Experience in programming with PL/PGSQL. Strong experience with load balancing using pg pool.
- Tune auto vacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples.
- Expertise in trouble shooting the database performance issues along the with query optimization.
- Solid understanding of infrastructure, application and database performance metrics.
- 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).
- Excellent verbal and written communications skills. Recommend and oversee implementation of database level configuration changes to optimize performance.
- Ensure maintenance of physical integrity of all production databases. Working knowledge of IDOL tool.
PostgreSQL DBA& Developer
Confidential
Responsibilities:
- Experienced in administering and maintaining medium enterprise database servers on Linux servers.
- Participating in daily meetings to discuss about the new database design, modeling and creation.
- Installing and Configuring PostgreSQL from source or packages on Linux machines.
- Experience designing database structures, indexes, views, partitioning. Implementing backup and recovery (Logical and Online).
- Controlling migrations of programs, data base changes, reference data changes and menu changes through the development life cycle.
- 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.
- Data migration while upgrading database versions ranging from 8.2 to 9.5. Extensive experience with Warm Standby ( PostgreSQL 8.x and earlier), and Hot Standby ( PostgreSQL 9.x and greater).
- Performance monitoring and optimization. Installing and configuring Object level replication like Slony etc.
- Installing and configuring connection pooling tools like Pgbouncer and pgpool etc.
- Installing and monitoring PostgreSQL database using the standard monitoring tools like Nagios etc.
- Configuring log analyzation tools like pgfouine and pgbadger etc. 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.
- Troubleshoots with problems regarding the databases, applications and development tools.
- Close collaboration with engineering on schema additions and updates utilizing Liquibase
Postgres developer
Confidential
Responsibilities:
- Expert in Coding of new tables, views and modifications as well as Pl/PgSQL Stored Procedures, Data Types, Triggers, Constraints and Constraints. Perform bulk loading of Inventory database.
- Worked on Replication and Log shipping for SQL Server High Availability. Extensively worked on Active-Active and Active-Passive Clustering
- Experience in Oracle Database 9i/10g Administration. Created PL/SQL packages, procedures and functions.
- Monitoring tools and Application support. Install, initialize, validate, and configure postgres Databases.
- Manage database objects and workload management processes by defining and managing roles, privileges, and resource queues.
- Extensively used data manipulation language and data query language to access, manage and query data.
- Expert in writing shell scripts.
- Perform system administrative tasks, including managing and checking the state of the postgres database and its data and checking the distribution of data.
- Worked on Improving query performance by keeping statistics up to date and tuning the database for sampling size and error conditions.
- Worked on optimizing indexes for better performance and maintainability
- Improve query performance by following performance enhancement tips and database best practices.
- Used explain and analyze to identify and fine tune sql queries for performance improvements.
- Load data into a postgres database instance using external tables, SQL copy and insert commands, and parallel load utilities.