Database Administrator - Must have PostgresSQL

Job Details

Level

Experienced

Job Location

DSS N Palm Beach - North Palm Beach, FL

Position Type

Full Time

Education Level

4 Year Degree

Travel Percentage

Up to 25%

Job Shift

Day

Job Category

Information Technology

Description

The Postgres Database Administrator will be responsible for the responsible for the monitoring and uptime of all production databases and estimate Microsoft SQL or PostgreSQL database capacities; develop methods for monitoring database capacity and usage. This is a "hands-on" position requiring solid technical skills, as well as excellent interpersonal and communication skills.

Hybrid or Remote candidates will be considered

What you'll do here:

• Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any needed downtime.
• Set database usage standards with developers.
• Manage schema updates and code-driven DB changes with developers.
• Participate in application development projects and be responsible for the database architecture and design.
• Participate in the creation of development, staging, and production database instances, and the migration from one environment to another.
• Diagnose and troubleshoot database errors.

Other Duties:

• Recommend and implement emerging database technologies.
• Create and manage database reports, visualizations, and dashboards.
• Recommend optimizations to existing application queries.
• Provide oversight and manage MS SQL Server, AWS cloud-native RDBMS and NoSQL DBs for new product lines.
• Work closely with IT team members, Development, DBA's to create and update policies, procedures to configure, monitor and support the Databases in Customer facing Cloud environments.
• Be a part of rotating on-call schedules.
• Support complex web-based applications.

The preceding functions are examples of the work performed by employees assigned to this job classification. Management reserves the right to add, modify, change or rescind work assignments and make a reasonable accommodation as needed.

Qualifications

About you:

• 3 years of experience as a PostgreSQL or Microsoft SQL database administrator. designing and deploying PostgreSQL databases on Cloud platforms such as AWS and Azure.
• Experience with AWS and Azure RDS offerings and support
• Experience with backups, restores and recovery models
• 3 years of expert experience performing database performance analysis, system and statement SQL tuning.
• Advanced knowledge of database security, backup and recovery, and performance monitoring standards
• U.S. Citizen or Permanent Resident status required
• Visa Sponsorship or C2C not available

Bonus points if you:

• Have extensive AWS RDS experience
• Experience with NoSQL technologies

Education:

• Required:
  • Bachelor's degree in an applicable discipline
  • Combination of experience and education will be considered
• Desired:
  • Advanced degree in an applicable discipline a plus

Physical Demands:

Standing

10% per day

Sitting

80% per day

Walking

5% per day

Stooping

5% per day

Lifting

Ability to lift up to 20 lbs. unassisted

Computer Work

80% per day

Telephone Work

10% per day

Reading

10% per day

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

If you need an accommodation seeking employment with DSS, Inc., please email [email protected] or call (561) 284-7373. Accommodations are made on a case-by-case basis.