Search Open Jobs

Greenplum/Postgres DBA

Alpharetta, Georgia | Contract

Job ID: 37524 Job Category: MySQL DBA
Greenplum/Postgres DBA   Rate is open based on the market.  This position is a 12-month contract opportunity.  This position is open for w-2 or c2c.  The location is Alpharetta, GA.     Job Description: Our client, a leader in their industry, has excellent opportunity available for an Greenplum/Postgress DBA to work on a 12-month contract position in Alpharetta, GA. This consultant will be responsible for providing working to support multiple Greenplum and Postgres database environments.   Key Responsibilities:
  • Certify that all Greenplum and Postgres environments meet security best practices, and provide suggestions for mitigating any observed vulnerabilities
  • Build new Greenplum an Postgre environments as required
  • Document all new and existing environments and create additional documentation for installations, upgrades, migrations etc. to match agreed-upon standards.
  • Create shell scripts required for monitoring and alerting, as well as automating tasks day-to-day tasks
  • Assure that all databases are being backed up properly and are recoverable
  • Work with various user groups to gather requirements for new or existing environments
  • Work with development teams to optimize load jobs and automate schema/table clones
  • Create new roles, schemas, group roles and assign to resources as appropriate
  • Assure that all environments are secured, patched per SLA and upgraded to new versions when released
  • Troubleshoot issues as required and assist application teams when necessary
  • Migrate multi-Terabyte databases from legacy servers to the new infrastructure
  • Set up multi-slave Postgres streaming replication for revenue generation applications
  • Participate in Disaster Recovery exercises
  Must Have Skills:
  • 7+ years of industry experience, including 2+ years supporting MPP data warehouse environments.
  • Thorough Understanding of best practices in implementing Greenplum security, installations and performance tuning.
  • Experience supporting OLAP workloads in multi-terabyte environments.
  • Experience with Greenplum and Postgres database administration, and Postgres SQL.
  • Ability to troubleshoot and resolve issues quickly in production environments.
  • Experience in Red Hat Enterprise Linux 5.x or CentOS Linux 2.0.
  • Experience with writing shell scripts (K-shell and/or Perl).
  • Experience with Greenplum backup/recovery strategies, including gp_dump, gpcrondump,  gpdbrestore and pg_dump, and psql loading utilities.
  • Experience installing, configuring, upgrading and maintaining Greenplum and Postgres environments
  • Understanding of the standard Greenplum architecture and catalog tables and views.
  • Knowledge of system performance tuning as well as Postgres SQL and Greenplum tuning.
  • Strong understanding of the Greenplum Clients tools along with data load utilities including gpload and gpfdist etc.
  Preferred Skills:
  • Bachelor’ s degree in computer science or similar technical area.
  • Strong communications skills (both verbally and written), and the ability to work with multiple end user and development groups.
  • Ability to manage multiple projects and environments at once.
  • Strong problem solving and conceptual thinking abilities.
  As a w-2 contract employee of Principle Solutions Group, you are eligible for our benefit plan that includes medical, dental, vision, disability and prescription drug coverage through UnitedHealthcare. We also offer a 401(k) plan with matching, direct deposit, and a referral bonus plan.    Please send your MS Word resume to ben.crosby@principlesolutions.com for immediate consideration.   Also, please connect with me on LinkedIn at https://www.linkedin.com/in/bencrosby/  

Ben Crosby
Senior Technical Recruiter

I work as a Sr. Technical Recruiter for Principle Solution Group’s Atlanta office and I am responsible for the fulfillment of contract and full-time permanent IT positions. I have over 10 years of professional experience filling technology positions for a wide variety of clients ranging from Silicon Valley start-ups, IT consulting firms, small/medium sized businesses, public sector clients, and Fortune 500 firms. I am passionate about the IT industry and I love helping IT professionals advance their careers. I started my career working as an IT consultant and software developer for a Big 5 firm so I am a recruiter that understands technology. I am committed to providing the highest quality service possible to my candidates, coworkers, and clients.
Apply Online

Not ready to apply?

Send an email reminder to:

Share This Job:

Related Jobs: