Postgresql Dba Resume
Princeton, NJ
SUMMARY
- 7+ years senior DBA having noledge and ability to perform all of teh basic database management skills of data administration, web connectivity, physical structure, SQL and SQL applications, and overall architecture and database analysis.
- Configuring PostgreSQL Streaming Replication and Pgpool for load balancing. Managing teh monitoring tools for better performance like PgBadger, Kibana, Graphana, and Nagios.
- Experience in upgrading and migrating various versions of PostgreSQL database on different platforms.
- Responsible for all backup, recovery, and upgrading of all of teh PostgreSQL databases.
- Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within teh organization.
- Implement, configure, and troubleshoot database instances, replication, backup, partitions, storage, and access. Set user privileges within and outside teh database environment.
- Managing teh servers, Web Servers, Load Balancing, and Keepalived, distcache, Apache Configurations, PHP configurations and deployment of accounts.
- Extensively worked on Mmapv1&Wiredtiger storage engine. Experience in handling CRUD operations in MONGODB.
- Extensive experience in developing Map - Reduce programs and aggregation frameworks using JavaScript's.
- Experience in Installation, Configuration and Troubleshooting of Oracle Database on Solaris OS, IBM-AIX, Red Hat Enterprise Linux (RHEL) and Windows on highly transactive and Very large databases.
- Expert level experience in Oracle RAC implementation & administration using Oracle Cluster-ware, Sun Cluster and VERITAS Cluster Server (Oracle Cluster ware setup and configuration, RAC installation, Configuration and Patching, RAC Backup and Recovery)
- Configured Automatic Storage Management (ASM) to fulfil storage needs. Experience in Implementing, configuring, trouble shooting, switchover, failover of Physical Standby Data Guard on 10g and 11g.
- Used ADDM (Automatic Database Diagnostic Monitor), AWR (Automatic Workload Repository), ASH (Active Session History) for analyzing teh database performance and tuning.
- Check teh Accuracy of teh Data being updated and ensure Perfect Reporting and Verify teh Data Accuracy through various SQL Queries.
- Migration of Data from Reports generated by various vendors into PostgreSQL Databases using PostgreSQL Export/Import Procedures.
- Manage teh Space and Storage of teh Databases through various Shell Scripts scheduled in teh corncob periodically in regular intervals. Write Complex Shell Scripts that automate teh Import of Reports to PostgreSQL and MySQL Databases.
TECHNICAL SKILLS
Database: PostgreSQL 8/9, noledge of MySQL, Oracle 10g & 11g
NoSQL Technologies: MongoDB, Appache Cassandra and Knowledge on basic concepts on hadoop.
Languages: C, Core Java, SQL & PL/pgsql, Shell Scripting.
Technical Tools: Toad (RDBMS tool for Oracle, pgAdmin, pgStudio)
Operating system: MS-DOS, MS- Windows 9X/NT, RHEL 6,7, Centos, Solaris 10.
Monitoring Tools: Postgres Enterprise Manager (PEM), Nagios, pgOn, Pivotal Command center.
PROFESSIONAL EXPERIENCE
PostgreSQL DBA
Confidential, Princeton, NJ
Responsibilities:
- Ability to proactively identify, troubleshoot and resolve live database systems issues. Knowledge in database design including logical and physical design.
- Knowledge of disaster recovery principals and practices, including planning, testing, backup/restore
- Hands-on experience on database administration, backup recovery and troubleshooting in co-location environments.
- Ability to thrive in a fast-paced, deadline-sensitive environment.
- Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within teh organization.
- Responsible for all backup, recovery, and upgrading of all of teh PostgreSQL databases. Monitoring databases to optimize database performance and diagnosing any issues.
- Develop, implement, maintain policies and procedures and document database architecture to ensure teh security and integrity of teh databases.
- Implement data models, database designs, data access, table maintenance and code changes together with our development team.
- Experience in code migration, database change management through various stages of development life cycle.
- Providing response for all system / database issues on 24 x 7 Schedule responding to critical events and situations outside normal work hours.
- Work with development and operations teams to tune production queries for optimal performance.
- Implement and monitor replication for high availability and disaster recovery scenarios.
- Review new database schema changes.
- Monitor and manage database indexes for optimal performance.
- Automate teh configuration management of database and Big Data systems.
- Performing schema management, database sizing, maintaining privileges.
- Installing and monitoring PostgreSQL database using teh standard monitoring tools like Nagios etc.
- Daily log analysis using pgbadger tool and query tuning.
- Maintaining custom vacuum strategies at table and db level.
- Monitoring teh DB growth for every month in DWH databases and planning to implement teh table partitioning for better performance.
- Monitoring teh bloat repot on every table and performing maintenance with minimal downtime.
- Performing minor and major level upgrades using minimal down by prior testing in test boxes with accurate time notifications.
Environment: SOA, Mulesoft, Java, SOAP, Core Java, J2EE, Struts, JSP, jQuery, SOAP, JMS, Eclipse, JUnit, PL/SQL, HTML, SVN, CVS, JIRA (defect-tracking tool), BMC Remedy Tool, JavaScript, Servlets, Windows XP.
PostgreSQL DBA
Confidential, Columbia MO
Responsibilities:
- Ability to proactively identify, troubleshoot and resolve live database systems issues. Knowledge in database design including logical and physical design.
- Technical mentor and halping technically to internally Greenplum Global support team.
- Worked on end to end application level performance tuning re designing data models, Choosing proper distribution keys rewrite Greenplum function code..
- Interacting with development, Testing, and release teams, providing recommendations, driving standards for effective Greenplum production operations.
- Knowledge of disaster recovery principals and practices, including planning, testing, backup/restore.
- Hands-on experience on database administration, backup recovery and troubleshooting in co-location environments.
- Ability to thrive in a fast-paced, deadline-sensitive environment.
- Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within teh organization.
- Responsible for all backup, recovery, and upgrading of all of teh PostgreSQL databases. Monitoring databases to optimize database performance and diagnosing any issues.
- Develop, implement, maintain policies and procedures and document database architecture to ensure teh security and integrity of teh databases.
- Implement data models, database designs, data access, table maintenance and code changes together with our development team.
- Experience in code migration, database change management through various stages of development life cycle.
- Providing response for all system / database issues on 24 x 7 Schedule responding to critical events and situations outside normal work hours.
- Work with development and operations teams to tune production queries for optimal performance.
- Implement and monitor replication for high availability and disaster recovery scenarios.
- Review new database schema changes.
- Monitor and manage database indexes for optimal performance.
- Automate teh configuration management of database and Big Data systems.
- Performing schema management, database sizing, maintaining privileges.
- Installing and monitoring PostgreSQL database using teh standard monitoring tools like Nagios etc.
- Daily log analysis using pgbadger tool and query tuning.
- Maintaining custom vacuum strategies at table and db level.
- Monitoring teh DB growth for every month in DWH databases and planning to implement teh table partitioning for better performance.
- Monitoring teh bloat repot on every table and performing maintenance with minimal downtime.
- Performing minor and major level upgrades using minimal down by prior testing in test boxes with accurate time notifications.
Environment: Oracle 11g, 10g, Linux, Solaris, Shell scripting, RMAN, Data guard, SQL*Loader, TKPROF, EXPLAIN PLAN, AWR, ADDM, RAC, Expdp and Impdp, IPMon, JIRA
PostgreSQL DBA
Confidential, Atlanta GA
Responsibilities:
- Experienced in administering and maintaining medium enterprise database servers on Linux servers.
- Participating in daily meetings to discuss about teh 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 teh 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).
- Installing pivotal-support packages to monitor performance like (gpsupport and mem watcher.. etc)
- Fixing teh memory issues and suggesting teh best practices.
- Responsible for monitoring environments using monitoring tool viz. Nagios,Check Postgres.pl, pgOn, custom scripts and other supporting tools like pgBadger and tailnmail.
- Installing and configuring new servers as per customer’s request.
- 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 teh standard monitoring tools like Nagios etc.
- Configuring log analyzation tools like pgfouine and pgbadger etc.
- Scheduled maintenance activities to vacuum, analyze to improve teh query response time.
- Maintaining custom vacuum strategies at table and DB level.
- Query optimization and troubleshooting.
- Troubleshoots with problems regarding teh databases, applications and development tools.
- Close collaboration with engineering on schema additions and updates utilizing Liquibase
Environment: Oracle 11g, 10g, Golden Gate, Linux, Solaris, RMAN, Data guard, SQL*Loader, TKPROF, EXPLAIN PLAN, AWR, ADDM, RAC, Expdp and Impdp, IPMon, JIRA.
PostgreSQL DBA
Confidential
Responsibilities:
- Ability to proactively identify, troubleshoot and resolve live database systems issues.
- Knowledge of disaster recovery principals and practices, including planning, testing, backup/restore
- Hands-on experience on database administration, backup recovery and troubleshooting in co-location environments.
- Ability to thrive in a fast-paced, deadline-sensitive environment.
- Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within teh organization.
- Responsible for all backup, recovery, and upgrading of all of teh PostgreSQL databases.
- Monitoring databases to optimize database performance and diagnosing any issues.
- Develop, implement, maintain policies and procedures and document database architecture to ensure teh security and integrity of teh databases.
- Implement data models, database designs, data access, table maintenance and code changes together with our development team.
- Experience in code migration, database change management through various stages of development life cycle.
- Providing response for all system / database issues on 24 x 7 schedules responding to critical events and situations outside normal work hours.
- Work with development and operations teams to tune production queries for optimal performance.
- Implement and monitor replication for high availability and disaster recovery scenarios.
- Review new database schema changes.
- Monitor and manage database indexes for optimal performance.
- Automate teh configuration management of database and Big Data systems.
- Performing schema management, database sizing, maintaining privileges.
- Installing and monitoring PostgreSQL database using teh standard monitoring tools like Nagios etc.
- Daily log analysis using pgbadger tool and query tuning.
- Maintaining custom vacuum strategies at table and db level.
- Monitoring teh DB growth for every month in DWH databases and planning to implement teh table partitioning for better performance.
- Monitoring teh bloat repot on every table and performing maintenance with minimal downtime.
- Performing minor and major level upgrades using minimal down by prior testing in test boxes with accurate time notifications.
Database Admin
Confidential
Responsibilities:
- Configuring and fixing teh Issues with Pgadmin-III client application. Responsible for monitoring environments using monitoring tool viz. Nagios, Check Postgres.pl, pgOn, custom scripts and other supporting tools like pgBadger and tailnmail.
- Installing and configuring new servers as per customer's request. Cloning teh Development, test and UAT environments with production data as per customer's request.
- Design and implement disaster recovery for teh PostgreSQL Database. Configuring third client software pgadmin-III, phppgadmin to access teh database server.
- Configuring teh backup jobs on customer system. Experienced in performing PITR.
- Patch, Upgrade and keep teh PostgreSQL DBs current. Develop and enhance scripts to automate and execute various DBA tasks.
- Assist engineering team in teh design of appropriate DB Schema and indexing strategy for performance and scalability.
- Experience supporting a mission-critical database environment with 24x7 On-Call Support including weekends.
- Identifying and resolving incidents and address to user problems/concerns. Trouble shooting database issues.
- Support developers for efficient SQL query and Identifying long running queries and optimizing. Setup/Maintenance of Test/Development/UAT Servers setup
- Coordinating of Service Request (SR) with business team and providing them SQL queries.
- Monitoring of system logs, OS logs, database logs, trace files, database alert files to detect and troubleshoot runtime problems.
- Planning, deploying RDBMS Upgrades/Patches and performing other weekend maintenance activities as a part of On Call support.
- Active participant in discussions related to Backup Strategy, DC/DR architecture. Maintained, patched, and upgraded servers as required.
- Expertise in Analyzing data Quality checks using shell scripts. Upgrading, installing, and configuring PostgreSQL servers.
- PostgreSQL Installation, Configuration, Migration, Upgrades and Patches. Server versions ranged from PostgreSQL 8.2 to 9.5.
- Disaster recovery planning or Emergency Recoveries and Ensuring Recoverability of Databases.
- Optimize postgresql.conf for performance improvement. Review all PostgreSQL logs for problems.
- Ensure night cron jobs for backups, re-Indexing & vacuuming & materialized views executed properly on 24/7/365 high availability Postgres production and development databases.
Environment: SOA, Mulesoft, Java, SOAP, Core Java, J2EE, Struts, JSP, jQuery, SOAP, JMS, Eclipse, JUnit, PL/SQL, HTML, SVN, CVS, JIRA (defect-tracking tool), BMC Remedy Tool, JavaScript, Servlets, Windows XP.
