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.
...Solar Energy Solutions (SES) is actively seeking reliable and skilled Solar Installers to become part of our growing team. As a key member of our installation crew, you will be responsible for installing and maintaining solar energy systems for residential and commercial...
...clients and families. Ability to manage time effectively and complete documentation and administrative tasks efficiently. Portuguese proficiency required. Explore the Advantages of Joining Our Team: Enjoy competitive compensation and a wide range of benefits...
...Job Description Position: AWS Cloud Architect \n \n Location: ( Remote - Only in US)\n \n Visa Preference: USC / GC's \n \n Required Experience \n \n ~5+ years of hands-on AWS cloud engineering, DevOps, platform engineering, or cloud security experience...
...Job Description Job Description About the Role: The Mental Health Technician at Wagoner Community Hospital plays a crucial role in supporting the mental health care team and ensuring the well-being of patients. This position involves direct interaction with patients...
...Chief Safety Officer The Maryland Transit Administration (MTA) invites you to apply and join a team dedicated to serving the residents of Maryland through reliable, customer-focused transit services every day. The Maryland Transit Administration (MTA) is seeking an...