Greenplum And Database Engineer Resume
Irving, TX
PROFESSIONAL SUMMARY:
- 7+ years senior DBA having knowledge and ability to perform all of the basic database management skills of data administration, web connectivity, physical structure, PostgreSQL, SQL and SQL applications, and overall architecture and database analysis.
- Configuring Postgresql Streaming Replication and Pgpool for load balancing. Managing the 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 the PostgreSQL databases. ETL and data warehouse design experience, especially with Greenplum.
- Proficient with all major PostgreSQL procedural languages (PL/PgSQL, PL/Perl, PL/PgPython, PL/Tcl) as well as some Oracle PL/SQL and SQL - Server T-SQL.
- Excellent SQL skills including query optimization, complex nested and co-related queries, common table expressions, window functions, and business analytical reporting.
- 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 trans active and Very large databases.
- Extensively worked on Mmapv1&Wiredtiger storage engine. Experience in handling CRUD operations in MONGODB.
- Implemented various forms of replication in MySQL and SQL server environments based on company standards or client's needs.
- Experience in setting up Replication using pglogical extension and core PostgreSQL feature Logical Replication
- Implementing monitoring using Nagios and Zabbix monitoring tools. Experience with check postgres.pl script.
- Implemented and utilized different backup tools such as mysqldump, Percona Xtrabackup and MySQL Enterprise backup based on company standards or client's needs.
- Implemented and successfully tested Database Mirroring and Log Shipping in SQL Server environments Proactive Performance Monitoring and Tuning
- 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), and ASH (Active Session History) for analyzing the database performance and tuning.
- Check the Accuracy of the Data being updated and ensure Perfect Reporting and Verify the Data Accuracy through various SQL Queries.
- Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery planning and Security Management.
- Having Experience working on Data center servers and handling greater than 1.5 TB databases.
- Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization.
TECHNICAL SKILLS:
Database: PostgreSQL 8/9, knowledge 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
Monitoring Tools: Postgres Enterprise Manager (PEM), pgOn, Nagios, Pivotal Command center.
Operating system: MS-DOS, MS- Windows 9X/NT, RHEL 5, Centos, Solaris 10.
PROFESSIONAL EXPERIENCE:
Confidential, Irving, TX
Greenplum and database engineer
Environment: PostgreSQL 8.4/9.1/9.2, Greenplum 4.3.5
Responsibilities:
- Working as Sr. PostgreSQL DBA and handling various duty of postgres DBA part of remote servicegroup providing support to consulting clients for various projects for ongoing issue in Development, Testing and PROD environment including Database upgrade, Application patches and DR activities
- Configuring and fixing the 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 the Development, test and UAT environments with production data as per customer's request.
- Design and implement disaster recovery for the PostgreSQL Database.
- Configuring third client software pgadmin-III, phppgadmin to access the database server.
- Configuring the backup jobs on customer system. Experienced in performing PITR.
- Patch, Upgrade and keep the PostgreSQL DBs current. Develop and enhance scripts to automate and execute various DBA tasks.
- Assist engineering team in the 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 corn jobs for backups, re-Indexing & vacuuming & materialized views executed properly on 24/7 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.
Confidential, Omaha, NE
PostgreSQL DBA
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 principles and practices, including planning, testing, backup/restore
- Responsible for all backup, recovery, and upgrading of all of the PostgreSQL databases. Monitoring databases to optimize database performance and diagnosing any issues.
- Responsible for setting up Logical Replication using pglogical extension.
- Daily log analysis using pgbadger tool and query tuning.
- Maintaining custom vacuum strategies at table and db level. Identifying and fixing the issues on gpcrondump and gpdbrestore.
- Fixing the issues on External tables, gpfdist and gpload utilities.Fixing heap and Append-only table corruption issues.
- Recovering the failed segment instances using gprecoverseg incremental and full recovery.
- Configuring and fixing the Issues with Pgadmin-III client application.
- Monitoring the DB growth for every month in DWH databases and planning to implement the table partitioning for better performance.
- Develop, implement, maintain policies and procedures and document database architecture to ensure the security and integrity of the databases.
- Responsible for monitoring environments using monitoring tool viz. Nagios,Check Postgres.pl, pgOn, Zabbix, custom scripts and other supporting tools like pgBadger and tailnmail.
- Hands-on experience on database administration, backup recovery and troubleshooting in co-location environments.
- Ability to thrive in a fast-paced, deadline-sensitive environment.
- Monitoring the DB growth for every month in DWH databases and planning to implement the table partitioning for better performance.
- Monitoring the bloat repot on every table and performing maintenance with minimal downtime.
- Experience supporting a mission-critical database environment with 24x7 On-Call Support including weekends.
- Identifying and resolving incidents and address to user problems/concerns
- Attending initial sales calls to Offer technical solutions for customer queries in pre-sales cycle
- Performing minor and major level upgrades using minimal down by prior testing in test boxes with accurate time notifications.
Environment: Oracle 11g, 10g, Golden Gate, Linux, Solaris, RMAN, Data guard, SQL*Loader, TKPROF, EXPLAIN PLAN, AWR, ADDM, RAC, Expdp and Impdp, IPMon, JIRA.
Confidential
Database Administrator
Responsibilities:
- Experienced in administering and maintaining medium enterprise database servers on Linux servers.
- Responsible for issue resolutions participates in client meetings and presentation. Managed performance of team members, career, training and development planning.
- 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).
- Installing pivotal-support packages to monitor performance like (gpsupport and mem watcher.. etc)
- Fixing the memory issues and suggesting the 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 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
Environment: Oracle 11g, 10g, Linux, Solaris, Shell scripting, RMAN, Data guard, SQL*Loader, TKPROF, EXPLAIN PLAN, AWR, ADDM, RAC, Expdp and Impdp, IPMon, JIRA
Confidential
LINUX Administrator
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.
- Single Point of Contact for technical support, application support, users and help desk personnel of all applications.
- Expertise in writing Shell Scripts.
- Conducted Linux administration activities and managed test databases. Evaluated database performance and executed table maintenance processes
- Maintaining documentation and standards for Database. 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.
- 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
Environment: Oracle 8i, 9i and 10g, Sybase, Sun Solaris, HP-UX, Windows 2003, SQL Server, Sybase, RMAN, Dataguard, SQL/PL-SQL, HTML, STATSPACK, Erwin