Job Title: Database Administrator (DBA) Contractor
Location: Fort Worth, TX
Duration: 12 months
Job Description: Our Client is seeking a Database Administrator (DBA) contractor for staff augmentation to manage the PostgreSQL environment. This role involves ongoing administration of existing environments, including defining, planning, implementing, and supporting Our Client's physical Marklogic databases for the enterprise. The candidate should possess extensive knowledge of all aspects of PostgreSQL, including monitoring and performance tuning. This position requires 50% onsite presence.
Responsibilities:
- Strong proficiency in PostgreSQL database administration and management.
- Develop SQL Queries as required by Business Divisions.
- Develop Stored Procedures.
- Load Balancing and High Availability.
- Ensure System Optimization by improving and restructuring the databases.
- Perform database Updates and Migrations.
- Synchronize multiple Databases in various branches.
- Thorough understanding of database design, performance tuning, and optimization techniques.
- Generate Comprehensive Documentation.
- Support database issues arising from Customer Queries.
- Proficient in troubleshooting and solving complex performance problems.
- Proficient in PostgreSQL Database Patching, Upgrades, and Migrations.
- Proficient in monitoring and performance analysis.
- Experience working with or in an automated operation environment.
- Experience managing operations on core cloud-based infrastructure environments.
- Investigate and troubleshoot database-related issues, including connectivity problems, performance degradation, and data inconsistencies.
- Provide timely resolution and root cause analysis for incidents.
- Willingness for 24/7 shift support and on-call support.
Key Skills:
- Significant background in creating complex stored procedures and SQL scripts in PostgreSQL.
- Understanding of database normalization concepts.
- A minimum of 7 years of database administration experience.
- Proven SQL and PostgreSQL experience.
- Experience in designing and automating repetitive processes.
- Familiarity with other SQL/NoSQL databases such as MySQL.
- Experience with cloud-based database services (e.g., AWS RDS, Google Cloud SQL, Azure Database for PostgreSQL).
- Good hands-on scripting language skills.
- Excellent problem-solving and analytical skills.
- Effective communication and collaboration abilities.
- Experience working with or in an automated operations environment (e.g., Ansible).
Required Skills : PostgreSQL Database Administration SQLLong term project, may be up to 3 years
Background Check :Yes
Drug Screen :Yes
Notes :
Selling points for candidate :Long term project, may be up to 3 years
Project Verification Info :The information provided below is for Apex Systems AV use only and is not to be distributed publicly, or to any third party. Any distribution of the below information will result in corrective action from Apex Systems Vendor Management. MSA: Restricted Client Letter: Will Not Provide
Candidate must be your W2 Employee :Yes
Exclusive to Apex :No
Face to face interview required :No
Candidate must be local :Yes
Candidate must be authorized to work without sponsorship No
Interview times set No
Type of project :
Master Job Title :
Branch Code :