Iris Software - Holmdel, NJ

posted 2 months ago

Full-time - Senior
Holmdel, NJ
Publishing Industries

About the position

Iris's Fortune 100 direct client is seeking a Senior Database Administrator/Architect specializing in Oracle and SQL to join their team in Holmdel, NJ. This hybrid role requires a seasoned professional with over 10 years of DBA experience, particularly in PostgreSQL replication and database performance tuning. The ideal candidate will possess strong skills in SQL or Oracle coding, shell scripting, and automation, as well as experience with AWS/Cloud Services, including EC2, RDS, and Aurora. The role demands hands-on expertise in cloud deployments using tools like Jenkins, Bitbucket, and Terraform, and the ability to perform essential database tasks such as upgrades, backups, recovery, and migrations. The successful candidate will be technically adept, capable of troubleshooting and optimizing database performance, and will have a deep understanding of PostgreSQL's underlying storage engines. They will be responsible for profiling server resource usage and making necessary optimizations. The position requires a commitment to following SDLC and Change Management principles, and the ability to work independently with minimal supervision. Strong communication skills, both oral and written, are essential, as is experience with ticketing tools like ServiceNow and monitoring tools such as CloudWatch and AppDynamics. Iris Software, Inc., the hiring company, is a well-established IT solutions provider based in New Jersey, recognized for its rapid growth and excellence in service delivery. The company has been honored as one of New Jersey's Finest 25 companies and has received accolades for its performance in the technology sector.

Responsibilities

  • Perform required database tasks including upgrades, backups, recovery, and migration.
  • Optimize and tune SQL or Oracle performance.
  • Profile server resource usage and make necessary optimizations.
  • Install, configure, and patch PostgreSQL RDBMS.
  • Troubleshoot and monitor database performance in large and dynamic environments.
  • Follow SDLC and Change Management principles diligently.
  • Utilize ticketing tools and cloud monitoring tools effectively.

Requirements

  • 10+ years of DBA experience.
  • Experience with PostgreSQL replication.
  • Strong SQL or Oracle coding and tuning experience.
  • Shell scripting and automation experience.
  • Experience with AWS/Cloud Services: EC2, RDS, and Aurora.
  • Hands-on experience with cloud deployments using Jenkins, Bitbucket, and Terraform.
  • Strong troubleshooting and performance tuning skills.
  • Ability to assess and improve SQL or Oracle performance.
  • Understanding of PostgreSQL's underlying storage engines.
  • Experience with data quality, data management, and data testing strategies.

Nice-to-haves

  • Experience with AppDynamics or similar APM tools.
  • Familiarity with ticketing tools such as Zenoss.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service