PostgreSQL Database Administrator

3 weeks ago


Detroit, Michigan, United States TEKsystems Full time

Top Skills' Details

  • Experience with SQL Server 2016 and above
  • Experience with PostgreSQL 11 and above
  • Experience with AWS; able to maintain AWS RDS and Aurora instances

Description:

  • Looking for a PostgreSQL DBA to support daily tasks within the environment and lead an upcoming project to upgrade 150 clusters to the latest version of mySQL.
  • The team consists of 6 other DBA's, so being open to learning and collaborating with various database technologies beyond PostgreSQL is crucial for this role.
  • Seeking someone who can assess current implementation strategies and recommend solutions to enhance performance and efficiency for the team.

Responsibilities:

  • Collaborate with developers and business analysts to design and adjust database structure
  • Monitor database server performance
  • Rotation-based on-call support (1 week every 6-7 weeks)
  • Proficient in configuring and diagnosing physical and logical replication in PostgreSQL
  • Proficient in configuring and diagnosing log shipping and Always-on HA solutions in SQL Server
  • Identify and address performance bottlenecks in on-premises and cloud environments
  • Experience with deploying and managing PostgreSQL, SQL Server in cloud platforms like AWS, Azure, GCP, preferably AWS
  • Conduct database maintenance tasks such as backups/restores, updating statistics, rebuilding indexes, etc.
  • Collaborate with data engineers to align data in production databases with the data warehouse
  • Ensure system security and data integrity
  • Coordinate with systems engineers to optimize hardware and storage subsystems
  • Develop, manage, and update disaster recovery and high availability plans
  • Install, upgrade, and patch database servers
  • Participate in code and design reviews
  • Engage in production code pushes

About TEKsystems:

We are agents of change. Collaborating with clients to implement ideas and solutions that capitalize on emerging opportunities, our team of 80,000 professionals partners with over 6,000 clients, including 80% of the Fortune 500, spanning North America, Europe, and Asia. As a leading force in Full-Stack Technology Services, Talent Services, and practical application, we collaborate with forward-thinking leaders to foster progress. This is the strength of authentic partnerships. TEKsystems is a division of Allegis Group.

The organization is an equal opportunities employer and does not discriminate based on race, gender, age, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information, or any other legally protected characteristic.


  • Postgresql Dba

    3 weeks ago


    Detroit, Michigan, United States TEKsystems Full time

    :Our client is looking for a PostgreSQL DBA to support day to day tasks within their environment, as well as an upcoming project to upgrade 150 clusters to the most recent version of mySQL. The team is currently made up of 6 other DBA's, so the openness to learn and work with other database technologies outside of PostgreSQL is important for this...

  • Postgresql Dba

    3 weeks ago


    Detroit, Michigan, United States TEKsystems Full time

    :Our client is looking for a PostgreSQL DBA to support day to day tasks within their environment, as well as an upcoming project to upgrade 150 clusters to the most recent version of MySQL. The team is currently made up of 6 other DBA's, so the openness to learn and work with other database technologies outside of PostgreSQL is important for this...

  • Postgresql Dba

    3 weeks ago


    Detroit, Michigan, United States TEKsystems Full time

    :Our client is looking for a PostgreSQL DBA to support day to day tasks within their environment, as well as an upcoming project to upgrade 150 clusters to the most recent version of mySQL. The team is currently made up of 6 other DBA's, so the openness to learn and work with other database technologies outside of PostgreSQL is important for this...


  • Detroit, Michigan, United States Quicken Loans Full time

    RKT Holdings is a centralized hub that delivers thoughtful and innovative solutions for Rocket Companies. We are the center of operations, technology, marketing, HR, legal, strategy and more that propels our companies forward. Here, we'll give you the opportunity to launch your career and work with various companies, spanning multiple industries from...


  • Detroit, Michigan, United States Henry Ford Health System Full time

    Join Henry Ford Health as the Manager of Pharmacy Database and Technology System Management, part of our Shared Services leadership team. Drive innovation and efficiency in healthcare technology while advancing patient care across our network. GENERAL SUMMARY: The Manager-Pharmacy Database & Technology Systems Management is a member of the Pharmacy Shared...

  • Office Administrator

    1 month ago


    Detroit, Michigan, United States DTE Energy Full time

    Job SummaryLocations: Stanton, TNThis position is responsible for providing administrative support to the Plant Manager and other site employees within the newly constructed Central Utility Plant located at Ford's Blue Oval City complex. Work is performed under direct supervision of the Plant Manager while having a matrixed reporting relationship to a Senior...


  • Detroit, Michigan, United States SAIC Career Site Full time

    Description We are looking for an experienced, Full-time, ATCTraining Materials Administrator to join the SAIC Controller Training Solutions (CTS) team at the Detroit Metropolitan Wayne County ATCT (DTW) in Detroit, MI, supporting air traffic controller training services for the Federal Aviation Administration (FAA).Description:The position of Training...


  • Detroit, Michigan, United States SAIC Career Site Full time

    Description We are looking for an experienced, Full-time, ATCTraining Materials Administrator to join the SAIC Controller Training Solutions (CTS) team at the Detroit Metropolitan Wayne County ATCT (DTW) in Detroit, MI, supporting air traffic controller training services for the Federal Aviation Administration (FAA).Description:The position of Training...


  • Detroit, Michigan, United States Wayne State Full time

    Sr. Grant/Contract Administrator Wayne State University is searching for an experiencedSr. Grant/Contract Administratorat its Detroit campus location. Wayne State is a premier, public, urban research university located in the heart of Detroit, Michigan where students from all backgrounds are offered a rich, high-quality education. Our deep-rooted commitment...


  • Detroit, Michigan, United States Flex-N-Gate Full time

    Overview: Flex-N-Gate is a leading manufacturer and supplier of components for the automotive industry, recently ranked 10th of the 150 Top North American Suppliers in Automotive News. A growing and vital company, Flex-N-Gate provides a great opportunity for hard-working and skilled individuals. Scope of the Position: Responsible to ensure that customer...


  • Detroit, Michigan, United States Alixpartners Llc Full time

    At AlixPartners, we solve the most complex and critical challenges by moving quickly from analysis to action when it really matters; creating value that has a lasting impact on companies, their people, and the communities they serve.By understanding, respecting, and honoring the needs of our employees, clients, and communities, AlixPartners actively promotes...


  • Detroit, Michigan, United States KOSTAL Group Full time

    Company DescriptionKOSTAL has a strong family history built on innovation and care for our employees. For over 100 years, our values have guided how we work together to influence, evolve and grow our future.If you are interested in being part of our next generation, we want to hear from youJob DescriptionThis position is primarily responsible for OEM and...


  • Detroit, Michigan, United States KOSTAL Group Full time

    Company DescriptionKOSTAL has a strong family history built on innovation and care for our employees. For over 100 years, our values have guided how we work together to influence, evolve and grow our future.If you are interested in being part of our next generation, we want to hear from youJob DescriptionThis position is primarily responsible for OEM and...


  • Detroit, Michigan, United States Maayee Inc Full time

    Job DescriptionJob DescriptionJob Title: Oracle DBA with MongoDB ExperienceLocation: Charlotte, NC or Detroit, MI (Hybrid)Job Type: Long Term ContractW2 OnlyDuration : Long termMOI: VideoSkills Required: Oracle DBA,Mongo DBJob Summary:The Oracle DBA with MongoDB experience will be responsible for the installation, configuration, maintenance, and performance...


  • Detroit, Michigan, United States Apexon Full time

    About Apexon Apexon is a digital-first technology services firm specializing in accelerating business transformation and delivering human-centric digital experiences. We have been meeting customers wherever they are in the digital lifecycle and helping them outperform their competition through speed and innovation.Role Description & Responsibilities...


  • Detroit, Michigan, United States Tenet Healthcare Full time

    Administrative Director Nursing Specialty FT Days Description : DMC Detroit Receiving Hospital, Michigan's first Level I Trauma Center, helped pioneer the evolution of emergency medicine and currently has one of the busiest and most well-equipped emergency departments anywhere. The first and largest verified burn center in the state is at...


  • Detroit, Michigan, United States Tenet Healthcare Full time

    Administrative Director Nursing Specialty FT Days Description : DMC Detroit Receiving Hospital, Michigan's first Level I Trauma Center, helped pioneer the evolution of emergency medicine and currently has one of the busiest and most well-equipped emergency departments anywhere. The first and largest verified burn center in the state is at...


  • Detroit, Michigan, United States Wayne State University Full time

    Applications Specialist IIWayne State University is searching for an experiencedApplications Specialist IIat its Detroit campus location.Wayne State is a premier, public, urban research university located in the heart of Detroit, Michigan where students from all backgrounds are offered a rich, high-quality education. Our deep-rooted commitment to excellence,...


  • Detroit, Michigan, United States Wayne State University Full time

    Applications Specialist IIWayne State University is searching for an experiencedApplications Specialist IIat its Detroit campus location.Wayne State is a premier, public, urban research university located in the heart of Detroit, Michigan where students from all backgrounds are offered a rich, high-quality education. Our deep-rooted commitment to excellence,...

  • mssql dba

    1 week ago


    Detroit, Michigan, United States ApTask Full time

    About Client:The Client is a leading global IT services and consulting company, providing a wide range of services to clients in various industries, including banking, financial services, retail, manufacturing, healthcare, and more. It is one of the largest employers in the IT industry and has a vast and diverse workforce. The company places a strong...