Database Administrator
Spectraforce Technologies Inc
Senior PostgreSQL DBA (AWS Cloud & Migration Specialist)
Oakland, CA-Hybrid
6 months+ contract
Position Summary:
Oakland, CA-Hybrid
6 months+ contract
Position Summary:
- We are seeking an experienced Senior PostgreSQL Database Administrator with 12+ years of database administration experience to Migrate and support mission-critical database environments across on-premises and AWS cloud platforms.
- The ideal candidate will be responsible for the administration, performance tuning, security, backup and recovery, high availability, automation, and migration of PostgreSQL databases.
- This role requires deep expertise in PostgreSQL database administration along with strong hands-on experience in AWS services, Infrastructure as Code (Terraform), AWS CLI automation, monitoring, and large-scale database migration initiatives, including Oracle to AWS RDS/Aurora PostgreSQL ,sqlserver to AWS RDS/Aurora PostgresSQL and On-Premises PostgreSQL to AWS RDS/Aurora PostgreSQL.
- The successful candidate will work closely with application teams, infrastructure teams, cloud architects, and project stakeholders to ensure highly available, secure, and performant database environments.
- Bachelor's degree in Computer Science, Information Technology, Engineering, or related field.
- 12+ years of Database Administration experience.
- 8+ years of PostgreSQL Database Administration experience.
- 5+ years of AWS & Azuew cloud database administration experience.
- Strong experience managing mission-critical production databases.
- Proven experience with PostgreSQL upgrades, migrations, and performance tuning.
- Strong troubleshooting and problem-solving skills.
- Excellent verbal and written communication skills.
- AWS Certified Database Specialty.
- AWS Certified Solutions Architect Associate/Professional.
- PostgreSQL Professional Certification.
- Experience with Enterprise Monitoring tools.
- Experience supporting large-scale utility, financial or regulated environments.
- Experience with DevOps and CI/CD pipelines.
- Knowledge of Kubernetes and containerized PostgreSQL environments.
- Experience with pgBouncer, Pgpool-II, Patroni, or similar PostgreSQL HA solutions.
- Senior PostgreSQL Database Administrator (AWS Cloud & Migration Specialist)
- PostgreSQL Administration & AWS Cloud Experience
- Extensive experience installing, configuring, upgrading, patching, and maintaining PostgreSQL databases in enterprise environments.
- Proven experience monitoring database performance, availability, capacity, and storage utilization to ensure optimal system health.
- Strong expertise in performance tuning, query optimization, indexing strategies, and execution plan analysis.
- Experience managing database security, user roles, permissions, access controls, encryption, and compliance requirements.
- Skilled in troubleshooting database issues, performing root cause analysis, and resolving production incidents.
- Experience supporting production, development, test, QA, and disaster recovery environments.
- Strong background in capacity planning, workload analysis, and database growth forecasting.
- Experience providing on-call support and managing critical database operations.
- Extensive experience implementing and managing PostgreSQL backup and recovery solutions.
- Hands-on experience with pg_dump, pg_basebackup, WAL Archiving, and Point-in-Time Recovery (PITR).
- Experience performing backup validation, restoration testing, and disaster recovery exercises.
- Develop and maintain disaster recovery procedures and documentation.
- Ensure adherence to RTO/RPO requirements and business continuity standards.
- Experience configuring and administering PostgreSQL replication technologies.
- Design, implement, and support High Availability (HA) and disaster recovery architectures.
- Monitor replication health, troubleshoot synchronization issues, and optimize replication performance.
- Execute failover, switchover, and recovery activities with minimal downtime.
- Design and support highly available PostgreSQL architectures across on-premises and AWS cloud environments.
- AWS Database Administration Experience,Migration, Monitoring & Automation Experience
- Hands-on experience administering Amazon RDS PostgreSQL, Amazon Aurora PostgreSQL, and EC2-hosted PostgreSQL environments.
- Experience provisioning, configuring, and managing cloud database infrastructure within AWS.
- Monitor, analyze, and optimize database performance using AWS-native monitoring tools.
- Implement database security controls, encryption, auditing, and compliance best practices.
- Experience managing AWS database backups, maintenance activities, upgrades, and patching.
- Strong understanding of AWS architecture, networking, IAM, KMS, and cloud operational best practices
- Extensive experience with AWS database administration, migration, monitoring, and automation across enterprise PostgreSQL environments.
- Hands-on experience utilizing AWS Lambda, Amazon CloudWatch, Amazon SNS, AWS Systems Manager, and AWS CLI to implement automated database management solutions.
- Experience developing automated database health checks, proactive monitoring, and custom alerting solutions to improve database uptime and operational efficiency.
- Strong background in automating routine DBA tasks, operational processes, and infrastructure provisioning using Terraform and AWS-native services.
- Experience integrating monitoring, notification, and reporting platforms to provide real-time visibility into database performance and availability.
- Create and maintain operational dashboards, performance reports, and key metrics for database operations and service health.
- Experience in handling complex PostgreSQL, Oracle, and SQL Server migration projects across on-premises and cloud environments.
- Experience migrating On-Premises PostgreSQL databases to Amazon RDS PostgreSQL and Amazon Aurora PostgreSQL.
- Perform Oracle-to-PostgreSQL assessments, schema conversions, compatibility analysis, and performance optimization.
- Support PostgreSQL version upgrades, platform migrations, and cloud modernization initiatives.
- Extensive experience using AWS Database Migration Service (AWS DMS), AWS Schema Conversion Tool (AWS SCT), and native database migration utilities.
- Execute end-to-end migration activities including assessment, planning, testing, cutover, validation, and post-migration support.
- Desired Outcomes & Deliverables
- Maintain highly available, secure, and scalable PostgreSQL database environments.
- Deliver optimized database performance, reliability, and operational excellence.
- Implement automated monitoring, alerting, reporting, and operational processes.
- Ensure disaster recovery readiness, backup compliance, and adherence to RTO/RPO requirements.
- Drive infrastructure automation and cloud adoption using Terraform and AWS services.
- Successfully execute database migration projects with minimal downtime and business impact.
Vacancy posted 2 days ago
Similar jobs that could be interesting for youBased on the Database Administrator in Castro Valley, CA vacancy
- ...Senior Oracle Database Administrator 12 Months Oakland, CA 94612 (Hybrid: 1 day onsite per week- Tuesdays) Local candidates only Position Summary: We are seeking an experienced Senior Oracle Database Administrator to lead the administration...SuggestedLocal area1 day per week
Spectraforce Technologies
San Lorenzo, CA5 days ago - A food and beverage services company is seeking a skilled Business Analyst – SCM to enhance Oracle Fusion Cloud Supply Chain applications in a hybrid work model in Union City, CA. You will bridge the gap between business and IT, supporting manufacturing, logistics, and...Suggested
La Terra Fina
Union City, CA10 hours ago - ...exceptionally talented people who in turn provide the highest quality of services to our clients. Job Description Implement and/or maintain database systems pursuant to project specifications to satisfy the needs of clients. Improve database management procedures by setting up...SuggestedFlexible hours
GTS FZCO
Dublin, CA3 days ago $160k - $185k
Position: Project Manager, Discovery & Preclinical Development Location: Newark, CA Job Id: 404 Job Description: Project Manager, Discovery & Preclinical Development Role Overview We are seeking a highly organized, driven, collaborative, and scientifically grounded Project...SuggestedContract workProtagonist Therapeutics
Newark, CA10 hours ago$143k - $224k
...in Kubernetes, OpenShift Container Platform 4+ years of Kafka/MQ Series Messaging experience 4+ year of experience with in-memory databases such as Redis, MongoDB, or Cassandra 5+ years of technical troubleshooting experience using monitoring tools such as AppDynamics,...SuggestedFull timeWork experience placementRelocation package- It’s your time, make it matter. At Peterson, we partner with our customers to build the future. For over 85 years, our peoples’ work has shaped the communities where we live, where we raise our families, and where we thrive. Peterson’s legacy permeates every aspect of ...Work experience placement
Peterson Holding Company
San Leandro, CA10 hours ago - Atria Group LLC is seeking a highly skilled professional with 6-8 years of experience in ETL and Data Warehousing. The ideal candidate will demonstrate strong expertise in Informatica PowerCenter, particularly in banking sector applications, and will take responsibility...
Atria Group
San Leandro, CA10 hours ago - Peterson seeks a MuleSoft Developer to design, build, and maintain integration solutions. You will implement APIs, data mappings, and connectors while adhering to development standards and participating in code reviews. Ideal candidates have knowledge of MuleSoft Anypoint...
Peterson Holding Company
San Leandro, CA10 hours ago - ...Chandler, AZ (onsite) Duration: 6-12+ Months Job Description: Senior Developer (Keyword – Apigee, Cloud, API development, Administration, Security, Java) Define API strategy and execution including service virtualization Developing and publishing APIs...
Zortech Solutions
San Leandro, CA5 days ago - Human Bees is currently hiring a CMM Programmer Level 4 for a leading aerospace manufacturing company in San Leandro, CA. This is a full-time day shift opportunity for an experienced CMM professional. The ideal candidate will be responsible for operating CMM machines using...Full timeCurrently hiringDay shift
Human Bees
San Leandro, CA1 day ago - ...services and AHS internal Total Rewards processes. Conducts various total rewards activities. The Senior Total Rewards Programs Administrator engages with the Total Rewards Department regarding all aspects of total rewards administration, including time-sensitive tasks...Full time
Alameda Health System
Castro Valley, CA4 days ago $17.79 - $18.5 per hour
Compensation Range: $17.79 to $18.50 Hourly Location: 529 Jackson St, Hayward, California 94544 United States of America Are you a people person? Do you love helping others? U-Haul is in search of friendly, motivated people for the position of Customer Service Representative...Hourly payFull timeStart working todayLocal area$45k - $90k
Requisition Number: 232044 Job Description Cintas is seeking a Route Service Representative to manage and grow customer accounts in the Rental Division. Our partners drive a truck along an established route and service and sell within an existing customer base. It is a...Base plus commissionFull timeLocal areaWeekend workDay shift- ...environments and use technologies such as client/server architecture, object-oriented programming languages and tools, distributed database management systems, state-of-the-art networking, and communications infrastructures. Our honest and realistic approach to...
$27.2 - $39.44 per hour
Do you love working with a wide variety of people, building relationships with customers, and solving problems? Can you adapt to changing priorities and balance several projects at once? If so, we want to hear from you! Pape’ Kenworth, the premier medium and heavy-duty...Temporary workMonday to FridayFlexible hoursPapé Group
San Leandro, CA2 days ago$161.64k
...laboratory data entry and reporting; Build backend services and RESTful APIs using FastAPI and Flask to connect frontend applications, databases, and data analysis pipelines; Develop and maintain full-stack web applications using HTML, CSS, JavaScript, TypeScript, React, and...Full timeWork experience placementInternshipPredicine Inc
Hayward, CA10 hours ago- A leading software development company in San Leandro, California, is seeking an App System Engineer to manage the platform environment, including software and media deployments. The role involves working as part of a team and requires skills in various technologies such...
360 IT Professionals
San Leandro, CA1 day ago $100k
Top Dog Service Advisor Wanted Hourly pay plus commission possibly making $100K per year. Are you a top performer and consistently deliver the best numbers in your service department? Is your compensation package reflecting your "TOP DOG" status? We are looking...Hourly payWork experience placementWork at officeLocal areaShift workAfternoon shiftThe Ford Store San Leandro
San Leandro, CA3 days ago- Description The Salvation Army Mission Statement: The Salvation Army, an international movement, is an evangelical part of the universal Christian Church. Its message is based on the Bible. Its ministry is motivated by the love for God. Its mission is to preach...Summer workWork at officeLocal areaNight shift
The Salvation Army USA Western Territory
San Lorenzo, CA1 day ago - Family Service Advisor at Chapel of the Chimes Hayward Funeral Home and Memorial Park Join NorthStar Memorial Group as a Family Service Advisor at Chapel of the Chimes Hayward Funeral Home and Memorial Park in Hayward, CA. At NorthStar, we're redefining how families...
NorthStar Memorial Group
Hayward, CA3 days ago - Job Description: Automotive Service Advisor Company Description Victory Automotive Group is family owned and operated since 1997 with over 50 locations across the United States. We provide the best opportunities for all employees, customers, communities, and ...
Victory Mazda of San Leandro
San Leandro, CA3 days ago $175k - $185k
Hayward Post Acute, Hayward, CA 94544, USA Description Are you looking for your new career? We are now hiring a Nursing Home Administrator to be the newest member of our awesome team! Salary Range: $175k-$185k per year. We believe in cultivating a family culture and...Hourly payLocal areaImmediate start$17.1 per hour
We are California’s largest regional, full-service grocery chain, founded over 70 years ago in Modesto, California, where our headquarters are still located today. With 194 stores across Central and Northern California and Western Nevada, our banners—Save Mart, Lucky, ...Local areaShift workAfternoon shiftCornerstone OnDemand
San Lorenzo, CA3 days ago$23.93 per hour
Please use Google Chrome or Mozilla Firefox when accessing Candidate Home. By joining the American Red Cross you will touch millions of lives every year and experience the greatness of the human spirit at its best. Are you ready to be part of the world's largest humanitarian...Temporary workWork at officeLocal areaFlexible hoursNight shiftWeekend workEarly shiftAmerican Red Cross
San Leandro, CA5 days ago- Pape’ Kenworth in San Leandro, CA is seeking a Service Advisor to manage service and warranty work orders, assist customers, and support shop workflow. This role emphasizes teamwork, customer service excellence, and a positive attitude in a fast-paced environment. The ...Monday to Friday
Papé
San Leandro, CA1 day ago $42.5 - $50 per hour
Job Title Mobile Building Engineer Job Description Summary ***EPA 608 Universal Certification is required*** The position involves maintaining and repairing HVAC, plumbing, electrical, and building mechanical systems to ensure maximum efficiency of building...Minimum wageFull timeApprenticeshipWork at officeLocal areaFlexible hoursShift workWeekend work- Principal Solutions Engineer-Mobile & Platform Location: Oakland, CA (Hybrid-2 days in a month) Duration: 12 months+ contract *****Local candidates only***** Role Overview Client is seeking a Lead Software Engineer - Mobile & Platforms to provide...Contract workLocal area
Spectraforce Technologies
Hayward, CA5 days ago - Menzo Technologies in Hayward, California is looking for a Principal Software Engineer to enhance delivery frameworks for their banking applications. The ideal candidate has over 10 years of experience in technology and people management, with a solid grasp of Microsoft...Work at office
Menzo Technologies Corp
Hayward, CA10 hours ago - An established industry player is seeking a Senior Software Engineer to join their dynamic team. This role requires extensive experience in software engineering, particularly in web application development using Java and Spring frameworks. The ideal candidate will have...
TechDigital Group
San Leandro, CA10 hours ago - Job Description Job Description Job Title: Service Advisor – Tire & Auto Shop Location: Hayward, CA Job Type: Full-Time Pay: DOE (Hourly) + Commission & Bonus Potential Are you a natural people person who thrives on closing deals and delivering exceptional...Hourly payFull timeWeekend work
Big O Tires
Hayward, CA14 days ago
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Database Administrator. Be the first to apply!
