Greenplum USA ( Remote ) at Remote, Remote, USA |
Email: [email protected] |
From: Gopi Chand, Yochana IT [email protected] Reply to: [email protected] Hello, Im a Technical Recruiter with Yochana Solutions Inc., a national IT staffing solutions provider with 13 plus years of experience delivering value to leading companies across the U.S and Canada. I'm currently staffing for Greenplum USA ( Remote ) . Below you will find the job description, if you are qualified and interested, please send me your Updated Word Document Resume. My apologies if this position is not an ideal fit, we'll keep you in mind for other suitable positions and referrals would be appreciated. Thank you in advance. Role: Greenplum Location: USA ( Remote ) Vendor / Client: Direct Vendor Duration: Contract Job Description Key skill being considered while evaluating profiles by customer here is Greenplum Building Blocks (GBB) . Proven administrator experience with the following technologies, tools, utilities or methodologies: Day to day administration of Greenplum and Postgres databases Experience in UNIX/LINUX PL/SQL, PL/pgsql, Shell, Perl, python A deep understanding of Postgres internals from versions 8.2 to 9.x Database connectivity/networking - clients, ODBC, JDBC. Experience in Data warehousing technologies. Database fundamentals - Database concepts, SQL, queries, plans, joins. OS fundamentals - Linux, navigation, memory, swap, understanding ps, top, vmstat, iostat, filesystem, etc. Strong Performance Tuning experience with relational databases. Database troubleshooting - client/server, query execution sequence, execution plan, log files. Collaborate with development, architecture, and release teams, providing architectural design recommendations, driving standards for effective GreenPlum and Postgres transition to production operations. Drive end to end availability, performance monitoring, and capacity planning for GreenPlum, using different tools. Develop best practices for performance that can be shared with the development teams to prevent performance issues in production. Implement automated methods and industry best practices for consistent installation and configuration of GreenPlum for production and non-production environments. Conduct technical reviews and Walkthroughs of system design documentation with development and design team members. Manage backup and recovery functions for a Greenplum data warehouse environment for example using Data Domain. Proactively monitor and setup alerting mechanism for both database and supporting hardware to ensure system health and maximum availability. Create users, establish database security, create resource queue, performance tuning in terms of query execution etc. Installing Greenplum Database for example: 6.x Plan and coordinate system upgrades. Perform capacity monitoring and short and long-term capacity planning in collaboration with development resources, system administrators and system architects Manage Disaster Recovery environment. Identify and resolve incidents and address to user problems/concerns. Generate reports of all processes and jobs currently running on Greenplum with details like users, start and end time, CPU Usage and time, Memory usage, IO Time, locking etc. Strong analytical, troubleshooting, & problem solving skills. Thanks and regards Gopi Chand Senior Resource Specialist, Yochana IT Solutions Inc, 23000 Commerce Dr., Farmington hills, MI-48335 Direct: 248-516-7363, 248-213-6465,Ext 159 [email protected] || https://www.linkedin.com/in/gopi-chand-%F0%9F%A4%B4%F0%9F%8F%BB-187294190/ Lets Challenge The Status Quo Keywords: information technology procedural language Michigan |
[email protected] View all |
Thu Jul 27 00:41:00 UTC 2023 |