Conexess – Conexess Design Skip to main content

PostgreSQL DBA (Remote)

Job Title
PostgreSQL DBA (Remote)
Job ID
27688388
Work From Home
Yes
Location
Philadelphia,  PA 19192
Other Location
Description
Our History:
From our start in 2009, Conexess has established itself in 3 markets, employing nearly 200+ individuals nation-wide. Operating in over 15 states, our client base ranges from Fortune 500/1000 companies to mid-small range companies. For the majority of the mid-small range companies, we are exclusively used due to our outstanding staffing track record.

Who We Are:
Conexess is a full-service staffing firm offering contract, contract-to hire, and direct placements. We have a wide range of recruiting capabilities extending from help desk technicians to CIOs. We are also capable of offering project-based work.

Conexess Group is aiding a large healthcare client in their search for a PostgreSQL DBA in a remote capacity. This is a long-term opportunity with a competitive compensation package.

******We are unable to work C2C on this role******

Responsibilities:
  • Analyzes, designs, creates, and implements databases for complex applications including access methods, device allocations, validation checks, organization and security
  • Designs logical and physical data models, data dictionaries and schemas
  • Provides guidance on migration of on-premises workloads to the cloud (AWS)
  • Performing maintenance tasks like Vacuuming, Clustering, Reindex, Analyze
  • Creating Tablespaces, Schemas, Users, profiles and implementing various adjustments in postgresql.conf file and granting users and application access through pg_hba.conf file etc.
  • Configure SSL, PAM, Kerberos and LDAP Active directory authentication with PostgreSQL
  • Installation and using Splunk enterprise for database log monitoring and troubleshooting
  • Ensure application observability patterns and site reliability practices - configured CloudWatch logs and Alarms
  • Automated configuration management and deployments using Ansible playbooks and Yaml for resource declaration
  • Configure and maintain Aurora databases, RDS databases and databases on EC2 instance  
Qualifications:
  • Significant experience working with a diverse set of RDBMs – including their installation, maintenance, data model design, query optimization and monitoring
  • Experience administering Postgres (PEM, PgAdmin, pg_dump, pg_restore and pg_basebackup) on PostgreSQL 12 and up
  • Used Ansible for database deployments and change managements
  • Experienced in Cloud automation using AWS Cloud Formation or Terraform templates to create Experience in working on AWS and its services like AWS IAM, VPC, EC2, ECS, EBS, RDS, S3, Lambda, ELB, Auto Scaling, Route 53, Cloud Front, Cloud Watch, Cloud Trail, SQS, and SNS
  • custom sized VPC, subnets, NAT, EC2 instances, ELB and Security groups and more
  • DevOps Tools: GIT, Jenkins, Dockers, Ansible, Kubernetes
  • Containerization Tools: AWS ECS, Docker
  • Scripting Languages: Shell Scripting, python
  • Databases: PostgreSQL, Oracle, Sql Server, DB2, Document databases
  • Automation Tools: Jenkins, Terraform
  • Server Management: OpenShift
  • Operating Systems: Linux (Red Hat, CENTOS & SUSE), Ubuntu, Windows
  • Logging & Monitoring Tools: Splunk, Cloudwatch, Prometheus, Grafana, PEM, Datadog, Nagios, SolarWinds, IDERA, Ops manager, Atlas
  • Provisioning Tools: Terraform, CloudFormation
#LI-CT1
#LI-Remote

 

Option 1: Create a New Profile