*Role: PostgreSQL Database Administrator* *Location: Baltimore, MD*
*Duration: Long Term* *GC & US-Citizens Only* *This position will be responsible for: * · Administration of PostgreSQL databases throughout the development and production lifecycles in an AWS environment. · Design and develop logical and physical database designs from customer requirements. · 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. · Provide mentorship to group members and will be expected to help develop and support mid and junior level staff. · May be scheduled for after hours on-call support and will be required to apply production packages during non-peak hours. · The selected candidate will accept other duties as directed by management. *Skills Requirements:* · Hadoop distribution experience, such as Hortonworks, Cloudera, MapR, etc. · Day to day administration of PostgreSQL databases in AWS · Collaborate with development, architecture, and release teams, providing architectural design recommendations, driving standards for effective PostgreSQL transition to production operations. · In depth knowledge of he PostgreSQL architecture · Drive end to end availability, performance monitoring, and capacity planning for PostgreSQL, using different tools · Implement automated methods and industry best practices for consistent installation and configuration of PostgreSQL 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 PostgreSQL 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 PostgreSQL with details like users, start and end time, CPU Usage and time, Memory usage, IO Time, locking etc. Thanks and Regards Faiz Ahmad Shaik Pace Computer Solutions Inc (An Inc 500 Company) 10500 Little Patuxent Pkwy, Suite 310 Columbia, MD 21044 Phone# 443-539-0949 *209 -- *Warm Regards* *Faiz Shaik* *Pace Computer Solutions Inc* *(**An Inc 500 Company**)* *10500 Little Patuxent Pkwy, Suite 310* *Columbia, MD 21044* *Phone*# 443-539-0949 *209 *Fax*# 443-539-0292 Toll Free # 1-877-225-PACE [email protected] www.pace-solutionsinc.com ****** PACE Selected for the 2009 & 2010 Best of Columbia Award by the US Commerce Association ****** *Pace Computer Solutions, Inc. is a registered user of E-Verify* The contents of this message and any attachments are intended solely for the addressee(s) named in this message. This communication is intended to be and to remain confidential and may be subject to privilege. If you are not the intended recipient of this message, or if this message has been addressed to you in error, please immediately alert the sender and then destroy this message and its attachments. Do not deliver, distribute or copy this message and/or any attachments and if you are not the intended recipient, do not disclose the contents or take any action in reliance upon the information contained in this communication or any attachments. -- You received this message because you are subscribed to the Google Groups "IT RECURITER" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/it-recuriter. For more options, visit https://groups.google.com/d/optout.
