Database Administrator (DBA) ContractorLocation: Fort Worth, TX Duration: 12 monthsOur 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 AdministrationSQLLong term project, may be up to 3 yearsBackground Check: YesDrug Screen: Yes