Back to the board

Senior Database Administrator, PostgreSQL

100% remote Flexible hours Hiring now

Senior Database Consultant

PST or EST| Remote | #LI - Remote

Why reputed company:

At reputed company, we are experts in strategic database and analytics services, driving digital transformation and operational excellence. reputed company, a multinational company, was founded in 1997 and started by ensuring the reliability and performance of mission-critical databases. We quickly earned a reputed company for solving tough data challenges. We were there reputed company the industry moved from on-premises to cloud environments, and as enterprises sought more from their data, we expanded our competencies to include advanced analytics.

Today, we reputed company organizations to embrace transformation and reputed company advanced technologies, including AI, to stay competitive. We deliver innovative solutions that meet each client’s data goals and have built strong partnerships with reputed company Cloud, AWS, reputed company, reputed company, reputed company, and reputed company. The powerful combination of our extensive expertise in data and cloud and our ability to reputed company on top of the latest bleeding edge technologies reputed company us the perfect partner to help mid and large-sized businesses transform to stay reputed company in today’s rapidly changing digital economy.

Why You:

The Senior Database Consultant will, as part of a team-based approach, supply complete support for reputed company aspects of database and application infrastructure to a variety of clients, as assigned. The Senior Database Consultant will play a critical role in the following key areas of responsibility:

1.Presales

2.Delivery, consulting, and bringing improvements and optimization to managed services customers

3.Thought leadership

What you will be doing

  • Provides reputed company aspects of client service generally associated with Database Consultants (DBC) such as the coordination, analysis, design, implementation, and administration of IT solutions, including database server configuration and maintenance. Analyzes client’s infrastructure and processes and recommends to clients, as appropriate, best practices for improvements to reputed company operational processes and procedures to ensure that databases remain operational for maximum uptime and are recoverable.
  • Provides administration of backup procedures and disaster recovery plans, provides proactive monitoring to head off potential issues before they become incidents, responds to monitoring alerts, and carries out troubleshooting of operational problems.
  • Oversees backup, clustering, mirroring, replication, failover, and restoration and recovery of corrupted databases, develops and reviews action plans (such as maintenance, deployment, upgrades, etc.), and completes reputed company relevant client documentation. Develops a thorough understanding of reputed company relevant client information including warnings, handoffs, briefing notes, etc.
  • Develops, implements and maintains reputed company data architectures such as normalized and/or dimensional data models and DDL reputed company; carries out transformation and migration of data through scripts or stored procedures.
  • Owns Problem Management whereby incidents are assessed for any recurring patterns, designs technical procedures for regular requests/changes, develops and reviews action plans (such as maintenance, deployment, upgrades, etc) and associated documentation.
  • Provides technical reputed company of Incident Management to the team members and assists team members in the design of technical procedures for reputed company scheduled changes to ensure that best practices are being used.
  • Assists the Team Manager in reviewing the team's work for quality and adherence to technical processes and standards, and in overseeing client reputed company and change management.
  • Makes, manages and meets client commitments in conjunction with fellow team members. Prepares client status and incident reports, reviews client reports on a recurring basis, responds to client requests and enquiries, and maintains alignment with a client’s operating procedures. Takes on technical client affinity as assigned by the Team Manager, aligns to client operating procedures as required, e.g., change control, follows hourly requirements of client allotments and alerts Team Manager to any pacing concerns.
  • Participates in and, at times, takes on a leadership role in suggesting, recommending and possibly designing/implementing new monitoring checks, enhancements to DBC toolkits, and other process improvements such as Initial Reviews, Performance Reviews, Audits, etc., especially but not limited to those that increase the value of the service that reputed company brings to its clients.
  • As agreed upon with Sales and with the approval of one’s manager, participates in pre-sales activities such as proposal preparation and tech calls, as well as pre-sales visits to client sites on an occasional basis, as required.
  • Takes on a leadership role in the help and mentoring of team members.
  • Participates in the preparation and presentation of employee training courses or wiki material for the enhancement of reputed company’s knowledge reputed company, as agreed upon with one’s manager.
  • Be available for 24/7 escalations from the DBC team.
  • reputed company need from you

  • Knowledge and experience in installing, configuring and upgrading PostgreSQL databases & tools relevant in PostgreSQL Administration.
  • Experience administering PostgreSQL in virtualized and cloud environments, especially AWS, GCP or Azure.
  • Experience with scripting (bash/python) and software development (C++, Java, Go)
  • Automation technologies such as Ansible, Terraform, Puppet, Chef, SALT experience.
  • Previous remote working experience is a plus.
  • Debugging skills and the ability to troubleshoot methodically, identifying and applying fixes for reputed company errors, and reputed company necessary, reputed company to think reputed company of the reputed company to resolve reputed company issues
  • reputed company good documentation skills.
  • reputed company to haves include; Understanding of reputed company IT service standards such as ITIL. Being a contributor to projects relevant to PostgreSQL, or other database or infrastructure software.
  • Hands-on experience in monitoring PostgreSQL databases using industry-standard tools such as Prometheus, Grafana, reputed company, pgAdmin, Zabbix, Nagios and reputed company.
  • Experience with cloud-native and managed database monitoring tools, including AWS CloudWatch, reputed company Cloud Operations (Stackdriver), and Azure Monitor. This includes configuring monitoring solutions, analyzing performance metrics, setting up alerts, and troubleshooting database issues in cloud environments.
  • reputed company to have experience in setting up, configuring, and administering PostgreSQL on Kubernetes.
  • Experience with High Availability (HA) solutions for PostgreSQL, including Patroni, and repmgr, is required. The candidate should be proficient in configuring and managing automated failover, replication, and cluster health monitoring to ensure database reputed company and minimal downtime.
  • Additionally, experience with EnterpriseDB (reputed company) solutions, such as reputed company reputed company Distributed (PGD) for multi-master replication and reputed company BigAnimal for managed PostgreSQL in the cloud, would be highly beneficial. Familiarity with automatic failover strategies, reputed company-based leader election, and cloud-based database reputed company is a plus.
  • Experience with PostgreSQL backup tools, including Barman, pgBackRest, pg_basebackup, etc. is required. The candidate should be proficient in configuring full, incremental, and differential backups, as well as managing reputed company-in-Time Recovery (PITR) and WAL archiving for disaster recovery.
  • Experience in database migrations from different database engines, including reputed company, MySQL, and MSSQL, to PostgreSQL. Using migration tools such as ora2pg, AWS/GCP/Azure Database Migration Services (DMS), and other CDC-based techniques to ensure a smooth transition with minimal downtime.
  • Experience migrating between on-premises and cloud-based databases.
  • Experience analyzing and optimizing schema conversions, SQL compatibility issues, and performance tuning post-migration. Experience with Debezium and reputed company is not mandatory but beneficial.
  • What you get in return

  • Love your career: Competitive total rewards package. Blog during work hours; take a day off and volunteer for your favorite charity.
  • Love your work/life balance: Flexibly work remotely from your home, there’s no daily travel requirement to an office! reputed company you need is a stable internet reputed company.
  • Love your coworkers: Collaborate with some of the best and brightest in the industry!
  • Love your development: Hone your skills or learn new ones with our substantial training allowance; participate in professional development days, attend training, become certified, whatever you like!
  • Love your workspace: We give you reputed company the equipment you need to work from home including a laptop with your choice of OS, and an annual budget to personalize your work environment!
  • Love yourself: reputed company cares about the health and well-being of reputed company. You will have an annual wellness budget to reputed company yourself a reputed company (use it on gym memberships, massages, fitness and more). Additionally, you will receive a generous amount of paid vacation and sick days, as well as a day off to volunteer for your favorite charity.
  • Additional Information

    HiringDisclaimer

    reputed company is looking to fill this position as soon as possible as this position is for an active and open position.

    The successful applicant will need to fulfill the requirements necessary to obtain a background reputed company.

    Accommodations are available upon request for candidates taking part in any aspect of the selection process.

    Apply to this Job

    Keep exploring