Database Administrator
Sorry, this job was removed at 12:08 a.m. (MST) on Thursday, June 15, 2017
By clicking Apply Now you agree to share your profile information with the hiring company.
As a Database Administrator on the Healthgrades team you will provide technical support in the planning, design, and development of the database infrastructure. You will focus on performance tuning, load testing, security administration, backup/restoration, real-time monitoring, troubleshooting, and ongoing grooming and maintenance. You will specifically focus on Greenplum and Oracle databases and their supporting tools while providing guidance related to policies and procedures.
Primary Responsibilities:
• Administration of GreenPlum and Oracle databases throughout the development and production lifecycles.
• Provide advice and support to development resources.
• Provide guidance in the creation and modification of standards and procedures.
• Supporting the standing standards, policies and procedures of the customer team.
• May be scheduled for after hours on-call support and will be required to apply production packages during non-peak hours.
Skills Requirements:
• 8-10 years of day to day administration of GreenPlum and Oracle databases with additional GreenPlum architecture experience.
• Demonstrated experience collaborating with development, architecture, and release teams, providing architectural design recommendations, and driving standards for effective GreenPlum transition to production operations.
• Drive end to end availability, performance monitoring, and capacity planning for GreenPlum, using different tools
• 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
• 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.
• 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 and oracle with details like users, start and end time, CPU Usage and time, Memory usage, IO Time, locking etc.
Primary Responsibilities:
• Administration of GreenPlum and Oracle databases throughout the development and production lifecycles.
• Provide advice and support to development resources.
• Provide guidance in the creation and modification of standards and procedures.
• Supporting the standing standards, policies and procedures of the customer team.
• May be scheduled for after hours on-call support and will be required to apply production packages during non-peak hours.
Skills Requirements:
• 8-10 years of day to day administration of GreenPlum and Oracle databases with additional GreenPlum architecture experience.
• Demonstrated experience collaborating with development, architecture, and release teams, providing architectural design recommendations, and driving standards for effective GreenPlum transition to production operations.
• Drive end to end availability, performance monitoring, and capacity planning for GreenPlum, using different tools
• 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
• 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.
• 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 and oracle with details like users, start and end time, CPU Usage and time, Memory usage, IO Time, locking etc.
Read Full Job Description