Database Administration (Postgres/RDBMs)


Strategic Staffing Solutions


Job Title: Database Administration (Postgres/RDBMs)

Location: Bloomfield, CT

Role Type: W2 Only

Contract Length: 6 Months

How to Apply: Please send resume and contact information to Rene May, Sourcing Specialist, at and reference job #209177.

Job Description/Responsibilities:

  • Responsible for research and development of a Data Retention Application within the Information Lifecycle Management (ILM) team by leveraging industry and big data platform tools.
  • The objective of this position is to work with business and technical experts to implement data retention policies and practices related to managing our data from inception until disposal in a manner that optimizes storage and access at the lowest cost.
  • The individual must have superb analytical and technical skills coupled with the ability to drive project deliverables.
  • The individual will be expected to participate in collaborative concept definition, architectural refinement, design, development, and realization of products that support the strategic technology needs to support the organization.
  • The applicant will be working in a team that demands technical excellence and whose members are expected to hold each other accountable in the overall success of the output.
  • The qualifications and skills required or preferred below are as they relate to Information Lifecycle Management technologies.
  • Provides counsel and advice to stake holders on significant Database Administration & Management matters
  • 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
  • Recognized internally as “the go-to person” for Database Administration assignments
  • Provides guidance on migration of on-premises workloads to the cloud (AWS)

Required Qualifications/Experience:

  • DevOps Tools: GIT, Jenkins, Dockers, Ansible, Kubernetes
  • Containerization Tools: AWS ECS, Docker,
  • Cloud Environment:  Amazon Web Services (AWS)
  • 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

Ideal candidates should have:

  • Formal education in Computer Science, or related field or equivalent experience preferred
  • Significant experience working with a diverse set of RDBMs – including their installation, maintenance, data model design, query optimization and monitoring
  • Strong foundation in relational concepts such as normalization, referential integrity, primary and secondary index design, data modelling for both operational and warehouse environments
  • 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
  • Performing maintenance task 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
  • Experienced in Cloud automation using AWS Cloud Formation or Terraform templates to create custom sized VPC, subnets, NAT, EC2 instances, ELB and Security groups and more
  • 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
  • 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
  • Configure and maintain Aurora databases, RDS databases and databases on EC2 instance 
  • Logging & Monitoring Tools: Splunk, Cloudwatch, Prometheus, Grafana, PEM, Datadog, Nagios, SolarWinds, IDERA, Ops manager, Atlas
  • Provisioning Tools: Terraform, CloudFormation

S3 supports and adheres to customer COVID-19 vaccination policies, which may include the disclosure of vaccination status.

The S3 Difference

The global mission of S3 is to build trusting relationships and deliver solutions that positively impact our customers, our consultants, and our communities.  The four pillars of our company are to:

  • Set the bar high for what a company should do
  • Create jobs
  • Offer people an opportunity to succeed and change their station in life
  • Improve the communities where we live and work through volunteering and charitable giving

As an S3 employee, you’re eligible for a full benefits package that may include:

  • Medical Insurance
  • Dental Insurance
  • Vision Insurance
  • 401(k) Plan
  • Vacation Package
  • Life & Disability Insurance Plans
  • Flexible Spending Accounts
  • Tuition Reimbursement

Job ID: JOB-209177
Publish Date: 08 Nov 2022

Tagged as: Database Administration (Postgres/RDBMs)