Job Description

Who We Are



Magnit is the future of work. Serving hundreds of the world's most recognizable brands for the past 30+ years, Magnit offers the industry's first holistic platform for the modern workforce. Magnit's integrated workforce management (IWM) platform supported by data, software, intelligence, and best-in-class services team is key to our clients' success. It can adapt quickly to regional or industry economic shifts, and provides the speed, scale, flexibility, transparency, and expertise required to meet an organization's contingent workforce management, talent strategy and broader organization goals. At Magnit, you'll work with passionate colleagues who collaborate and deliver meaningful results that positively transform the largest companies around the globe.



We are seekingan experienced and skilled Senior PostgreSQL Database Administrator (DBA) to join our dynamic IT team. In this role, you will be responsible formanaging, maintaining, and optimizingour PostgreSQL databases to ensure their performance, availability, security, and scalability. You will work closely with our development teams to design and implement database structures and provide guidance and support for database-related issues.



Key Responsibilities:

Database Management and Maintenance:

Perform regular database maintenance tasks such as backups, restores, vacuuming, and indexing.

Monitor database performance, tune database parameters, and apply patches and upgrades to ensure optimalperformance and security.



Database Design and Development:

Collaborate with development teams to design efficient and scalable database schemas.

Assistin the development and optimization of SQL queries and stored procedures.



Security and Compliance:

Implement and maintaindatabase security measures, including access controls and encryption.

Ensure compliance with data privacy regulations and best practices.



Performance Tuning and Optimization:

Analyze database performance issues and implement solutions to resolve them.

Optimize database configuration and resources for optimalperformance.



Disaster Recovery and High Availability:

Develop and test disaster recovery plans.

Implement and maintainhigh-availability solutions such as replication, clustering, or failover systems.



Technical Support and Consultation:

Provide expert advice and support to development teams on database-related topics.

Troubleshoot complex database issues and provide effective solutions.



Documentation and Reporting:

Maintain comprehensive documentation of database environments and procedures.

Prepare reports on database performance and health for management review.



Qualifications:

Bachelor's degree in computer science, information technology, or a related field.

Minimum of 5 years of experience as a PostgreSQL DBA or in a similar role.

Strong experience in managing large-scale PostgreSQL database environments.

Expertisein SQL and database optimization techniques.

Knowledge of database security, backup, and recovery best practices.

Familiaritywith scripting languages such as Python, Bash, or Perl.

Experience with cloud-based database solutions is a plus.

Excellent problem-solving skills and attention to detail.

Strong communicationand collaboration abilities.



What Magnit will Offer You



At Magnit, you'll be joining an innovative, high-growth environment and can quickly make an impact to help transform the largest companies in the world. You will work with passionate colleagues who collaborate and deliver. Magnit offers all employees the opportunity for growth and development, and we want individuals to fulfill their potential and blaze their own trails!



Magnit will offer you a competitive PTO and benefits package, including medical, dental, and vision coverage, retirement planning, as well as discounts and perks for tickets, travel, merchandise and more! Magnit encourages employees to participate in giving back, and we will match employee contributions to favorite charities and support corporate volunteering hours to make a difference in your community!



If this role isn't for you

Stay in touch, we will let you know when we have new positions on the team.



To see a complete list of our open career opportunities please visit.

https://magnitglobal.com/us/en/company/careers.html



To do our best work we need different viewpoints. Therefore, we celebrate diversity and embrace inclusion.



As an equal opportunity employer, we are dedicated to building a team that represents a variety of backgrounds, perspectives, and skills. We strive to ensure that we maintain a positive and enriching work environment for all.



By applying to this role, you consent to Magnit safely storing and managing your personal data. Please read this link to learn more.

https://magnitglobal.com/us/en/privacy-notice.html