Job Description - SQL/PostgreSQL Database Administrator (REMOTE) in Houston
Return to jobs

SQL/PostgreSQL Database Administrator (REMOTE)

Ref: US_EN_6_914777_1425037

Posted on 07 January 2022
Job Location
Houston, Texas
Contract Type
Contract/Temporary
Category
Information Systems

SQL/PostgreSQL Database Administrator job is available through Modis. This is a contract opportunity that is 100% remote based. Candidates must reside within the United States. Our client is currently moving from an On-premise MS SQL to PostgreSQL in Azure environment.

We are looking for a strong contributor to assist client in their SQL/PostgreSQL/database/data related efforts. This role will join a small and nimble 100% remote team working in a fast-paced environment. This is a great opportunity to join our technology team that provides data driven solutions to our customers and stakeholders. In this role, you will be responsible for delivering solutions and support for our evolving database environment. Data migration is a key function of this position. The database environment currently features a mix of MS SQL and PostgreSQL databases.

Your responsibilities will include deploying, upgrading and maintaining the database systems, and specifically migrating legacy data from our on prem SQL databases to our PostgreSQL database servers hosted on Azure. You will need to have recent experience in developing and deploying database server design patterns.

This position will suit you if you are a skilled in MS SQL, PostgreSQL, with a DevOps mindset

Your day-to-day responsibilities will include:

  • Data migration from on prem MS SQL to PostgreSQL on Azure
  • Designing and building “data loaders” (ETL) to automate data ingestion and management
  • Manage the performance of database systems and address any problems that may arise
  • Maintain our databases including installing upgrades, protecting against threats, managing storage and security, various implementations, and other associated duties
  • Build high-quality databases that meet both back end and front-end needs, minimizing downtime and offering fast query responses
  • Assist with query tuning and configurations, while crafting and deploying associated patches
  • Assist Application Developers with their database-related needs
  • Establish Database Administrator best practices
  • Maintain and document audit trails, report on usage and performance, testing upgrades and sharing statistical information in accordance with company needs
  • Create database policies that outline standards and procedures for associated team members
  • Qualifications:

  • Experience using PostgreSQL solutions within Azure
  • Experience with data migrations across environments
  • Programming experience with Python or Ansible or Shell scripting or other demonstrable open-source programming languages
  • Experience creating and configuring Availability Groups and Listeners
  • Experience with third-party tools, DBA case tools (both front and backend), and strong knowledge of schema and data concepts and standards.
  • Capable of creating, managing, and modifying custom reports as needed.
  • Highly communicative (both verbal and written), with the ability to work both with a team or on your own as required.
  • If you are interested in this SQL/PostgreSQL Database Administrator job with Modis then please click APPLY NOW. For other opportunities available at Modis go to www.modis.com. If you have questions about the position or would like more information, please contact David Baio by email at David.Baio@modis.com

    Equal Opportunity Employer/Veterans/Disabled

    To read our Candidate Privacy Information Statement, which explains how we will use your information, please navigate to https://www.modis.com/en-us/candidate-privacy

    The Company will consider qualified applicants with arrest and conviction records

    Apply

    Find your local office.

    Modis has over 100 offices in the United States, Canada and Europe. With both industry and location-specific expertise, our people know their area and their labor market and can find the right position for you.

    Locations