Skill :
Postgres DBA
Location:
Onsite ( Las Vegas ) , from day1 onsite .
Job Responsibilities
The primary objective of the Database Administrator (Sr DBA) is to develop and maintain the corporate databases ensuring data integrity, security, retention, and recoverability of the data.
In this role, the PostgreSQL DBA will design, build, test, and deploy quality database solutions that are consistent with project objectives, technology architecture standards and departmental best practices.
The DBA will design and implement database strategies, administer enterprise-wide data architecture, implement complex data structures, and provide daily management of Postgres databases.
The DBA will create and administer all database objects from design to deployment utilizing subject matter expertise to design or re-use, configure, and implement database solutions/processes that maximize system availability, efficiency, effectiveness, integrity, recoverability, and supportability. Specific responsibilities include:
•ll aspects of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning, backup and recovery.
•Responsible for evaluating patch releases and patching requests from development, and communicating constraints, issues, and timelines for deployment.
•Change management including maintenance of multiple development, test, QA, and production environments. Responsible for deploying approved changes to production.
•24x7 rotational on-call support, including driving Root Cause Analysis (RCA), Preventative action follow-though, and participation in weekly operations reviews.
•Proactive database monitoring and issue resolution through custom built scripts as well as using PgAdmin/Enterprise manager tools
•Database optimization including performance tuning, query optimization and supportability.
•ctively participate and contribute to projects involving enterprise systems enhancements.
•Implementation and ongoing support of high availability architecture not limited to Active/Active and Active/Passive Clusters
•Work with development project teams to design and implement database solutions to meet business requirements.
•Regular proactive capacity planning and tending reviews of all databases. Producing weekly, monthly management reports.
•Develop and implement Database security polices and procedures, in line with corporate objectives
Job Requirements
•Must have 8+ years DBA working experience with PostgreSQL 9.6+ version and good understanding of Oracle Database and Microsoft SQL Server.
•Must be knowledgeable and experienced in managing PostgreSQL on multiple operating systems including Microsoft Windows, Linux (RHEL) and Kubernetes in OpenShift platform
•Experienced in setting up PostgreSQL clusters and supporting databases cluster in on-prem and hybrid cloud environment, and specifically in AWS RDS instance.
•Strong skills in UNIX/Linux Shell Scripting
•Experience in implementing Postgres STIG implementation, testing, and other vulnerability remediation.
•Working Knowledge of connection poolers (pgPool and pgBouncer).
•Install, monitor and maintain PostgreSQL software, implement monitoring and alerting.
•Experience in building high-scalable clusters, failover and hot standby solutions based on Maximum available architecture
•Experience in architecting, configuring, setting up Enterprise Fail over manager or similar technology for High availability solution.
•Experience in leading efforts related to system and SQL performance tuning and assisting business process integration with various data sources.
•bility to work well with development and infrastructure teams in doing database design, changes and enhancement to new and existing applications
•Proven ability to provide High Availability and Disaster Recovery solutions.
•Maintain operational documentation (e.g., procedures, task lists, architecture blueprints)
•Strong Troubleshooting Skills
•bility to maintain a positive attitude while working with high demands and short deadlines
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.
United States - NV - NV - Henderson
June 24, 2024
• TRUCK DRIVING JOBS: WE ARE HIRING DRIVERS! • STRONGER TOGETHER AT CRETE CARRIER, INDUSTRY LEADING PAY IS JUST THE BEGINNINGLearn more about all of the ways Crete Carrier and Shaffer Trucking go the extra mile to provide financial stability, flexible home time, and more to our drivers. • Call a...
United States - NV - NV - Las Vegas
June 29, 2024
Now is the time to join Mountain Dental Group. You will have opportunities to learn new skills from our team of experienced professionals. If you're ready to take your career to the next level and gain valuable experience, apply today! • As a General Dentist at a PDS-supported practice, you will...
United States - NV - NV - Glenbrook
June 28, 2024
Company Profile Superprof is the 1 tutoring platform in the USA- We are looking for students, professionals or anyone with a passion to tutor to join the largest community of tutors worldwide. • Superprof has opened in over 41 countries around the world in order to be a window of education for those...
United States - NV - NV - Reno
June 28, 2024
Medical Solutions is seeking a travel nurse RN NICU - Neonatal Intensive Care for a travel nursing job in Reno, Nevada. & Requirements • Specialty: NICU - Neonatal Intensive Care • Discipline: RN • Duration: 13 weeks • 36 hours per week • Shift: 12 hours, days • Employment Type: Travel Were seeking...
United States - NV - NV - Orovada
June 28, 2024
Company Profile Superprof is the 1 tutoring platform in the USA- We are looking for students, professionals or anyone with a passion to tutor to join the largest community of tutors worldwide. • Superprof has opened in over 41 countries around the world in order to be a window of education for those...
United States - NV - NV - Elko
June 28, 2024
CrossMed Allied is seeking a travel Ultrasound Technologist for a travel job in Elko, Nevada. & Requirements • Specialty: Ultrasound Technologist • Discipline: Allied Health Professional • Start Date: 07/15/2024 • Duration: 13 weeks • 40 hours per week • Shift: 8 hours • Employment Type: Travel Job...
United States - NV - NV - Mesquite
June 29, 2024
Core Medical Group is seeking a travel nurse RN ICU - Intensive Care Unit for a travel nursing job in Mesquite, Nevada. & Requirements • Specialty: ICU - Intensive Care Unit • Discipline: RN • Start Date: 07/08/2024 • Duration: 13 weeks • 36 hours per week • Shift: 12 hours • Employment Type: Travel...
United States - NV - NV - Elko
June 28, 2024
Aequor Allied is seeking a travel Ultrasound Technologist for a travel job in Elko, Nevada. & Requirements • Specialty: Ultrasound Technologist • Discipline: Allied Health Professional • Start Date: 07/15/2024 • Duration: 13 weeks • 40 hours per week • Shift: 8 hours • Employment Type: Travel...
United States - NV - NV - Las Vegas
June 29, 2024
Travel Rehab: • Occupational Therapy Las Vegas Location: • Las Vegas Start Date: • 7/1/2024 Shift Details: • 12H Days (12: • 00 AM-12: • 00 PM) 40 hours per week Length: • 13 WEEKS 13 weeks Apply for specific facility details.Occupational Therapist...
United States - NV - NV - Mesquite
June 29, 2024
TotalMed Staffing is seeking a travel nurse RN ICU - Intensive Care Unit for a travel nursing job in Mesquite, Nevada. & Requirements • Specialty: ICU - Intensive Care Unit • Discipline: RN • Start Date: 07/08/2024 • Duration: 13 weeks • 36 hours per week • Shift: 12 hours, nights • Employment Type:...
Fusion Medical Staffing Nursing
United States - NV - NV - Mesquite
June 29, 2024
Fusion Medical Staffing-Nursing is seeking a travel nurse RN ICU - Intensive Care Unit for a travel nursing job in Mesquite, Nevada. & Requirements • Specialty: ICU - Intensive Care Unit • Discipline: RN • Start Date: 07/08/2024 • Duration: 8 weeks • 36 hours per week • Shift: 12 hours, nights •...
United States - NV - NV - Winnemucca
June 28, 2024
No experience requited, hiring immediately, appy now.Waste Management is currently accepting applications for a Trash Collector! Primary duties of the Trash Collector include: • - Operating garbage trucks - Collecting and dumping trash receptacles - Following route assignments as directed Waste...
United States - NV - NV - Henderson
May 23, 2024
Responsibilities About Henderson Hospital • Henderson Hospital is a member of TheValley Health System, a network of acute care and specialty hospitals that provide care for patients throughout Southern Nevada and nearby communities. • Located in Henderson, NV, the acute care hospital offers...
United States - NV - NV - Schurz
June 28, 2024
Company Profile Superprof is the 1 tutoring platform in the USA- We are looking for students, professionals or anyone with a passion to tutor to join the largest community of tutors worldwide. • Superprof has opened in over 41 countries around the world in order to be a window of education for those...
United States - NV - NV - Las Vegas
June 18, 2024
Adapt Marketing is hiring for LGCY Power is a leading force in the solar industry, dedicated to providing an extraordinary customer experience while becoming the best version of ourselves and helping others do the same. • We are the US's largest privately held solar company and have been around for...
United States - NV - NV - Mesquite
June 29, 2024
Planet Healthcare is seeking a travel nurse RN ICU - Intensive Care Unit for a travel nursing job in Mesquite, Nevada. & Requirements • Specialty: ICU - Intensive Care Unit • Discipline: RN • Duration: 8 weeks • 36 hours per week • Shift: 12 hours • Employment Type: Travel Planet Healthcare Job ID...
United States - NV - NV - elko
June 17, 2024
Aureus Medical Group - Nursing is seeking a travel nurse RN ED - Emergency Department for a travel nursing job in Elko, Nevada. & Requirements • Specialty: ED - Emergency Department • Discipline: RN • Start Date: ASAP • Duration: 9 weeks • 36 hours per week • Shift: 12 hours, nights • Employment...
United States - NV - NV - Carson City
June 29, 2024
Synergy Medical Staffing is seeking a travel Certified Occupational Therapy Assistant for a travel job in Carson City, Nevada. & Requirements • Specialty: Certified Occupational Therapy Assistant • Discipline: Therapy • Start Date: 07/08/2024 • Duration: 13 weeks • 40 hours per week • Shift: 8...
United States - NV - NV - Mesquite
June 29, 2024
Anders Group is seeking a travel nurse RN Float ICU - Intensive Care Unit for a travel nursing job in Mesquite, Nevada. & Requirements • Specialty: ICU - Intensive Care Unit • Discipline: RN • Start Date: 07/08/2024 • Duration: 13 weeks • 36 hours per week • Shift: 12 hours • Employment Type: Travel...
United States - NV - NV - Mesquite
June 29, 2024
KPG Healthcare is seeking a travel nurse RN ICU - Intensive Care Unit for a travel nursing job in Mesquite, Nevada. & Requirements • Specialty: ICU - Intensive Care Unit • Discipline: RN • Start Date: 07/08/2024 • Duration: 13 weeks • 36 hours per week • Shift: 12 hours, days, nights • Employment...
United States - NV - NV - Reno
June 28, 2024
Medical Solutions is seeking a travel nurse RN NICU - Neonatal Intensive Care for a travel nursing job in Reno, Nevada. & Requirements • Specialty: NICU - Neonatal Intensive Care • Discipline: RN • Duration: 13 weeks • 36 hours per week • Shift: 12 hours, nights • Employment Type: Travel Were...
United States - NV - NV - Mesquite
June 29, 2024
MedPro Healthcare Staffing is seeking a travel nurse RN ICU - Intensive Care Unit for a travel nursing job in Mesquite, Nevada. & Requirements • Specialty: ICU - Intensive Care Unit • Discipline: RN • Start Date: 07/08/2024 • Duration: 13 weeks • 36 hours per week • Shift: 12 hours, days, nights •...
United States - NV - NV - Las Vegas
June 28, 2024
Job Posting: • Retail Associate - Inventory Starting Wage: • $13.75 - $18.00 Part Time: • Paid hours depend on your availability and business need. • Ability to work varied, traditional and non-traditional hours, including flexible schedules. • The more you are available, the more you can earn!...
United States - NV - NV - Mesquite
June 29, 2024
Host Healthcare is seeking a travel nurse RN ICU - Intensive Care Unit for a travel nursing job in Mesquite, Nevada. & Requirements • Specialty: ICU - Intensive Care Unit • Discipline: RN • Start Date: 07/08/2024 • Duration: 8 weeks • 40 hours per week • Shift: 8 hours, days, nights • Employment...
United States - NV - NV - Mina
June 28, 2024
Company Profile Superprof is the 1 tutoring platform in the USA- We are looking for students, professionals or anyone with a passion to tutor to join the largest community of tutors worldwide. • Superprof has opened in over 41 countries around the world in order to be a window of education for those...
United States - NV - NV - Moapa
June 28, 2024
This inclusive employer is a member of myGwork the largest global platform for the LGBTQ+ business community.At Automattic , we believe in making the web a better place, and making our workplace a happy place. • We hope you can join us on this journey!The Affiliate Program Manager for WordPress.com...
United States - NV - NV - Reno
June 28, 2024
Focus Staff is seeking a Med Surg Registered Nurse for a travel contract in Reno, NV. The ideal candidate will have at least 1 year of experience in a Med Surg setting. Contract Length: 13 Weeks Start Date: 07/15/2024 Shift: 3x12 Nights Benefits for Travel RN Med Surgs: • Health insurance • Vision...