J.P. Morgan Intelligent Solutions
Description: (JPMIS) transforms JPMC data assets to create and commercialize information and solutions that enable consumers, businesses and governments to make better decisions and achieve their objectives.
As a Database Administrator you will be supporting multiple Big data initiatives at JPMorgan Intelligent Solutions . This role requires to focus primarily on the Operations of complex Greenplum and Postgres systems managing availability, optimum performance, and end user support. This role requires strong collaboration, communication, and leadership skills to interact with various IT and business groups.
Day to day administration of Greenplum and Postgres databases
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
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 DR environment
Identifying and resolving incidents and address to user problems/concerns
Generating reports of all processes and jobs currently running on GP with details like users, start and end time, CPU Usage and time, Memory usage, IO Time, locking etc.
B.S. Degree in Computer Science or equivalent
5+ years of information technology experience
Minimum 2 years DBA experience with Greenplum and PostgreSQL supporting large enterprise environment.
3 years experience of working in Linux environment
Expertise in problem diagnosis, troubleshooting, and problem solving skill
Any Hadoop distribution experience, such as Hortonworks, Cloudera, MapR, etc.
In depth knowledge about the GreenPlum architecture
Solutions Design and installation/configuration experience with GreenPlum administration
Exposure to ITIL processes
Expertise on GreenPlum sizing & end to end performance fine tuning
Excellent verbal and written communications skills, working effectively with IT support teams, management, and internal users.
Experience working in a 24x7 support environment
JPMorgan Chase (NYSE: JPM) is one of the oldest financial institutions in the United... States. With a history dating back over 200 years, here's where we stand today:
We are a leading global financial services firm with assets of $2.4 trillion.
We operate in more than 60 countries.
We have 260,000 employees.
We serve millions of consumers, small businesses and many of the world's most prominent corporate, institutional and government clients.
We are a leader in investment banking, financial services for consumers, small business and commercial banking, financial transaction processing, asset management and private equity.
Our stock is a component of the Dow Jones Industrial Average. Read full description