Database Administrator Job at SFE, San Antonio, TX

  • SFE
  • San Antonio, TX

Job Description

Job Details:-

Job Title: Senior Postgres /DB2 DBA

Location: San Antonio, TX Onsite

Duration: Fulltime Hire

Salary Range: $120,000-$130,000 a year + benefits

Experience :- 6+

Job Description

PostgreSQL/ DB2

PostgreSQL Database Administration (v11 and above)

Installation, configuration, upgrades, and patching

Performance tuning and query optimization

Replication, clustering, and high availability

Backup and recovery strategies

Database monitoring and health checks

PostgreSQL security and access management

PostgreSQL on Linux environments

Experience with AWS RDS PostgreSQL or cloud-hosted databases

IBM DB2 Database Administration

DB2 Performance Monitoring and Tuning

SQL Optimization and Index Management

Database Backup and Recovery

DB2 Security and User Administration

Database Migration and Upgrade Activities

Production Support and Incident Management

Additional Skills

Linux/Unix Administration

Shell Scripting (Bash/KSH)

SQL and Stored Procedure Development

Monitoring Tools and Alert Management

Database Migration and Modernization Projects

Git, Jenkins, CI/CD Concepts

Cloud platforms (AWS preferred)

ITSM and Change Management Processes

Database Administration

Install, configure, upgrade, patch, and administer PostgreSQL and DB2 databases.

Manage database capacity planning, growth forecasting, and storage utilization.

Create and maintain development, QA, UAT, and production database environments.

Performance Management

Monitor database performance and availability.

Analyze and optimize SQL queries, indexes, and execution plans.

Troubleshoot slow-running queries and application performance bottlenecks.

Implement proactive monitoring and alerting mechanisms.

Backup, Recovery & High Availability

Design and execute database backup and recovery strategies.

Maintain disaster recovery and business continuity solutions.

Configure and support replication, failover, and high-availability architectures.

Conduct regular DR drills and recovery validation exercises.

Production Support

Provide L3 database support for critical production environments.

Perform root cause analysis for incidents and recurring issues.

Participate in on-call support rotations when required.

Prepare RCA documents and operational reports.

Security & Compliance

Implement database security standards and best practices.

Manage user accounts, roles, privileges, and auditing.

Ensure compliance with organizational and regulatory requirements.

Support vulnerability remediation and security audits.

Migration & Modernization

Lead database migration initiatives between environments and platforms.

Support cloud migration and modernization programs.

Ensure minimal downtime and data integrity during migrations.

Collaboration

Work closely with application teams, architects, cloud engineers, and business stakeholders.

Provide technical guidance and mentoring to junior DBAs.

Participate in design reviews and architecture discussions.

Job Tags

Full time

Similar Jobs

Trans-Tech

Assembler/Clean Line Operator Job at Trans-Tech

 ...magnetic materials, dielectrics, ceramic bandpass filters, coaxial resonators, and coaxial inductors. Technical Operator (Assembler/Clean Line Operator) Position Description: The Technical Operator will assemble ceramic parts and operate cleaning machine to clean... 

MBI Management Services Inc.

Ergonomist - PRN Job at MBI Management Services Inc.

 ...Job Description Job Description Role Summary: The Ergonomist is responsible for evaluating work environments, job tasks, equipment, and processes to reduce musculoskeletal risk, improve employee safety, and support efficient, sustainable performance. This role... 

Success Academy Charter Schools, Inc.

Entry-Level Teacher Job at Success Academy Charter Schools, Inc.

Success Academy Charter Schools is seeking passionate and creative Entry-level Teachers who are eager to foster a love of learning in our students. Our schools are committed to achieving high educational standards and providing a dynamic learning environment that promotes... 

Brown & Brown

Claims Adjuster (Warranty) Job at Brown & Brown

 ...for our customers. \n One80 Intermediaries is seeking a Claims Adjuster to join our growing team!\n \n In this role, you will...  ...License (preferred not required). \n \n \n Skills & Experience to be Successful: \n \n High School Diploma or equivalent... 

Cardinal Health

Delivery Driver (Weekends) Job at Cardinal Health

 ...MA-Woburn-Boston Nucl Pharm #55 Part time 20188103 Now offering a $1,000 new hire sign...  ...extended periods of time Ability to work weekends, holidays, overtime, alternate days/...  ...Benefits: 401k Contributions, Paid Time Off, Access to wages before pay day with myFlexPay...