Job Title
Database Administrator
Company
TISTA Science & Technology Corporation
Job Description
Overview
Are you a talented Database Administrator looking to positively affect the lives of millions of people? The selected candidate will join a team of dreamers, drivers, and doers helping reshape healthcare IT with CMS!
Additional perks with TISTA will include above Industry Healthcare Benefits, Remote Working Options, Paid Time Off, Training/Certification opportunities, Healthcare Savings Account & Flexible Savings Account, Paid Life Insurance, Short-term & Long-term Disability, 401K Match, Tuition Reimbursement, Employee Assistance Program, Paid Holidays, Military Leave, and much more!
Responsibilities
- Experienced with PostgreSQL & PostgreSQL Architecture
- Responsible for the monitoring and uptime of all production databases.
- Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage.
- Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need downtime.
- Develop Stored Procedures and Database Triggers in support of application development.
- 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.
- Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release.
- Responsible for regular backups and recovery of databases.
Responsible for regular maintenance on databases.
- Expert knowledge of DBMS and admin tools, performance and monitoring tools. (especially Erwin)
- Responsible for pro-active remediation of database operational problems.
- Responsible for Query tuning and preventative maintenance.
- Participate in a 24×7 support rotation.
Qualifications
- 6+ years of information systems experience including
- 6+ years of database administration experience
- PostgreSQL experience required
- Must have strong analytical, verbal and written communication skills.
- Must have experience in PostgreSQL database architecture, logical and physical design, automation, documentation, installs, shell scripting, PL/ SQL programming, catalog navigation, query tuning, system tuning, resource contention analysis, backup and recovery, standby, replication, etc.
- Experience in DB2 is an added plus
Education:
- Bachelor’s degree in related field
Clearance:
- CMS US Residency Requirement (3/last 5 years working in US)
- Must be eligible to obtain a Public Trust clearance
Location:
- Remote
Salary Inforamtion:
- The pay for this position ranges from $65,205 to $134,375.
- The actual salary offer will carefully consider a wide range of factors, including your skills, qualifications, experience, and location.
- Also, certain positions are eligible for additional forms of compensation, such as bonuses.
- TISTA associates are eligible to participate in our comprehensive benefits plan! More information can be found here: https://tistatech.com/working-at-tista/
Expected Salary
$65205 – 134375 per year
Location
USA
Job Posting Date
Wed, 12 Jul 2023 05:51:43 GMT