Title: Greenplum DBA (DTJP00016449) - (NOT a Developer. This is an Administrative Role)
Duration: 12 months contract to start with
Location: Round Rock, TX 78682 [Open to candidates willing to relocate at own expense to Round Rock, TX]
Job Description:
Primary responsibilities:
• Candidate should have high functioning knowledge of Linux Greenplum Database Installation
• Should be able to optimize SQL.
• Should be able to interact with developers and Data architects and provide consulting on best practices
• Write bash shell and python scripts to support DBA tasks.
• Managing recovery for failed Greenplum segment instances.
• Managing failover and recovery for a failed Greenplum master instance.
• Backup Greenplum database Transferring data between Greenplum databases.
• Performing Segment mirroring on the segments to maintain high availability in the event of primary segment failure.
• Work with Pivotal Greenplum support when required.
Designs, plans, and implements most aspects of database management and may begin to specialize in one aspect of database management such as data administration, web connectivity, physical structure, logical design, SQL and SQL applications or overall architecture and database analysis Participates on new initiatives/projects of moderate complexity Evaluates and recommends the purchase and utilization of software products to assist in the management of data Plans and performs installation and maintenance of DBMS software Diagnoses problems and determines resolution for applications and system software Measures DMBS performance and modifies system level configuration to optimize performance Anticipates business constraints and their applicability to database management May be responsible for planning and upgrading of major/complex application and database upgrades Develops, upgrades and maintains medium to large size database systems Performs security management by auditing and maintaining roles, privileges and user profiles Performs complex application builds and refreshes; installs, upgrades, patches and maintains application environments Supports planning and execution of new application capabilities and major upgrades; supports creation of disaster recovery procedures Consistently provides guidance and project direction to less experienced team members
Minimum experience
• 5-7+ Years of Greenplum administrative experience.
Thanks & Regards,
Imran (Emu) Shikalgar
APN Software Services, Inc
39899 Balentine Drive, Suite 385, Newark, CA 94560
510-402-4704 (Voice & Text)
Phone: 510-623-5050 Extn.129 | Fax 510-623-5055 | Imran@apninc.com
linkedin.com/in/imranshikalgar