Job Description :
Sr. Postgres DBA
Location: Baltimore, MD
Must have 3 years experience working in USA
Rate: Open
Term: 3 Year Contract
Must be US Citizen or GC Holder.
Job Description- Sr. Postgres DBA
* 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
* Support the current standards, policies and procedures of the
customer team.
* Provide mentorship to group members and 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.
* Bachelor''s degree in a related area and 10+ years of professional
experience
* 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 the 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.
* Migration experience is a plus
Technologies used in the project:
AWS cloud, MarkLogic, Hadoop, Mongo DB, Informatica, SailPoint, Java, Talend
SoftSkills:
* Good collaboration & communication skills, the ability to
participate in an interdisciplinary team.
* Strong written communications and documentation experience
* Excellent time management and organizational management skills
* Able to lead an initiative from end to end