Client is looking for a Database Administrator (DBA) contractor for staff augmentation purposes to help manage the PostgreSQL environment.
The position will be responsible for on-going administration of existing environments including defining, planning, implementing, and supporting client’s physical Marklogic databases for the enterprise.
Candidate should possess extensive knowledge of all aspects of PostgreSQL including monitoring and performance tuning.
50% onsite is required.
Responsibilities
Strong proficiency in PostgreSQL database administration and management.
You will be required to 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 Database’s 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 & solving complex performance problems.
Proficient in PostgreSQL Database Patching, Upgrades & Migrations.
Proficient in monitoring & performance analysis
Experience working with or in an automated operation environment.
Experience managing operations on core & cloud-based infra 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 database administration experience
Proven SQL and PostgreSQL experience
Experience in designing and automating repetitive processes.
Familiarity with other SQL/NoSQL databases such as MySQL etc.
Experience with cloud-based database services (e.g., AWS RDS, Google Cloud SQL, Azure Database for PostgreSQL).
Good Hands-on scripting language
Excellent problem-solving and analytical skills
Effective communication and collaboration abilities.
Experience working with or in an automated operations environment (e.g. Ansible)