We provide IT Staff Augmentation Services!

Greenplum And Database Engineer Resume

4.00/5 (Submit Your Rating)

Irving, TX

SUMMARY

  • 7+ years senior DBA having knowledge and ability to perform all of teh 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 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. ETL and data warehouse design experience, especially wif Greenplum.
  • Proficient wif 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 wif 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 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.
  • 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 wifin teh 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 teh Issues wif 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 wif 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 wif 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) wif 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

Postgre SQL 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 principals and practices, including planning, testing, backup/restore
  • Responsible for all backup, recovery, and upgrading of all of teh 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 teh issues on gpcrondump and gpdbrestore.
  • Fixing teh issues on External tables, gpfdist and gpload utilities.Fixing heap and Append-only table corruption issues.
  • Recovering teh failed segment instances using gprecoverseg incremental and full recovery.
  • Configuring and fixing teh Issues wif Pgadmin-III client application.
  • Monitoring teh DB growth for every month in DWH databases and planning to implement teh table partitioning for better performance.
  • Develop, implement, maintain policies and procedures and document database architecture to ensure teh security and integrity of teh 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 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 wif minimal downtime.
  • Experience supporting a mission-critical database environment wif 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 wif 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 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 wif 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 wif problems regarding teh databases, applications and development tools.
  • Close collaboration wif 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 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 wif 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 teh 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) wif 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 teh query response time.
  • Maintaining custom vacuum strategies at table and DB level. Query optimization and troubleshooting.
  • Troubleshoots wif problems regarding teh databases, applications and development tools.
  • Close collaboration wif 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

We'd love your feedback!